| 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 | 52534137 | 2144868 | 0.00 | 3.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 | 598473859 | 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 | 7881582 | 0 | 0.00 | 0.00 | | 2025-10-07 17:56:51.075171+00 | | 2025-10-07 17:07:05.687919+00 |
| e202510 | a_stay_time | 9964029 | 0 | 0.00 | 0.00 | | 2025-10-07 16:21:12.724816+00 | | 2025-10-07 17:11:05.748015+00 |
| e202510 | t_position_history | 150964030 | 0 | 0.00 | 0.00 | | 2025-10-07 05:03:10.011161+00 | | 2025-10-08 00:01:24.682054+00 |
| e202510 | t_presence_history | 20369709 | 895317 | 0.00 | 4.00 | | 2025-10-08 00:43:24.494578+00 | | 2025-10-08 00:39:12.718233+00 |
| e202510 | t_sensor_history | 2836784 | 0 | 0.00 | 0.00 | | 2025-10-07 23:20:17.105871+00 | | 2025-10-07 07:39:48.591054+00 |
| public | __digdag_status | 1035 | 0 | 0.00 | 0.00 | | 2025-10-07 13:02:20.894489+00 | | 2025-10-07 12:30:09.861382+00 |
| public | a_attendance_sum | 162900 | 27074 | 0.00 | 14.00 | | 2025-10-06 00:04:39.344155+00 | | 2025-10-08 00:36:12.205523+00 |
| public | a_plan_actual | 1217265 | 1 | 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 | 36431 | 25 | 0.00 | 0.00 | | 2025-10-02 19:45:45.296606+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2047 | 0 | 0.00 | 0.00 | | 2025-10-07 23:27:46.167409+00 | | 2025-10-07 02:10:08.82178+00 |
| public | l_location | 118126 | 276 | 0.00 | 0.00 | | 2025-10-02 19:45:41.090779+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 109100 | 320 | 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 | 464222 | 1545 | 0.00 | 0.00 | | 2025-10-02 19:45:53.129589+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 14289 | 90 | 0.00 | 0.00 | | 2025-10-02 19:45:41.254609+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 236590 | 409 | 0.00 | 0.00 | | 2025-10-02 19:45:44.934365+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 104606 | 448 | 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 | 7040 | 7 | 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 | 151591 | 25139 | 0.00 | 14.00 | | 2025-10-04 01:39:59.987421+00 | | 2025-10-07 07:27:18.603956+00 |
| public | l_user | 66409 | 645 | 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 | 6 | 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 | 189764 | 528 | 0.00 | 0.00 | | 2025-10-04 11:43:25.951424+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 118179 | 53 | 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 | 29105 | 3062 | 0.00 | 9.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 | 24788 | 58 | 0.00 | 0.00 | | 2025-10-02 06:10:36.447202+00 | | |
| public | m_lob_log | 2370 | 0 | 0.00 | 0.00 | | 2025-10-08 00:21:11.272476+00 | | 2025-09-29 04:32:21.117028+00 |
| public | m_location | 45521 | 102 | 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-07 09:14:24.121028+00 | | |
| public | m_personal_setting | 136135 | 13552 | 0.00 | 9.00 | | 2025-10-07 03:28:07.809192+00 | | 2025-10-08 00:29:16.867093+00 |
| public | m_pot | 209049 | 15625 | 0.00 | 6.00 | | 2025-10-03 19:00:49.552055+00 | | 2025-10-07 08:07:17.76992+00 |
| public | m_pot_profile | 52108 | 55 | 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 | 16022 | 2712 | 0.00 | 14.00 | | 2025-10-06 07:22:27.58271+00 | | 2025-10-07 01:29:27.469204+00 |
| public | m_setting_log | 36611 | 1520 | 0.00 | 3.00 | | 2025-10-03 02:53:35.779392+00 | | 2025-10-07 12:30:10.111593+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 | 131067 | 14482 | 0.00 | 9.00 | | 2025-10-07 13:14:15.106223+00 | | 2025-10-07 15:43:48.940486+00 |
| public | m_user | 37528 | 58 | 0.00 | 0.00 | | 2025-10-07 04:32:09.173374+00 | | 2025-09-24 00:24:08.965179+00 |
| public | m_zone | 7943 | 8 | 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 | 54852 | 105 | 0.00 | 0.00 | | 2025-10-05 08:47:00.97489+00 | | 2025-09-30 07:42:30.306467+00 |
| public | r_pot_auth | 8425 | 853 | 0.00 | 9.00 | | 2025-10-01 22:35:59.625887+00 | | 2025-10-02 06:32:17.177394+00 |
| public | r_pot_category | 11958 | 0 | 0.00 | 0.00 | | 2025-10-07 23:27:45.92528+00 | | 2025-10-02 06:27:17.344153+00 |
| public | r_pot_group | 122436 | 126 | 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 | 70962 | 598 | 0.00 | 0.00 | | 2025-10-02 01:57:46.897422+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 21231 | 50 | 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 | 6285 | 3 | 0.00 | 0.00 | | 2025-10-07 00:46:10.261347+00 | | |
| public | r_tenant_feature | 4586 | 20 | 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 | 22083 | 38 | 0.00 | 0.00 | | 2025-10-02 07:16:06.957629+00 | | |
| public | r_user_site | 5559 | 5 | 0.00 | 0.00 | | 2025-10-03 07:17:06.027896+00 | | |
| public | r_zone_category | 5048 | 0 | 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 | 3398115 | 22398 | 0.00 | 0.00 | | 2025-10-05 17:24:40.612818+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4329 | 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 | 914887 | 0 | 0.00 | 0.00 | | 2025-10-03 15:10:34.565813+00 | | |
| public | t_mobile_status_history | 2259084 | 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 | 6887671 | 9677 | 0.00 | 0.00 | | 2025-10-03 17:07:01.384726+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22910828 | 71 | 0.00 | 0.00 | | 2025-10-01 21:30:42.004095+00 | | |
| public | t_plan | 29431856 | 447297 | 0.00 | 1.00 | | 2025-10-06 14:21:26.565986+00 | | 2025-10-07 23:16:11.564103+00 |
| public | t_plan_cancel_history | 718315 | 92697 | 0.00 | 11.00 | | 2025-10-02 09:34:09.534231+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 50378844 | 1589323 | 0.00 | 3.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 | 68309 | 6351 | 0.00 | 8.00 | | 2025-10-08 00:18:24.405764+00 | | 2025-10-08 00:35:11.009426+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 | 152958 | 27188 | 0.00 | 15.00 | | 2025-10-08 00:48:44.951948+00 | 2025-10-07 13:30:01.962047+00 | 2025-10-08 00:49:44.52199+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-03 07:17:03.152944+00 | | |
| public | t_terminal | 21803 | 1722 | 0.00 | 7.00 | | 2025-10-07 20:01:20.866275+00 | | 2025-10-08 00:37:12.987897+00 |
| public | t_terminal_log | 32085303 | 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 | 239758 | 0 | 0.00 | 0.00 | | 2025-10-02 11:39:59.949086+00 | | |
| public | w_arrival_notify | 98 | 7 | 0.00 | 6.00 | | 2025-10-07 15:01:01.561004+00 | | 2025-10-07 23:49:46.144862+00 |
| public | w_latest_mobile_device | 58362 | 1544 | 0.00 | 2.00 | | 2025-10-06 09:32:24.261632+00 | | 2025-10-07 23:55:22.967923+00 |
| public | w_latest_mobile_status | 57328 | 9173 | 0.00 | 13.00 | | 2025-10-07 08:56:56.371682+00 | | 2025-10-08 00:10:24.593187+00 |
| public | w_latest_position | 80431 | 23700 | 0.00 | 22.00 | | 2025-10-08 00:49:44.757662+00 | | 2025-10-08 00:49:44.920992+00 |
| public | w_latest_presence | 224685 | 132406 | 0.00 | 37.00 | | 2025-10-08 00:50:01.483695+00 | | 2025-10-08 00:50:03.66991+00 |
| public | w_latest_sensor | 386 | 262 | 0.00 | 40.00 | | 2025-10-08 00:49:45.618315+00 | | 2025-10-08 00:49:45.735794+00 |
| public | w_lock | 19265 | 0 | 0.00 | 0.00 | | 2025-10-06 22:53:38.777098+00 | | |
| public | w_master_update | 197 | 2 | 0.00 | 1.00 | | 2025-10-08 00:35:10.684308+00 | | 2025-10-08 00:09:22.811216+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-07 10:02:37.086345+00 | | 2025-10-07 13:48:23.642816+00 |
| public | w_plan_with_detail | 25411878 | 4840745 | 0.00 | 16.00 | | 2025-10-03 12:08:47.378307+00 | | 2025-10-07 07:49:40.701554+00 |