| 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 | 582013162 | 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 | 598740666 | 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 | 64460325 | 0 | 0.00 | 0.00 | | 2025-10-03 05:21:54.742031+00 | | 2025-09-30 14:47:50.312729+00 |
| e202509 | t_sensor_history | 11637768 | 0 | 0.00 | 0.00 | | 2025-10-03 12:10:52.895399+00 | | 2025-09-29 19:30:39.022501+00 |
| e202510 | a_proximity_sum | 4731762 | 0 | 0.00 | 0.00 | | 2025-10-03 16:31:10.485754+00 | | 2025-10-03 17:34:16.246483+00 |
| e202510 | a_stay_time | 5966873 | 0 | 0.00 | 0.00 | | 2025-10-03 18:53:24.613291+00 | | 2025-10-03 17:18:09.905249+00 |
| e202510 | t_position_history | 80438111 | 0 | 0.00 | 0.00 | | 2025-10-03 08:34:48.404295+00 | | 2025-10-03 11:25:17.180482+00 |
| e202510 | t_presence_history | 7490313 | 3924695 | 0.00 | 34.00 | | 2025-10-03 23:56:28.092325+00 | | 2025-10-03 23:59:42.510495+00 |
| e202510 | t_sensor_history | 1313735 | 0 | 0.00 | 0.00 | | 2025-10-03 21:32:36.635743+00 | | 2025-10-03 23:39:23.368208+00 |
| public | __digdag_status | 32 | 8 | 0.00 | 20.00 | | 2025-10-01 21:31:14.579211+00 | | 2025-10-03 12:30:34.155635+00 |
| public | a_attendance_sum | 161163 | 29636 | 0.00 | 15.00 | | 2025-10-03 06:32:04.346029+00 | | 2025-10-03 12:08:53.875665+00 |
| public | a_plan_actual | 1202566 | 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-10-03 07:17:05.867163+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-10-03 07:17:04.321472+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:03.097941+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 | 36413 | 2 | 0.00 | 0.00 | | 2025-10-02 19:45:45.296606+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2042 | 7 | 0.00 | 0.00 | | 2025-10-01 14:32:15.236015+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 117852 | 23 | 0.00 | 0.00 | | 2025-10-02 19:45:41.090779+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 108798 | 29 | 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 | 463073 | 364 | 0.00 | 0.00 | | 2025-10-02 19:45:53.129589+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 14195 | 23 | 0.00 | 0.00 | | 2025-10-02 19:45:41.254609+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 236413 | 143 | 0.00 | 0.00 | | 2025-10-02 19:45:44.934365+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 104265 | 113 | 0.00 | 0.00 | | 2025-10-02 19:45:42.380849+00 | | 2025-10-02 00:02:22.235052+00 |
| public | l_role | 782 | 0 | 0.00 | 0.00 | | 2025-10-02 19:44:32.253817+00 | | |
| public | l_role_feature | 7038 | 4 | 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 | 151490 | 14983 | 0.00 | 9.00 | | 2025-10-03 08:29:39.772959+00 | | 2025-10-03 09:02:15.968743+00 |
| public | l_user | 66114 | 217 | 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 | 11 | 0.00 | 1.00 | | 2025-09-29 09:46:56.388562+00 | | 2025-10-01 05:38:37.738397+00 |
| public | m_auth | 152 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:05.908278+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 | 27505 | 3 | 0.00 | 0.00 | | 2025-10-03 04:40:04.045906+00 | | |
| public | m_favorite | 240199 | 3421 | 0.00 | 1.00 | | 2025-09-29 04:36:20.461205+00 | | |
| public | m_favorite_group | 118026 | 725 | 0.00 | 0.00 | | 2025-09-30 20:29:56.419371+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-10-03 10:51:58.242175+00 | | |
| public | m_group | 29096 | 4788 | 0.00 | 14.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 | 24753 | 45 | 0.00 | 0.00 | | 2025-10-02 06:10:36.447202+00 | | |
| public | m_lob_log | 2369 | 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 | 3021 | 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 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:06.177092+00 | | |
| public | m_outside | 377 | 0 | 0.00 | 0.00 | | 2025-10-01 06:58:10.082658+00 | | |
| public | m_personal_setting | 135916 | 17564 | 0.00 | 11.00 | | 2025-10-01 01:30:48.446821+00 | | 2025-10-03 11:27:37.092507+00 |
| public | m_pot | 208827 | 34 | 0.00 | 0.00 | | 2025-10-03 19:00:49.552055+00 | | 2025-10-02 00:27:25.638173+00 |
| public | m_pot_profile | 52015 | 34 | 0.00 | 0.00 | | 2025-10-02 11:39:58.926248+00 | | |
| public | m_provider_user | 85 | 0 | 0.00 | 0.00 | | 2025-10-03 12:35:18.236944+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:06.288817+00 | | |
| public | m_role | 785 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:06.270112+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:06.053801+00 | | |
| public | m_setting | 16026 | 3222 | 0.00 | 16.00 | | 2025-10-02 03:19:37.084508+00 | | 2025-10-03 05:44:57.089256+00 |
| public | m_setting_log | 36562 | 2163 | 0.00 | 5.00 | | 2025-10-03 02:53:35.779392+00 | | 2025-10-03 12:30:34.41102+00 |
| public | m_site | 189 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:05.888076+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:06.321602+00 | | |
| public | m_tx | 220488 | 5208 | 0.00 | 2.00 | | 2025-10-03 08:38:52.775706+00 | | 2025-10-03 08:34:52.111611+00 |
| public | m_user | 37582 | 456 | 0.00 | 1.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-10-03 07:17:03.071898+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-10-03 07:17:06.20464+00 | | |
| public | r_group_auth | 573 | 1 | 0.00 | 0.00 | | 2025-09-30 02:21:37.244358+00 | | |
| public | r_location_zone | 55667 | 1928 | 0.00 | 3.00 | | 2025-09-29 09:46:56.225108+00 | | 2025-09-30 07:42:30.306467+00 |
| public | r_pot_auth | 8412 | 851 | 0.00 | 9.00 | | 2025-10-01 22:35:59.625887+00 | | 2025-10-02 06:32:17.177394+00 |
| public | r_pot_category | 11931 | 87 | 0.00 | 0.00 | | 2025-10-01 14:32:15.09545+00 | | 2025-10-02 06:27:17.344153+00 |
| public | r_pot_group | 446063 | 4533 | 0.00 | 1.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 | 70964 | 255 | 0.00 | 0.00 | | 2025-10-02 01:57:46.897422+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 21243 | 30 | 0.00 | 0.00 | | 2025-10-02 07:16:07.88145+00 | | |
| public | r_provider_tenant | 946 | 0 | 0.00 | 0.00 | | 2025-10-03 02:53:35.225855+00 | | 2025-10-03 02:53:35.227376+00 |
| public | r_role_feature | 6228 | 12 | 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 | 22090 | 23 | 0.00 | 0.00 | | 2025-10-02 07:16:06.957629+00 | | |
| public | r_user_site | 5560 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:06.027896+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 | 3456300 | 46553 | 0.00 | 1.00 | | 2025-09-29 15:04:14.567247+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4309 | 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 | 908109 | 0 | 0.00 | 0.00 | | 2025-10-03 15:10:34.565813+00 | | |
| public | t_mobile_status_history | 2233659 | 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-10-03 07:17:06.22791+00 | | |
| public | t_notify_history | 6845168 | 357 | 0.00 | 0.00 | | 2025-10-03 17:07:01.384726+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22753353 | 30 | 0.00 | 0.00 | | 2025-10-01 21:30:42.004095+00 | | |
| public | t_plan | 29234134 | 1046449 | 0.00 | 3.00 | | 2025-09-30 10:24:37.391323+00 | | 2025-10-02 02:46:11.117678+00 |
| public | t_plan_cancel_history | 712600 | 28713 | 0.00 | 3.00 | | 2025-10-02 09:34:09.534231+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 49998883 | 950214 | 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 | 68032 | 18942 | 0.00 | 21.00 | | 2025-10-03 13:33:34.344631+00 | | 2025-10-03 23:41:19.715759+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:06.3542+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-10-03 07:17:03.121545+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-10-03 07:17:06.300133+00 | | |
| public | t_recv_position_history | 145409 | 483679 | 3.00 | 76.00 | | 2025-10-04 00:01:42.574956+00 | 2025-10-03 13:30:03.576299+00 | 2025-10-04 00:01:42.788376+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-03 07:17:03.152944+00 | | |
| public | t_terminal | 21779 | 1547 | 0.00 | 6.00 | | 2025-10-03 21:57:15.020546+00 | | 2025-10-03 23:43:20.544635+00 |
| public | t_terminal_log | 31744796 | 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 | 19 | 0.00 | 16.00 | | 2025-10-02 06:20:18.00941+00 | | 2025-10-03 06:41:02.509214+00 |
| public | w_latest_mobile_device | 58264 | 501 | 0.00 | 0.00 | | 2025-09-30 07:54:33.692494+00 | | 2025-10-03 03:24:56.048929+00 |
| public | w_latest_mobile_status | 57231 | 9267 | 0.00 | 13.00 | | 2025-10-03 03:01:00.821811+00 | | 2025-10-03 12:08:53.255904+00 |
| public | w_latest_position | 80352 | 47478 | 0.00 | 37.00 | | 2025-10-03 23:54:25.504946+00 | | 2025-10-04 00:00:42.307111+00 |
| public | w_latest_presence | 231190 | 3193576 | 13.00 | 93.00 | | 2025-10-04 00:00:55.250865+00 | | 2025-10-04 00:00:55.717551+00 |
| public | w_latest_sensor | 386 | 1218 | 3.00 | 75.00 | | 2025-10-04 00:00:42.320231+00 | | 2025-10-04 00:00:42.434189+00 |
| public | w_lock | 19212 | 0 | 0.00 | 0.00 | | 2025-09-30 16:35:51.991832+00 | | |
| public | w_master_update | 113 | 82 | 0.00 | 42.00 | | 2025-10-03 18:59:17.992093+00 | | 2025-10-03 23:12:46.081374+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-10-03 08:27:04.63904+00 | | |
| public | w_plan_sync_retry | 0 | 45 | 0 | 100.00 | | 2025-10-03 09:32:54.255195+00 | | 2025-10-03 11:03:11.691098+00 |
| public | w_plan_with_detail | 28970270 | 30360 | 0.00 | 0.00 | | 2025-10-03 12:08:47.378307+00 | | 2025-10-02 02:57:10.247533+00 |