| 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-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 | 582013073 | 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 | 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 | 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 | 24909151 | 0 | 0.00 | 0.00 | | 2025-09-24 15:49:44.104555+00 | | 2025-09-24 18:37:47.228879+00 |
| e202509 | a_stay_time | 32775045 | 0 | 0.00 | 0.00 | | 2025-09-24 17:11:27.067147+00 | | 2025-09-25 15:45:54.973264+00 |
| e202509 | t_position_history | 508068300 | 0 | 0.00 | 0.00 | | 2025-09-23 14:08:50.634291+00 | | 2025-09-24 08:52:53.886698+00 |
| e202509 | t_presence_history | 58747794 | 667841 | 0.00 | 1.00 | | 2025-09-26 00:46:49.130565+00 | | 2025-09-26 00:27:35.178073+00 |
| e202509 | t_sensor_history | 9872501 | 0 | 0.00 | 0.00 | | 2025-09-23 14:18:42.970823+00 | | 2025-09-24 14:09:29.564634+00 |
| public | __digdag_status | 33 | 0 | 0.00 | 0.00 | | 2025-09-25 23:22:08.912724+00 | | 2025-09-24 12:30:52.444456+00 |
| public | a_attendance_sum | 158060 | 21238 | 0.00 | 11.00 | | 2025-09-24 05:23:42.10948+00 | | 2025-09-26 00:47:11.165597+00 |
| public | a_plan_actual | 1155011 | 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-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-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 | 1 | 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 | 37069 | 102 | 0.00 | 0.00 | | 2025-09-20 17:46:11.556034+00 | | |
| public | l_lob | 2015 | 0 | 0.00 | 0.00 | | 2025-09-25 18:01:07.224287+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 116083 | 621 | 0.00 | 0.00 | | 2025-09-20 17:46:08.856445+00 | | 2025-09-15 08:51:20.047628+00 |
| public | l_location_zone | 106699 | 969 | 0.00 | 0.00 | | 2025-09-20 17:46:07.868669+00 | | 2025-09-12 06:37:57.741842+00 |
| public | l_outside | 454 | 1 | 0.00 | 0.00 | | 2025-09-20 17:46:07.321458+00 | | |
| public | l_pot | 447335 | 5356 | 0.00 | 1.00 | | 2025-09-20 17:46:15.81417+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 14046 | 26 | 0.00 | 0.00 | | 2025-09-20 17:46:09.025912+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 231651 | 267 | 0.00 | 0.00 | | 2025-09-20 17:46:11.331477+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 102921 | 298 | 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 | 6750 | 7 | 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 | 150988 | 9541 | 0.00 | 5.00 | | 2025-09-24 04:04:40.778461+00 | | 2025-09-24 09:00:06.15134+00 |
| public | l_user | 64975 | 1046 | 0.00 | 1.00 | | 2025-09-20 17:46:05.432142+00 | | 2025-09-05 09:09:18.220322+00 |
| public | l_zone | 9795 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:07.969265+00 | | |
| public | l_zone_category | 4890 | 0 | 0.00 | 0.00 | | 2025-09-20 17:46:04.506444+00 | | |
| public | m_area | 790 | 17 | 0.00 | 2.00 | | 2025-09-23 09:34:23.312986+00 | | |
| public | m_auth | 149 | 0 | 0.00 | 0.00 | | 2025-09-22 00:28:35.738774+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 | 27407 | 23 | 0.00 | 0.00 | | 2025-09-21 17:11:43.250279+00 | | |
| public | m_favorite | 232508 | 400 | 0.00 | 0.00 | | 2025-09-22 17:05:46.180896+00 | | |
| public | m_favorite_group | 117104 | 20 | 0.00 | 0.00 | | 2025-09-24 22:52:40.587625+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-09-22 03:58:14.147087+00 | | |
| public | m_group | 28024 | 911 | 0.00 | 3.00 | | 2025-09-24 15:31:27.687202+00 | | 2025-09-24 14:40:33.260053+00 |
| public | m_holiday | 43842 | 0 | 0.00 | 0.00 | | 2025-09-19 08:19:25.61968+00 | | |
| public | m_lob | 24709 | 47 | 0.00 | 0.00 | | 2025-09-19 16:32:52.646057+00 | | |
| public | m_lob_log | 2055 | 0 | 0.00 | 0.00 | | 2025-09-25 21:44:10.253938+00 | | |
| public | m_location | 45324 | 233 | 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-22 00:28:35.909906+00 | | |
| public | m_outside | 377 | 0 | 0.00 | 0.00 | | 2025-09-25 07:43:52.287136+00 | | |
| public | m_personal_setting | 135242 | 15472 | 0.00 | 10.00 | | 2025-09-25 02:13:15.489112+00 | | 2025-09-26 00:04:33.167064+00 |
| public | m_pot | 207906 | 13387 | 0.00 | 6.00 | | 2025-09-22 06:46:50.629157+00 | | 2025-09-24 14:40:31.900251+00 |
| public | m_pot_profile | 52039 | 118 | 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 | 16203 | 2964 | 0.00 | 15.00 | | 2025-09-24 06:51:30.178012+00 | | 2025-09-25 15:29:53.4556+00 |
| public | m_setting_log | 37014 | 1696 | 0.00 | 4.00 | | 2025-09-23 02:16:57.747993+00 | | 2025-09-25 08:43:51.994504+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 | 130498 | 23820 | 0.00 | 15.00 | | 2025-09-25 02:49:36.452646+00 | | 2025-09-25 23:16:40.802096+00 |
| public | m_user | 37988 | 29 | 0.00 | 0.00 | | 2025-09-25 03:18:58.262558+00 | | 2025-09-24 00:24:08.965179+00 |
| public | m_zone | 7927 | 219 | 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-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 | 0 | 0.00 | 0.00 | | 2025-09-24 02:50:26.518569+00 | | |
| public | r_location_zone | 54154 | 562 | 0.00 | 1.00 | | 2025-09-23 09:34:23.237393+00 | | 2025-09-16 22:57:19.988245+00 |
| public | r_pot_auth | 9464 | 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 | 14099 | 0 | 0.00 | 0.00 | | 2025-09-25 18:07:07.385886+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 447336 | 74 | 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 | 70639 | 340 | 0.00 | 0.00 | | 2025-09-19 07:23:32.429621+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 21351 | 4 | 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 | 6230 | 2 | 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 | 22190 | 6 | 0.00 | 0.00 | | 2025-09-19 20:48:06.404386+00 | | |
| public | r_user_site | 5562 | 2 | 0.00 | 0.00 | | 2025-09-22 00:28:35.854524+00 | | |
| public | r_zone_category | 5034 | 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 | 3312809 | 24417 | 0.00 | 0.00 | | 2025-09-23 19:30:00.957583+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4273 | 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 | 889595 | 0 | 0.00 | 0.00 | | 2025-09-22 05:42:05.331232+00 | | |
| public | t_mobile_status_history | 2109754 | 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 | 6818641 | 11963 | 0.00 | 0.00 | | 2025-09-22 06:16:36.580815+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22486498 | 1 | 0.00 | 0.00 | | 2025-09-25 23:22:08.498288+00 | | |
| public | t_plan | 28828721 | 595011 | 0.00 | 2.00 | | 2025-09-24 11:40:24.231947+00 | | 2025-09-24 11:40:49.257417+00 |
| public | t_plan_cancel_history | 704454 | 67308 | 0.00 | 8.00 | | 2025-09-20 04:42:59.465495+00 | | |
| public | t_plan_detail | 49302155 | 1530807 | 0.00 | 3.00 | | 2025-09-19 13:47:02.988837+00 | | 2025-09-24 03:38:45.699608+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 | 67826 | 12075 | 0.00 | 15.00 | | 2025-09-25 23:35:32.528863+00 | | 2025-09-26 00:34:33.84851+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 | 152551 | 25152 | 0.00 | 14.00 | | 2025-09-26 00:50:08.399544+00 | 2025-09-25 13:30:07.883449+00 | 2025-09-26 00:50:08.64402+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-22 00:28:33.953803+00 | | |
| public | t_terminal | 21744 | 2692 | 0.00 | 11.00 | | 2025-09-25 21:35:37.209967+00 | | 2025-09-26 00:47:13.115168+00 |
| public | t_terminal_log | 30980529 | 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 | 239900 | 0 | 0.00 | 0.00 | | 2025-09-20 09:09:16.500967+00 | | |
| public | w_arrival_notify | 98 | 60 | 0.00 | 37.00 | | 2025-09-20 12:14:01.043555+00 | | 2025-09-25 04:04:58.972948+00 |
| public | w_latest_mobile_device | 57740 | 1865 | 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 | 56706 | 3483 | 0.00 | 5.00 | | 2025-09-26 00:08:34.284087+00 | | 2025-09-26 00:47:10.463895+00 |
| public | w_latest_position | 80090 | 39969 | 0.00 | 33.00 | | 2025-09-26 00:50:08.78811+00 | | 2025-09-26 00:50:08.962704+00 |
| public | w_latest_presence | 250569 | 270305 | 1.00 | 51.00 | | 2025-09-26 00:50:22.788783+00 | | 2025-09-26 00:50:25.156865+00 |
| public | w_latest_sensor | 386 | 422 | 1.00 | 52.00 | | 2025-09-26 00:50:08.980302+00 | | 2025-09-26 00:50:09.092828+00 |
| public | w_lock | 18884 | 0 | 0.00 | 0.00 | | 2025-09-24 19:54:52.573582+00 | | |
| public | w_master_update | 113 | 70 | 0.00 | 38.00 | | 2025-09-25 21:31:36.338127+00 | | 2025-09-26 00:47:09.153158+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-22 01:55:00.417322+00 | | |
| public | w_plan_sync_retry | 0 | 22 | 0 | 100.00 | | 2025-09-25 23:47:38.493187+00 | | 2025-09-25 23:51:32.38581+00 |
| public | w_plan_with_detail | 28823033 | 1107017 | 0.00 | 3.00 | | 2025-09-22 04:44:10.133184+00 | | 2025-09-24 13:19:36.375969+00 |