| 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 | 41494145 | 0 | 0.00 | 0.00 | | 2025-12-09 05:46:16.303515+00 | | 2025-10-31 17:24:22.03982+00 |
| e202510 | a_stay_time | 44674841 | 0 | 0.00 | 0.00 | | 2025-12-06 21:49:41.610627+00 | | 2025-10-31 16:15:51.689039+00 |
| e202510 | t_position_history | 641929033 | 0 | 0.00 | 0.00 | | 2025-12-09 05:13:40.33875+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 | 11673871 | 0 | 0.00 | 0.00 | | 2025-12-07 20:43:30.115545+00 | | 2025-10-30 01:18:33.550108+00 |
| e202511 | a_proximity_sum | 55877975 | 71389 | 0.00 | 0.00 | | 2025-12-05 05:37:11.58356+00 | | 2025-11-29 16:49:11.217033+00 |
| e202511 | a_stay_time | 40837145 | 473121 | 0.00 | 1.00 | | 2025-12-08 07:31:55.473139+00 | | 2025-11-28 20:10:59.778401+00 |
| e202511 | t_position_history | 561644764 | 0 | 0.00 | 0.00 | | 2025-12-08 10:10:12.117768+00 | | 2025-11-29 02:17:09.975534+00 |
| e202511 | t_presence_history | 52917266 | 0 | 0.00 | 0.00 | | 2025-12-09 05:48:09.675079+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 | 23339136 | 33303 | 0.00 | 0.00 | | 2025-12-09 05:52:03.743529+00 | | 2025-12-09 16:00:20.947796+00 |
| e202512 | a_stay_time | 16220412 | 61325 | 0.00 | 0.00 | | 2025-12-08 17:39:28.293805+00 | | 2025-12-09 17:55:32.858915+00 |
| e202512 | t_position_history | 214501723 | 21 | 0.00 | 0.00 | | 2025-12-09 06:29:54.45857+00 | | 2025-12-09 08:32:03.543073+00 |
| e202512 | t_presence_history | 15717823 | 258369465 | 16.00 | 94.00 | | 2025-12-10 00:51:47.243222+00 | | 2025-12-10 00:39:04.238489+00 |
| e202512 | t_sensor_history | 3467664 | 0 | 0.00 | 0.00 | | 2025-12-08 17:46:36.583433+00 | | 2025-12-09 18:54:25.639659+00 |
| public | __digdag_status | 35 | 4 | 0.00 | 10.00 | | 2025-12-09 23:08:10.828068+00 | | 2025-12-08 12:30:49.860087+00 |
| public | a_attendance_sum | 196760 | 347400 | 1.00 | 63.00 | | 2025-12-10 00:52:14.335907+00 | | 2025-12-10 00:22:49.13869+00 |
| public | a_plan_actual | 1569522 | 3478 | 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-09 23:07:32.544513+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-12-09 23:07:19.152872+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:07.683903+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-12-06 13:33:10.432068+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-06 02:28:39.446062+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-06 02:28:39.46825+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-12-06 02:28:39.488806+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-06 02:28:37.367241+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 | 1735 | 5 | 0.00 | 0.00 | | 2025-12-09 05:52:03.868117+00 | | 2025-11-20 04:34:00.972924+00 |
| public | l_auth | 197 | 0 | 0.00 | 0.00 | | 2025-12-09 05:52:03.775783+00 | | |
| public | l_category | 2763 | 44 | 0.00 | 1.00 | | 2025-12-09 05:52:04.10973+00 | | |
| public | l_group | 37135 | 90 | 0.00 | 0.00 | | 2025-12-09 05:52:04.442186+00 | | |
| public | l_lob | 2263 | 6 | 0.00 | 0.00 | | 2025-12-08 08:20:20.110342+00 | | 2025-11-25 02:07:03.012893+00 |
| public | l_location | 130755 | 243 | 0.00 | 0.00 | | 2025-12-09 23:11:31.104717+00 | | 2025-12-03 03:07:37.511058+00 |
| public | l_location_zone | 135310 | 103 | 0.00 | 0.00 | | 2025-12-05 04:51:10.844482+00 | | 2025-11-29 07:06:54.490052+00 |
| public | l_outside | 443 | 2 | 0.00 | 0.00 | | 2025-12-09 05:52:03.802184+00 | | |
| public | l_pot | 500273 | 1191 | 0.00 | 0.00 | | 2025-12-09 05:52:08.81559+00 | | 2025-12-01 03:18:19.255248+00 |
| public | l_pot_category | 27501 | 423 | 0.00 | 1.00 | | 2025-12-05 04:51:11.124001+00 | | 2025-12-05 00:01:24.508055+00 |
| public | l_pot_group | 498649 | 503 | 0.00 | 0.00 | | 2025-12-05 04:51:14.920308+00 | | 2025-10-29 08:46:37.528183+00 |
| public | l_pot_tx | 152542 | 674 | 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-09 05:44:55.6197+00 | | |
| public | l_role_feature | 8059 | 7 | 0.00 | 0.00 | | 2025-12-05 04:49:58.503144+00 | | 2025-10-29 08:49:05.223461+00 |
| public | l_site | 259 | 1 | 0.00 | 0.00 | | 2025-12-09 05:52:03.889387+00 | | |
| public | l_tx | 165087 | 14919 | 0.00 | 8.00 | | 2025-12-09 00:57:33.842345+00 | | 2025-12-08 05:51:32.908164+00 |
| public | l_user | 70328 | 549 | 0.00 | 0.00 | | 2025-12-09 05:44:55.570336+00 | | 2025-11-27 00:25:59.232006+00 |
| public | l_zone | 11059 | 55 | 0.00 | 0.00 | | 2025-12-09 05:52:04.046275+00 | | |
| public | l_zone_category | 6587 | 27 | 0.00 | 0.00 | | 2025-12-05 04:49:58.34163+00 | | 2025-12-07 11:39:14.825058+00 |
| public | m_area | 824 | 24 | 0.00 | 2.00 | | 2025-12-05 10:07:09.800991+00 | | 2025-12-05 12:08:26.097943+00 |
| public | m_auth | 150 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.077167+00 | | |
| public | m_category | 2463 | 44 | 0.00 | 1.00 | | 2025-12-05 10:07:09.751899+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-12-06 20:59:31.842016+00 | | |
| public | m_exb | 28722 | 123 | 0.00 | 0.00 | | 2025-12-09 05:44:34.069919+00 | | 2025-11-18 03:16:32.600306+00 |
| public | m_favorite | 195226 | 390 | 0.00 | 0.00 | | 2025-12-05 06:06:34.809156+00 | | 2025-12-03 07:18:48.83535+00 |
| public | m_favorite_group | 116943 | 40 | 0.00 | 0.00 | | 2025-12-07 20:43:26.767243+00 | | 2025-12-03 07:18:48.571033+00 |
| public | m_feature | 171 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.313467+00 | | |
| public | m_group | 28844 | 2746 | 0.00 | 8.00 | | 2025-12-09 05:04:19.789361+00 | | 2025-12-09 14:42:20.416449+00 |
| public | m_holiday | 41626 | 0 | 0.00 | 0.00 | | 2025-12-08 11:29:44.898482+00 | | |
| public | m_lob | 22251 | 15 | 0.00 | 0.00 | | 2025-12-08 11:26:24.539095+00 | | |
| public | m_lob_log | 5970 | 0 | 0.00 | 0.00 | | 2025-12-08 11:29:44.877697+00 | | 2025-12-02 20:01:23.488624+00 |
| public | m_location | 47397 | 1971 | 0.00 | 3.00 | | 2025-12-05 09:24:33.523939+00 | | 2025-12-07 14:16:16.394151+00 |
| public | m_notify_template | 1215 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.294557+00 | | |
| public | m_outside | 368 | 1 | 0.00 | 0.00 | | 2025-12-08 06:07:45.760775+00 | | |
| public | m_personal_setting | 125512 | 197564 | 1.00 | 61.00 | | 2025-12-10 00:52:12.707427+00 | | 2025-12-10 00:10:13.461943+00 |
| public | m_pot | 213538 | 16656 | 0.00 | 7.00 | | 2025-12-09 05:44:53.994686+00 | | 2025-12-08 14:42:18.308136+00 |
| public | m_pot_profile | 58469 | 29 | 0.00 | 0.00 | | 2025-12-09 05:44:09.457974+00 | | |
| public | m_provider_user | 86 | 10 | 0.00 | 10.00 | | 2025-12-09 23:08:12.831048+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.415037+00 | | |
| public | m_role | 788 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.395345+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.245395+00 | | |
| public | m_setting | 27213 | 3848 | 0.00 | 12.00 | | 2025-12-09 07:25:33.65193+00 | | 2025-12-09 07:22:11.777842+00 |
| public | m_setting_log | 38592 | 4362 | 0.00 | 10.00 | | 2025-12-06 12:31:40.573463+00 | | 2025-12-09 12:31:43.580627+00 |
| public | m_site | 188 | 1 | 0.00 | 0.00 | | 2025-12-09 23:07:34.053747+00 | | |
| public | m_tenant | 113 | 1 | 0.00 | 0.00 | | 2025-12-09 23:07:34.654401+00 | | |
| public | m_tx | 259846 | 55199 | 0.00 | 17.00 | | 2025-12-10 00:51:48.2503+00 | | 2025-12-09 02:55:11.401849+00 |
| public | m_user | 38640 | 523 | 0.00 | 1.00 | | 2025-12-08 01:58:47.089803+00 | | 2025-12-02 09:51:45.064708+00 |
| public | m_zone | 8076 | 44 | 0.00 | 0.00 | | 2025-12-09 23:08:14.688554+00 | | 2025-12-02 09:09:49.640452+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-12-09 23:07:07.656502+00 | | |
| public | r_auth_zone | 176 | 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-09 23:07:34.339999+00 | | |
| public | r_group_auth | 460 | 0 | 0.00 | 0.00 | | 2025-12-06 12:02:55.525011+00 | | 2025-11-17 06:43:36.264507+00 |
| public | r_location_zone | 56850 | 55 | 0.00 | 0.00 | | 2025-12-05 10:07:09.615795+00 | | 2025-11-28 07:33:28.813592+00 |
| public | r_pot_auth | 9012 | 1 | 0.00 | 0.00 | | 2025-12-08 11:24:30.895789+00 | | 2025-11-28 05:28:47.020235+00 |
| public | r_pot_category | 12333 | 343 | 0.00 | 2.00 | | 2025-12-08 08:20:19.94758+00 | | 2025-12-08 06:01:44.928417+00 |
| public | r_pot_group | 418759 | 127 | 0.00 | 0.00 | | 2025-12-06 20:59:31.816966+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-12-09 23:08:12.913529+00 | | |
| public | r_pot_tx | 71850 | 568 | 0.00 | 0.00 | | 2025-12-08 11:26:24.941989+00 | | 2025-12-01 11:13:11.715075+00 |
| public | r_pot_user | 21388 | 5 | 0.00 | 0.00 | | 2025-12-08 11:26:24.264505+00 | | 2025-12-03 02:39:54.914143+00 |
| public | r_provider_tenant | 931 | 643 | 0.00 | 40.00 | | 2025-12-10 00:52:14.347361+00 | | 2025-12-09 00:35:22.82254+00 |
| public | r_role_feature | 6722 | 7 | 0.00 | 0.00 | | 2025-12-08 00:06:33.535896+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-07 20:40:29.642391+00 | | |
| public | r_user_region | 21705 | 6 | 0.00 | 0.00 | | 2025-12-08 11:24:31.183022+00 | | 2025-12-03 08:08:50.88222+00 |
| public | r_user_site | 5464 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.2152+00 | | 2025-11-17 06:49:36.429664+00 |
| public | r_zone_category | 5625 | 26 | 0.00 | 0.00 | | 2025-12-08 08:20:19.827471+00 | | 2025-12-07 11:39:14.852119+00 |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-12-06 23:12:28.569236+00 | | |
| public | t_attendance | 3791436 | 25263 | 0.00 | 0.00 | | 2025-12-05 22:40:47.291304+00 | | 2025-11-28 04:00:24.432875+00 |
| public | t_general | 4646 | 7 | 0.00 | 0.00 | | 2025-12-06 13:33:10.068006+00 | | |
| public | t_general_20250618 | 2590 | 0 | 0.00 | 0.00 | | 2025-12-08 04:10:14.863998+00 | | |
| public | t_job | 58 | 0 | 0.00 | 0.00 | | 2025-12-08 08:20:20.136309+00 | | |
| public | t_mobile_device_history | 1386763 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.03253+00 | | |
| public | t_mobile_status_history | 2614266 | 0 | 0.00 | 0.00 | | 2025-12-08 11:29:46.442962+00 | | 2025-12-08 03:15:06.269743+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-12-09 23:07:34.367152+00 | | |
| public | t_notify_history | 7446901 | 18458 | 0.00 | 0.00 | | 2025-12-09 23:08:10.699585+00 | | 2025-11-17 06:24:32.780981+00 |
| public | t_operation_log | 26521777 | 12 | 0.00 | 0.00 | | 2025-12-08 11:28:03.106753+00 | | |
| public | t_plan | 28903548 | 5205046 | 0.00 | 15.00 | | 2025-12-07 16:17:41.800742+00 | | 2025-12-09 01:53:41.145431+00 |
| public | t_plan_cancel_history | 813925 | 12408 | 0.00 | 1.00 | | 2025-12-09 05:04:42.2514+00 | | 2025-11-17 06:40:32.133611+00 |
| public | t_plan_detail | 53386937 | 8837703 | 0.00 | 14.00 | | 2025-12-09 08:11:35.051855+00 | | 2025-12-09 05:03:51.076953+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-12-09 23:08:12.892415+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-12-09 23:08:12.867176+00 | | |
| public | t_plan_sync | 72781 | 216617 | 2.00 | 74.00 | | 2025-12-10 00:52:12.512173+00 | | 2025-12-10 00:35:18.593294+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-12-09 23:08:10.728501+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-12-09 23:07:07.883519+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-12-09 23:07:34.437374+00 | | |
| public | t_recv_position_history | 171819 | 23954872 | 139.00 | 99.00 | | 2025-12-10 00:51:58.639625+00 | 2025-12-09 13:31:45.114964+00 | 2025-12-10 00:51:59.172213+00 |
| public | t_safr_event_history | 0 | 0 | 0 | 0 | | 2025-12-06 11:59:37.127145+00 | | |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-12-09 23:07:08.042952+00 | | |
| public | t_terminal | 20274 | 173680 | 8.00 | 89.00 | | 2025-12-10 00:52:14.803577+00 | | 2025-12-10 00:39:31.749987+00 |
| public | t_terminal_log | 37192120 | 0 | 0.00 | 0.00 | | 2025-12-08 08:21:13.175987+00 | | 2025-11-24 08:37:11.884041+00 |
| public | temp_pivot_table | 238906 | 0 | 0.00 | 0.00 | | 2025-12-09 05:44:58.262916+00 | | |
| public | w_arrival_notify | 102 | 36 | 0.00 | 26.00 | | 2025-12-05 08:09:44.119677+00 | | 2025-12-05 08:34:18.166303+00 |
| public | w_latest_mobile_device | 56823 | 2130 | 0.00 | 3.00 | | 2025-12-07 08:26:02.733074+00 | | 2025-12-05 06:13:33.761361+00 |
| public | w_latest_mobile_status | 55827 | 91840 | 1.00 | 62.00 | | 2025-12-10 00:52:13.462814+00 | | 2025-12-10 00:06:09.509263+00 |
| public | w_latest_position | 80707 | 34360283 | 425.00 | 99.00 | | 2025-12-10 00:52:11.726908+00 | | 2025-12-10 00:52:12.290845+00 |
| public | w_latest_presence | 148367 | 261343083 | 1761.00 | 99.00 | | 2025-12-10 00:49:15.973216+00 | | 2025-12-10 00:49:16.428955+00 |
| public | w_latest_sensor | 386 | 532427 | 1379.00 | 99.00 | | 2025-12-10 00:52:15.035423+00 | | 2025-12-10 00:52:15.395723+00 |
| public | w_lock | 20090 | 0 | 0.00 | 0.00 | | 2025-12-07 20:43:25.503192+00 | | |
| public | w_master_update | 507 | 644 | 1.00 | 55.00 | | 2025-12-10 00:52:12.312178+00 | | 2025-12-09 20:08:40.295974+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-12-09 23:08:12.796879+00 | | |
| public | w_plan_sync_retry | 0 | 30 | 0 | 100.00 | | 2025-12-09 23:19:25.147063+00 | | 2025-12-09 08:45:49.619929+00 |
| public | w_plan_with_detail | 28894444 | 3287019 | 0.00 | 10.00 | | 2025-12-09 10:01:11.526206+00 | | 2025-12-09 00:41:28.955437+00 |