| 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 |
|---|
| e202506 | a_proximity_sum | 31875043 | 0 | 0.00 | 0.00 | | 2025-08-26 08:13:00.615066+00 | | |
| e202506 | a_stay_time | 42841987 | 0 | 0.00 | 0.00 | | 2025-08-25 23:19:52.473101+00 | | |
| e202506 | t_position_history | 547026602 | 0 | 0.00 | 0.00 | | 2025-08-27 11:06:49.177973+00 | | |
| e202506 | t_presence_history | 67840651 | 0 | 0.00 | 0.00 | | 2025-08-26 19:31:47.153914+00 | | |
| e202506 | t_sensor_history | 11758360 | 0 | 0.00 | 0.00 | | 2025-08-30 00:06:43.087749+00 | | |
| e202507 | a_proximity_sum | 57061161 | 0 | 0.00 | 0.00 | | 2025-08-28 04:11:00.867822+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-08-29 01:19:12.377192+00 | | |
| e202507 | t_position_history | 610147561 | 0 | 0.00 | 0.00 | | 2025-08-29 05:11:18.352514+00 | | |
| e202507 | t_presence_history | 55790761 | 0 | 0.00 | 0.00 | | 2025-08-29 03:31:56.746341+00 | | |
| e202507 | t_sensor_history | 11690426 | 0 | 0.00 | 0.00 | | 2025-08-29 09:20:05.086305+00 | | |
| e202508 | a_proximity_sum | 34046475 | 0 | 0.00 | 0.00 | | 2025-08-28 05:51:15.974026+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36220387 | 0 | 0.00 | 0.00 | | 2025-08-28 15:21:13.177374+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 568570201 | 0 | 0.00 | 0.00 | | 2025-08-26 07:29:14.725515+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 52246746 | 6221239 | 0.00 | 10.00 | | 2025-08-30 00:20:43.120205+00 | | 2025-08-30 00:50:12.016952+00 |
| e202508 | t_sensor_history | 11394208 | 0 | 0.00 | 0.00 | | 2025-08-25 23:05:13.740337+00 | | 2025-08-28 22:46:31.047543+00 |
| public | __digdag_status | 32 | 8 | 0.00 | 20.00 | | 2025-08-28 03:47:37.696146+00 | | 2025-08-28 12:30:18.362409+00 |
| public | a_attendance_sum | 147873 | 26669 | 0.00 | 15.00 | | 2025-08-28 01:41:58.658146+00 | | 2025-08-29 09:49:06.510597+00 |
| public | a_plan_actual | 935402 | 0 | 0.00 | 0.00 | | 2025-08-25 19:44:13.32388+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:45.556903+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:44.85802+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:43.56926+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-08-26 07:41:34.392053+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:49.671035+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-08-26 04:24:03.325027+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.355582+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-08-26 04:24:03.35024+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-08-26 04:24:03.370724+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.375533+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.331476+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-08-26 04:24:01.496523+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.397932+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-08-26 03:38:00.419021+00 | | |
| public | l_area | 1539 | 8 | 0.00 | 0.00 | | 2025-08-29 02:39:03.624866+00 | | |
| public | l_auth | 173 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:03.531273+00 | | |
| public | l_category | 2684 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:05.006558+00 | | |
| public | l_group | 35413 | 7 | 0.00 | 0.00 | | 2025-08-29 02:39:07.069636+00 | | |
| public | l_lob | 1925 | 15 | 0.00 | 0.00 | | 2025-08-26 10:11:39.840951+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 103104 | 396 | 0.00 | 0.00 | | 2025-08-29 02:39:04.798722+00 | | |
| public | l_location_zone | 100211 | 1621 | 0.00 | 1.00 | | 2025-08-29 02:39:04.037808+00 | | |
| public | l_outside | 441 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:03.559857+00 | | |
| public | l_pot | 431914 | 863 | 0.00 | 0.00 | | 2025-08-29 02:39:13.107243+00 | | |
| public | l_pot_category | 13384 | 152 | 0.00 | 1.00 | | 2025-08-29 02:39:04.916179+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 227642 | 461 | 0.00 | 0.00 | | 2025-08-29 02:39:06.870491+00 | | |
| public | l_pot_tx | 98553 | 126 | 0.00 | 0.00 | | 2025-08-29 02:39:05.678988+00 | | |
| public | l_role | 769 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:01.364422+00 | | |
| public | l_role_feature | 6183 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:01.28785+00 | | |
| public | l_site | 254 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:03.652806+00 | | |
| public | l_tx | 140889 | 24233 | 0.00 | 14.00 | | 2025-08-29 11:55:59.762298+00 | | 2025-08-29 12:08:56.982472+00 |
| public | l_user | 62027 | 129 | 0.00 | 0.00 | | 2025-08-29 02:39:01.147802+00 | | |
| public | l_zone | 9977 | 6 | 0.00 | 0.00 | | 2025-08-29 02:39:04.132076+00 | | |
| public | l_zone_category | 5212 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:00.228516+00 | | |
| public | m_area | 783 | 18 | 0.00 | 2.00 | | 2025-08-26 01:14:55.996512+00 | | |
| public | m_auth | 141 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.588843+00 | | |
| public | m_category | 2421 | 11 | 0.00 | 0.00 | | 2025-08-26 01:14:55.663505+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-08-26 10:09:39.884392+00 | | |
| public | m_exb | 26434 | 95 | 0.00 | 0.00 | | 2025-08-29 08:31:43.277481+00 | | |
| public | m_favorite | 239222 | 1077 | 0.00 | 0.00 | | 2025-08-25 12:13:48.901453+00 | | |
| public | m_favorite_group | 113284 | 136 | 0.00 | 0.00 | | 2025-08-27 04:11:18.789539+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-08-29 20:56:34.194737+00 | | |
| public | m_group | 27906 | 1204 | 0.00 | 4.00 | | 2025-08-27 02:15:21.692043+00 | | 2025-08-29 14:40:13.956404+00 |
| public | m_holiday | 43942 | 0 | 0.00 | 0.00 | | 2025-08-28 07:28:59.552994+00 | | |
| public | m_lob | 24498 | 25 | 0.00 | 0.00 | | 2025-08-28 12:37:15.856479+00 | | |
| public | m_lob_log | 1963 | 0 | 0.00 | 0.00 | | 2025-08-28 03:08:18.640809+00 | | |
| public | m_location | 44580 | 1722 | 0.00 | 3.00 | | 2025-08-25 23:22:15.217914+00 | | 2025-08-29 11:38:48.027813+00 |
| public | m_notify_template | 1224 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.923329+00 | | |
| public | m_outside | 372 | 0 | 0.00 | 0.00 | | 2025-08-27 22:21:30.813856+00 | | |
| public | m_personal_setting | 132066 | 17330 | 0.00 | 11.00 | | 2025-08-27 07:10:30.84288+00 | | 2025-08-29 12:33:55.209765+00 |
| public | m_pot | 200679 | 29609 | 0.00 | 12.00 | | 2025-08-25 06:50:55.353411+00 | | 2025-08-29 08:05:47.999574+00 |
| public | m_pot_profile | 52353 | 0 | 0.00 | 0.00 | | 2025-08-29 00:24:59.621977+00 | | |
| public | m_provider_user | 84 | 0 | 0.00 | 0.00 | | 2025-08-30 00:11:13.188894+00 | | |
| public | m_region | 113 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.065754+00 | | |
| public | m_role | 772 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.022102+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.717675+00 | | |
| public | m_setting | 30121 | 1327 | 0.00 | 4.00 | | 2025-08-29 05:12:18.057324+00 | | 2025-08-28 20:56:22.770823+00 |
| public | m_setting_log | 36389 | 0 | 0.00 | 0.00 | | 2025-08-29 02:36:01.163381+00 | | 2025-08-29 16:48:16.145703+00 |
| public | m_site | 187 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.577023+00 | | |
| public | m_tenant | 112 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.099196+00 | | |
| public | m_tx | 120914 | 11106 | 0.00 | 8.00 | | 2025-08-29 12:17:53.661403+00 | | 2025-08-29 12:17:53.838711+00 |
| public | m_user | 36314 | 172 | 0.00 | 0.00 | | 2025-08-27 07:58:40.272056+00 | | |
| public | m_zone | 7847 | 78 | 0.00 | 0.00 | | 2025-08-25 07:48:17.883557+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.541931+00 | | |
| public | r_auth_zone | 214 | 0 | 0.00 | 0.00 | | 2025-08-25 13:21:06.214384+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.950491+00 | | |
| public | r_group_auth | 557 | 0 | 0.00 | 0.00 | | 2025-08-26 08:13:00.546406+00 | | |
| public | r_location_zone | 54125 | 1648 | 0.00 | 2.00 | | 2025-08-26 01:14:55.631973+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8058 | 3 | 0.00 | 0.00 | | 2025-08-28 04:10:54.559129+00 | | |
| public | r_pot_category | 11651 | 357 | 0.00 | 2.00 | | 2025-08-28 02:16:28.437743+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 435309 | 538 | 0.00 | 0.00 | | 2025-08-26 10:09:39.838734+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-08-25 08:00:37.796162+00 | | |
| public | r_pot_tx | 69801 | 418 | 0.00 | 0.00 | | 2025-08-28 06:41:32.962464+00 | | |
| public | r_pot_user | 20039 | 19 | 0.00 | 0.00 | | 2025-08-28 14:02:52.624522+00 | | |
| public | r_provider_tenant | 1241 | 0 | 0.00 | 0.00 | | 2025-08-29 05:33:21.593808+00 | | |
| public | r_role_feature | 5937 | 23 | 0.00 | 0.00 | | 2025-08-27 04:26:37.059589+00 | | |
| public | r_tenant_feature | 4419 | 34 | 0.00 | 0.00 | | 2025-08-26 03:37:52.872125+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-08-27 02:15:21.703208+00 | | |
| public | r_user_region | 21398 | 19 | 0.00 | 0.00 | | 2025-08-28 14:02:51.893863+00 | | |
| public | r_user_site | 6254 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.686288+00 | | |
| public | r_zone_category | 4964 | 0 | 0.00 | 0.00 | | 2025-08-28 03:08:18.608534+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-08-26 18:00:01.5338+00 | | |
| public | t_attendance | 3193564 | 39843 | 0.00 | 1.00 | | 2025-08-26 03:38:49.64713+00 | | |
| public | t_general | 4163 | 4 | 0.00 | 0.00 | | 2025-08-26 07:32:50.956286+00 | | |
| public | t_general_20250618 | 3410 | 0 | 0.00 | 0.00 | | 2025-08-27 17:02:52.764855+00 | | |
| public | t_job | 31 | 15 | 0.00 | 32.00 | | | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 951602 | 2 | 0.00 | 0.00 | | 2025-08-25 06:01:22.867229+00 | | |
| public | t_mobile_status_history | 1835295 | 0 | 0.00 | 0.00 | | 2025-08-28 10:21:25.44824+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.972227+00 | | |
| public | t_notify_history | 6491507 | 14386 | 0.00 | 0.00 | | 2025-08-25 06:17:31.445402+00 | | |
| public | t_operation_log | 21945322 | 28 | 0.00 | 0.00 | | 2025-08-28 03:47:37.590212+00 | | |
| public | t_plan | 27495617 | 1027719 | 0.00 | 3.00 | | 2025-08-27 01:10:39.679048+00 | | 2025-08-27 01:17:16.258795+00 |
| public | t_plan_cancel_history | 590987 | 18350 | 0.00 | 3.00 | | 2025-08-28 23:05:37.563117+00 | | |
| public | t_plan_detail | 46951594 | 1093150 | 0.00 | 2.00 | | 2025-08-28 10:03:48.699853+00 | | 2025-08-29 02:50:54.584931+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-08-25 08:00:37.77739+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-08-25 08:00:37.756937+00 | | |
| public | t_plan_sync | 65959 | 4937 | 0.00 | 6.00 | | 2025-08-30 00:37:10.722338+00 | | 2025-08-30 00:37:11.045586+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.13182+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.603149+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:46.077048+00 | | |
| public | t_recv_position_history | 144046 | 7625 | 0.00 | 5.00 | | 2025-08-30 00:51:11.044497+00 | 2025-08-29 13:30:02.815987+00 | 2025-08-30 00:51:11.522889+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.839998+00 | | |
| public | t_terminal | 20934 | 3104 | 0.00 | 12.00 | | 2025-08-29 19:50:29.030376+00 | | 2025-08-30 00:22:11.244119+00 |
| public | t_terminal_log | 27949777 | 0 | 0.00 | 0.00 | | 2025-08-28 01:39:25.712669+00 | | |
| public | temp_pivot_table | 240184 | 0 | 0.00 | 0.00 | | 2025-08-29 00:25:06.94772+00 | | |
| public | w_arrival_notify | 97 | 12 | 0.00 | 11.00 | | 2025-08-29 01:19:12.397653+00 | | 2025-08-27 23:53:09.287893+00 |
| public | w_latest_mobile_device | 56342 | 683 | 0.00 | 1.00 | | 2025-08-26 22:47:03.156676+00 | | 2025-08-25 02:17:24.507308+00 |
| public | w_latest_mobile_status | 55312 | 7815 | 0.00 | 12.00 | | 2025-08-29 05:46:57.789334+00 | | 2025-08-29 13:34:33.693695+00 |
| public | w_latest_position | 79180 | 3416 | 0.00 | 4.00 | | 2025-08-30 00:51:11.707754+00 | | 2025-08-30 00:51:11.869522+00 |
| public | w_latest_presence | 210918 | 88152 | 0.00 | 29.00 | | 2025-08-30 00:51:29.309278+00 | | 2025-08-30 00:51:31.820969+00 |
| public | w_latest_sensor | 386 | 212 | 0.00 | 35.00 | | 2025-08-30 00:51:12.515244+00 | | 2025-08-30 00:51:12.62835+00 |
| public | w_lock | 18404 | 5 | 0.00 | 0.00 | | 2025-08-27 03:17:30.783256+00 | | |
| public | w_master_update | 195 | 17 | 0.00 | 8.00 | | 2025-08-29 23:38:41.604829+00 | | 2025-08-29 22:02:31.557927+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-08-29 14:40:13.993678+00 | | |
| public | w_plan_sync_retry | 0 | 6 | 0 | 100.00 | | 2025-08-29 12:52:32.087854+00 | | 2025-08-29 11:38:48.041855+00 |
| public | w_plan_with_detail | 27180678 | 2933 | 0.00 | 0.00 | | 2025-08-29 23:38:14.910805+00 | | 2025-08-27 01:19:10.217508+00 |