| 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 | 57061101 | 0 | 0.00 | 0.00 | | 2025-09-02 09:38:20.22516+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-09-03 05:56:44.83893+00 | | |
| e202507 | t_position_history | 610147566 | 0 | 0.00 | 0.00 | | 2025-09-03 09:22:05.504051+00 | | |
| e202507 | t_presence_history | 55790713 | 0 | 0.00 | 0.00 | | 2025-09-03 07:49:44.319596+00 | | |
| e202507 | t_sensor_history | 11690422 | 0 | 0.00 | 0.00 | | 2025-09-03 21:30:38.187021+00 | | |
| e202508 | a_proximity_sum | 32424357 | 0 | 0.00 | 0.00 | | 2025-09-02 12:43:57.582627+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36270140 | 0 | 0.00 | 0.00 | | 2025-09-03 02:27:48.031126+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582786800 | 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 | 54679185 | 0 | 0.00 | 0.00 | | 2025-09-02 15:54:34.785902+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 | 4682505 | 0 | 0.00 | 0.00 | | 2025-09-03 17:03:14.86487+00 | | 2025-09-03 18:56:51.234953+00 |
| e202509 | a_stay_time | 6168770 | 0 | 0.00 | 0.00 | | 2025-09-03 17:17:12.341271+00 | | 2025-09-03 17:26:24.006358+00 |
| e202509 | t_position_history | 84080904 | 0 | 0.00 | 0.00 | | 2025-09-03 06:56:52.919535+00 | | 2025-09-03 20:23:22.451673+00 |
| e202509 | t_presence_history | 12175909 | 548481 | 0.00 | 4.00 | | 2025-09-04 00:49:05.727999+00 | | 2025-09-04 00:47:14.147146+00 |
| e202509 | t_sensor_history | 1319027 | 0 | 0.00 | 0.00 | | 2025-09-03 12:32:02.847115+00 | | 2025-09-03 23:55:57.753523+00 |
| public | __digdag_status | 33 | 8 | 0.00 | 19.00 | | 2025-09-02 09:17:33.265173+00 | | 2025-08-28 12:30:18.362409+00 |
| public | a_attendance_sum | 150246 | 24189 | 0.00 | 13.00 | | 2025-09-03 01:11:25.225582+00 | | 2025-09-04 00:23:02.902698+00 |
| public | a_plan_actual | 1031764 | 0 | 0.00 | 0.00 | | 2025-08-30 23:36:05.630777+00 | | 2025-09-02 17:17:15.571058+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-09-04 00:14:08.977787+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-09-04 00:14:08.380492+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:07.201294+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 | 1548 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:50.892245+00 | | |
| public | l_auth | 173 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:50.807898+00 | | |
| public | l_category | 2642 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:52.453223+00 | | |
| public | l_group | 35851 | 2 | 0.00 | 0.00 | | 2025-09-03 07:05:55.25874+00 | | |
| public | l_lob | 1945 | 2 | 0.00 | 0.00 | | 2025-09-02 07:47:38.571929+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 102875 | 170 | 0.00 | 0.00 | | 2025-09-03 07:05:52.226311+00 | | |
| public | l_location_zone | 99617 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:51.473253+00 | | |
| public | l_outside | 445 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:50.819578+00 | | |
| public | l_pot | 437870 | 211 | 0.00 | 0.00 | | 2025-09-03 07:06:00.35821+00 | | |
| public | l_pot_category | 13525 | 34 | 0.00 | 0.00 | | 2025-09-03 07:05:52.423476+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 229649 | 112 | 0.00 | 0.00 | | 2025-09-03 07:05:55.022078+00 | | |
| public | l_pot_tx | 101052 | 149 | 0.00 | 0.00 | | 2025-09-03 07:05:53.414165+00 | | |
| public | l_role | 770 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:35.291198+00 | | |
| public | l_role_feature | 6874 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:35.242313+00 | | |
| public | l_site | 255 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:50.944448+00 | | |
| public | l_tx | 141329 | 431 | 0.00 | 0.00 | | 2025-09-03 08:49:21.42909+00 | | 2025-09-03 08:50:17.546425+00 |
| public | l_user | 62866 | 275 | 0.00 | 0.00 | | 2025-09-03 07:05:35.112601+00 | | |
| public | l_zone | 9817 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:51.571705+00 | | |
| public | l_zone_category | 5155 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:34.254092+00 | | |
| public | m_area | 784 | 9 | 0.00 | 1.00 | | 2025-08-31 07:12:17.78997+00 | | |
| public | m_auth | 141 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.152382+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 | 26760 | 0 | 0.00 | 0.00 | | 2025-09-03 18:18:08.890095+00 | | |
| public | m_favorite | 235904 | 1785 | 0.00 | 0.00 | | 2025-08-30 15:17:27.111905+00 | | |
| public | m_favorite_group | 114212 | 378 | 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 | 28024 | 1629 | 0.00 | 5.00 | | 2025-09-01 09:12:19.246068+00 | | 2025-09-02 14:40:24.378939+00 |
| public | m_holiday | 43859 | 0 | 0.00 | 0.00 | | 2025-09-02 19:18:17.411059+00 | | |
| public | m_lob | 24548 | 8 | 0.00 | 0.00 | | 2025-09-03 01:37:20.98757+00 | | |
| public | m_lob_log | 2003 | 0 | 0.00 | 0.00 | | 2025-09-02 08:36:18.552889+00 | | |
| public | m_location | 44679 | 562 | 0.00 | 1.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-09-04 00:14:09.335375+00 | | |
| public | m_outside | 376 | 0 | 0.00 | 0.00 | | 2025-09-02 03:59:15.518457+00 | | |
| public | m_personal_setting | 132793 | 18360 | 0.00 | 12.00 | | 2025-09-01 22:34:35.261922+00 | | 2025-09-04 00:19:30.879603+00 |
| public | m_pot | 203153 | 27370 | 0.00 | 11.00 | | 2025-08-30 04:00:41.329102+00 | | 2025-09-04 00:23:02.281881+00 |
| public | m_pot_profile | 52627 | 4 | 0.00 | 0.00 | | 2025-09-03 05:08:34.396624+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-09-04 00:14:09.452544+00 | | |
| public | m_role | 773 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.426107+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.301148+00 | | |
| public | m_setting | 15989 | 3057 | 0.00 | 16.00 | | 2025-09-02 06:09:52.880787+00 | | 2025-09-03 06:46:18.469947+00 |
| public | m_setting_log | 36545 | 1742 | 0.00 | 4.00 | | 2025-09-03 02:06:25.012167+00 | | 2025-09-03 12:31:01.730473+00 |
| public | m_site | 187 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.010676+00 | | |
| public | m_tenant | 112 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.49419+00 | | |
| public | m_tx | 121259 | 10220 | 0.00 | 7.00 | | 2025-09-03 08:49:01.476201+00 | | 2025-09-03 11:34:27.771774+00 |
| public | m_user | 33218 | 744 | 0.00 | 2.00 | | 2025-09-01 23:58:32.019978+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 7847 | 13 | 0.00 | 0.00 | | 2025-08-30 06:30:41.401825+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-09-04 00:14:07.174553+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-09-04 00:14:09.363944+00 | | |
| public | r_group_auth | 557 | 0 | 0.00 | 0.00 | | 2025-09-01 01:19:58.239654+00 | | |
| public | r_location_zone | 54172 | 184 | 0.00 | 0.00 | | 2025-08-31 07:12:17.601543+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8445 | 103 | 0.00 | 1.00 | | 2025-09-02 09:38:19.28621+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 11616 | 73 | 0.00 | 0.00 | | 2025-09-02 07:51:32.134264+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 439586 | 756 | 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 | 69981 | 262 | 0.00 | 0.00 | | 2025-09-02 15:03:22.660988+00 | | |
| public | r_pot_user | 20673 | 171 | 0.00 | 0.00 | | 2025-09-03 02:11:24.316438+00 | | |
| public | r_provider_tenant | 1210 | 0 | 0.00 | 0.00 | | 2025-09-03 09:56:16.138515+00 | | |
| public | r_role_feature | 5844 | 6 | 0.00 | 0.00 | | 2025-09-01 12:38:18.794239+00 | | |
| public | r_tenant_feature | 4517 | 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 | 21516 | 183 | 0.00 | 0.00 | | 2025-09-03 02:11:18.462933+00 | | |
| public | r_user_site | 6673 | 1 | 0.00 | 0.00 | | 2025-09-04 00:14:09.27485+00 | | |
| public | r_zone_category | 4970 | 0 | 0.00 | 0.00 | | 2025-09-02 08:36:18.528915+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-01 05:19:49.762173+00 | | |
| public | t_attendance | 3191604 | 32714 | 0.00 | 1.00 | | 2025-08-31 13:33:02.7707+00 | | |
| public | t_general | 4184 | 1 | 0.00 | 0.00 | | 2025-09-01 01:16:12.459577+00 | | |
| public | t_general_20250618 | 3357 | 0 | 0.00 | 0.00 | | 2025-09-02 03:48:42.61602+00 | | |
| public | t_job | 31 | 0 | 0.00 | 0.00 | | 2025-09-02 07:49:15.377944+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 923224 | 0 | 0.00 | 0.00 | | 2025-08-30 01:44:15.681829+00 | | |
| public | t_mobile_status_history | 1871906 | 0 | 0.00 | 0.00 | | 2025-09-03 00:37:09.413143+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.388001+00 | | |
| public | t_notify_history | 6520185 | 13644 | 0.00 | 0.00 | | 2025-08-30 02:30:31.165877+00 | | |
| public | t_operation_log | 22049586 | 22 | 0.00 | 0.00 | | 2025-09-02 09:17:33.174535+00 | | |
| public | t_plan | 27721966 | 1023627 | 0.00 | 3.00 | | 2025-09-01 08:10:47.659333+00 | | 2025-09-03 04:16:16.758944+00 |
| public | t_plan_cancel_history | 601725 | 16693 | 0.00 | 2.00 | | 2025-09-03 04:12:22.465704+00 | | |
| public | t_plan_detail | 47492485 | 908588 | 0.00 | 1.00 | | 2025-09-03 00:29:42.943932+00 | | 2025-09-03 05:34:45.175164+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 | 66150 | 1163 | 0.00 | 1.00 | | 2025-09-04 00:38:13.677515+00 | | 2025-09-04 00:38:14.0007+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.526027+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-09-04 00:14:07.224946+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-09-04 00:14:09.475963+00 | | |
| public | t_recv_position_history | 154188 | 43246 | 0.00 | 21.00 | | 2025-09-04 00:51:24.277148+00 | 2025-09-03 13:30:02.991043+00 | 2025-09-04 00:51:24.545249+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-04 00:14:07.256432+00 | | |
| public | t_terminal | 20962 | 4090 | 0.00 | 16.00 | | 2025-09-03 18:14:09.328073+00 | | 2025-09-04 00:36:19.72253+00 |
| public | t_terminal_log | 28303638 | 0 | 0.00 | 0.00 | | 2025-09-02 07:12:16.990009+00 | | |
| public | temp_pivot_table | 240113 | 0 | 0.00 | 0.00 | | 2025-09-03 05:08:36.394858+00 | | |
| public | w_arrival_notify | 99 | 14 | 0.00 | 12.00 | | 2025-09-03 05:56:44.69118+00 | | 2025-09-02 23:09:22.881724+00 |
| public | w_latest_mobile_device | 56738 | 969 | 0.00 | 1.00 | | 2025-09-01 06:20:02.943264+00 | | 2025-08-31 11:26:59.109828+00 |
| public | w_latest_mobile_status | 55710 | 1721 | 0.00 | 2.00 | | 2025-09-04 00:41:13.457265+00 | | 2025-09-04 00:35:18.419511+00 |
| public | w_latest_position | 79164 | 62382 | 0.00 | 44.00 | | 2025-09-04 00:51:24.673353+00 | | 2025-09-04 00:51:24.855503+00 |
| public | w_latest_presence | 257948 | 351875 | 1.00 | 57.00 | | 2025-09-04 00:51:25.140175+00 | | 2025-09-04 00:51:27.093346+00 |
| public | w_latest_sensor | 386 | 447 | 1.00 | 53.00 | | 2025-09-04 00:51:24.873381+00 | | 2025-09-04 00:51:24.986246+00 |
| public | w_lock | 18460 | 2 | 0.00 | 0.00 | | 2025-09-01 10:22:51.233301+00 | | |
| public | w_master_update | 112 | 65 | 0.00 | 36.00 | | 2025-09-03 23:54:54.38272+00 | | 2025-09-04 00:38:12.98148+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-08-29 14:40:13.993678+00 | | |
| public | w_plan_sync_retry | 0 | 23 | 0 | 100.00 | | 2025-09-03 09:46:08.338178+00 | | 2025-09-03 12:19:52.244971+00 |
| public | w_plan_with_detail | 27717144 | 1430815 | 0.00 | 4.00 | | 2025-08-29 23:38:14.910805+00 | | 2025-09-03 04:20:15.310293+00 |