| 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 |
|---|
| e202507 | a_proximity_sum | 57060921 | 0 | 0.00 | 0.00 | | 2025-09-19 04:29:34.655223+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-09-20 12:14:01.164351+00 | | |
| e202507 | t_position_history | 611252344 | 0 | 0.00 | 0.00 | | 2025-09-21 03:59:54.523088+00 | | |
| e202507 | t_presence_history | 55790569 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:05.71734+00 | | |
| e202507 | t_sensor_history | 11690410 | 0 | 0.00 | 0.00 | | 2025-09-21 20:07:57.808553+00 | | |
| e202508 | a_proximity_sum | 32424209 | 0 | 0.00 | 0.00 | | 2025-09-19 06:22:48.155661+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36269781 | 0 | 0.00 | 0.00 | | 2025-09-19 21:37:27.688888+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582013225 | 0 | 0.00 | 0.00 | | 2025-09-17 05:29:12.691343+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 54679077 | 0 | 0.00 | 0.00 | | 2025-09-19 07:26:52.267797+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764805 | 0 | 0.00 | 0.00 | | 2025-09-16 15:09:07.788408+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 21573374 | 0 | 0.00 | 0.00 | | 2025-09-18 15:14:45.548841+00 | | 2025-09-22 15:52:24.606929+00 |
| e202509 | a_stay_time | 28667790 | 0 | 0.00 | 0.00 | | 2025-09-18 15:49:57.624016+00 | | 2025-09-22 17:16:46.25202+00 |
| e202509 | t_position_history | 443318720 | 0 | 0.00 | 0.00 | | 2025-09-18 04:53:40.862704+00 | | 2025-09-22 02:35:05.994537+00 |
| e202509 | t_presence_history | 41844416 | 1842700 | 0.00 | 4.00 | | 2025-09-23 00:35:31.522912+00 | | 2025-09-23 00:48:54.814056+00 |
| e202509 | t_sensor_history | 8692737 | 0 | 0.00 | 0.00 | | 2025-09-19 06:21:29.741811+00 | | 2025-09-22 07:41:47.35428+00 |
| public | __digdag_status | 32 | 17 | 0.00 | 34.00 | | 2025-09-19 04:09:07.601873+00 | | 2025-09-15 12:30:25.294298+00 |
| public | a_attendance_sum | 156330 | 17817 | 0.00 | 10.00 | | 2025-09-17 09:22:08.782112+00 | | 2025-09-22 11:49:07.775803+00 |
| public | a_plan_actual | 1129621 | 0 | 0.00 | 0.00 | | 2025-09-23 00:52:54.561968+00 | | 2025-09-19 16:41:52.537694+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-09-22 00:28:35.245314+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-09-22 00:28:34.983076+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:33.844442+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-09-17 06:32:56.811408+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-09-17 01:55:15.252589+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-09-17 02:34:18.040026+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.929502+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-09-17 02:34:18.063243+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-09-17 02:34:18.086221+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.950797+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.907163+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-09-17 02:34:16.014379+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.973518+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.994521+00 | | |
| public | l_area | 1563 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:07.345386+00 | | |
| public | l_auth | 188 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:07.298828+00 | | |
| public | l_category | 2712 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:09.045189+00 | | |
| public | l_group | 36997 | 25 | 0.00 | 0.00 | | 2025-09-20 17:46:11.556034+00 | | |
| public | l_lob | 1994 | 4 | 0.00 | 0.00 | | 2025-09-19 02:27:53.252742+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 115766 | 312 | 0.00 | 0.00 | | 2025-09-20 17:46:08.856445+00 | | 2025-09-15 08:51:20.047628+00 |
| public | l_location_zone | 105859 | 383 | 0.00 | 0.00 | | 2025-09-20 17:46:07.868669+00 | | 2025-09-12 06:37:57.741842+00 |
| public | l_outside | 454 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:07.321458+00 | | |
| public | l_pot | 442604 | 809 | 0.00 | 0.00 | | 2025-09-20 17:46:15.81417+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 14036 | 10 | 0.00 | 0.00 | | 2025-09-20 17:46:09.025912+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 231345 | 168 | 0.00 | 0.00 | | 2025-09-20 17:46:11.331477+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 102557 | 77 | 0.00 | 0.00 | | 2025-09-20 17:46:09.913271+00 | | |
| public | l_role | 775 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:05.55463+00 | | |
| public | l_role_feature | 6740 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:05.509627+00 | | |
| public | l_site | 258 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:07.366747+00 | | |
| public | l_tx | 150770 | 21599 | 0.00 | 12.00 | | 2025-09-21 16:39:29.017284+00 | | 2025-09-22 03:14:12.021618+00 |
| public | l_user | 64065 | 102 | 0.00 | 0.00 | | 2025-09-20 17:46:05.432142+00 | | 2025-09-05 09:09:18.220322+00 |
| public | l_zone | 9779 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:07.969265+00 | | |
| public | l_zone_category | 4872 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:04.506444+00 | | |
| public | m_area | 788 | 3 | 0.00 | 0.00 | | 2025-09-16 22:56:19.695053+00 | | |
| public | m_auth | 149 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:35.738774+00 | | |
| public | m_category | 2449 | 0 | 0.00 | 0.00 | | 2025-09-16 22:56:19.665124+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-09-17 08:29:53.291589+00 | | |
| public | m_exb | 27407 | 6 | 0.00 | 0.00 | | 2025-09-21 17:11:43.250279+00 | | |
| public | m_favorite | 232048 | 0 | 0.00 | 0.00 | | 2025-09-22 17:05:46.180896+00 | | |
| public | m_favorite_group | 116476 | 99 | 0.00 | 0.00 | | 2025-09-18 03:21:32.345781+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-09-22 03:58:14.147087+00 | | |
| public | m_group | 28140 | 1712 | 0.00 | 5.00 | | 2025-09-18 01:27:52.316022+00 | | 2025-09-22 14:41:01.566901+00 |
| public | m_holiday | 43842 | 0 | 0.00 | 0.00 | | 2025-09-19 08:19:25.61968+00 | | |
| public | m_lob | 24644 | 16 | 0.00 | 0.00 | | 2025-09-19 16:32:52.646057+00 | | |
| public | m_lob_log | 2066 | 0 | 0.00 | 0.00 | | 2025-09-19 03:25:03.9077+00 | | |
| public | m_location | 45316 | 1708 | 0.00 | 3.00 | | 2025-09-16 16:02:10.698532+00 | | 2025-09-19 06:15:04.836821+00 |
| public | m_notify_template | 1242 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:35.909906+00 | | |
| public | m_outside | 377 | 0 | 0.00 | 0.00 | | 2025-09-18 17:03:31.255435+00 | | |
| public | m_personal_setting | 134632 | 15785 | 0.00 | 10.00 | | 2025-09-18 06:22:00.834309+00 | | 2025-09-22 10:52:05.250492+00 |
| public | m_pot | 207642 | 1273 | 0.00 | 0.00 | | 2025-09-22 06:46:50.629157+00 | | 2025-09-22 00:08:38.773997+00 |
| public | m_pot_profile | 51780 | 0 | 0.00 | 0.00 | | 2025-09-20 09:09:16.280738+00 | | |
| public | m_provider_user | 85 | 0 | 0.00 | 0.00 | | 2025-09-22 04:49:41.553409+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:36.020606+00 | | |
| public | m_role | 778 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:35.997646+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:35.88562+00 | | |
| public | m_setting | 24934 | 1242 | 0.00 | 4.00 | | 2025-09-22 05:54:04.948732+00 | | 2025-09-21 13:20:55.908621+00 |
| public | m_setting_log | 36798 | 0 | 0.00 | 0.00 | | 2025-09-17 21:30:56.084132+00 | | 2025-09-22 21:03:57.141322+00 |
| public | m_site | 189 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:35.560637+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:36.064965+00 | | |
| public | m_tx | 130316 | 17357 | 0.00 | 11.00 | | 2025-09-22 10:21:03.300705+00 | | 2025-09-22 10:25:02.761147+00 |
| public | m_user | 36696 | 134 | 0.00 | 0.00 | | 2025-09-18 07:26:13.415748+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 7911 | 0 | 0.00 | 0.00 | | 2025-09-22 08:22:57.285515+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-09-22 00:28:33.817129+00 | | |
| public | r_auth_zone | 229 | 0 | 0.00 | 0.00 | | 2025-09-22 19:17:41.070506+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:35.937301+00 | | |
| public | r_group_auth | 574 | 1 | 0.00 | 0.00 | | 2025-09-17 06:39:51.266188+00 | | |
| public | r_location_zone | 55001 | 1368 | 0.00 | 2.00 | | 2025-09-16 22:56:19.520024+00 | | 2025-09-16 22:57:19.988245+00 |
| public | r_pot_auth | 8912 | 0 | 0.00 | 0.00 | | 2025-09-19 04:29:33.991678+00 | | 2025-09-22 00:49:20.732285+00 |
| public | r_pot_category | 13775 | 23 | 0.00 | 0.00 | | 2025-09-19 02:29:12.842783+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 446050 | 6166 | 0.00 | 1.00 | | 2025-09-17 08:29:53.266288+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-09-22 08:37:18.320915+00 | | |
| public | r_pot_tx | 70497 | 118 | 0.00 | 0.00 | | 2025-09-19 07:23:32.429621+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 20694 | 3 | 0.00 | 0.00 | | 2025-09-19 20:48:06.95799+00 | | |
| public | r_provider_tenant | 1203 | 0 | 0.00 | 0.00 | | 2025-09-19 21:22:08.118145+00 | | 2025-09-11 06:34:01.277345+00 |
| public | r_role_feature | 6226 | 0 | 0.00 | 0.00 | | 2025-09-18 03:43:32.136685+00 | | |
| public | r_tenant_feature | 4582 | 0 | 0.00 | 0.00 | | 2025-09-17 01:48:34.090111+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-18 01:27:52.347279+00 | | |
| public | r_user_region | 21533 | 6 | 0.00 | 0.00 | | 2025-09-19 20:48:06.404386+00 | | |
| public | r_user_site | 5561 | 2 | 0.00 | 0.00 | | 2025-09-22 00:28:35.854524+00 | | |
| public | r_zone_category | 5001 | 0 | 0.00 | 0.00 | | 2025-09-19 03:25:03.876342+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-17 13:57:30.152607+00 | | |
| public | t_attendance | 3355430 | 39780 | 0.00 | 1.00 | | 2025-09-17 01:49:26.607103+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4261 | 0 | 0.00 | 0.00 | | 2025-09-17 06:32:56.738256+00 | | |
| public | t_general_20250618 | 3204 | 0 | 0.00 | 0.00 | | 2025-09-18 16:02:19.298468+00 | | |
| public | t_job | 33 | 1 | 0.00 | 2.00 | | 2025-09-19 02:27:53.282884+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 880078 | 0 | 0.00 | 0.00 | | 2025-09-22 05:42:05.331232+00 | | |
| public | t_mobile_status_history | 2078124 | 0 | 0.00 | 0.00 | | 2025-09-19 14:12:28.391646+00 | | 2025-09-04 10:03:21.422779+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:35.959837+00 | | |
| public | t_notify_history | 6773271 | 1920 | 0.00 | 0.00 | | 2025-09-22 06:16:36.580815+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22393508 | 21 | 0.00 | 0.00 | | 2025-09-19 04:09:07.507687+00 | | |
| public | t_plan | 28635691 | 979622 | 0.00 | 3.00 | | 2025-09-18 00:28:13.340536+00 | | 2025-09-19 01:40:22.926577+00 |
| public | t_plan_cancel_history | 697784 | 20582 | 0.00 | 2.00 | | 2025-09-20 04:42:59.465495+00 | | |
| public | t_plan_detail | 48899411 | 668737 | 0.00 | 1.00 | | 2025-09-19 13:47:02.988837+00 | | 2025-09-19 06:38:48.96778+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-09-22 08:37:18.30122+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-09-22 08:37:18.278851+00 | | |
| public | t_plan_sync | 67780 | 6272 | 0.00 | 8.00 | | 2025-09-23 00:19:21.980201+00 | | 2025-09-23 00:35:54.333329+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:36.102143+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-09-22 00:28:33.890912+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-09-22 00:28:36.041977+00 | | |
| public | t_recv_position_history | 145682 | 6629 | 0.00 | 4.00 | | 2025-09-23 00:52:55.127394+00 | 2025-09-22 13:30:06.495726+00 | 2025-09-23 00:52:55.339051+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-22 00:28:33.953803+00 | | |
| public | t_terminal | 21713 | 4051 | 0.00 | 15.00 | | 2025-09-22 19:15:41.942348+00 | | 2025-09-23 00:35:56.879466+00 |
| public | t_terminal_log | 30745837 | 0 | 0.00 | 0.00 | | 2025-09-19 01:27:55.71492+00 | | 2025-09-21 13:00:59.492055+00 |
| public | temp_pivot_table | 239900 | 0 | 0.00 | 0.00 | | 2025-09-20 09:09:16.500967+00 | | |
| public | w_arrival_notify | 110 | 9 | 0.00 | 7.00 | | 2025-09-20 12:14:01.043555+00 | | 2025-09-22 23:50:21.350406+00 |
| public | w_latest_mobile_device | 57525 | 685 | 0.00 | 1.00 | | 2025-09-17 19:25:11.784497+00 | | 2025-09-17 08:24:58.407674+00 |
| public | w_latest_mobile_status | 56497 | 9504 | 0.00 | 14.00 | | 2025-09-19 07:53:26.427681+00 | | 2025-09-22 11:10:06.161968+00 |
| public | w_latest_position | 79972 | 15691 | 0.00 | 16.00 | | 2025-09-23 00:49:54.134022+00 | | 2025-09-23 00:52:55.51556+00 |
| public | w_latest_presence | 222860 | 102113 | 0.00 | 31.00 | | 2025-09-23 00:53:10.961145+00 | | 2025-09-23 00:53:13.287797+00 |
| public | w_latest_sensor | 386 | 226 | 0.00 | 36.00 | | 2025-09-23 00:52:55.530822+00 | | 2025-09-23 00:52:55.642093+00 |
| public | w_lock | 18813 | 2 | 0.00 | 0.00 | | 2025-09-18 02:30:09.912499+00 | | |
| public | w_master_update | 113 | 53 | 0.00 | 31.00 | | 2025-09-22 21:06:56.931302+00 | | 2025-09-22 22:16:36.100594+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-22 01:55:00.417322+00 | | |
| public | w_plan_sync_retry | 6 | 36 | 6.00 | 85.00 | | 2025-09-22 23:09:46.396042+00 | | 2025-09-23 00:46:53.639396+00 |
| public | w_plan_with_detail | 28242070 | 208284 | 0.00 | 0.00 | | 2025-09-22 04:44:10.133184+00 | | 2025-09-19 02:14:54.24258+00 |