| 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 | 57061041 | 0 | 0.00 | 0.00 | | 2025-09-08 00:28:06.649082+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-09-08 12:43:52.287603+00 | | |
| e202507 | t_position_history | 611252323 | 0 | 0.00 | 0.00 | | 2025-09-09 00:04:01.807572+00 | | |
| e202507 | t_presence_history | 55790665 | 0 | 0.00 | 0.00 | | 2025-09-08 21:09:44.284807+00 | | |
| e202507 | t_sensor_history | 11690418 | 0 | 0.00 | 0.00 | | 2025-09-09 03:50:47.060613+00 | | |
| e202508 | a_proximity_sum | 32424307 | 0 | 0.00 | 0.00 | | 2025-09-08 02:00:56.422554+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36270080 | 0 | 0.00 | 0.00 | | 2025-09-08 07:37:28.810808+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582012906 | 0 | 0.00 | 0.00 | | 2025-09-10 13:06:19.428649+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 54679149 | 0 | 0.00 | 0.00 | | 2025-09-08 03:00:47.6298+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764816 | 0 | 0.00 | 0.00 | | 2025-09-10 02:30:39.823558+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 11898510 | 0 | 0.00 | 0.00 | | 2025-09-10 18:35:45.826521+00 | | 2025-09-10 18:35:55.15242+00 |
| e202509 | a_stay_time | 15971746 | 0 | 0.00 | 0.00 | | 2025-09-10 18:42:07.871418+00 | | 2025-09-10 18:42:08.464489+00 |
| e202509 | t_position_history | 227409328 | 0 | 0.00 | 0.00 | | 2025-09-09 13:10:16.729592+00 | | 2025-09-10 08:51:47.651549+00 |
| e202509 | t_presence_history | 21757360 | 1095001 | 0.00 | 4.00 | | 2025-09-11 00:48:01.977254+00 | | 2025-09-11 00:50:27.539632+00 |
| e202509 | t_sensor_history | 4043523 | 0 | 0.00 | 0.00 | | 2025-09-10 12:38:00.231366+00 | | 2025-09-10 15:17:27.549978+00 |
| public | __digdag_status | 33 | 11 | 0.00 | 25.00 | | 2025-09-08 00:13:05.632803+00 | | 2025-09-06 12:30:47.783954+00 |
| public | a_attendance_sum | 197858 | 4428 | 0.00 | 2.00 | | 2025-09-11 00:29:10.495545+00 | | 2025-09-11 00:21:06.143083+00 |
| public | a_plan_actual | 1069032 | 0 | 0.00 | 0.00 | | 2025-09-10 01:32:05.009404+00 | | 2025-09-02 17:17:15.571058+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-09-09 05:14:01.616097+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-09-09 05:14:00.896483+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-09-09 05:13:59.747769+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-09-10 17:01:25.990262+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-09-10 07:13:21.041857+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-09-10 07:57:48.16125+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.541941+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-09-10 07:57:48.182503+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-09-10 07:57:48.203228+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.563296+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.518058+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-09-10 07:57:45.411599+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.586916+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.607437+00 | | |
| public | l_area | 1559 | 6 | 0.00 | 0.00 | | 2025-09-08 17:16:54.715338+00 | | |
| public | l_auth | 177 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:54.640895+00 | | |
| public | l_category | 2696 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:55.985284+00 | | |
| public | l_group | 36468 | 13 | 0.00 | 0.00 | | 2025-09-08 17:16:58.006518+00 | | |
| public | l_lob | 1962 | 8 | 0.00 | 0.00 | | 2025-09-07 22:00:31.786762+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 105223 | 385 | 0.00 | 0.00 | | 2025-09-08 17:16:55.816882+00 | | |
| public | l_location_zone | 99213 | 8 | 0.00 | 0.00 | | 2025-09-08 17:16:55.15422+00 | | |
| public | l_outside | 454 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:54.655954+00 | | |
| public | l_pot | 438228 | 1066 | 0.00 | 0.00 | | 2025-09-08 17:17:02.278545+00 | | |
| public | l_pot_category | 13743 | 12 | 0.00 | 0.00 | | 2025-09-08 17:16:55.966217+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 230507 | 166 | 0.00 | 0.00 | | 2025-09-08 17:16:57.828943+00 | | |
| public | l_pot_tx | 101678 | 229 | 0.00 | 0.00 | | 2025-09-08 17:16:56.698936+00 | | |
| public | l_role | 774 | 0 | 0.00 | 0.00 | | 2025-09-08 17:15:54.316985+00 | | |
| public | l_role_feature | 6857 | 4 | 0.00 | 0.00 | | 2025-09-08 17:15:54.304525+00 | | |
| public | l_site | 258 | 1 | 0.00 | 0.00 | | 2025-09-08 17:16:54.73031+00 | | |
| public | l_tx | 135607 | 1571 | 0.00 | 1.00 | | 2025-09-08 23:33:21.459577+00 | | 2025-09-05 13:46:26.432571+00 |
| public | l_user | 63506 | 394 | 0.00 | 0.00 | | 2025-09-08 17:15:54.234464+00 | | 2025-09-05 09:09:18.220322+00 |
| public | l_zone | 9794 | 2 | 0.00 | 0.00 | | 2025-09-08 17:16:55.21462+00 | | |
| public | l_zone_category | 4986 | 0 | 0.00 | 0.00 | | 2025-09-08 17:15:53.610457+00 | | |
| public | m_area | 786 | 4 | 0.00 | 0.00 | | 2025-09-10 04:39:39.05262+00 | | |
| public | m_auth | 143 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:01.833046+00 | | |
| public | m_category | 2433 | 0 | 0.00 | 0.00 | | 2025-09-10 04:39:38.769675+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-09-10 23:41:44.944613+00 | | |
| public | m_exb | 27205 | 87 | 0.00 | 0.00 | | 2025-09-09 03:00:15.759305+00 | | |
| public | m_favorite | 217373 | 274 | 0.00 | 0.00 | | 2025-09-09 23:11:44.683475+00 | | |
| public | m_favorite_group | 115149 | 107 | 0.00 | 0.00 | | 2025-09-06 05:51:13.45764+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-09-09 07:28:27.512178+00 | | |
| public | m_group | 28075 | 1610 | 0.00 | 5.00 | | 2025-09-06 01:18:38.658039+00 | | 2025-09-10 14:40:27.718447+00 |
| public | m_holiday | 43937 | 0 | 0.00 | 0.00 | | 2025-09-08 03:38:53.597851+00 | | |
| public | m_lob | 24608 | 27 | 0.00 | 0.00 | | 2025-09-08 06:48:59.455649+00 | | |
| public | m_lob_log | 2041 | 0 | 0.00 | 0.00 | | 2025-09-07 23:32:32.875571+00 | | |
| public | m_location | 44810 | 308 | 0.00 | 0.00 | | 2025-09-10 02:43:18.821835+00 | | 2025-08-29 11:38:48.027813+00 |
| public | m_notify_template | 1231 | 6 | 0.00 | 0.00 | | 2025-09-09 05:14:02.004786+00 | | |
| public | m_outside | 377 | 8 | 0.00 | 2.00 | | 2025-09-07 06:59:04.858578+00 | | |
| public | m_personal_setting | 133604 | 18033 | 0.00 | 11.00 | | 2025-09-06 13:20:39.169712+00 | | 2025-09-11 00:17:06.414597+00 |
| public | m_pot | 203764 | 13473 | 0.00 | 6.00 | | 2025-09-09 09:41:04.228012+00 | | 2025-09-11 00:13:09.99761+00 |
| public | m_pot_profile | 52716 | 32 | 0.00 | 0.00 | | 2025-09-08 11:01:36.882003+00 | | |
| public | m_provider_user | 85 | 0 | 0.00 | 0.00 | | 2025-09-09 08:13:19.655811+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:02.084305+00 | | |
| public | m_role | 777 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:02.072333+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:01.98221+00 | | |
| public | m_setting | 29915 | 1565 | 0.00 | 4.00 | | 2025-09-10 02:28:39.220329+00 | | 2025-09-09 06:50:01.438548+00 |
| public | m_setting_log | 36778 | 0 | 0.00 | 0.00 | | 2025-09-08 03:01:07.510349+00 | | 2025-09-10 14:14:25.72249+00 |
| public | m_site | 189 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:01.632856+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:02.117979+00 | | |
| public | m_tx | 121868 | 18527 | 0.00 | 13.00 | | 2025-09-08 00:45:34.811526+00 | | 2025-09-08 04:06:24.656094+00 |
| public | m_user | 36253 | 246 | 0.00 | 0.00 | | 2025-09-06 17:29:02.142298+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 8634 | 4 | 0.00 | 0.00 | | 2025-09-09 11:46:07.611479+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-09-09 05:13:59.722963+00 | | |
| public | r_auth_zone | 215 | 0 | 0.00 | 0.00 | | 2025-09-09 23:57:02.714158+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:02.031926+00 | | |
| public | r_group_auth | 567 | 0 | 0.00 | 0.00 | | 2025-09-10 18:34:14.789049+00 | | |
| public | r_location_zone | 55582 | 5 | 0.00 | 0.00 | | 2025-09-10 04:39:38.747801+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8170 | 38 | 0.00 | 0.00 | | 2025-09-08 00:28:04.397293+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 11760 | 36 | 0.00 | 0.00 | | 2025-09-07 22:08:45.308061+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 443772 | 0 | 0.00 | 0.00 | | 2025-09-10 23:41:44.920669+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-09-09 12:18:07.687294+00 | | |
| public | r_pot_tx | 70155 | 277 | 0.00 | 0.00 | | 2025-09-08 02:48:38.40331+00 | | |
| public | r_pot_user | 20678 | 6 | 0.00 | 0.00 | | 2025-09-08 07:18:35.477781+00 | | |
| public | r_provider_tenant | 944 | 0 | 0.00 | 0.00 | | 2025-09-08 07:33:06.10313+00 | | 2025-09-08 07:32:05.893484+00 |
| public | r_role_feature | 6050 | 8 | 0.00 | 0.00 | | 2025-09-06 06:42:00.752074+00 | | |
| public | r_tenant_feature | 4580 | 0 | 0.00 | 0.00 | | 2025-09-10 07:12:11.364705+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-06 01:18:38.684822+00 | | |
| public | r_user_region | 21520 | 6 | 0.00 | 0.00 | | 2025-09-08 07:18:28.251598+00 | | |
| public | r_user_site | 5559 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:01.955979+00 | | |
| public | r_zone_category | 4954 | 0 | 0.00 | 0.00 | | 2025-09-07 23:32:32.841277+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-05 11:13:04.780161+00 | | |
| public | t_attendance | 3293864 | 6735 | 0.00 | 0.00 | | 2025-09-10 07:13:01.458336+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4212 | 1 | 0.00 | 0.00 | | 2025-09-10 17:01:25.873137+00 | | |
| public | t_general_20250618 | 3305 | 0 | 0.00 | 0.00 | | 2025-09-07 06:30:48.325152+00 | | |
| public | t_job | 32 | 1 | 0.00 | 3.00 | | 2025-09-07 22:03:31.056353+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 893082 | 0 | 0.00 | 0.00 | | 2025-09-09 08:47:30.700406+00 | | |
| public | t_mobile_status_history | 2035107 | 0 | 0.00 | 0.00 | | 2025-09-08 06:05:54.597934+00 | | 2025-09-04 10:03:21.422779+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:02.055154+00 | | |
| public | t_notify_history | 6536481 | 5905 | 0.00 | 0.00 | | 2025-09-09 09:04:46.711356+00 | | |
| public | t_operation_log | 22262415 | 34 | 0.00 | 0.00 | | 2025-09-08 00:13:05.553378+00 | | |
| public | t_plan | 28068723 | 1263772 | 0.00 | 4.00 | | 2025-09-05 22:18:30.908913+00 | | 2025-09-10 18:51:26.090908+00 |
| public | t_plan_cancel_history | 615507 | 62219 | 0.00 | 9.00 | | 2025-09-08 09:22:15.069517+00 | | |
| public | t_plan_detail | 48136421 | 1659056 | 0.00 | 3.00 | | 2025-09-08 06:05:42.975431+00 | | 2025-09-10 23:15:45.167194+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-09-09 12:18:07.668991+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-09-09 12:18:07.644138+00 | | |
| public | t_plan_sync | 67650 | 11919 | 0.00 | 14.00 | | 2025-09-10 23:16:45.799795+00 | | 2025-09-11 00:35:07.680604+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-09-09 05:14:02.150614+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-09-09 05:13:59.794063+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-09-09 05:14:02.105977+00 | | |
| public | t_recv_position_history | 153883 | 15904 | 0.00 | 9.00 | | 2025-09-11 00:52:30.171641+00 | 2025-09-10 13:30:06.670848+00 | 2025-09-11 00:52:30.614542+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-09 05:13:59.856928+00 | | |
| public | t_terminal | 20998 | 2270 | 0.00 | 9.00 | | 2025-09-10 19:45:29.562302+00 | | 2025-09-11 00:44:08.351732+00 |
| public | t_terminal_log | 28893562 | 0 | 0.00 | 0.00 | | 2025-09-07 18:11:12.886005+00 | | |
| public | temp_pivot_table | 240042 | 0 | 0.00 | 0.00 | | 2025-09-08 11:01:38.98329+00 | | |
| public | w_arrival_notify | 98 | 29 | 0.00 | 22.00 | | 2025-09-08 12:43:52.15648+00 | | 2025-09-10 04:43:38.989167+00 |
| public | w_latest_mobile_device | 57028 | 2585 | 0.00 | 4.00 | | 2025-09-05 13:44:09.460437+00 | | 2025-09-10 00:26:33.083157+00 |
| public | w_latest_mobile_status | 55995 | 4785 | 0.00 | 7.00 | | 2025-09-10 23:59:46.443196+00 | | 2025-09-11 00:36:06.944177+00 |
| public | w_latest_position | 79449 | 25272 | 0.00 | 24.00 | | 2025-09-11 00:52:30.744111+00 | | 2025-09-11 00:52:30.921394+00 |
| public | w_latest_presence | 234783 | 153022 | 0.00 | 39.00 | | 2025-09-11 00:52:46.597337+00 | | 2025-09-11 00:52:49.033353+00 |
| public | w_latest_sensor | 386 | 235 | 0.00 | 37.00 | | 2025-09-11 00:52:30.936764+00 | | 2025-09-11 00:52:31.975451+00 |
| public | w_lock | 18633 | 0 | 0.00 | 0.00 | | 2025-09-06 03:45:47.195658+00 | | |
| public | w_master_update | 113 | 63 | 0.00 | 35.00 | | 2025-09-10 23:17:43.745621+00 | | 2025-09-11 00:39:10.229297+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-09 06:06:44.700249+00 | | |
| public | w_plan_sync_retry | 1 | 35 | 35.00 | 97.00 | | 2025-09-10 10:23:47.117259+00 | | 2025-09-11 00:48:26.209661+00 |
| public | w_plan_with_detail | 28118897 | 691157 | 0.00 | 2.00 | | 2025-09-09 08:12:54.593391+00 | | 2025-09-10 15:01:28.601384+00 |