| 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 |
|---|
| e202510 | a_proximity_sum | 41494161 | 0 | 0.00 | 0.00 | | 2025-12-04 12:28:30.217261+00 | | 2025-10-31 17:24:22.03982+00 |
| e202510 | a_stay_time | 44674893 | 0 | 0.00 | 0.00 | | 2025-12-02 06:27:43.13349+00 | | 2025-10-31 16:15:51.689039+00 |
| e202510 | t_position_history | 641928839 | 0 | 0.00 | 0.00 | | 2025-12-04 05:16:52.924122+00 | | 2025-10-29 19:35:21.809624+00 |
| e202510 | t_presence_history | 65121806 | 0 | 0.00 | 0.00 | | 2025-12-05 06:06:55.802329+00 | | 2025-10-31 14:59:46.05603+00 |
| e202510 | t_sensor_history | 11673883 | 0 | 0.00 | 0.00 | | 2025-12-02 18:11:20.956757+00 | | 2025-10-30 01:18:33.550108+00 |
| e202511 | a_proximity_sum | 55788306 | 0 | 0.00 | 0.00 | | 2025-12-05 05:37:11.58356+00 | | 2025-11-29 16:49:11.217033+00 |
| e202511 | a_stay_time | 40273748 | 0 | 0.00 | 0.00 | | 2025-12-03 07:32:41.508209+00 | | 2025-11-28 20:10:59.778401+00 |
| e202511 | t_position_history | 561645401 | 0 | 0.00 | 0.00 | | 2025-12-03 10:24:01.357012+00 | | 2025-11-29 02:17:09.975534+00 |
| e202511 | t_presence_history | 52917296 | 0 | 0.00 | 0.00 | | 2025-12-04 08:45:35.678617+00 | | 2025-11-30 14:33:44.67193+00 |
| e202511 | t_sensor_history | 11233626 | 0 | 0.00 | 0.00 | | 2025-12-05 01:57:01.428414+00 | | 2025-11-28 12:39:29.055744+00 |
| e202512 | a_proximity_sum | 18217669 | 1253957 | 0.00 | 6.00 | | 2025-12-04 22:46:46.347397+00 | | 2025-12-05 17:55:58.108076+00 |
| e202512 | a_stay_time | 11145118 | 0 | 0.00 | 0.00 | | 2025-12-05 18:36:40.224101+00 | | 2025-12-05 17:38:49.766844+00 |
| e202512 | t_position_history | 135255144 | 4 | 0.00 | 0.00 | | 2025-12-05 11:10:21.433577+00 | | 2025-12-05 07:16:40.095065+00 |
| e202512 | t_presence_history | 11476778 | 2107572 | 0.00 | 15.00 | | 2025-12-06 00:40:06.279591+00 | | 2025-12-06 00:51:34.442406+00 |
| e202512 | t_sensor_history | 1989317 | 0 | 0.00 | 0.00 | | 2025-12-05 20:41:02.782634+00 | | 2025-12-05 13:56:57.74449+00 |
| public | __digdag_status | 35 | 5 | 0.00 | 12.00 | | 2025-12-05 00:46:42.395229+00 | | 2025-11-28 12:32:16.407126+00 |
| public | a_attendance_sum | 156138 | 551 | 0.00 | 0.00 | | 2025-12-05 17:28:37.52065+00 | | 2025-12-05 10:13:53.811337+00 |
| public | a_plan_actual | 1530361 | 0 | 0.00 | 0.00 | | 2025-12-05 06:05:35.343009+00 | | 2025-11-27 16:37:02.352391+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-12-04 23:33:46.155222+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-12-04 23:33:43.527673+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:41.31032+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-12-02 04:48:03.105022+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-12-05 22:40:47.308389+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-12-02 01:55:14.022851+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-12-05 22:39:24.554076+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-12-02 01:55:14.045604+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-12-02 01:55:14.065669+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-12-05 22:39:24.579738+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-12-05 22:39:24.531283+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-12-02 01:55:12.243458+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-12-05 22:39:24.601982+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-12-05 22:39:24.624597+00 | | |
| public | l_area | 1726 | 2 | 0.00 | 0.00 | | 2025-12-04 06:47:23.904692+00 | | 2025-11-20 04:34:00.972924+00 |
| public | l_auth | 196 | 0 | 0.00 | 0.00 | | 2025-12-04 06:47:23.815248+00 | | |
| public | l_category | 2696 | 0 | 0.00 | 0.00 | | 2025-12-04 06:47:24.284282+00 | | |
| public | l_group | 37060 | 34 | 0.00 | 0.00 | | 2025-12-04 06:47:24.741692+00 | | |
| public | l_lob | 2252 | 8 | 0.00 | 0.00 | | 2025-12-03 08:22:18.7388+00 | | 2025-11-25 02:07:03.012893+00 |
| public | l_location | 131898 | 679 | 0.00 | 0.00 | | 2025-12-04 23:34:18.767423+00 | | 2025-12-03 03:07:37.511058+00 |
| public | l_location_zone | 134965 | 12 | 0.00 | 0.00 | | 2025-12-05 04:51:10.844482+00 | | 2025-11-29 07:06:54.490052+00 |
| public | l_outside | 440 | 0 | 0.00 | 0.00 | | 2025-12-04 06:47:23.839035+00 | | |
| public | l_pot | 504203 | 551 | 0.00 | 0.00 | | 2025-12-04 06:47:33.878118+00 | | 2025-12-01 03:18:19.255248+00 |
| public | l_pot_category | 26802 | 79 | 0.00 | 0.00 | | 2025-12-05 04:51:11.124001+00 | | 2025-12-05 00:01:24.508055+00 |
| public | l_pot_group | 497940 | 293 | 0.00 | 0.00 | | 2025-12-05 04:51:14.920308+00 | | 2025-10-29 08:46:37.528183+00 |
| public | l_pot_tx | 151613 | 95 | 0.00 | 0.00 | | 2025-12-05 04:51:12.377653+00 | | 2025-12-03 07:20:12.846955+00 |
| public | l_role | 785 | 0 | 0.00 | 0.00 | | 2025-12-04 06:41:33.566519+00 | | |
| public | l_role_feature | 8054 | 0 | 0.00 | 0.00 | | 2025-12-05 04:49:58.503144+00 | | 2025-10-29 08:49:05.223461+00 |
| public | l_site | 258 | 0 | 0.00 | 0.00 | | 2025-12-04 06:47:23.936335+00 | | |
| public | l_tx | 146921 | 0 | 0.00 | 0.00 | | 2025-12-05 17:25:04.118768+00 | | 2025-12-05 07:29:42.138964+00 |
| public | l_user | 69982 | 257 | 0.00 | 0.00 | | 2025-12-04 06:41:33.464558+00 | | 2025-11-27 00:25:59.232006+00 |
| public | l_zone | 10790 | 0 | 0.00 | 0.00 | | 2025-12-04 06:47:24.178176+00 | | |
| public | l_zone_category | 6589 | 0 | 0.00 | 0.00 | | 2025-12-05 04:49:58.34163+00 | | 2025-10-29 08:47:04.390518+00 |
| public | m_area | 822 | 2 | 0.00 | 0.00 | | 2025-12-05 10:07:09.800991+00 | | 2025-12-05 12:08:26.097943+00 |
| public | m_auth | 149 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.209434+00 | | |
| public | m_category | 2438 | 0 | 0.00 | 0.00 | | 2025-12-05 10:07:09.751899+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-12-02 06:18:26.311509+00 | | |
| public | m_exb | 28726 | 80 | 0.00 | 0.00 | | 2025-12-04 12:28:08.761599+00 | | 2025-11-18 03:16:32.600306+00 |
| public | m_favorite | 194496 | 147 | 0.00 | 0.00 | | 2025-12-05 06:06:34.809156+00 | | 2025-12-03 07:18:48.83535+00 |
| public | m_favorite_group | 116139 | 3796 | 0.00 | 3.00 | | 2025-12-02 19:11:22.070695+00 | | 2025-12-03 07:18:48.571033+00 |
| public | m_feature | 171 | 0 | 0.00 | 0.00 | | 2025-12-05 00:46:06.596501+00 | | |
| public | m_group | 28838 | 1280 | 0.00 | 4.00 | | 2025-12-04 05:08:47.581393+00 | | 2025-12-05 14:41:49.909825+00 |
| public | m_holiday | 41705 | 0 | 0.00 | 0.00 | | 2025-12-03 11:39:15.881712+00 | | |
| public | m_lob | 21971 | 28 | 0.00 | 0.00 | | 2025-12-03 11:36:58.986549+00 | | |
| public | m_lob_log | 5976 | 0 | 0.00 | 0.00 | | 2025-12-03 11:39:15.772976+00 | | 2025-12-02 20:01:23.488624+00 |
| public | m_location | 47381 | 636 | 0.00 | 1.00 | | 2025-12-05 09:24:33.523939+00 | | 2025-11-30 10:37:30.022123+00 |
| public | m_notify_template | 1215 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.410495+00 | | |
| public | m_outside | 367 | 0 | 0.00 | 0.00 | | 2025-12-03 06:05:38.261577+00 | | |
| public | m_personal_setting | 124907 | 1636 | 0.00 | 1.00 | | 2025-12-05 17:28:29.06745+00 | | 2025-12-05 14:11:49.379068+00 |
| public | m_pot | 212731 | 7275 | 0.00 | 3.00 | | 2025-12-04 09:28:18.176875+00 | | 2025-12-04 14:40:40.437191+00 |
| public | m_pot_profile | 57967 | 19 | 0.00 | 0.00 | | 2025-12-04 06:28:30.328182+00 | | |
| public | m_provider_user | 86 | 0 | 0.00 | 0.00 | | 2025-12-05 00:46:46.263697+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.534959+00 | | |
| public | m_role | 788 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.508828+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.357948+00 | | |
| public | m_setting | 16066 | 2523 | 0.00 | 13.00 | | 2025-12-05 06:18:33.367467+00 | | 2025-12-05 20:03:22.744392+00 |
| public | m_setting_log | 37999 | 5690 | 0.00 | 13.00 | | 2025-12-04 15:00:27.193927+00 | | 2025-12-05 12:31:32.197684+00 |
| public | m_site | 188 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.182257+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.570192+00 | | |
| public | m_tx | 142118 | 0 | 0.00 | 0.00 | | 2025-12-05 17:25:09.113737+00 | | 2025-12-05 13:33:39.937553+00 |
| public | m_user | 37182 | 174 | 0.00 | 0.00 | | 2025-12-03 01:21:38.808401+00 | | 2025-12-02 09:51:45.064708+00 |
| public | m_zone | 8023 | 12 | 0.00 | 0.00 | | 2025-12-05 00:46:49.180033+00 | | 2025-12-02 09:09:49.640452+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-12-04 23:33:41.287355+00 | | |
| public | r_auth_zone | 175 | 0 | 0.00 | 0.00 | | 2025-12-05 06:06:34.820546+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.435575+00 | | |
| public | r_group_auth | 446 | 1 | 0.00 | 0.00 | | 2025-12-02 04:24:48.304639+00 | | 2025-11-17 06:43:36.264507+00 |
| public | r_location_zone | 56554 | 6 | 0.00 | 0.00 | | 2025-12-05 10:07:09.615795+00 | | 2025-11-28 07:33:28.813592+00 |
| public | r_pot_auth | 8410 | 4 | 0.00 | 0.00 | | 2025-12-03 11:35:36.192411+00 | | 2025-11-28 05:28:47.020235+00 |
| public | r_pot_category | 11978 | 255 | 0.00 | 2.00 | | 2025-12-03 08:22:18.675952+00 | | 2025-11-28 00:03:05.894062+00 |
| public | r_pot_group | 411127 | 4407 | 0.00 | 1.00 | | 2025-12-02 06:18:26.285851+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-12-05 00:46:46.3546+00 | | |
| public | r_pot_tx | 70429 | 384 | 0.00 | 0.00 | | 2025-12-03 11:36:59.627229+00 | | 2025-12-01 11:13:11.715075+00 |
| public | r_pot_user | 20779 | 5 | 0.00 | 0.00 | | 2025-12-03 11:36:58.683859+00 | | 2025-12-03 02:39:54.914143+00 |
| public | r_provider_tenant | 929 | 216 | 0.00 | 18.00 | | 2025-12-02 04:08:24.522536+00 | | 2025-12-02 04:08:24.52368+00 |
| public | r_role_feature | 6724 | 25 | 0.00 | 0.00 | | 2025-12-02 23:52:35.376084+00 | | |
| public | r_tenant_feature | 4514 | 0 | 0.00 | 0.00 | | 2025-12-05 22:39:21.033685+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-12-02 17:26:55.085836+00 | | |
| public | r_user_region | 21700 | 5 | 0.00 | 0.00 | | 2025-12-03 11:35:36.343478+00 | | 2025-12-03 08:08:50.88222+00 |
| public | r_user_site | 5165 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.330262+00 | | 2025-11-17 06:49:36.429664+00 |
| public | r_zone_category | 5292 | 0 | 0.00 | 0.00 | | 2025-12-03 08:22:18.11182+00 | | |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-12-02 06:47:30.381718+00 | | |
| public | t_attendance | 3762289 | 5 | 0.00 | 0.00 | | 2025-12-05 22:40:47.291304+00 | | 2025-11-28 04:00:24.432875+00 |
| public | t_general | 4413 | 3 | 0.00 | 0.00 | | 2025-12-02 04:48:02.006013+00 | | |
| public | t_general_20250618 | 2629 | 0 | 0.00 | 0.00 | | 2025-12-03 04:04:53.710546+00 | | |
| public | t_job | 58 | 0 | 0.00 | 0.00 | | 2025-12-03 08:22:18.786105+00 | | |
| public | t_mobile_device_history | 1427282 | 0 | 0.00 | 0.00 | | 2025-12-05 00:46:06.5541+00 | | |
| public | t_mobile_status_history | 2426330 | 0 | 0.00 | 0.00 | | 2025-12-03 11:39:16.736714+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.465742+00 | | |
| public | t_notify_history | 7422563 | 11148 | 0.00 | 0.00 | | 2025-12-05 00:46:42.268245+00 | | 2025-11-17 06:24:32.780981+00 |
| public | t_operation_log | 26539934 | 18 | 0.00 | 0.00 | | 2025-12-03 11:37:55.750894+00 | | |
| public | t_plan | 28542427 | 4156410 | 0.00 | 12.00 | | 2025-12-02 13:27:39.411013+00 | | 2025-12-05 02:18:19.540211+00 |
| public | t_plan_cancel_history | 808725 | 35893 | 0.00 | 4.00 | | 2025-12-04 05:09:08.282607+00 | | 2025-11-17 06:40:32.133611+00 |
| public | t_plan_detail | 52919160 | 4211762 | 0.00 | 7.00 | | 2025-12-05 08:32:50.07332+00 | | 2025-12-05 04:02:16.198504+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-12-05 00:46:46.330205+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-12-05 00:46:46.305897+00 | | |
| public | t_plan_sync | 72726 | 3878 | 0.00 | 5.00 | | 2025-12-06 00:33:48.76497+00 | | 2025-12-06 00:33:49.10465+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-12-04 23:33:46.611133+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-12-04 23:33:41.344685+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-12-04 23:33:46.552867+00 | | |
| public | t_recv_position_history | 159979 | 8405 | 0.00 | 4.00 | | 2025-12-06 00:55:58.149113+00 | 2025-12-05 13:31:14.50686+00 | 2025-12-06 00:55:58.586567+00 |
| public | t_safr_event_history | 0 | 0 | 0 | 0 | | 2025-12-02 04:23:47.055222+00 | | |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-12-04 23:33:41.392738+00 | | |
| public | t_terminal | 20252 | 2455 | 0.00 | 10.00 | | 2025-12-05 20:50:47.761271+00 | | 2025-12-06 00:43:23.30518+00 |
| public | t_terminal_log | 36837867 | 0 | 0.00 | 0.00 | | 2025-12-03 08:23:07.086877+00 | | 2025-11-24 08:37:11.884041+00 |
| public | temp_pivot_table | 238977 | 0 | 0.00 | 0.00 | | 2025-12-04 06:28:32.024601+00 | | |
| public | w_arrival_notify | 100 | 14 | 0.00 | 12.00 | | 2025-12-05 08:09:44.119677+00 | | 2025-12-05 08:34:18.166303+00 |
| public | w_latest_mobile_device | 56606 | 3605 | 0.00 | 5.00 | | 2025-12-02 09:11:49.858645+00 | | 2025-12-05 06:13:33.761361+00 |
| public | w_latest_mobile_status | 55612 | 873 | 0.00 | 1.00 | | 2025-12-05 17:28:31.134081+00 | | 2025-12-06 00:44:42.391055+00 |
| public | w_latest_position | 78098 | 8317 | 0.00 | 9.00 | | 2025-12-06 00:50:39.304213+00 | | 2025-12-06 00:54:44.734061+00 |
| public | w_latest_presence | 99176 | 83729 | 0.00 | 45.00 | | 2025-12-06 00:55:30.080174+00 | | 2025-12-06 00:55:32.796426+00 |
| public | w_latest_sensor | 386 | 46 | 0.00 | 10.00 | | 2025-12-06 00:55:58.600654+00 | | 2025-12-06 00:55:59.672446+00 |
| public | w_lock | 19973 | 18 | 0.00 | 0.00 | | 2025-12-02 19:11:19.608989+00 | | |
| public | w_master_update | 507 | 63 | 0.00 | 11.00 | | 2025-12-05 17:28:23.693908+00 | | 2025-12-05 13:13:48.30885+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-12-05 00:46:46.237106+00 | | |
| public | w_plan_sync_retry | 0 | 1 | 0 | 100.00 | | 2025-12-05 17:28:37.675019+00 | | 2025-12-05 10:20:42.26302+00 |
| public | w_plan_with_detail | 28580542 | 1673468 | 0.00 | 5.00 | | 2025-12-05 00:44:58.197147+00 | | 2025-12-05 00:55:11.322434+00 |