| 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 |
|---|
| e202510 | a_proximity_sum | 41494177 | 0 | 0.00 | 0.00 | | 2025-11-30 23:10:20.213025+00 | | 2025-10-31 17:24:22.03982+00 |
| e202510 | a_stay_time | 44674945 | 0 | 0.00 | 0.00 | | 2025-11-27 06:08:56.206751+00 | | 2025-10-31 16:15:51.689039+00 |
| e202510 | t_position_history | 641928656 | 0 | 0.00 | 0.00 | | 2025-11-30 00:49:27.217921+00 | | 2025-10-29 19:35:21.809624+00 |
| e202510 | t_presence_history | 65121838 | 0 | 0.00 | 0.00 | | 2025-12-01 08:24:42.957934+00 | | 2025-10-31 14:59:46.05603+00 |
| e202510 | t_sensor_history | 11673895 | 0 | 0.00 | 0.00 | | 2025-11-27 16:44:06.130401+00 | | 2025-10-30 01:18:33.550108+00 |
| e202511 | a_proximity_sum | 55794877 | 0 | 0.00 | 0.00 | | 2025-12-01 07:57:57.832465+00 | | 2025-11-29 16:49:11.217033+00 |
| e202511 | a_stay_time | 40278716 | 0 | 0.00 | 0.00 | | 2025-11-28 07:33:21.891809+00 | | 2025-11-28 20:10:59.778401+00 |
| e202511 | t_position_history | 561635663 | 0 | 0.00 | 0.00 | | 2025-11-28 11:23:29.978683+00 | | 2025-11-29 02:17:09.975534+00 |
| e202511 | t_presence_history | 51301818 | 6375169 | 0.00 | 11.00 | | 2025-11-30 13:19:15.847341+00 | | 2025-11-30 14:33:44.67193+00 |
| e202511 | t_sensor_history | 11287026 | 0 | 0.00 | 0.00 | | 2025-12-01 04:36:19.486936+00 | | 2025-11-28 12:39:29.055744+00 |
| e202512 | a_proximity_sum | 2266257 | 0 | 0.00 | 0.00 | | 2025-12-01 18:56:10.895024+00 | | 2025-12-01 18:58:07.217319+00 |
| e202512 | a_stay_time | 2210544 | 0 | 0.00 | 0.00 | | 2025-12-01 17:55:58.297935+00 | | 2025-12-01 18:56:10.061455+00 |
| e202512 | t_position_history | 31698986 | 0 | 0.00 | 0.00 | | 2025-12-02 00:06:53.747685+00 | | 2025-12-02 00:39:45.324633+00 |
| e202512 | t_presence_history | 2972080 | 654212 | 0.00 | 18.00 | | 2025-12-02 00:52:04.126898+00 | | 2025-12-02 00:54:38.267104+00 |
| e202512 | t_sensor_history | 536145 | 0 | 0.00 | 0.00 | | 2025-12-01 20:05:36.513526+00 | | 2025-12-01 23:52:15.122548+00 |
| public | __digdag_status | 36 | 4 | 0.00 | 10.00 | | 2025-12-01 03:20:09.478429+00 | | 2025-11-28 12:32:16.407126+00 |
| public | a_attendance_sum | 183879 | 22057 | 0.00 | 10.00 | | 2025-12-01 23:35:38.316392+00 | | 2025-12-02 00:34:19.993686+00 |
| public | a_plan_actual | 1502775 | 0 | 0.00 | 0.00 | | 2025-12-01 08:24:09.420989+00 | | 2025-11-27 16:37:02.352391+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-12-01 02:10:44.612287+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-12-01 02:10:44.014822+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:35.610486+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-11-27 04:25:51.385859+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-11-27 00:26:30.510493+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-11-27 01:23:07.05397+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-11-27 00:24:44.6843+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-11-27 01:23:07.084187+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-11-27 01:23:07.106229+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-11-27 00:24:44.707317+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-11-27 00:24:44.649077+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-11-27 01:23:05.186127+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-11-27 00:24:44.73225+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-11-27 00:24:44.756939+00 | | |
| public | l_area | 1697 | 2 | 0.00 | 0.00 | | 2025-11-30 06:55:18.42626+00 | | 2025-11-20 04:34:00.972924+00 |
| public | l_auth | 196 | 0 | 0.00 | 0.00 | | 2025-11-30 06:55:18.284036+00 | | |
| public | l_category | 2681 | 0 | 0.00 | 0.00 | | 2025-11-30 06:55:18.790829+00 | | |
| public | l_group | 38105 | 357 | 0.00 | 0.00 | | 2025-11-30 06:55:19.108361+00 | | |
| public | l_lob | 2233 | 4 | 0.00 | 0.00 | | 2025-11-28 08:26:04.167859+00 | | 2025-11-25 02:07:03.012893+00 |
| public | l_location | 127561 | 1 | 0.00 | 0.00 | | 2025-12-01 02:11:39.813603+00 | | 2025-11-18 07:33:16.104528+00 |
| public | l_location_zone | 130171 | 4 | 0.00 | 0.00 | | 2025-12-01 07:13:01.776965+00 | | 2025-11-29 07:06:54.490052+00 |
| public | l_outside | 440 | 0 | 0.00 | 0.00 | | 2025-11-30 06:55:18.339308+00 | | |
| public | l_pot | 495596 | 6392 | 0.00 | 1.00 | | 2025-11-30 06:55:25.86084+00 | | 2025-12-01 03:18:19.255248+00 |
| public | l_pot_category | 26992 | 92 | 0.00 | 0.00 | | 2025-12-01 07:13:01.937906+00 | | 2025-11-14 00:34:56.265278+00 |
| public | l_pot_group | 484771 | 1288 | 0.00 | 0.00 | | 2025-12-01 07:13:04.759121+00 | | 2025-10-29 08:46:37.528183+00 |
| public | l_pot_tx | 188226 | 1017 | 0.00 | 0.00 | | 2025-12-01 07:13:02.832382+00 | | 2025-10-29 08:46:32.434364+00 |
| public | l_role | 782 | 0 | 0.00 | 0.00 | | 2025-11-30 06:30:32.15434+00 | | |
| public | l_role_feature | 8464 | 0 | 0.00 | 0.00 | | 2025-12-01 07:12:30.797941+00 | | 2025-10-29 08:49:05.223461+00 |
| public | l_site | 254 | 0 | 0.00 | 0.00 | | 2025-11-30 06:55:18.462639+00 | | |
| public | l_tx | 166967 | 4747 | 0.00 | 2.00 | | 2025-11-29 06:44:17.943029+00 | | 2025-11-27 05:50:08.37544+00 |
| public | l_user | 68991 | 690 | 0.00 | 0.00 | | 2025-11-30 06:30:32.050787+00 | | 2025-11-27 00:25:59.232006+00 |
| public | l_zone | 10702 | 66 | 0.00 | 0.00 | | 2025-11-30 06:55:18.667973+00 | | |
| public | l_zone_category | 7270 | 0 | 0.00 | 0.00 | | 2025-12-01 07:12:30.762658+00 | | 2025-10-29 08:47:04.390518+00 |
| public | m_area | 822 | 0 | 0.00 | 0.00 | | 2025-12-01 21:14:24.519119+00 | | 2025-11-15 05:14:42.661579+00 |
| public | m_auth | 149 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:44.668535+00 | | |
| public | m_category | 2423 | 0 | 0.00 | 0.00 | | 2025-12-01 21:14:24.420784+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-11-27 05:58:51.882258+00 | | |
| public | m_exb | 28531 | 0 | 0.00 | 0.00 | | 2025-11-30 23:09:56.932201+00 | | 2025-11-18 03:16:32.600306+00 |
| public | m_favorite | 235985 | 463 | 0.00 | 0.00 | | 2025-12-01 08:24:18.214963+00 | | |
| public | m_favorite_group | 119129 | 2093 | 0.00 | 1.00 | | 2025-11-27 21:20:00.930514+00 | | |
| public | m_feature | 171 | 0 | 0.00 | 0.00 | | 2025-12-01 03:19:35.12964+00 | | |
| public | m_group | 28792 | 1994 | 0.00 | 6.00 | | 2025-11-30 00:26:27.573025+00 | | 2025-12-01 15:38:52.694035+00 |
| public | m_holiday | 41849 | 0 | 0.00 | 0.00 | | 2025-11-28 11:36:55.949108+00 | | |
| public | m_lob | 21862 | 378 | 0.00 | 1.00 | | 2025-11-28 11:35:18.571071+00 | | |
| public | m_lob_log | 5717 | 0 | 0.00 | 0.00 | | 2025-11-28 11:36:55.92274+00 | | |
| public | m_location | 46205 | 1 | 0.00 | 0.00 | | 2025-12-01 15:23:52.234472+00 | | 2025-11-30 10:37:30.022123+00 |
| public | m_notify_template | 1208 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:44.837972+00 | | |
| public | m_outside | 367 | 0 | 0.00 | 0.00 | | 2025-11-28 06:01:27.291312+00 | | |
| public | m_personal_setting | 131371 | 19966 | 0.00 | 13.00 | | 2025-12-01 19:48:18.681044+00 | | 2025-12-02 00:21:17.719158+00 |
| public | m_pot | 210694 | 13080 | 0.00 | 5.00 | | 2025-11-30 19:49:11.453034+00 | | 2025-12-01 00:20:02.862076+00 |
| public | m_pot_profile | 57644 | 28 | 0.00 | 0.00 | | 2025-11-30 05:36:59.77084+00 | | |
| public | m_provider_user | 86 | 0 | 0.00 | 0.00 | | 2025-12-01 03:20:09.524264+00 | | |
| public | m_region | 113 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:44.970126+00 | | |
| public | m_role | 785 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:44.947021+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:44.800824+00 | | |
| public | m_setting | 26865 | 24 | 0.00 | 0.00 | | 2025-12-02 00:48:19.386015+00 | | 2025-12-01 23:54:30.014709+00 |
| public | m_setting_log | 37966 | 0 | 0.00 | 0.00 | | 2025-12-01 23:42:49.914727+00 | | 2025-12-01 16:19:55.705782+00 |
| public | m_site | 187 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:44.643229+00 | | |
| public | m_tenant | 112 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:45.022843+00 | | |
| public | m_tx | 128985 | 22931 | 0.00 | 15.00 | | 2025-11-30 16:40:26.981477+00 | | 2025-11-30 17:08:26.745906+00 |
| public | m_user | 37003 | 271 | 0.00 | 0.00 | | 2025-11-28 01:11:03.610226+00 | | 2025-11-18 07:12:28.496788+00 |
| public | m_zone | 7937 | 1 | 0.00 | 0.00 | | 2025-12-01 03:20:10.295796+00 | | 2025-11-25 02:10:03.34792+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-12-01 02:10:35.583787+00 | | |
| public | r_auth_zone | 175 | 0 | 0.00 | 0.00 | | 2025-12-01 08:24:18.263709+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:44.867402+00 | | |
| public | r_group_auth | 446 | 0 | 0.00 | 0.00 | | 2025-11-27 04:02:50.656653+00 | | 2025-11-17 06:43:36.264507+00 |
| public | r_location_zone | 54204 | 2 | 0.00 | 0.00 | | 2025-12-01 21:14:24.292792+00 | | 2025-11-28 07:33:28.813592+00 |
| public | r_pot_auth | 9204 | 83 | 0.00 | 0.00 | | 2025-11-28 11:35:08.344161+00 | | 2025-11-28 05:28:47.020235+00 |
| public | r_pot_category | 12067 | 188 | 0.00 | 1.00 | | 2025-11-28 08:26:04.055817+00 | | 2025-11-28 00:03:05.894062+00 |
| public | r_pot_group | 410988 | 2775 | 0.00 | 0.00 | | 2025-11-27 05:58:51.855976+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-12-01 03:20:09.603703+00 | | |
| public | r_pot_tx | 73265 | 1288 | 0.00 | 1.00 | | 2025-11-28 11:35:19.253752+00 | | 2025-12-01 11:13:11.715075+00 |
| public | r_pot_user | 20331 | 6 | 0.00 | 0.00 | | 2025-11-28 11:35:18.006909+00 | | |
| public | r_provider_tenant | 925 | 0 | 0.00 | 0.00 | | 2025-12-01 06:47:55.393514+00 | | 2025-11-26 05:47:40.77365+00 |
| public | r_role_feature | 6699 | 0 | 0.00 | 0.00 | | 2025-11-27 23:36:05.808191+00 | | |
| public | r_tenant_feature | 4485 | 0 | 0.00 | 0.00 | | 2025-11-27 00:24:31.173836+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-11-27 15:58:36.281234+00 | | |
| public | r_user_region | 21263 | 6 | 0.00 | 0.00 | | 2025-11-28 11:35:08.469755+00 | | |
| public | r_user_site | 4857 | 1 | 0.00 | 0.00 | | 2025-12-01 02:10:44.777555+00 | | 2025-11-17 06:49:36.429664+00 |
| public | r_zone_category | 5230 | 40 | 0.00 | 0.00 | | 2025-11-28 08:26:03.919921+00 | | |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-11-27 06:30:55.599682+00 | | |
| public | t_attendance | 3705298 | 36000 | 0.00 | 0.00 | | 2025-11-27 00:25:58.291134+00 | | 2025-11-28 04:00:24.432875+00 |
| public | t_general | 4461 | 1 | 0.00 | 0.00 | | 2025-11-27 04:25:51.345209+00 | | |
| public | t_general_20250618 | 2669 | 0 | 0.00 | 0.00 | | 2025-11-28 03:51:26.398364+00 | | |
| public | t_job | 58 | 0 | 0.00 | 0.00 | | 2025-11-28 08:26:04.216615+00 | | |
| public | t_mobile_device_history | 1484126 | 0 | 0.00 | 0.00 | | 2025-12-01 03:19:35.11043+00 | | |
| public | t_mobile_status_history | 2416469 | 0 | 0.00 | 0.00 | | 2025-11-28 11:36:57.201728+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:44.899801+00 | | |
| public | t_notify_history | 7305660 | 10211 | 0.00 | 0.00 | | 2025-12-01 03:20:09.376899+00 | | 2025-11-17 06:24:32.780981+00 |
| public | t_operation_log | 26411097 | 6 | 0.00 | 0.00 | | 2025-11-28 11:36:55.906294+00 | | |
| public | t_plan | 28037471 | 3941987 | 0.00 | 12.00 | | 2025-11-27 12:37:53.485249+00 | | 2025-12-01 22:54:32.179296+00 |
| public | t_plan_cancel_history | 799359 | 21127 | 0.00 | 2.00 | | 2025-11-30 00:26:53.019787+00 | | 2025-11-17 06:40:32.133611+00 |
| public | t_plan_detail | 52057630 | 9676938 | 0.00 | 15.00 | | 2025-11-27 23:35:45.197609+00 | | 2025-12-01 06:31:53.044293+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-12-01 03:20:09.581697+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-12-01 03:20:09.559051+00 | | |
| public | t_plan_sync | 71036 | 2982 | 0.00 | 4.00 | | 2025-12-02 00:34:18.954684+00 | | 2025-12-02 00:34:19.321723+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-12-01 02:10:45.058209+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-12-01 02:10:35.668515+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-12-01 02:10:44.991211+00 | | |
| public | t_recv_position_history | 169949 | 50472 | 0.00 | 22.00 | | 2025-12-02 00:55:17.672805+00 | 2025-12-01 13:30:07.35734+00 | 2025-12-02 00:55:18.193946+00 |
| public | t_safr_event_history | 0 | 0 | 0 | 0 | | 2025-11-27 03:56:48.972799+00 | | |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-12-01 02:10:35.728477+00 | | |
| public | t_terminal | 20229 | 1110 | 0.00 | 5.00 | | 2025-12-01 23:59:30.762349+00 | | 2025-12-02 00:50:20.478492+00 |
| public | t_terminal_log | 36477478 | 0 | 0.00 | 0.00 | | 2025-11-28 08:27:03.167468+00 | | 2025-11-24 08:37:11.884041+00 |
| public | temp_pivot_table | 239048 | 0 | 0.00 | 0.00 | | 2025-11-30 05:37:04.855942+00 | | |
| public | w_arrival_notify | 101 | 11 | 0.00 | 9.00 | | 2025-12-01 11:39:57.643819+00 | | 2025-12-01 15:01:05.934655+00 |
| public | w_latest_mobile_device | 56407 | 678 | 0.00 | 1.00 | | 2025-11-27 08:54:50.83682+00 | | 2025-11-25 00:42:22.87682+00 |
| public | w_latest_mobile_status | 55415 | 10972 | 0.00 | 16.00 | | 2025-12-01 23:57:31.028805+00 | | 2025-12-02 00:29:18.417202+00 |
| public | w_latest_position | 82766 | 38275 | 0.00 | 31.00 | | 2025-12-02 00:55:18.531006+00 | | 2025-12-02 00:55:18.95663+00 |
| public | w_latest_presence | 114238 | 184187 | 1.00 | 61.00 | | 2025-12-02 00:55:36.771619+00 | | 2025-12-02 00:55:37.140531+00 |
| public | w_latest_sensor | 386 | 376 | 0.00 | 49.00 | | 2025-12-02 00:55:18.97131+00 | | 2025-12-02 00:55:19.086074+00 |
| public | w_lock | 19852 | 0 | 0.00 | 0.00 | | 2025-11-27 17:58:33.763974+00 | | |
| public | w_master_update | 194 | 23 | 0.00 | 10.00 | | 2025-12-02 00:32:17.565368+00 | | 2025-12-02 00:19:17.122598+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-12-01 03:20:09.501183+00 | | |
| public | w_plan_sync_retry | 0 | 10 | 0 | 100.00 | | 2025-12-01 23:03:27.815773+00 | | 2025-12-01 22:44:27.300522+00 |
| public | w_plan_with_detail | 28154033 | 1479755 | 0.00 | 4.00 | | 2025-12-01 03:16:18.326516+00 | | 2025-12-01 11:00:12.221853+00 |