| 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 | 32424077 | 0 | 0.00 | 0.00 | | 2025-10-08 03:29:41.045736+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36269697 | 0 | 0.00 | 0.00 | | 2025-10-08 10:55:56.862292+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 | 69665849 | 0 | 0.00 | 0.00 | | 2025-10-08 04:59:58.040019+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 | 598474987 | 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 | 62037605 | 2422720 | 0.00 | 3.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 | 9367515 | 0 | 0.00 | 0.00 | | 2025-10-08 19:03:08.196692+00 | | 2025-10-08 19:03:12.396245+00 |
| e202510 | a_stay_time | 11858020 | 0 | 0.00 | 0.00 | | 2025-10-08 17:00:57.624377+00 | | 2025-10-08 19:02:55.041941+00 |
| e202510 | t_position_history | 175764357 | 0 | 0.00 | 0.00 | | 2025-10-08 07:42:25.212572+00 | | 2025-10-08 08:47:10.939667+00 |
| e202510 | t_presence_history | 22870303 | 4251873 | 0.00 | 15.00 | | 2025-10-09 00:44:03.81425+00 | | 2025-10-09 00:39:47.955194+00 |
| e202510 | t_sensor_history | 3245389 | 0 | 0.00 | 0.00 | | 2025-10-07 23:20:17.105871+00 | | 2025-10-08 19:09:07.278817+00 |
| public | __digdag_status | 535 | 0 | 0.00 | 0.00 | | 2025-10-08 13:01:23.038669+00 | | 2025-10-08 12:30:59.605029+00 |
| public | a_attendance_sum | 199273 | 13899 | 0.00 | 6.00 | | 2025-10-09 00:46:13.788766+00 | | 2025-10-09 00:32:52.343578+00 |
| public | a_plan_actual | 1249679 | 1674 | 0.00 | 0.00 | | 2025-10-04 21:29:57.789712+00 | | 2025-10-08 16:50:49.780136+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 | 1565 | 16 | 0.00 | 1.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 | 2650 | 30 | 0.00 | 1.00 | | 2025-10-02 19:45:41.26585+00 | | |
| public | l_group | 35353 | 1129 | 0.00 | 3.00 | | 2025-10-02 19:45:45.296606+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2051 | 10 | 0.00 | 0.00 | | 2025-10-07 23:27:46.167409+00 | | 2025-10-07 02:10:08.82178+00 |
| public | l_location | 117868 | 768 | 0.00 | 0.00 | | 2025-10-02 19:45:41.090779+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 111016 | 775 | 0.00 | 0.00 | | 2025-10-02 19:45:40.158999+00 | | 2025-10-08 06:15:53.514279+00 |
| public | l_outside | 448 | 6 | 0.00 | 1.00 | | 2025-10-02 19:45:39.618309+00 | | |
| public | l_pot | 457555 | 13936 | 0.00 | 2.00 | | 2025-10-02 19:45:53.129589+00 | | 2025-10-08 08:16:47.032966+00 |
| public | l_pot_category | 14320 | 120 | 0.00 | 0.00 | | 2025-10-02 19:45:41.254609+00 | | 2025-10-09 00:24:05.35073+00 |
| public | l_pot_group | 235511 | 9668 | 0.00 | 3.00 | | 2025-10-02 19:45:44.934365+00 | | 2025-10-08 06:51:13.475539+00 |
| public | l_pot_tx | 100550 | 6754 | 0.00 | 6.00 | | 2025-10-02 19:45:42.380849+00 | | 2025-10-02 00:02:22.235052+00 |
| public | l_role | 776 | 8 | 0.00 | 1.00 | | 2025-10-02 19:44:32.253817+00 | | |
| public | l_role_feature | 6986 | 148 | 0.00 | 2.00 | | 2025-10-02 19:44:32.214734+00 | | |
| public | l_site | 248 | 10 | 0.00 | 3.00 | | 2025-10-02 19:45:39.665934+00 | | |
| public | l_tx | 147401 | 20863 | 0.00 | 12.00 | | 2025-10-08 02:19:26.102753+00 | | 2025-10-08 03:18:43.382572+00 |
| public | l_user | 66454 | 840 | 0.00 | 1.00 | | 2025-10-02 19:44:32.12576+00 | | 2025-09-30 09:16:26.739287+00 |
| public | l_zone | 9808 | 97 | 0.00 | 0.00 | | 2025-10-02 19:45:40.246889+00 | | |
| public | l_zone_category | 4982 | 108 | 0.00 | 2.00 | | 2025-10-02 19:44:30.893099+00 | | |
| public | m_area | 792 | 2 | 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 | 2420 | 29 | 0.00 | 1.00 | | 2025-10-05 08:47:01.009222+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-10-06 05:11:10.371382+00 | | |
| public | m_exb | 27182 | 341 | 0.00 | 1.00 | | 2025-10-03 04:40:04.045906+00 | | 2025-10-08 06:39:33.915423+00 |
| public | m_favorite | 186276 | 4371 | 0.00 | 2.00 | | 2025-10-04 11:43:25.951424+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 115038 | 3320 | 0.00 | 2.00 | | 2025-10-07 00:18:45.100114+00 | | 2025-10-08 06:28:55.123658+00 |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-10-03 10:51:58.242175+00 | | |
| public | m_group | 28292 | 5013 | 0.00 | 15.00 | | 2025-10-05 14:40:11.54664+00 | | 2025-10-08 14:40:52.426612+00 |
| public | m_holiday | 42898 | 695 | 0.00 | 1.00 | | 2025-10-08 05:22:25.101436+00 | | |
| public | m_lob | 21697 | 2 | 0.00 | 0.00 | | 2025-10-08 08:47:25.718252+00 | | 2025-10-08 07:12:18.311027+00 |
| public | m_lob_log | 5310 | 0 | 0.00 | 0.00 | | 2025-10-08 07:12:19.05236+00 | | 2025-10-08 07:12:19.071766+00 |
| public | m_location | 45526 | 210 | 0.00 | 0.00 | | 2025-10-05 02:40:26.86613+00 | | 2025-10-01 00:59:46.898895+00 |
| public | m_notify_template | 1228 | 14 | 0.00 | 1.00 | | 2025-10-03 07:17:06.177092+00 | | |
| public | m_outside | 373 | 4 | 0.00 | 1.00 | | 2025-10-07 09:14:24.121028+00 | | |
| public | m_personal_setting | 129866 | 24540 | 0.00 | 15.00 | | 2025-10-08 08:41:56.752388+00 | | 2025-10-09 00:29:52.089366+00 |
| public | m_pot | 208942 | 18450 | 0.00 | 8.00 | | 2025-10-03 19:00:49.552055+00 | | 2025-10-07 08:07:17.76992+00 |
| public | m_pot_profile | 52992 | 0 | 0.00 | 0.00 | | 2025-10-08 22:49:33.959437+00 | | 2025-10-08 07:13:12.749032+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 | 786 | 1 | 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 | 24086 | 1064 | 0.00 | 4.00 | | 2025-10-08 07:45:14.527272+00 | | 2025-10-08 02:19:05.486534+00 |
| public | m_setting_log | 36618 | 0 | 0.00 | 0.00 | | 2025-10-08 07:42:59.413174+00 | | 2025-10-08 19:50:52.683775+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 | 127027 | 17920 | 0.00 | 12.00 | | 2025-10-08 03:14:40.63529+00 | | 2025-10-08 06:38:32.566598+00 |
| public | m_user | 37531 | 133 | 0.00 | 0.00 | | 2025-10-07 04:32:09.173374+00 | | 2025-09-24 00:24:08.965179+00 |
| public | m_zone | 7944 | 10 | 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 | 54707 | 318 | 0.00 | 0.00 | | 2025-10-05 08:47:00.97489+00 | | 2025-09-30 07:42:30.306467+00 |
| public | r_pot_auth | 8428 | 1 | 0.00 | 0.00 | | 2025-10-08 01:36:12.727357+00 | | 2025-10-02 06:32:17.177394+00 |
| public | r_pot_category | 11959 | 30 | 0.00 | 0.00 | | 2025-10-07 23:27:45.92528+00 | | 2025-10-02 06:27:17.344153+00 |
| public | r_pot_group | 119195 | 3820 | 0.00 | 3.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 | 68942 | 2149 | 0.00 | 3.00 | | 2025-10-08 04:31:50.095983+00 | | 2025-10-09 00:14:51.631362+00 |
| public | r_pot_user | 21199 | 2 | 0.00 | 0.00 | | 2025-10-08 10:30:29.869504+00 | | |
| public | r_provider_tenant | 935 | 11 | 0.00 | 1.00 | | 2025-10-06 02:33:51.794038+00 | | 2025-10-06 02:33:51.799078+00 |
| public | r_role_feature | 6236 | 71 | 0.00 | 1.00 | | 2025-10-07 00:46:10.261347+00 | | |
| public | r_tenant_feature | 4546 | 62 | 0.00 | 1.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 | 22047 | 1 | 0.00 | 0.00 | | 2025-10-08 10:30:28.381015+00 | | |
| public | r_user_site | 5562 | 5 | 0.00 | 0.00 | | 2025-10-03 07:17:06.027896+00 | | |
| public | r_zone_category | 5012 | 37 | 0.00 | 0.00 | | 2025-10-08 00:21:10.831109+00 | | |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-10-06 08:04:22.017682+00 | | |
| public | t_attendance | 3394966 | 47912 | 0.00 | 1.00 | | 2025-10-05 17:24:40.612818+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4334 | 3 | 0.00 | 0.00 | | 2025-10-06 03:16:16.823226+00 | | |
| public | t_general_20250618 | 3060 | 0 | 0.00 | 0.00 | | 2025-10-07 09:10:53.430364+00 | | |
| public | t_job | 55 | 0 | 0.00 | 0.00 | | 2025-10-07 23:27:46.182276+00 | | 2025-10-07 11:10:36.569592+00 |
| public | t_mobile_device_history | 906233 | 12492 | 0.00 | 1.00 | | 2025-10-03 15:10:34.565813+00 | | |
| public | t_mobile_status_history | 2244358 | 0 | 0.00 | 0.00 | | 2025-10-08 08:19:50.088037+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 | 6904366 | 14495 | 0.00 | 0.00 | | 2025-10-03 17:07:01.384726+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22846807 | 19 | 0.00 | 0.00 | | 2025-10-08 01:18:18.596097+00 | | |
| public | t_plan | 29483901 | 740577 | 0.00 | 2.00 | | 2025-10-06 14:21:26.565986+00 | | 2025-10-07 23:16:11.564103+00 |
| public | t_plan_cancel_history | 719343 | 1032 | 0.00 | 0.00 | | 2025-10-08 19:02:52.79431+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 42749212 | 979088 | 0.00 | 2.00 | | 2025-10-08 03:11:55.561254+00 | | 2025-10-08 03:00:40.08948+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 | 102609 | 9536 | 0.00 | 8.00 | | 2025-10-09 00:35:46.880785+00 | | 2025-10-09 00:28:52.169657+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 | 151417 | 448754 | 2.00 | 74.00 | | 2025-10-09 00:52:08.359444+00 | 2025-10-08 13:30:02.297346+00 | 2025-10-09 00:52:08.857866+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-03 07:17:03.152944+00 | | |
| public | t_terminal | 19906 | 3078 | 0.00 | 13.00 | | 2025-10-08 20:47:48.882277+00 | | 2025-10-09 00:41:49.164171+00 |
| public | t_terminal_log | 32195605 | 0 | 0.00 | 0.00 | | 2025-10-07 21:01:08.198212+00 | | 2025-09-21 13:00:59.492055+00 |
| public | temp_pivot_table | 239687 | 0 | 0.00 | 0.00 | | 2025-10-08 22:49:35.712668+00 | | |
| public | w_arrival_notify | 103 | 18 | 0.00 | 14.00 | | 2025-10-07 15:01:01.561004+00 | | 2025-10-07 23:49:46.144862+00 |
| public | w_latest_mobile_device | 55483 | 5354 | 0.00 | 8.00 | | 2025-10-06 09:32:24.261632+00 | | 2025-10-08 06:44:33.697242+00 |
| public | w_latest_mobile_status | 54463 | 9386 | 0.00 | 14.00 | | 2025-10-08 10:52:44.352461+00 | | 2025-10-09 00:06:52.681728+00 |
| public | w_latest_position | 77407 | 847705 | 10.00 | 91.00 | | 2025-10-09 00:52:09.191082+00 | | 2025-10-09 00:52:09.442056+00 |
| public | w_latest_presence | 229986 | 4400855 | 19.00 | 95.00 | | 2025-10-09 00:52:11.966222+00 | | 2025-10-09 00:52:13.683932+00 |
| public | w_latest_sensor | 386 | 7775 | 20.00 | 95.00 | | 2025-10-09 00:52:09.460764+00 | | 2025-10-09 00:52:10.471022+00 |
| public | w_lock | 19278 | 0 | 0.00 | 0.00 | | 2025-10-06 22:53:38.777098+00 | | |
| public | w_master_update | 196 | 40 | 0.00 | 16.00 | | 2025-10-09 00:47:08.6092+00 | | 2025-10-09 00:45:08.522191+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-10-03 08:27:04.63904+00 | | |
| public | w_plan_sync_retry | 0 | 29 | 0 | 100.00 | | 2025-10-08 10:52:44.497754+00 | | 2025-10-08 14:05:52.253154+00 |
| public | w_plan_with_detail | 23485910 | 1808905 | 0.00 | 7.00 | | 2025-10-08 02:15:31.42862+00 | | 2025-10-08 02:19:02.931571+00 |