| 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 | 582013182 | 0 | 0.00 | 0.00 | | 2025-10-06 02:07:20.146414+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 53879005 | 800000 | 0.00 | 1.00 | | 2025-10-02 02:01:26.956091+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764772 | 0 | 0.00 | 0.00 | | 2025-10-05 02:40:27.365384+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 29571698 | 0 | 0.00 | 0.00 | | 2025-10-05 20:10:47.413323+00 | | 2025-09-30 15:54:26.616538+00 |
| e202509 | a_stay_time | 38725572 | 0 | 0.00 | 0.00 | | 2025-10-06 21:02:06.148495+00 | | 2025-09-30 17:25:54.238102+00 |
| e202509 | t_position_history | 598473847 | 0 | 0.00 | 0.00 | | 2025-10-04 01:07:40.474218+00 | | 2025-09-29 20:40:54.897196+00 |
| e202509 | t_presence_history | 63660325 | 800000 | 0.00 | 1.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 | 6343349 | 0 | 0.00 | 0.00 | | 2025-10-06 18:37:55.983287+00 | | 2025-10-06 17:34:05.184267+00 |
| e202510 | a_stay_time | 8002663 | 0 | 0.00 | 0.00 | | 2025-10-06 17:13:36.62531+00 | | 2025-10-06 17:15:54.54492+00 |
| e202510 | t_position_history | 125468839 | 0 | 0.00 | 0.00 | | 2025-10-06 05:22:27.423685+00 | | 2025-10-06 22:19:07.595797+00 |
| e202510 | t_presence_history | 17803201 | 942146 | 0.00 | 5.00 | | 2025-10-07 00:45:51.049262+00 | | 2025-10-07 00:40:01.659897+00 |
| e202510 | t_sensor_history | 2479523 | 0 | 0.00 | 0.00 | | 2025-10-06 15:06:01.54546+00 | | 2025-10-06 16:55:46.748849+00 |
| public | __digdag_status | 1773 | 164 | 0.00 | 8.00 | | 2025-10-06 12:00:25.401858+00 | | 2025-10-06 12:16:25.191225+00 |
| public | a_attendance_sum | 162327 | 15679 | 0.00 | 8.00 | | 2025-10-06 00:04:39.344155+00 | | 2025-10-07 00:25:51.144634+00 |
| public | a_plan_actual | 1207567 | 0 | 0.00 | 0.00 | | 2025-10-04 21:29:57.789712+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-10-06 03:16:17.21591+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-10-05 17:26:09.086172+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-10-05 23:03:56.922519+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-10-05 17:23:42.634618+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-10-05 23:03:56.947876+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-10-05 23:03:56.970133+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-10-05 17:23:42.65481+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-10-05 17:23:42.612551+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-10-05 23:03:38.313976+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-10-05 17:23:42.679032+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-10-05 17:23:42.700909+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 | 36417 | 10 | 0.00 | 0.00 | | 2025-10-02 19:45:45.296606+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2044 | 9 | 0.00 | 0.00 | | 2025-10-01 14:32:15.236015+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 118013 | 166 | 0.00 | 0.00 | | 2025-10-02 19:45:41.090779+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 108977 | 211 | 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 | 463378 | 713 | 0.00 | 0.00 | | 2025-10-02 19:45:53.129589+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 14258 | 60 | 0.00 | 0.00 | | 2025-10-02 19:45:41.254609+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 236505 | 343 | 0.00 | 0.00 | | 2025-10-02 19:45:44.934365+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 104478 | 332 | 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 | 151554 | 13441 | 0.00 | 8.00 | | 2025-10-04 01:39:59.987421+00 | | 2025-10-04 01:40:00.408853+00 |
| public | l_user | 66258 | 482 | 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 | 0 | 0.00 | 0.00 | | 2025-10-05 08:47:01.071309+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-10-05 08:47:01.009222+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-10-06 05:11:10.371382+00 | | |
| public | m_exb | 27505 | 5 | 0.00 | 0.00 | | 2025-10-03 04:40:04.045906+00 | | |
| public | m_favorite | 189697 | 191 | 0.00 | 0.00 | | 2025-10-04 11:43:25.951424+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 118087 | 0 | 0.00 | 0.00 | | 2025-10-07 00:18:45.100114+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-10-03 10:51:58.242175+00 | | |
| public | m_group | 29100 | 2158 | 0.00 | 6.00 | | 2025-10-05 14:40:11.54664+00 | | 2025-10-06 14:40:56.438257+00 |
| public | m_holiday | 43676 | 0 | 0.00 | 0.00 | | 2025-10-02 02:45:09.2+00 | | |
| public | m_lob | 24765 | 48 | 0.00 | 0.00 | | 2025-10-02 06:10:36.447202+00 | | |
| public | m_lob_log | 2373 | 0 | 0.00 | 0.00 | | 2025-10-01 18:45:08.351914+00 | | 2025-09-29 04:32:21.117028+00 |
| public | m_location | 45518 | 5 | 0.00 | 0.00 | | 2025-10-05 02:40:26.86613+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 | 136074 | 17627 | 0.00 | 11.00 | | 2025-10-01 01:30:48.446821+00 | | 2025-10-07 00:29:00.47488+00 |
| public | m_pot | 208947 | 9008 | 0.00 | 4.00 | | 2025-10-03 19:00:49.552055+00 | | 2025-10-04 14:40:39.72492+00 |
| public | m_pot_profile | 52079 | 50 | 0.00 | 0.00 | | 2025-10-02 11:39:58.926248+00 | | |
| public | m_provider_user | 85 | 12 | 0.00 | 12.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 | 26996 | 1103 | 0.00 | 3.00 | | 2025-10-06 07:22:27.58271+00 | | 2025-10-05 05:48:57.099567+00 |
| public | m_setting_log | 36515 | 1436 | 0.00 | 3.00 | | 2025-10-03 02:53:35.779392+00 | | 2025-10-06 09:19:37.328384+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 | 131031 | 7218 | 0.00 | 5.00 | | 2025-10-06 01:02:33.2698+00 | | 2025-10-06 01:02:33.446731+00 |
| public | m_user | 37582 | 560 | 0.00 | 1.00 | | 2025-10-01 02:28:19.470281+00 | | 2025-09-24 00:24:08.965179+00 |
| public | m_zone | 7943 | 0 | 0.00 | 0.00 | | 2025-10-04 01:15:16.74612+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 | 0 | 0.00 | 0.00 | | 2025-10-04 14:29:24.230724+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-10-03 07:17:06.20464+00 | | |
| public | r_group_auth | 573 | 0 | 0.00 | 0.00 | | 2025-10-06 03:22:06.336031+00 | | |
| public | r_location_zone | 54832 | 2 | 0.00 | 0.00 | | 2025-10-05 08:47:00.97489+00 | | 2025-09-30 07:42:30.306467+00 |
| public | r_pot_auth | 8414 | 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 | 11957 | 124 | 0.00 | 1.00 | | 2025-10-01 14:32:15.09545+00 | | 2025-10-02 06:27:17.344153+00 |
| public | r_pot_group | 122417 | 60 | 0.00 | 0.00 | | 2025-10-06 05:11:09.84612+00 | | 2025-10-06 05:12:08.991893+00 |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-10-04 01:14:16.384311+00 | | |
| public | r_pot_tx | 70952 | 480 | 0.00 | 0.00 | | 2025-10-02 01:57:46.897422+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 21242 | 31 | 0.00 | 0.00 | | 2025-10-02 07:16:07.88145+00 | | |
| public | r_provider_tenant | 946 | 0 | 0.00 | 0.00 | | 2025-10-06 02:33:51.794038+00 | | 2025-10-06 02:33:51.799078+00 |
| public | r_role_feature | 6286 | 0 | 0.00 | 0.00 | | 2025-10-07 00:46:10.261347+00 | | |
| public | r_tenant_feature | 4583 | 0 | 0.00 | 0.00 | | 2025-10-05 17:23:41.948795+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-10-06 19:08:24.043342+00 | | |
| public | r_user_region | 22089 | 24 | 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-10-06 08:04:22.017682+00 | | |
| public | t_attendance | 3387069 | 11172 | 0.00 | 0.00 | | 2025-10-05 17:24:40.612818+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4324 | 0 | 0.00 | 0.00 | | 2025-10-06 03:16:16.823226+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 | 909608 | 0 | 0.00 | 0.00 | | 2025-10-03 15:10:34.565813+00 | | |
| public | t_mobile_status_history | 2248079 | 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 | 6870601 | 7512 | 0.00 | 0.00 | | 2025-10-03 17:07:01.384726+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22843825 | 61 | 0.00 | 0.00 | | 2025-10-01 21:30:42.004095+00 | | |
| public | t_plan | 28906054 | 115608 | 0.00 | 0.00 | | 2025-10-06 14:21:26.565986+00 | | 2025-10-02 02:46:11.117678+00 |
| public | t_plan_cancel_history | 715931 | 59039 | 0.00 | 7.00 | | 2025-10-02 09:34:09.534231+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 50280933 | 1418963 | 0.00 | 2.00 | | 2025-10-02 05:43:45.323203+00 | | 2025-10-06 00:03:45.74198+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-10-04 01:14:16.365718+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-10-04 01:14:16.344803+00 | | |
| public | t_plan_sync | 68044 | 6567 | 0.00 | 8.00 | | 2025-10-07 00:19:45.967048+00 | | 2025-10-07 00:35:00.17522+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 | 153585 | 15737 | 0.00 | 9.00 | | 2025-10-07 00:51:15.316051+00 | 2025-10-06 13:30:03.432039+00 | 2025-10-07 00:51:15.55646+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-03 07:17:03.152944+00 | | |
| public | t_terminal | 21794 | 1798 | 0.00 | 7.00 | | 2025-10-06 19:44:21.397055+00 | | 2025-10-07 00:33:01.394058+00 |
| public | t_terminal_log | 32065432 | 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 | 99 | 53 | 0.00 | 34.00 | | 2025-10-02 06:20:18.00941+00 | | 2025-10-06 23:41:11.927852+00 |
| public | w_latest_mobile_device | 58325 | 192 | 0.00 | 0.00 | | 2025-10-06 09:32:24.261632+00 | | 2025-10-03 03:24:56.048929+00 |
| public | w_latest_mobile_status | 57293 | 3253 | 0.00 | 5.00 | | 2025-10-07 00:17:46.392505+00 | | 2025-10-07 00:20:45.140048+00 |
| public | w_latest_position | 80407 | 27892 | 0.00 | 25.00 | | 2025-10-07 00:51:15.726635+00 | | 2025-10-07 00:51:15.889298+00 |
| public | w_latest_presence | 223015 | 251638 | 1.00 | 53.00 | | 2025-10-07 00:50:25.816915+00 | | 2025-10-07 00:50:28.324148+00 |
| public | w_latest_sensor | 386 | 256 | 0.00 | 39.00 | | 2025-10-07 00:51:15.912058+00 | | 2025-10-07 00:51:16.027227+00 |
| public | w_lock | 19253 | 0 | 0.00 | 0.00 | | 2025-10-06 22:53:38.777098+00 | | |
| public | w_master_update | 197 | 35 | 0.00 | 15.00 | | 2025-10-06 23:33:11.423117+00 | | 2025-10-06 22:15:06.139562+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-10-03 08:27:04.63904+00 | | |
| public | w_plan_sync_retry | 1 | 37 | 37.00 | 97.00 | | 2025-10-06 07:58:44.296831+00 | | 2025-10-06 23:57:28.292854+00 |
| public | w_plan_with_detail | 29065762 | 564943 | 0.00 | 1.00 | | 2025-10-03 12:08:47.378307+00 | | 2025-10-02 02:57:10.247533+00 |