| 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 |
|---|
| e202508 | a_proximity_sum | 32424121 | 0 | 0.00 | 0.00 | | 2025-10-02 01:01:03.10771+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36269725 | 0 | 0.00 | 0.00 | | 2025-10-02 07:25:51.629311+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582013161 | 0 | 0.00 | 0.00 | | 2025-09-30 01:14:54.329299+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 54679005 | 0 | 0.00 | 0.00 | | 2025-10-02 02:01:26.956091+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764783 | 0 | 0.00 | 0.00 | | 2025-09-29 07:57:32.843752+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 29568114 | 0 | 0.00 | 0.00 | | 2025-09-29 17:32:29.741943+00 | | 2025-09-30 15:54:26.616538+00 |
| e202509 | a_stay_time | 38733918 | 0 | 0.00 | 0.00 | | 2025-09-30 13:45:23.224814+00 | | 2025-09-30 17:25:54.238102+00 |
| e202509 | t_position_history | 598740644 | 267 | 0.00 | 0.00 | | 2025-09-29 01:48:58.159382+00 | | 2025-09-29 20:40:54.897196+00 |
| e202509 | t_presence_history | 56847880 | 4947215 | 0.00 | 8.00 | | 2025-09-30 13:59:20.140036+00 | | 2025-09-30 14:47:50.312729+00 |
| e202509 | t_sensor_history | 11647042 | 0 | 0.00 | 0.00 | | 2025-09-28 21:23:01.795283+00 | | 2025-09-29 19:30:39.022501+00 |
| e202510 | a_proximity_sum | 3259228 | 0 | 0.00 | 0.00 | | 2025-10-02 19:05:31.297198+00 | | 2025-10-02 18:36:41.439954+00 |
| e202510 | a_stay_time | 4070432 | 0 | 0.00 | 0.00 | | 2025-10-02 17:51:45.882364+00 | | 2025-10-02 18:53:41.145972+00 |
| e202510 | t_position_history | 57839472 | 0 | 0.00 | 0.00 | | 2025-10-02 08:55:39.308517+00 | | 2025-10-02 19:40:32.041649+00 |
| e202510 | t_presence_history | 5383774 | 1048730 | 0.00 | 16.00 | | 2025-10-03 00:46:09.122177+00 | | 2025-10-03 00:48:50.08869+00 |
| e202510 | t_sensor_history | 928442 | 0 | 0.00 | 0.00 | | 2025-10-02 18:51:41.918741+00 | | 2025-10-02 20:25:56.762409+00 |
| public | __digdag_status | 33 | 3 | 0.00 | 8.00 | | 2025-10-01 21:31:14.579211+00 | | 2025-09-24 12:30:52.444456+00 |
| public | a_attendance_sum | 161129 | 25720 | 0.00 | 13.00 | | 2025-09-30 00:17:12.62908+00 | | 2025-10-03 00:27:43.003158+00 |
| public | a_plan_actual | 1193153 | 0 | 0.00 | 0.00 | | 2025-09-29 06:40:51.038075+00 | | 2025-09-19 16:41:52.537694+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:09.260565+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:09.249504+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:08.198039+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-09-30 02:16:43.326733+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-09-29 15:04:14.591899+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-09-29 20:59:48.518944+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.508183+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-09-29 20:59:48.542343+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-09-29 20:59:48.562157+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.5286+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.484714+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-09-29 20:52:32.085624+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.552228+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.578587+00 | | |
| public | l_area | 1579 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:39.64785+00 | | |
| public | l_auth | 197 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:39.589169+00 | | |
| public | l_category | 2680 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:41.26585+00 | | |
| public | l_group | 36411 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:45.296606+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2037 | 2 | 0.00 | 0.00 | | 2025-10-01 14:32:15.236015+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 117829 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:41.090779+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 108769 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:40.158999+00 | | 2025-09-12 06:37:57.741842+00 |
| public | l_outside | 454 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:39.618309+00 | | |
| public | l_pot | 462755 | 39 | 0.00 | 0.00 | | 2025-10-02 19:45:53.129589+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 14171 | 2 | 0.00 | 0.00 | | 2025-10-02 19:45:41.254609+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 236304 | 18 | 0.00 | 0.00 | | 2025-10-02 19:45:44.934365+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 104120 | 68 | 0.00 | 0.00 | | 2025-10-02 19:45:42.380849+00 | | 2025-10-02 00:02:22.235052+00 |
| public | l_role | 781 | 0 | 0.00 | 0.00 | | 2025-10-02 19:44:32.253817+00 | | |
| public | l_role_feature | 7020 | 0 | 0.00 | 0.00 | | 2025-10-02 19:44:32.214734+00 | | |
| public | l_site | 258 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:39.665934+00 | | |
| public | l_tx | 151431 | 29377 | 0.00 | 16.00 | | 2025-10-01 05:53:00.519008+00 | | 2025-10-01 23:48:25.465012+00 |
| public | l_user | 66019 | 40 | 0.00 | 0.00 | | 2025-10-02 19:44:32.12576+00 | | 2025-09-30 09:16:26.739287+00 |
| public | l_zone | 9904 | 0 | 0.00 | 0.00 | | 2025-10-02 19:45:40.246889+00 | | |
| public | l_zone_category | 5052 | 0 | 0.00 | 0.00 | | 2025-10-02 19:44:30.893099+00 | | |
| public | m_area | 792 | 9 | 0.00 | 1.00 | | 2025-09-29 09:46:56.388562+00 | | 2025-10-01 05:38:37.738397+00 |
| public | m_auth | 152 | 18 | 0.00 | 10.00 | | 2025-09-28 08:26:24.228097+00 | | |
| public | m_category | 2449 | 0 | 0.00 | 0.00 | | 2025-09-29 09:46:56.352543+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-09-30 04:08:10.510591+00 | | |
| public | m_exb | 27511 | 0 | 0.00 | 0.00 | | 2025-09-27 23:13:41.371815+00 | | |
| public | m_favorite | 240080 | 3048 | 0.00 | 1.00 | | 2025-09-29 04:36:20.461205+00 | | |
| public | m_favorite_group | 117888 | 681 | 0.00 | 0.00 | | 2025-09-30 20:29:56.419371+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-09-28 19:17:20.699203+00 | | |
| public | m_group | 29094 | 3824 | 0.00 | 11.00 | | 2025-09-30 12:58:57.925093+00 | | 2025-10-02 14:40:59.936546+00 |
| public | m_holiday | 43676 | 0 | 0.00 | 0.00 | | 2025-10-02 02:45:09.2+00 | | |
| public | m_lob | 24760 | 23 | 0.00 | 0.00 | | 2025-10-02 06:10:36.447202+00 | | |
| public | m_lob_log | 2357 | 0 | 0.00 | 0.00 | | 2025-10-01 18:45:08.351914+00 | | 2025-09-29 04:32:21.117028+00 |
| public | m_location | 45500 | 3005 | 0.00 | 6.00 | | 2025-09-29 07:57:31.141608+00 | | 2025-10-01 00:59:46.898895+00 |
| public | m_notify_template | 1242 | 1 | 0.00 | 0.00 | | 2025-09-28 08:26:24.393836+00 | | |
| public | m_outside | 377 | 0 | 0.00 | 0.00 | | 2025-10-01 06:58:10.082658+00 | | |
| public | m_personal_setting | 135807 | 17464 | 0.00 | 11.00 | | 2025-10-01 01:30:48.446821+00 | | 2025-10-03 00:07:39.96503+00 |
| public | m_pot | 208748 | 34711 | 0.00 | 14.00 | | 2025-09-29 00:25:21.777348+00 | | 2025-10-02 00:27:25.638173+00 |
| public | m_pot_profile | 51968 | 31 | 0.00 | 0.00 | | 2025-10-02 11:39:58.926248+00 | | |
| public | m_provider_user | 85 | 11 | 0.00 | 11.00 | | 2025-09-28 22:01:50.627287+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.491149+00 | | |
| public | m_role | 784 | 1 | 0.00 | 0.00 | | 2025-09-28 08:26:24.466766+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.356467+00 | | |
| public | m_setting | 30495 | 1429 | 0.00 | 4.00 | | 2025-10-02 03:19:37.084508+00 | | 2025-10-01 08:15:12.407775+00 |
| public | m_setting_log | 36965 | 1680 | 0.00 | 4.00 | | 2025-09-28 01:51:05.799914+00 | | 2025-10-02 12:30:59.453211+00 |
| public | m_site | 189 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.030169+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.535602+00 | | |
| public | m_tx | 130927 | 2283 | 0.00 | 1.00 | | 2025-10-01 23:48:02.688168+00 | | 2025-10-01 23:48:02.862352+00 |
| public | m_user | 37565 | 370 | 0.00 | 0.00 | | 2025-10-01 02:28:19.470281+00 | | 2025-09-24 00:24:08.965179+00 |
| public | m_zone | 7943 | 126 | 0.00 | 1.00 | | 2025-09-29 01:49:31.277728+00 | | 2025-09-25 00:44:34.586772+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.170572+00 | | |
| public | r_auth_zone | 232 | 6 | 0.00 | 2.00 | | 2025-09-29 05:17:12.389541+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.418839+00 | | |
| public | r_group_auth | 573 | 1 | 0.00 | 0.00 | | 2025-09-30 02:21:37.244358+00 | | |
| public | r_location_zone | 55667 | 1899 | 0.00 | 3.00 | | 2025-09-29 09:46:56.225108+00 | | 2025-09-30 07:42:30.306467+00 |
| public | r_pot_auth | 8347 | 848 | 0.00 | 9.00 | | 2025-10-01 22:35:59.625887+00 | | 2025-10-02 06:32:17.177394+00 |
| public | r_pot_category | 11929 | 65 | 0.00 | 0.00 | | 2025-10-01 14:32:15.09545+00 | | 2025-10-02 06:27:17.344153+00 |
| public | r_pot_group | 446079 | 4408 | 0.00 | 0.00 | | 2025-09-30 04:08:10.203754+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-09-29 01:49:27.870676+00 | | |
| public | r_pot_tx | 70865 | 209 | 0.00 | 0.00 | | 2025-10-02 01:57:46.897422+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 21253 | 0 | 0.00 | 0.00 | | 2025-10-02 07:16:07.88145+00 | | |
| public | r_provider_tenant | 946 | 0 | 0.00 | 0.00 | | 2025-10-01 04:45:06.794644+00 | | 2025-10-01 04:44:04.371703+00 |
| public | r_role_feature | 6213 | 9 | 0.00 | 0.00 | | 2025-09-30 21:53:35.884736+00 | | |
| public | r_tenant_feature | 4583 | 0 | 0.00 | 0.00 | | 2025-09-29 15:03:17.239868+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-30 12:58:57.936255+00 | | |
| public | r_user_region | 22096 | 0 | 0.00 | 0.00 | | 2025-10-02 07:16:06.957629+00 | | |
| public | r_user_site | 6370 | 17 | 0.00 | 0.00 | | 2025-09-28 08:26:24.33156+00 | | |
| public | r_zone_category | 4999 | 1 | 0.00 | 0.00 | | 2025-10-01 18:45:08.145005+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-30 06:44:08.908945+00 | | |
| public | t_attendance | 3336317 | 34972 | 0.00 | 1.00 | | 2025-09-29 15:04:14.567247+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4304 | 3 | 0.00 | 0.00 | | 2025-09-30 02:16:42.908797+00 | | |
| public | t_general_20250618 | 3107 | 0 | 0.00 | 0.00 | | 2025-10-01 06:54:48.837284+00 | | |
| public | t_job | 46 | 0 | 0.00 | 0.00 | | 2025-10-01 14:32:15.250222+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 897860 | 0 | 0.00 | 0.00 | | 2025-09-28 23:30:19.361438+00 | | |
| public | t_mobile_status_history | 2223570 | 0 | 0.00 | 0.00 | | 2025-10-02 05:45:43.510802+00 | | 2025-09-29 04:23:22.984019+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.440471+00 | | |
| public | t_notify_history | 6875160 | 17243 | 0.00 | 0.00 | | 2025-09-29 00:01:54.230029+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22706750 | 22 | 0.00 | 0.00 | | 2025-10-01 21:30:42.004095+00 | | |
| public | t_plan | 29186369 | 893339 | 0.00 | 2.00 | | 2025-09-30 10:24:37.391323+00 | | 2025-10-02 02:46:11.117678+00 |
| public | t_plan_cancel_history | 710882 | 3462 | 0.00 | 0.00 | | 2025-10-02 09:34:09.534231+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 49910578 | 567004 | 0.00 | 1.00 | | 2025-10-02 05:43:45.323203+00 | | 2025-10-01 10:07:14.035002+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-09-29 01:49:27.852841+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-09-29 01:49:27.831503+00 | | |
| public | t_plan_sync | 68018 | 11209 | 0.00 | 14.00 | | 2025-10-02 23:48:39.377276+00 | | 2025-10-03 00:36:43.835087+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.564337+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.243556+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:24.51431+00 | | |
| public | t_recv_position_history | 152441 | 15745 | 0.00 | 9.00 | | 2025-10-03 00:50:48.69391+00 | 2025-10-02 13:30:03.19776+00 | 2025-10-03 00:50:48.917557+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.303302+00 | | |
| public | t_terminal | 21776 | 1583 | 0.00 | 6.00 | | 2025-10-02 20:12:56.07284+00 | | 2025-10-03 00:35:44.945633+00 |
| public | t_terminal_log | 31636725 | 0 | 0.00 | 0.00 | | 2025-10-01 11:55:54.11529+00 | | 2025-09-21 13:00:59.492055+00 |
| public | temp_pivot_table | 239758 | 0 | 0.00 | 0.00 | | 2025-10-02 11:39:59.949086+00 | | |
| public | w_arrival_notify | 97 | 6 | 0.00 | 5.00 | | 2025-10-02 06:20:18.00941+00 | | 2025-10-02 00:15:03.083861+00 |
| public | w_latest_mobile_device | 58219 | 438 | 0.00 | 0.00 | | 2025-09-30 07:54:33.692494+00 | | 2025-09-29 10:02:56.584683+00 |
| public | w_latest_mobile_status | 57186 | 10302 | 0.00 | 15.00 | | 2025-10-02 06:58:24.851331+00 | | 2025-10-03 00:40:49.558938+00 |
| public | w_latest_position | 80333 | 23221 | 0.00 | 22.00 | | 2025-10-03 00:50:49.057214+00 | | 2025-10-03 00:50:49.221664+00 |
| public | w_latest_presence | 218782 | 170949 | 0.00 | 43.00 | | 2025-10-03 00:51:05.916092+00 | | 2025-10-03 00:51:07.921606+00 |
| public | w_latest_sensor | 386 | 249 | 0.00 | 39.00 | | 2025-10-03 00:50:49.238031+00 | | 2025-10-03 00:50:49.351473+00 |
| public | w_lock | 19198 | 0 | 0.00 | 0.00 | | 2025-09-30 16:35:51.991832+00 | | |
| public | w_master_update | 197 | 4 | 0.00 | 1.00 | | 2025-10-03 00:48:48.976348+00 | | 2025-10-03 00:11:39.299662+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-28 12:37:53.287481+00 | | |
| public | w_plan_sync_retry | 0 | 40 | 0 | 100.00 | | 2025-10-02 09:52:59.582339+00 | | 2025-10-02 23:47:38.435069+00 |
| public | w_plan_with_detail | 29236131 | 1594630 | 0.00 | 5.00 | | 2025-09-28 21:06:56.358731+00 | | 2025-10-02 02:57:10.247533+00 |