| 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 | 57060861 | 0 | 0.00 | 0.00 | | 2025-09-25 23:51:32.484111+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-09-26 19:33:35.675241+00 | | |
| e202507 | t_position_history | 611252344 | 0 | 0.00 | 0.00 | | 2025-09-27 09:50:05.387636+00 | | |
| e202507 | t_presence_history | 55790521 | 0 | 0.00 | 0.00 | | 2025-09-27 00:30:49.64006+00 | | |
| e202507 | t_sensor_history | 11690406 | 0 | 0.00 | 0.00 | | 2025-09-28 01:53:03.422199+00 | | |
| e202508 | a_proximity_sum | 32424165 | 0 | 0.00 | 0.00 | | 2025-09-26 01:46:10.382598+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36269753 | 0 | 0.00 | 0.00 | | 2025-09-26 08:31:15.018665+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582013412 | 0 | 0.00 | 0.00 | | 2025-09-24 01:42:58.657834+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 54679041 | 0 | 0.00 | 0.00 | | 2025-09-26 02:50:13.277811+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764794 | 0 | 0.00 | 0.00 | | 2025-09-23 04:23:22.431408+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 26409592 | 0 | 0.00 | 0.00 | | 2025-09-24 15:49:44.104555+00 | | 2025-09-26 16:35:54.77064+00 |
| e202509 | a_stay_time | 34704415 | 0 | 0.00 | 0.00 | | 2025-09-24 17:11:27.067147+00 | | 2025-09-26 18:55:29.280449+00 |
| e202509 | t_position_history | 551557978 | 0 | 0.00 | 0.00 | | 2025-09-23 14:08:50.634291+00 | | 2025-09-26 06:56:56.008871+00 |
| e202509 | t_presence_history | 60820504 | 133435 | 0.00 | 0.00 | | 2025-09-29 00:52:31.440122+00 | | 2025-09-29 00:30:15.466446+00 |
| e202509 | t_sensor_history | 10942540 | 0 | 0.00 | 0.00 | | 2025-09-28 21:23:01.795283+00 | | 2025-09-26 23:59:49.460374+00 |
| public | __digdag_status | 32 | 13 | 0.00 | 28.00 | | 2025-09-25 23:22:08.912724+00 | | 2025-09-24 12:30:52.444456+00 |
| public | a_attendance_sum | 158734 | 28142 | 0.00 | 15.00 | | 2025-09-24 05:23:42.10948+00 | | 2025-09-29 00:26:13.622689+00 |
| public | a_plan_actual | 1164437 | 2 | 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-28 08:26:09.260565+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:09.249504+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:08.198039+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-09-24 02:45:29.188354+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-09-23 19:54:17.790276+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-09-23 22:54:22.866869+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-09-23 19:29:04.020335+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-09-23 22:54:22.891987+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-09-23 22:54:22.912062+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-09-23 19:29:04.041514+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-09-23 19:29:03.995101+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-09-23 22:45:43.254023+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-09-23 19:29:04.065521+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-09-23 19:29:04.090894+00 | | |
| public | l_area | 1566 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:07.508429+00 | | |
| public | l_auth | 188 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:07.411657+00 | | |
| public | l_category | 2712 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:08.877212+00 | | |
| public | l_group | 37085 | 2 | 0.00 | 0.00 | | 2025-09-27 00:31:11.413414+00 | | |
| public | l_lob | 2021 | 3 | 0.00 | 0.00 | | 2025-09-25 18:01:07.224287+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 112017 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:08.713558+00 | | 2025-09-15 08:51:20.047628+00 |
| public | l_location_zone | 106630 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:07.982628+00 | | 2025-09-12 06:37:57.741842+00 |
| public | l_outside | 454 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:07.435231+00 | | |
| public | l_pot | 445638 | 40 | 0.00 | 0.00 | | 2025-09-27 00:31:17.429297+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 14067 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:08.84655+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 231264 | 14 | 0.00 | 0.00 | | 2025-09-27 00:31:11.164723+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 103180 | 84 | 0.00 | 0.00 | | 2025-09-27 00:31:09.694461+00 | | |
| public | l_role | 778 | 0 | 0.00 | 0.00 | | 2025-09-27 00:30:49.406991+00 | | |
| public | l_role_feature | 6791 | 0 | 0.00 | 0.00 | | 2025-09-27 00:30:49.368171+00 | | |
| public | l_site | 258 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:07.531251+00 | | |
| public | l_tx | 151052 | 16068 | 0.00 | 9.00 | | 2025-09-26 12:19:57.173632+00 | | 2025-09-26 12:26:53.090432+00 |
| public | l_user | 65105 | 180 | 0.00 | 0.00 | | 2025-09-27 00:30:49.281338+00 | | 2025-09-05 09:09:18.220322+00 |
| public | l_zone | 9849 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:08.005735+00 | | |
| public | l_zone_category | 4902 | 0 | 0.00 | 0.00 | | 2025-09-27 00:30:47.298473+00 | | |
| public | m_area | 790 | 20 | 0.00 | 2.00 | | 2025-09-23 09:34:23.312986+00 | | |
| public | m_auth | 149 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.228097+00 | | |
| public | m_category | 2449 | 4 | 0.00 | 0.00 | | 2025-09-23 09:34:23.259705+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-09-24 04:42:45.335313+00 | | |
| public | m_exb | 27511 | 0 | 0.00 | 0.00 | | 2025-09-27 23:13:41.371815+00 | | |
| public | m_favorite | 232948 | 712 | 0.00 | 0.00 | | 2025-09-22 17:05:46.180896+00 | | |
| public | m_favorite_group | 117336 | 59 | 0.00 | 0.00 | | 2025-09-24 22:52:40.587625+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-09-28 19:17:20.699203+00 | | |
| public | m_group | 28223 | 1473 | 0.00 | 4.00 | | 2025-09-24 15:31:27.687202+00 | | 2025-09-28 14:41:00.109814+00 |
| public | m_holiday | 43759 | 0 | 0.00 | 0.00 | | 2025-09-26 03:40:58.963395+00 | | |
| public | m_lob | 24713 | 15 | 0.00 | 0.00 | | 2025-09-26 07:10:51.143152+00 | | |
| public | m_lob_log | 2070 | 0 | 0.00 | 0.00 | | 2025-09-25 21:44:10.253938+00 | | |
| public | m_location | 45329 | 310 | 0.00 | 0.00 | | 2025-09-23 04:23:51.155814+00 | | 2025-09-19 06:15:04.836821+00 |
| public | m_notify_template | 1242 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.393836+00 | | |
| public | m_outside | 377 | 3 | 0.00 | 0.00 | | 2025-09-25 07:43:52.287136+00 | | |
| public | m_personal_setting | 135354 | 15471 | 0.00 | 10.00 | | 2025-09-25 02:13:15.489112+00 | | 2025-09-29 00:43:13.278038+00 |
| public | m_pot | 208005 | 4614 | 0.00 | 2.00 | | 2025-09-29 00:25:21.777348+00 | | 2025-09-26 08:48:20.444254+00 |
| public | m_pot_profile | 51880 | 4 | 0.00 | 0.00 | | 2025-09-26 15:58:50.426619+00 | | |
| public | m_provider_user | 85 | 0 | 0.00 | 0.00 | | 2025-09-28 22:01:50.627287+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.491149+00 | | |
| public | m_role | 781 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.466766+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.356467+00 | | |
| public | m_setting | 23826 | 1124 | 0.00 | 4.00 | | 2025-09-28 07:24:46.093437+00 | | 2025-09-27 11:02:07.589717+00 |
| public | m_setting_log | 36816 | 0 | 0.00 | 0.00 | | 2025-09-28 01:51:05.799914+00 | | 2025-09-28 22:45:52.502069+00 |
| public | m_site | 189 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.030169+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.535602+00 | | |
| public | m_tx | 186168 | 30756 | 0.00 | 14.00 | | 2025-09-26 12:56:38.175269+00 | | 2025-09-26 12:51:37.651728+00 |
| public | m_user | 38003 | 112 | 0.00 | 0.00 | | 2025-09-25 03:18:58.262558+00 | | 2025-09-24 00:24:08.965179+00 |
| public | m_zone | 7928 | 232 | 0.00 | 2.00 | | 2025-09-22 08:22:57.285515+00 | | 2025-09-25 00:44:34.586772+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.170572+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-28 08:26:24.418839+00 | | |
| public | r_group_auth | 574 | 0 | 0.00 | 0.00 | | 2025-09-24 02:50:26.518569+00 | | |
| public | r_location_zone | 54143 | 757 | 0.00 | 1.00 | | 2025-09-23 09:34:23.237393+00 | | 2025-09-16 22:57:19.988245+00 |
| public | r_pot_auth | 9465 | 0 | 0.00 | 0.00 | | 2025-09-25 23:51:31.814069+00 | | 2025-09-22 00:49:20.732285+00 |
| public | r_pot_category | 14113 | 7 | 0.00 | 0.00 | | 2025-09-25 18:07:07.385886+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 447375 | 126 | 0.00 | 0.00 | | 2025-09-24 04:42:44.737605+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 | 70692 | 120 | 0.00 | 0.00 | | 2025-09-26 02:46:12.901782+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 21364 | 0 | 0.00 | 0.00 | | 2025-09-26 08:20:53.683302+00 | | |
| public | r_provider_tenant | 1173 | 0 | 0.00 | 0.00 | | 2025-09-26 08:25:48.01334+00 | | 2025-09-11 06:34:01.277345+00 |
| public | r_role_feature | 6266 | 8 | 0.00 | 0.00 | | 2025-09-24 23:29:02.367671+00 | | |
| public | r_tenant_feature | 4582 | 0 | 0.00 | 0.00 | | 2025-09-23 19:29:03.024965+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-24 15:31:27.711341+00 | | |
| public | r_user_region | 22203 | 0 | 0.00 | 0.00 | | 2025-09-26 08:20:47.334422+00 | | |
| public | r_user_site | 6372 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.33156+00 | | |
| public | r_zone_category | 5035 | 0 | 0.00 | 0.00 | | 2025-09-25 21:44:09.793467+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-24 07:18:26.946836+00 | | |
| public | t_attendance | 3323876 | 35458 | 0.00 | 1.00 | | 2025-09-23 19:30:00.957583+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4285 | 4 | 0.00 | 0.00 | | 2025-09-24 02:45:28.077086+00 | | |
| public | t_general_20250618 | 3155 | 0 | 0.00 | 0.00 | | 2025-09-25 07:40:53.178749+00 | | |
| public | t_job | 39 | 0 | 0.00 | 0.00 | | 2025-09-25 18:01:07.239135+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 890994 | 0 | 0.00 | 0.00 | | 2025-09-28 23:30:19.361438+00 | | |
| public | t_mobile_status_history | 2103707 | 0 | 0.00 | 0.00 | | 2025-09-26 06:43:52.847749+00 | | 2025-09-04 10:03:21.422779+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.440471+00 | | |
| public | t_notify_history | 6800620 | 2228 | 0.00 | 0.00 | | 2025-09-29 00:01:54.230029+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22563981 | 18 | 0.00 | 0.00 | | 2025-09-25 23:22:08.498288+00 | | |
| public | t_plan | 28926423 | 954921 | 0.00 | 3.00 | | 2025-09-24 11:40:24.231947+00 | | 2025-09-24 11:40:49.257417+00 |
| public | t_plan_cancel_history | 696413 | 1330 | 0.00 | 0.00 | | 2025-09-26 11:53:59.678765+00 | | |
| public | t_plan_detail | 49368902 | 584255 | 0.00 | 1.00 | | 2025-09-26 06:42:29.231983+00 | | 2025-09-26 04:35:17.962469+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 | 108844 | 4482 | 0.00 | 3.00 | | 2025-09-29 00:34:13.597857+00 | | 2025-09-29 00:18:12.758644+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.564337+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.243556+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:24.51431+00 | | |
| public | t_recv_position_history | 152991 | 174861 | 1.00 | 53.00 | | 2025-09-29 00:42:12.827906+00 | 2025-09-28 13:30:05.697783+00 | 2025-09-29 00:43:12.378266+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.303302+00 | | |
| public | t_terminal | 21755 | 2953 | 0.00 | 11.00 | | 2025-09-28 21:35:32.803076+00 | | 2025-09-29 00:25:24.242992+00 |
| public | t_terminal_log | 31297579 | 0 | 0.00 | 0.00 | | 2025-09-25 14:01:30.339582+00 | | 2025-09-21 13:00:59.492055+00 |
| public | temp_pivot_table | 239829 | 0 | 0.00 | 0.00 | | 2025-09-26 15:58:50.989452+00 | | |
| public | w_arrival_notify | 98 | 10 | 0.00 | 9.00 | | 2025-09-26 07:20:51.645836+00 | | 2025-09-26 15:06:49.18336+00 |
| public | w_latest_mobile_device | 57780 | 2324 | 0.00 | 3.00 | | 2025-09-24 08:34:51.638061+00 | | 2025-09-25 21:44:10.894524+00 |
| public | w_latest_mobile_status | 56747 | 5204 | 0.00 | 8.00 | | 2025-09-28 23:51:19.741005+00 | | 2025-09-29 00:30:14.018506+00 |
| public | w_latest_position | 80106 | 60065 | 0.00 | 42.00 | | 2025-09-29 00:43:12.523802+00 | | 2025-09-29 00:43:12.691873+00 |
| public | w_latest_presence | 225404 | 1482296 | 6.00 | 86.00 | | 2025-09-29 00:42:27.836233+00 | | 2025-09-29 00:42:30.31309+00 |
| public | w_latest_sensor | 386 | 66 | 0.00 | 14.00 | | 2025-09-29 00:52:31.456255+00 | | 2025-09-29 00:52:31.570746+00 |
| public | w_lock | 18971 | 1 | 0.00 | 0.00 | | 2025-09-24 19:54:52.573582+00 | | |
| public | w_master_update | 113 | 64 | 0.00 | 36.00 | | 2025-09-28 22:13:50.857827+00 | | 2025-09-29 00:42:13.109567+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-28 12:37:53.287481+00 | | |
| public | w_plan_sync_retry | 0 | 18 | 0 | 100.00 | | 2025-09-28 02:32:50.816814+00 | | 2025-09-28 03:37:51.322391+00 |
| public | w_plan_with_detail | 28506378 | 174996 | 0.00 | 0.00 | | 2025-09-28 21:06:56.358731+00 | | 2025-09-24 13:19:36.375969+00 |