| 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 | 610147580 | 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 | 32489797 | 1641880 | 0.00 | 4.00 | | 2025-08-28 05:51:15.974026+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36284973 | 64272 | 0.00 | 0.00 | | 2025-08-28 15:21:13.177374+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582782071 | 143020 | 0.00 | 0.00 | | 2025-09-01 01:12:49.313432+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 53820966 | 699802 | 0.00 | 1.00 | | 2025-08-31 14:22:36.67427+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11924182 | 0 | 0.00 | 0.00 | | 2025-08-31 02:11:59.210078+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 1534672 | 0 | 0.00 | 0.00 | | 2025-09-01 18:59:31.025293+00 | | 2025-09-01 18:59:31.517703+00 |
| e202509 | a_stay_time | 2092512 | 0 | 0.00 | 0.00 | | 2025-09-01 18:00:33.227827+00 | | 2025-09-01 18:55:37.796819+00 |
| e202509 | t_position_history | 32226013 | 0 | 0.00 | 0.00 | | 2025-09-01 23:01:08.0096+00 | | 2025-09-01 23:50:03.593486+00 |
| e202509 | t_presence_history | 3179068 | 562793 | 0.00 | 15.00 | | 2025-09-02 00:52:26.026031+00 | | 2025-09-02 00:55:09.566436+00 |
| e202509 | t_sensor_history | 547710 | 0 | 0.00 | 0.00 | | 2025-09-01 20:55:28.59713+00 | | 2025-09-02 00:28:28.153811+00 |
| public | __digdag_status | 33 | 19 | 0.00 | 36.00 | | 2025-08-28 03:47:37.696146+00 | | 2025-08-28 12:30:18.362409+00 |
| public | a_attendance_sum | 149099 | 12316 | 0.00 | 7.00 | | 2025-09-01 23:58:04.655266+00 | | 2025-09-02 00:34:15.360317+00 |
| public | a_plan_actual | 942266 | 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-09-01 01:16:13.818492+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-08-31 13:33:02.783709+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.289939+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.386749+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.300939+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.311824+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.397995+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.374961+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:05.9155+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.409231+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.420554+00 | | |
| public | l_area | 1547 | 15 | 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 | 35455 | 54 | 0.00 | 0.00 | | 2025-08-29 02:39:07.069636+00 | | |
| public | l_lob | 1936 | 18 | 0.00 | 0.00 | | 2025-08-26 10:11:39.840951+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 103296 | 509 | 0.00 | 0.00 | | 2025-08-29 02:39:04.798722+00 | | |
| public | l_location_zone | 100347 | 1753 | 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 | 433753 | 3292 | 0.00 | 0.00 | | 2025-08-29 02:39:13.107243+00 | | |
| public | l_pot_category | 13471 | 273 | 0.00 | 1.00 | | 2025-08-29 02:39:04.916179+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 228109 | 1033 | 0.00 | 0.00 | | 2025-08-29 02:39:06.870491+00 | | |
| public | l_pot_tx | 99034 | 549 | 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 | 141124 | 14286 | 0.00 | 9.00 | | 2025-08-30 04:31:36.816025+00 | | 2025-08-30 04:33:36.638613+00 |
| public | l_user | 62260 | 490 | 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 | 784 | 7 | 0.00 | 0.00 | | 2025-08-31 07:12:17.78997+00 | | |
| public | m_auth | 141 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.588843+00 | | |
| public | m_category | 2421 | 0 | 0.00 | 0.00 | | 2025-08-31 07:12:17.760777+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-09-01 02:50:56.702024+00 | | |
| public | m_exb | 26434 | 97 | 0.00 | 0.00 | | 2025-08-29 08:31:43.277481+00 | | |
| public | m_favorite | 235166 | 1019 | 0.00 | 0.00 | | 2025-08-30 15:17:27.111905+00 | | |
| public | m_favorite_group | 113805 | 128 | 0.00 | 0.00 | | 2025-09-01 11:47:17.582229+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-08-29 20:56:34.194737+00 | | |
| public | m_group | 27661 | 947 | 0.00 | 3.00 | | 2025-09-01 09:12:19.246068+00 | | 2025-08-31 14:41:00.773862+00 |
| public | m_holiday | 43942 | 0 | 0.00 | 0.00 | | 2025-08-28 07:28:59.552994+00 | | |
| public | m_lob | 24491 | 83 | 0.00 | 0.00 | | 2025-08-28 12:37:15.856479+00 | | |
| public | m_lob_log | 2010 | 0 | 0.00 | 0.00 | | 2025-08-28 03:08:18.640809+00 | | |
| public | m_location | 44672 | 132 | 0.00 | 0.00 | | 2025-08-31 02:41:50.263825+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 | 132594 | 12738 | 0.00 | 8.00 | | 2025-09-01 22:34:35.261922+00 | | 2025-09-02 00:51:09.650047+00 |
| public | m_pot | 201038 | 24189 | 0.00 | 10.00 | | 2025-08-30 04:00:41.329102+00 | | 2025-09-01 08:20:15.970697+00 |
| public | m_pot_profile | 52386 | 21 | 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 | 15993 | 2782 | 0.00 | 14.00 | | 2025-08-31 07:25:16.682896+00 | | 2025-09-01 13:28:20.032678+00 |
| public | m_setting_log | 36395 | 1502 | 0.00 | 3.00 | | 2025-08-29 02:36:01.163381+00 | | 2025-09-01 06:56:36.407281+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 | 175718 | 10996 | 0.00 | 5.00 | | 2025-09-01 02:14:53.747345+00 | | 2025-09-01 02:13:53.047038+00 |
| public | m_user | 36560 | 13 | 0.00 | 0.00 | | 2025-09-01 23:58:32.019978+00 | | |
| public | m_zone | 7847 | 7 | 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-09-01 01:19:58.239654+00 | | |
| public | r_location_zone | 54130 | 51 | 0.00 | 0.00 | | 2025-08-31 07:12:17.601543+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8299 | 119 | 0.00 | 1.00 | | 2025-08-28 04:10:54.559129+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 11635 | 460 | 0.00 | 3.00 | | 2025-08-28 02:16:28.437743+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 437800 | 431 | 0.00 | 0.00 | | 2025-09-01 02:50:56.675397+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 | 69874 | 826 | 0.00 | 1.00 | | 2025-08-28 06:41:32.962464+00 | | |
| public | r_pot_user | 20036 | 25 | 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 | 5849 | 0 | 0.00 | 0.00 | | 2025-09-01 12:38:18.794239+00 | | |
| public | r_tenant_feature | 4516 | 0 | 0.00 | 0.00 | | 2025-08-31 13:32:10.069592+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-01 09:12:19.271531+00 | | |
| public | r_user_region | 21396 | 23 | 0.00 | 0.00 | | 2025-08-28 14:02:51.893863+00 | | |
| public | r_user_site | 6254 | 2 | 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-09-01 05:19:49.762173+00 | | |
| public | t_attendance | 3170559 | 10751 | 0.00 | 0.00 | | 2025-08-31 13:33:02.7707+00 | | |
| public | t_general | 4175 | 1 | 0.00 | 0.00 | | 2025-09-01 01:16:12.459577+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 | 921198 | 0 | 0.00 | 0.00 | | 2025-08-30 01:44:15.681829+00 | | |
| public | t_mobile_status_history | 1857141 | 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 | 6485359 | 6263 | 0.00 | 0.00 | | 2025-08-30 02:30:31.165877+00 | | |
| public | t_operation_log | 22030371 | 2365 | 0.00 | 0.00 | | 2025-08-28 03:47:37.590212+00 | | |
| public | t_plan | 27266774 | 257954 | 0.00 | 0.00 | | 2025-09-01 08:10:47.659333+00 | | 2025-08-31 22:35:31.099886+00 |
| public | t_plan_cancel_history | 594272 | 52325 | 0.00 | 8.00 | | 2025-08-28 23:05:37.563117+00 | | |
| public | t_plan_detail | 47206834 | 1757078 | 0.00 | 3.00 | | 2025-08-28 10:03:48.699853+00 | | 2025-09-01 08:52:14.103923+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 | 66097 | 9483 | 0.00 | 12.00 | | 2025-09-02 00:21:15.166041+00 | | 2025-09-02 00:38:14.296923+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 | 154653 | 35261 | 0.00 | 18.00 | | 2025-09-02 00:54:14.300983+00 | 2025-09-01 13:30:02.673932+00 | 2025-09-02 00:55:08.595+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.839998+00 | | |
| public | t_terminal | 20951 | 1605 | 0.00 | 7.00 | | 2025-09-01 20:32:28.04887+00 | | 2025-09-02 00:35:10.607985+00 |
| public | t_terminal_log | 28197740 | 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 | 100 | 33 | 0.00 | 24.00 | | 2025-08-29 01:19:12.397653+00 | | 2025-09-01 04:32:58.696539+00 |
| public | w_latest_mobile_device | 56619 | 288 | 0.00 | 0.00 | | 2025-09-01 06:20:02.943264+00 | | 2025-08-31 11:26:59.109828+00 |
| public | w_latest_mobile_status | 55590 | 5483 | 0.00 | 8.00 | | 2025-09-02 00:01:33.841337+00 | | 2025-09-02 00:48:16.197438+00 |
| public | w_latest_position | 78997 | 25383 | 0.00 | 24.00 | | 2025-09-02 00:55:08.797709+00 | | 2025-09-02 00:55:09.037816+00 |
| public | w_latest_presence | 244686 | 149551 | 0.00 | 37.00 | | 2025-09-02 00:55:22.880143+00 | | 2025-09-02 00:55:23.605174+00 |
| public | w_latest_sensor | 386 | 258 | 0.00 | 40.00 | | 2025-09-02 00:55:09.580493+00 | | 2025-09-02 00:55:09.692651+00 |
| public | w_lock | 18441 | 0 | 0.00 | 0.00 | | 2025-09-01 10:22:51.233301+00 | | |
| public | w_master_update | 194 | 32 | 0.00 | 14.00 | | 2025-09-02 00:23:08.605029+00 | | 2025-09-02 00:22:14.507053+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-08-29 14:40:13.993678+00 | | |
| public | w_plan_sync_retry | 0 | 38 | 0 | 100.00 | | 2025-09-01 23:30:57.864894+00 | | 2025-09-02 00:25:08.539146+00 |
| public | w_plan_with_detail | 27568980 | 734433 | 0.00 | 2.00 | | 2025-08-29 23:38:14.910805+00 | | 2025-08-31 22:13:29.722609+00 |