| 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 | 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 | 34091800 | 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 | 36289618 | 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 | 577890241 | 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 | 53453767 | 8629217 | 0.00 | 13.00 | | 2025-08-30 23:52:48.513055+00 | | 2025-08-31 00:27:21.309493+00 |
| e202508 | t_sensor_history | 11785560 | 0 | 0.00 | 0.00 | | 2025-08-25 23:05:13.740337+00 | | 2025-08-28 22:46:31.047543+00 |
| public | __digdag_status | 33 | 11 | 0.00 | 25.00 | | 2025-08-28 03:47:37.696146+00 | | 2025-08-28 12:30:18.362409+00 |
| public | a_attendance_sum | 147880 | 26814 | 0.00 | 15.00 | | 2025-08-28 01:41:58.658146+00 | | 2025-08-30 06:42:42.411393+00 |
| public | a_plan_actual | 933670 | 0 | 0.00 | 0.00 | | 2025-08-30 23:36:05.630777+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 | 1541 | 10 | 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 | 13 | 0.00 | 0.00 | | 2025-08-26 10:11:39.840951+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 103153 | 445 | 0.00 | 0.00 | | 2025-08-29 02:39:04.798722+00 | | |
| public | l_location_zone | 100294 | 1702 | 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 | 432001 | 948 | 0.00 | 0.00 | | 2025-08-29 02:39:13.107243+00 | | |
| public | l_pot_category | 13386 | 154 | 0.00 | 1.00 | | 2025-08-29 02:39:04.916179+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 227677 | 495 | 0.00 | 0.00 | | 2025-08-29 02:39:06.870491+00 | | |
| public | l_pot_tx | 98553 | 138 | 0.00 | 0.00 | | 2025-08-29 02:39:05.678988+00 | | |
| public | l_role | 770 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:01.364422+00 | | |
| public | l_role_feature | 6223 | 3 | 0.00 | 0.00 | | 2025-08-29 02:39:01.28785+00 | | |
| public | l_site | 255 | 1 | 0.00 | 0.00 | | 2025-08-29 02:39:03.652806+00 | | |
| public | l_tx | 140893 | 10302 | 0.00 | 6.00 | | 2025-08-30 04:31:36.816025+00 | | 2025-08-30 04:33:36.638613+00 |
| public | l_user | 62029 | 132 | 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 | 20 | 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 | 97 | 0.00 | 0.00 | | 2025-08-29 08:31:43.277481+00 | | |
| public | m_favorite | 235477 | 6 | 0.00 | 0.00 | | 2025-08-30 15:17:27.111905+00 | | |
| public | m_favorite_group | 113272 | 160 | 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 | 1278 | 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 | 24496 | 27 | 0.00 | 0.00 | | 2025-08-28 12:37:15.856479+00 | | |
| public | m_lob_log | 1965 | 0 | 0.00 | 0.00 | | 2025-08-28 03:08:18.640809+00 | | |
| public | m_location | 44580 | 1757 | 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 | 132036 | 17001 | 0.00 | 11.00 | | 2025-08-27 07:10:30.84288+00 | | 2025-08-30 12:28:13.483573+00 |
| public | m_pot | 200715 | 1659 | 0.00 | 0.00 | | 2025-08-30 04:00:41.329102+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 | 773 | 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 | 15984 | 2846 | 0.00 | 15.00 | | 2025-08-29 05:12:18.057324+00 | | 2025-08-30 17:58:57.592314+00 |
| public | m_setting_log | 36210 | 0 | 0.00 | 0.00 | | 2025-08-29 02:36:01.163381+00 | | 2025-08-30 23:12:05.256488+00 |
| public | m_site | 187 | 1 | 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 | 6882 | 0.00 | 5.00 | | 2025-08-30 04:37:19.578142+00 | | 2025-08-30 04:37:19.766451+00 |
| public | m_user | 36314 | 174 | 0.00 | 0.00 | | 2025-08-27 07:58:40.272056+00 | | |
| public | m_zone | 7847 | 0 | 0.00 | 0.00 | | 2025-08-30 06:30:41.401825+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-30 18:03:57.632279+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 | 54128 | 1728 | 0.00 | 3.00 | | 2025-08-26 01:14:55.631973+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8057 | 4 | 0.00 | 0.00 | | 2025-08-28 04:10:54.559129+00 | | |
| public | r_pot_category | 11651 | 359 | 0.00 | 2.00 | | 2025-08-28 02:16:28.437743+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 435310 | 572 | 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-30 07:02:06.507248+00 | | |
| public | r_pot_tx | 69789 | 430 | 0.00 | 0.00 | | 2025-08-28 06:41:32.962464+00 | | |
| public | r_pot_user | 20040 | 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 | 5974 | 26 | 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 | 3193704 | 39882 | 0.00 | 1.00 | | 2025-08-26 03:38:49.64713+00 | | |
| public | t_general | 4167 | 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 | 919073 | 0 | 0.00 | 0.00 | | 2025-08-30 01:44:15.681829+00 | | |
| public | t_mobile_status_history | 1835969 | 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 | 6458193 | 606 | 0.00 | 0.00 | | 2025-08-30 02:30:31.165877+00 | | |
| public | t_operation_log | 21950329 | 31 | 0.00 | 0.00 | | 2025-08-28 03:47:37.590212+00 | | |
| public | t_plan | 27504403 | 1041888 | 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 | 591202 | 18532 | 0.00 | 3.00 | | 2025-08-28 23:05:37.563117+00 | | |
| public | t_plan_detail | 46976313 | 1136218 | 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-30 07:02:06.48947+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-08-30 07:02:06.463177+00 | | |
| public | t_plan_sync | 65959 | 10884 | 0.00 | 14.00 | | 2025-08-31 00:03:19.173895+00 | | 2025-08-31 00:41:20.127826+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 | 144050 | 25255 | 0.00 | 14.00 | | 2025-08-31 00:50:21.181178+00 | 2025-08-30 13:30:02.241257+00 | 2025-08-31 00:51:19.766099+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.839998+00 | | |
| public | t_terminal | 20937 | 2917 | 0.00 | 12.00 | | 2025-08-30 19:37:28.127572+00 | | 2025-08-31 00:31:21.221185+00 |
| public | t_terminal_log | 28031020 | 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 | 56343 | 689 | 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 | 55313 | 7713 | 0.00 | 12.00 | | 2025-08-29 05:46:57.789334+00 | | 2025-08-30 13:47:13.49856+00 |
| public | w_latest_position | 79183 | 13904 | 0.00 | 14.00 | | 2025-08-31 00:44:20.438395+00 | | 2025-08-31 00:51:19.935356+00 |
| public | w_latest_presence | 212122 | 113057 | 0.00 | 34.00 | | 2025-08-31 00:51:37.943446+00 | | 2025-08-31 00:51:40.460749+00 |
| public | w_latest_sensor | 386 | 259 | 0.00 | 40.00 | | 2025-08-31 00:51:20.575794+00 | | 2025-08-31 00:51:20.6893+00 |
| public | w_lock | 18404 | 5 | 0.00 | 0.00 | | 2025-08-27 03:17:30.783256+00 | | |
| public | w_master_update | 112 | 60 | 0.00 | 34.00 | | 2025-08-30 20:10:57.318124+00 | | 2025-08-30 23:02:04.942702+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-08-29 14:40:13.993678+00 | | |
| public | w_plan_sync_retry | 0 | 16 | 0 | 100.00 | | 2025-08-29 12:52:32.087854+00 | | 2025-08-29 11:38:48.041855+00 |
| public | w_plan_with_detail | 27189464 | 33697 | 0.00 | 0.00 | | 2025-08-29 23:38:14.910805+00 | | 2025-08-27 01:19:10.217508+00 |