| 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 |
|---|
| e202502 | a_proximity_sum | 26956978 | 0 | 0.00 | 0.00 | | 2025-03-27 05:33:48.709257+00 | | |
| e202502 | a_stay_time | 33161132 | 0 | 0.00 | 0.00 | | 2025-03-27 05:33:48.759003+00 | | |
| e202502 | t_position_history | 416042002 | 0 | 0.00 | 0.00 | | 2025-03-27 02:56:03.113619+00 | | |
| e202502 | t_presence_history | 43102263 | 0 | 0.00 | 0.00 | | 2025-03-27 06:43:57.414244+00 | | |
| e202502 | t_sensor_history | 9718145 | 0 | 0.00 | 0.00 | | 2025-04-01 07:34:19.985184+00 | | |
| e202503 | a_proximity_sum | 32349166 | 0 | 0.00 | 0.00 | | 2025-03-26 17:56:54.018776+00 | | 2025-03-31 18:03:10.657748+00 |
| e202503 | a_stay_time | 37646760 | 0 | 0.00 | 0.00 | | 2025-04-02 12:13:56.57976+00 | | 2025-03-31 16:10:17.452785+00 |
| e202503 | t_position_history | 463591262 | 0 | 0.00 | 0.00 | | 2025-04-02 09:10:50.372355+00 | | 2025-03-31 02:22:42.238716+00 |
| e202503 | t_presence_history | 48013826 | 2378161 | 0.00 | 4.00 | | 2025-03-31 14:54:44.681469+00 | | 2025-03-31 14:30:05.025309+00 |
| e202503 | t_sensor_history | 13419616 | 0 | 0.00 | 0.00 | | 2025-03-25 17:22:15.106946+00 | | 2025-03-30 05:19:12.818843+00 |
| e202504 | a_proximity_sum | 3596971 | 0 | 0.00 | 0.00 | | 2025-04-02 17:58:09.800234+00 | | 2025-04-02 18:06:40.924353+00 |
| e202504 | a_stay_time | 4144063 | 0 | 0.00 | 0.00 | | 2025-04-02 17:51:23.991127+00 | | 2025-04-02 17:56:08.837295+00 |
| e202504 | t_position_history | 47291641 | 0 | 0.00 | 0.00 | | 2025-04-03 00:06:15.588043+00 | | 2025-04-02 19:39:17.918266+00 |
| e202504 | t_presence_history | 5474025 | 3043831 | 0.00 | 35.00 | | 2025-04-03 00:51:30.760432+00 | | 2025-04-03 00:50:30.721186+00 |
| e202504 | t_sensor_history | 1029090 | 0 | 0.00 | 0.00 | | 2025-04-02 23:06:18.079801+00 | | 2025-04-02 19:40:16.971172+00 |
| public | __digdag_status | 34 | 56 | 1.00 | 62.00 | | 2025-03-29 08:30:49.129579+00 | | 2025-04-02 08:30:48.504082+00 |
| public | a_attendance_sum | 94436 | 14816 | 0.00 | 13.00 | | 2025-04-03 00:30:37.365937+00 | | 2025-04-03 00:44:40.18137+00 |
| public | a_plan_actual | 257148 | 0 | 0.00 | 0.00 | | 2025-03-28 00:13:06.142201+00 | | 2025-03-31 16:03:09.09613+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-03-30 07:24:01.224661+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-03-30 07:23:46.507756+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-03-30 05:57:22.790104+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-04-01 12:40:28.988292+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:47.630499+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:48.718107+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:20.984533+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:48.73969+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:48.761615+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:21.012442+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:20.962532+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:47.661728+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:21.035171+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-04-01 07:10:21.0584+00 | | |
| public | m_area | 693 | 2 | 0.00 | 0.00 | | 2025-04-01 04:43:46.533955+00 | | |
| public | m_auth | 139 | 0 | 0.00 | 0.00 | | 2025-03-30 07:24:01.240942+00 | | |
| public | m_category | 2068 | 4 | 0.00 | 0.00 | | 2025-04-01 04:43:46.504606+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-04-02 04:41:38.977681+00 | | |
| public | m_exb | 22150 | 1423 | 0.00 | 6.00 | | 2025-03-30 00:20:55.022957+00 | | 2025-04-02 00:15:07.570528+00 |
| public | m_favorite | 217639 | 3763 | 0.00 | 1.00 | | 2025-03-31 12:05:12.975149+00 | | |
| public | m_favorite_group | 91546 | 1328 | 0.00 | 1.00 | | 2025-03-25 09:37:57.24877+00 | | |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-03-31 01:12:03.915845+00 | | |
| public | m_group | 19640 | 1280 | 0.00 | 6.00 | | 2025-03-25 11:23:36.756429+00 | | 2025-04-01 12:36:32.062401+00 |
| public | m_holiday | 34616 | 0 | 0.00 | 0.00 | | 2025-03-27 21:30:49.364865+00 | | |
| public | m_lob | 22775 | 239 | 0.00 | 1.00 | | 2025-03-28 02:53:31.716926+00 | | |
| public | m_lob_log | 1052 | 21 | 0.00 | 1.00 | | 2025-03-27 04:00:15.902921+00 | | 2025-04-01 04:42:54.133096+00 |
| public | m_location | 38045 | 2836 | 0.00 | 6.00 | | 2025-03-26 06:13:44.876331+00 | | 2025-03-31 17:59:07.792098+00 |
| public | m_notify_template | 793 | 3 | 0.00 | 0.00 | | 2025-03-30 07:24:01.417218+00 | | |
| public | m_outside | 338 | 0 | 0.00 | 0.00 | | 2025-03-26 13:20:43.51379+00 | | |
| public | m_pot | 171805 | 33186 | 0.00 | 16.00 | | 2025-04-02 00:07:13.650471+00 | | 2025-04-02 23:48:11.420798+00 |
| public | m_pot_profile | 50891 | 103 | 0.00 | 0.00 | | 2025-03-28 11:13:35.004824+00 | | |
| public | m_provider_user | 75 | 2 | 0.00 | 2.00 | | 2025-03-31 01:36:04.321609+00 | | |
| public | m_region | 106 | 0 | 0.00 | 0.00 | | 2025-03-30 07:24:01.509983+00 | | |
| public | m_role | 630 | 1 | 0.00 | 0.00 | | 2025-03-30 07:24:01.494174+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-03-30 07:24:01.347819+00 | | |
| public | m_setting | 21510 | 722 | 0.00 | 3.00 | | 2025-04-02 11:45:13.135331+00 | | 2025-04-01 22:16:49.882004+00 |
| public | m_setting_log | 30977 | 1478 | 0.00 | 4.00 | | 2025-03-31 03:52:44.034474+00 | | 2025-04-01 23:18:01.119828+00 |
| public | m_site | 167 | 1 | 0.00 | 0.00 | | 2025-03-30 07:24:01.371419+00 | | |
| public | m_tenant | 105 | 0 | 0.00 | 0.00 | | 2025-03-30 07:24:01.654073+00 | | |
| public | m_tx | 101910 | 6518 | 0.00 | 6.00 | | 2025-04-02 08:44:40.825054+00 | | 2025-04-02 08:44:40.995131+00 |
| public | m_user | 31644 | 938 | 0.00 | 2.00 | | 2025-03-26 01:55:48.204043+00 | | |
| public | m_zone | 6844 | 70 | 0.00 | 1.00 | | 2025-03-31 06:33:05.307296+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-03-30 07:23:45.46129+00 | | |
| public | r_auth_zone | 213 | 0 | 0.00 | 0.00 | | 2025-03-31 17:44:01.357653+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-03-30 07:24:01.438792+00 | | |
| public | r_group_auth | 520 | 0 | 0.00 | 0.00 | | 2025-04-02 02:01:02.990428+00 | | 2025-03-26 03:04:45.736116+00 |
| public | r_location_zone | 47763 | 3125 | 0.00 | 6.00 | | 2025-04-01 01:31:38.941191+00 | | 2025-04-01 02:43:47.282898+00 |
| public | r_pot_auth | 2913 | 367 | 0.00 | 11.00 | | 2025-03-31 09:53:50.358911+00 | | 2025-03-31 16:30:10.493211+00 |
| public | r_pot_category | 8289 | 3 | 0.00 | 0.00 | | 2025-04-02 20:11:09.49687+00 | | 2025-04-02 20:01:15.173831+00 |
| public | r_pot_group | 155059 | 3275 | 0.00 | 2.00 | | 2025-04-03 00:36:48.008878+00 | | 2025-04-03 00:23:05.779441+00 |
| public | r_pot_tx | 59155 | 6631 | 0.00 | 10.00 | | 2025-03-31 16:30:18.864434+00 | | 2025-03-31 16:30:18.955359+00 |
| public | r_pot_user | 17980 | 575 | 0.00 | 3.00 | | 2025-03-28 04:33:29.401013+00 | | |
| public | r_provider_tenant | 1262 | 3 | 0.00 | 0.00 | | 2025-03-27 17:34:43.966301+00 | | |
| public | r_role_feature | 5482 | 1 | 0.00 | 0.00 | | 2025-03-25 11:23:36.552259+00 | | |
| public | r_tenant_feature | 3933 | 0 | 0.00 | 0.00 | | 2025-04-01 07:10:12.908482+00 | | |
| public | r_tx_sensor | 359 | 0 | 0.00 | 0.00 | | 2025-04-03 00:47:29.699291+00 | | |
| public | r_user_region | 18792 | 583 | 0.00 | 3.00 | | 2025-03-28 05:38:45.191264+00 | | |
| public | r_user_site | 5557 | 398 | 0.00 | 6.00 | | 2025-03-30 07:24:01.326274+00 | | 2025-04-01 08:22:56.974638+00 |
| public | r_zone_category | 4099 | 42 | 0.00 | 1.00 | | 2025-03-27 04:00:15.878554+00 | | |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-04-02 08:56:37.436121+00 | | |
| public | t_attendance | 2188168 | 14244 | 0.00 | 0.00 | | 2025-04-01 07:10:47.605185+00 | | |
| public | t_general | 3474 | 0 | 0.00 | 0.00 | | 2025-03-30 07:24:01.639824+00 | | |
| public | t_mobile_device_history | 803630 | 0 | 0.00 | 0.00 | | 2025-03-31 23:42:01.04288+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-03-30 07:24:01.459554+00 | | |
| public | t_notify_history | 4777248 | 8684 | 0.00 | 0.00 | | 2025-03-31 03:42:52.146455+00 | | |
| public | t_operation_log | 16575305 | 62 | 0.00 | 0.00 | | 2025-03-27 04:50:42.131234+00 | | |
| public | t_plan | 20080833 | 155692 | 0.00 | 0.00 | | 2025-04-02 17:50:39.147964+00 | | 2025-04-02 05:50:16.313007+00 |
| public | t_plan_cancel_history | 348244 | 52618 | 0.00 | 13.00 | | 2025-04-02 02:48:25.757564+00 | | |
| public | t_plan_detail | 34479782 | 4538711 | 0.00 | 11.00 | | 2025-03-28 00:56:31.121429+00 | | 2025-04-02 00:34:01.815801+00 |
| public | t_plan_sync | 47541 | 6747 | 0.00 | 12.00 | | 2025-04-03 00:36:48.450122+00 | | 2025-04-03 00:36:48.764248+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-03-30 07:24:01.677385+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-03-30 07:23:45.519337+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-03-30 07:24:01.528368+00 | | |
| public | t_recv_position_history | 134629 | 1721376 | 12.00 | 92.00 | | 2025-04-03 00:51:26.28679+00 | 2025-04-02 13:30:09.558002+00 | 2025-04-03 00:51:26.958806+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-03-30 07:23:45.573251+00 | | |
| public | t_terminal | 148599 | 6075 | 0.00 | 3.00 | | 2025-03-28 06:45:48.357789+00 | | 2025-04-03 00:10:37.860554+00 |
| public | t_terminal_log | 18018999 | 0 | 0.00 | 0.00 | | 2025-03-27 00:52:44.370841+00 | | |
| public | temp_pivot_table | 241534 | 0 | 0.00 | 0.00 | | 2025-03-28 11:13:41.468718+00 | | |
| public | w_arrival_notify | 94 | 6 | 0.00 | 6.00 | | 2025-04-02 23:36:05.432979+00 | | 2025-04-02 01:36:21.182573+00 |
| public | w_latest_position | 64785 | 545894 | 8.00 | 89.00 | | 2025-04-03 00:51:27.194766+00 | | 2025-04-03 00:51:27.405519+00 |
| public | w_latest_presence | 220628 | 2966823 | 13.00 | 93.00 | | 2025-04-03 00:51:32.011175+00 | | 2025-04-03 00:51:34.256687+00 |
| public | w_latest_sensor | 386 | 6333 | 16.00 | 94.00 | | 2025-04-03 00:51:30.775248+00 | | 2025-04-03 00:51:30.891102+00 |
| public | w_lock | 16086 | 0 | 0.00 | 0.00 | | 2025-03-25 08:54:38.045793+00 | | |
| public | w_master_update | 185 | 74 | 0.00 | 28.00 | | 2025-04-02 23:36:04.78565+00 | | 2025-04-02 23:35:24.942965+00 |
| public | w_migration | 737 | 0 | 0.00 | 0.00 | | 2025-03-30 11:30:33.587188+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-03-29 23:20:39.014565+00 | | |
| public | w_plan_with_detail | 20087764 | 1296857 | 0.00 | 6.00 | | 2025-03-31 02:10:05.317601+00 | | 2025-04-02 05:46:07.642991+00 |