| schema | table | live_tupple | dead_tupple | ratio_of_dead_to_each_live | percent_of_dead | last_vacuum_at | last_autovacuum_at | last_analyze_at | last_autoanalyze_at |
|---|
| e202504 | a_proximity_sum | 30878862 | 0 | 0.00 | 0.00 | | 2025-05-28 19:34:32.705747+00 | | |
| e202504 | a_stay_time | 39029265 | 0 | 0.00 | 0.00 | | 2025-05-27 12:54:06.526509+00 | | |
| e202504 | t_position_history | 474217220 | 0 | 0.00 | 0.00 | | 2025-05-29 07:00:58.97427+00 | | |
| e202504 | t_presence_history | 55949935 | 0 | 0.00 | 0.00 | | 2025-05-27 03:13:41.032342+00 | | |
| e202504 | t_sensor_history | 12827583 | 0 | 0.00 | 0.00 | | 2025-05-25 22:21:03.589633+00 | | |
| e202505 | a_proximity_sum | 27238672 | 0 | 0.00 | 0.00 | | 2025-05-30 04:08:31.560882+00 | | 2025-05-29 16:19:02.792973+00 |
| e202505 | a_stay_time | 38090040 | 0 | 0.00 | 0.00 | | 2025-05-30 04:09:58.429718+00 | | 2025-05-29 16:02:44.985667+00 |
| e202505 | t_position_history | 529592962 | 0 | 0.00 | 0.00 | | 2025-05-31 15:50:49.647737+00 | | 2025-05-29 09:21:32.439172+00 |
| e202505 | t_presence_history | 51968109 | 8080673 | 0.00 | 13.00 | | 2025-05-31 14:25:22.430657+00 | | 2025-05-31 14:26:54.53826+00 |
| e202505 | t_sensor_history | 12772022 | 0 | 0.00 | 0.00 | | 2025-05-28 05:11:36.349708+00 | | 2025-05-29 19:52:27.630154+00 |
| e202506 | a_proximity_sum | 92539 | 0 | 0.00 | 0.00 | | 2025-06-01 17:57:08.973903+00 | | 2025-06-01 17:57:09.083735+00 |
| e202506 | a_stay_time | 42706 | 0 | 0.00 | 0.00 | | 2025-06-01 17:36:11.962827+00 | | 2025-06-01 17:56:08.788805+00 |
| e202506 | t_position_history | 11387325 | 0 | 0.00 | 0.00 | | 2025-06-01 23:31:35.644814+00 | | 2025-06-02 00:23:05.972136+00 |
| e202506 | t_presence_history | 1344556 | 154465 | 0.00 | 10.00 | | 2025-06-02 00:53:43.647477+00 | | 2025-06-02 00:53:44.257619+00 |
| e202506 | t_sensor_history | 547592 | 0 | 0.00 | 0.00 | | 2025-06-02 00:29:05.52901+00 | | 2025-06-01 23:50:27.449643+00 |
| public | __digdag_status | 33 | 20 | 0.00 | 37.00 | | 2025-05-28 09:38:39.781808+00 | | 2025-05-28 12:35:51.665267+00 |
| public | a_attendance_sum | 115377 | 16459 | 0.00 | 12.00 | | 2025-06-02 00:35:43.26594+00 | | 2025-06-02 00:53:44.825178+00 |
| public | a_plan_actual | 513805 | 0 | 0.00 | 0.00 | | 2025-05-29 03:50:48.741604+00 | | 2025-05-28 16:40:47.032705+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-05-31 05:00:20.992609+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-05-31 04:51:44.212688+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-05-31 04:26:31.574785+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-05-25 06:33:37.86406+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:50.508171+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.55819+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.667563+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.577661+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:51.597435+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.686497+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.645265+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:57:50.528949+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.707344+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-05-24 17:54:10.72768+00 | | |
| public | l_area | 1331 | 11 | 0.00 | 0.00 | | 2025-05-27 11:11:25.765295+00 | | 2025-05-27 11:11:25.775817+00 |
| public | l_auth | 152 | 0 | 0.00 | 0.00 | | | | 2025-05-27 11:12:25.457228+00 |
| public | l_category | 2331 | 1 | 0.00 | 0.00 | | 2025-05-27 11:11:26.39329+00 | | 2025-05-27 11:11:26.410357+00 |
| public | l_group | 31503 | 65 | 0.00 | 0.00 | | 2025-05-27 11:11:26.683893+00 | | 2025-05-27 11:11:27.996149+00 |
| public | l_location | 87097 | 1801 | 0.00 | 2.00 | | 2025-05-27 11:11:25.960033+00 | | 2025-05-27 11:11:26.378793+00 |
| public | l_location_zone | 70097 | 2889 | 0.00 | 3.00 | | 2025-05-27 11:12:25.509799+00 | | 2025-05-27 11:12:25.615825+00 |
| public | l_outside | 402 | 4 | 0.00 | 0.00 | | | | 2025-05-27 11:12:25.473139+00 |
| public | l_pot | 348305 | 3042 | 0.00 | 0.00 | | 2025-05-27 11:11:28.531419+00 | | 2025-05-27 11:11:29.437553+00 |
| public | l_pot_category | 10072 | 39 | 0.00 | 0.00 | | 2025-05-27 11:12:25.632047+00 | | 2025-05-27 11:12:25.6537+00 |
| public | l_pot_group | 204502 | 780 | 0.00 | 0.00 | | 2025-05-27 11:12:25.900684+00 | | 2025-05-27 11:12:26.045879+00 |
| public | l_pot_tx | 83162 | 327 | 0.00 | 0.00 | | 2025-05-27 11:12:25.698626+00 | | 2025-05-27 11:12:25.810722+00 |
| public | l_role | 649 | 1 | 0.00 | 0.00 | | | | 2025-05-27 11:12:22.546994+00 |
| public | l_role_feature | 6049 | 11 | 0.00 | 0.00 | | 2025-05-27 11:15:22.632488+00 | | 2025-05-27 11:15:22.647362+00 |
| public | l_site | 227 | 5 | 0.00 | 2.00 | | | | 2025-05-27 11:11:25.791401+00 |
| public | l_tx | 126521 | 19567 | 0.00 | 13.00 | | 2025-05-27 11:11:26.478849+00 | | 2025-05-30 03:30:57.992274+00 |
| public | l_user | 54121 | 544 | 0.00 | 0.00 | | 2025-05-27 11:11:22.362279+00 | | 2025-05-27 11:11:22.891703+00 |
| public | l_zone | 8771 | 15 | 0.00 | 0.00 | | 2025-05-27 11:11:25.812029+00 | | 2025-05-27 11:11:25.89755+00 |
| public | l_zone_category | 4521 | 10 | 0.00 | 0.00 | | 2025-05-27 11:12:22.373918+00 | | 2025-05-27 11:12:22.386434+00 |
| public | m_area | 703 | 10 | 0.00 | 1.00 | | 2025-05-24 09:16:50.429727+00 | | |
| public | m_auth | 128 | 0 | 0.00 | 0.00 | | 2025-05-31 05:34:00.250294+00 | | |
| public | m_category | 2137 | 1 | 0.00 | 0.00 | | 2025-05-24 09:16:50.389205+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-05-26 01:49:36.63992+00 | | |
| public | m_exb | 23572 | 0 | 0.00 | 0.00 | | 2025-05-30 16:56:09.034986+00 | | |
| public | m_favorite | 218095 | 29 | 0.00 | 0.00 | | 2025-06-01 22:50:21.587615+00 | | |
| public | m_favorite_group | 99848 | 328 | 0.00 | 0.00 | | 2025-05-27 00:53:40.214436+00 | | |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-05-31 13:41:18.349723+00 | | |
| public | m_group | 25718 | 3648 | 0.00 | 12.00 | | 2025-05-31 14:40:49.564824+00 | | 2025-06-01 14:41:11.166854+00 |
| public | m_holiday | 35132 | 0 | 0.00 | 0.00 | | 2025-05-29 03:19:27.926386+00 | | |
| public | m_lob | 22988 | 37 | 0.00 | 0.00 | | 2025-05-29 07:02:59.355151+00 | | |
| public | m_lob_log | 1433 | 0 | 0.00 | 0.00 | | 2025-05-28 08:01:18.601693+00 | | |
| public | m_location | 39931 | 3592 | 0.00 | 8.00 | | 2025-05-24 02:12:18.464624+00 | | 2025-05-30 05:23:29.847873+00 |
| public | m_notify_template | 825 | 0 | 0.00 | 0.00 | | 2025-05-31 05:34:00.407353+00 | | |
| public | m_outside | 340 | 3 | 0.00 | 0.00 | | 2025-05-28 01:09:34.950703+00 | | |
| public | m_personal_setting | 122347 | 15062 | 0.00 | 10.00 | | 2025-05-29 00:55:12.822778+00 | | 2025-06-02 00:42:41.456661+00 |
| public | m_pot | 179858 | 30191 | 0.00 | 14.00 | | 2025-05-26 08:03:52.452517+00 | | 2025-06-02 00:02:25.067561+00 |
| public | m_pot_profile | 59932 | 4 | 0.00 | 0.00 | | 2025-05-29 23:06:19.839989+00 | | |
| public | m_provider_user | 77 | 0 | 0.00 | 0.00 | | 2025-05-31 22:42:21.76094+00 | | |
| public | m_region | 108 | 0 | 0.00 | 0.00 | | 2025-05-31 05:36:00.496593+00 | | |
| public | m_role | 652 | 0 | 0.00 | 0.00 | | 2025-05-31 05:34:00.479618+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-05-31 05:34:00.361759+00 | | |
| public | m_setting | 14608 | 1853 | 0.00 | 11.00 | | 2025-05-31 16:38:01.618946+00 | | 2025-06-01 22:36:39.783928+00 |
| public | m_setting_log | 33015 | 1360 | 0.00 | 3.00 | | 2025-05-29 17:34:41.211733+00 | | 2025-06-01 01:55:05.590849+00 |
| public | m_site | 175 | 0 | 0.00 | 0.00 | | 2025-05-31 05:34:00.21954+00 | | |
| public | m_tenant | 107 | 0 | 0.00 | 0.00 | | 2025-05-31 05:36:00.648272+00 | | |
| public | m_tx | 164387 | 103 | 0.00 | 0.00 | | 2025-05-30 09:51:28.210033+00 | | 2025-05-30 09:29:21.925069+00 |
| public | m_user | 32315 | 324 | 0.00 | 0.00 | | 2025-05-27 07:25:28.832952+00 | | 2025-05-26 02:24:57.849514+00 |
| public | m_zone | 6326 | 0 | 0.00 | 0.00 | | 2025-06-01 07:31:27.893929+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-05-31 04:26:31.550222+00 | | |
| public | r_auth_zone | 203 | 0 | 0.00 | 0.00 | | 2025-06-02 00:18:08.609332+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-05-31 05:34:00.432175+00 | | |
| public | r_group_auth | 528 | 0 | 0.00 | 0.00 | | 2025-05-25 23:40:57.04958+00 | | |
| public | r_location_zone | 49783 | 3401 | 0.00 | 6.00 | | 2025-05-24 09:16:50.284214+00 | | 2025-05-30 09:29:34.54286+00 |
| public | r_pot_auth | 5591 | 0 | 0.00 | 0.00 | | 2025-05-31 04:26:31.538889+00 | | 2025-05-22 10:14:59.569465+00 |
| public | r_pot_category | 10866 | 76 | 0.00 | 0.00 | | 2025-05-28 06:52:03.244902+00 | | 2025-06-01 14:41:11.200709+00 |
| public | r_pot_group | 318678 | 822 | 0.00 | 0.00 | | 2025-05-26 01:07:37.176419+00 | | |
| public | r_pot_tx | 62959 | 315 | 0.00 | 0.00 | | 2025-05-29 00:02:58.212009+00 | | |
| public | r_pot_user | 19646 | 10 | 0.00 | 0.00 | | 2025-05-29 08:31:17.002962+00 | | 2025-05-26 02:24:57.152566+00 |
| public | r_provider_tenant | 1171 | 177 | 0.00 | 13.00 | | 2025-05-26 04:20:05.832872+00 | | 2025-05-30 01:40:20.095227+00 |
| public | r_role_feature | 5688 | 12 | 0.00 | 0.00 | | 2025-05-27 01:45:39.52967+00 | | |
| public | r_tenant_feature | 4224 | 0 | 0.00 | 0.00 | | 2025-05-24 17:50:05.433606+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-05-26 13:50:53.168236+00 | | |
| public | r_user_region | 20475 | 6 | 0.00 | 0.00 | | 2025-05-29 08:33:10.909697+00 | | |
| public | r_user_site | 5531 | 0 | 0.00 | 0.00 | | 2025-05-31 05:34:00.338423+00 | | |
| public | r_zone_category | 4274 | 4 | 0.00 | 0.00 | | 2025-05-28 08:01:18.561223+00 | | |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-05-26 05:41:23.370326+00 | | |
| public | t_attendance | 2633067 | 45500 | 0.00 | 1.00 | | 2025-05-24 17:55:02.313335+00 | | |
| public | t_general | 3781 | 1 | 0.00 | 0.00 | | 2025-05-31 05:36:00.633271+00 | | |
| public | t_mobile_device_history | 1173772 | 0 | 0.00 | 0.00 | | 2025-05-31 23:54:03.120929+00 | | |
| public | t_mobile_status_history | 776610 | 0 | 0.00 | 0.00 | | 2025-05-29 05:26:38.053337+00 | | 2025-05-28 01:51:31.590592+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-05-31 05:34:00.455562+00 | | |
| public | t_notify_history | 5402285 | 3266 | 0.00 | 0.00 | | 2025-06-01 01:00:51.26006+00 | | |
| public | t_operation_log | 19881020 | 41 | 0.00 | 0.00 | | 2025-05-28 09:38:38.934476+00 | | |
| public | t_plan | 22912030 | 1326765 | 0.00 | 5.00 | | 2025-05-26 10:46:58.08304+00 | | 2025-05-29 09:34:12.263267+00 |
| public | t_plan_cancel_history | 379965 | 68668 | 0.00 | 15.00 | | 2025-05-28 07:19:54.247181+00 | | |
| public | t_plan_detail | 39259763 | 1486974 | 0.00 | 3.00 | | 2025-05-29 05:26:11.904656+00 | | 2025-05-30 08:59:29.208665+00 |
| public | t_plan_sync | 49373 | 5168 | 0.00 | 9.00 | | 2025-06-02 00:36:39.076087+00 | | 2025-06-02 00:38:39.318779+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-05-31 05:36:00.672019+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-05-31 04:26:31.628679+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-05-31 05:36:00.518061+00 | | |
| public | t_recv_position_history | 132950 | 74360 | 0.00 | 35.00 | | 2025-06-02 00:53:39.157735+00 | 2025-06-01 13:30:19.128681+00 | 2025-06-02 00:53:39.809629+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-05-31 04:26:31.687809+00 | | |
| public | t_terminal | 14289 | 979 | 0.00 | 6.00 | | 2025-06-01 23:41:22.970503+00 | | 2025-06-02 00:35:44.00632+00 |
| public | t_terminal_log | 21361491 | 0 | 0.00 | 0.00 | | 2025-05-28 05:43:47.323415+00 | | |
| public | temp_pivot_table | 241036 | 0 | 0.00 | 0.00 | | 2025-05-29 23:08:26.883548+00 | | |
| public | w_arrival_notify | 96 | 5 | 0.00 | 4.00 | | 2025-06-02 00:16:23.81692+00 | | 2025-05-30 04:59:50.324906+00 |
| public | w_latest_mobile_device | 52006 | 2513 | 0.00 | 4.00 | | 2025-05-26 07:20:53.109502+00 | | 2025-05-29 00:26:28.563749+00 |
| public | w_latest_mobile_status | 50940 | 5842 | 0.00 | 10.00 | | 2025-06-02 00:08:23.607124+00 | | 2025-06-02 00:41:41.753919+00 |
| public | w_latest_position | 71602 | 24698 | 0.00 | 25.00 | | 2025-06-02 00:53:39.989956+00 | | 2025-06-02 00:53:40.138929+00 |
| public | w_latest_presence | 216662 | 171312 | 0.00 | 44.00 | | 2025-06-02 00:54:02.951911+00 | | 2025-06-02 00:54:05.533835+00 |
| public | w_latest_sensor | 386 | 243 | 0.00 | 38.00 | | 2025-06-02 00:53:45.535466+00 | | 2025-06-02 00:53:45.651826+00 |
| public | w_lock | 16900 | 0 | 0.00 | 0.00 | | 2025-05-26 23:49:50.845851+00 | | |
| public | w_master_update | 191 | 8 | 0.00 | 4.00 | | 2025-06-02 00:50:40.365356+00 | | 2025-06-02 00:49:39.996853+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-05-31 08:50:16.557581+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-05-31 04:26:47.514234+00 | | |
| public | w_plan_with_detail | 22815571 | 236014 | 0.00 | 1.00 | | 2025-05-31 21:01:11.431277+00 | | 2025-05-29 09:00:14.101661+00 |