| 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 | 610147602 | 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 | 581410911 | 0 | 0.00 | 0.00 | | 2025-09-05 05:10:33.633679+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 | 11764827 | 0 | 0.00 | 0.00 | | 2025-09-04 12:32:26.370668+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 7191821 | 0 | 0.00 | 0.00 | | 2025-09-04 18:38:56.761753+00 | | 2025-09-05 17:56:57.366818+00 |
| e202509 | a_stay_time | 9771691 | 0 | 0.00 | 0.00 | | 2025-09-04 18:55:28.075133+00 | | 2025-09-05 17:21:38.803995+00 |
| e202509 | t_position_history | 129624166 | 0 | 0.00 | 0.00 | | 2025-09-04 20:29:10.262471+00 | | 2025-09-05 07:08:26.287876+00 |
| e202509 | t_presence_history | 16807307 | 300521 | 0.00 | 1.00 | | 2025-09-06 00:50:23.503372+00 | | 2025-09-06 00:44:58.804926+00 |
| e202509 | t_sensor_history | 2072924 | 0 | 0.00 | 0.00 | | 2025-09-06 00:31:13.662405+00 | | 2025-09-05 14:49:04.428197+00 |
| public | __digdag_status | 33 | 16 | 0.00 | 32.00 | | 2025-09-02 09:17:33.265173+00 | | 2025-08-28 12:30:18.362409+00 |
| public | a_attendance_sum | 150734 | 18237 | 0.00 | 10.00 | | 2025-09-04 23:41:36.157979+00 | | 2025-09-05 10:24:24.872289+00 |
| public | a_plan_actual | 1045739 | 0 | 0.00 | 0.00 | | 2025-09-04 10:44:16.007601+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-05 05:41:19.00611+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-09-05 00:52:12.417107+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-09-05 01:35:40.477519+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-09-05 00:50:54.888151+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-09-05 01:35:40.498409+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-09-05 01:35:40.519823+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-09-05 00:50:54.908465+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-09-05 00:50:54.864329+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-09-05 01:35:38.782882+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-09-05 00:50:54.932983+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-09-05 00:50:54.955343+00 | | |
| public | l_area | 1552 | 3 | 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 | 2643 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:52.453223+00 | | |
| public | l_group | 35894 | 28 | 0.00 | 0.00 | | 2025-09-03 07:05:55.25874+00 | | |
| public | l_lob | 1951 | 5 | 0.00 | 0.00 | | 2025-09-02 07:47:38.571929+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 103476 | 769 | 0.00 | 0.00 | | 2025-09-03 07:05:52.226311+00 | | |
| public | l_location_zone | 99871 | 257 | 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 | 438847 | 1031 | 0.00 | 0.00 | | 2025-09-03 07:06:00.35821+00 | | |
| public | l_pot_category | 13562 | 71 | 0.00 | 0.00 | | 2025-09-03 07:05:52.423476+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 229957 | 249 | 0.00 | 0.00 | | 2025-09-03 07:05:55.022078+00 | | |
| public | l_pot_tx | 101273 | 310 | 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 | 141717 | 17707 | 0.00 | 11.00 | | 2025-09-05 13:25:30.739932+00 | | 2025-09-05 13:46:26.432571+00 |
| public | l_user | 63190 | 470 | 0.00 | 0.00 | | 2025-09-03 07:05:35.112601+00 | | 2025-09-05 09:09:18.220322+00 |
| public | l_zone | 9818 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:51.571705+00 | | |
| public | l_zone_category | 5156 | 0 | 0.00 | 0.00 | | 2025-09-03 07:05:34.254092+00 | | |
| public | m_area | 785 | 1 | 0.00 | 0.00 | | 2025-09-04 19:53:47.510816+00 | | |
| public | m_auth | 141 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.152382+00 | | |
| public | m_category | 2422 | 0 | 0.00 | 0.00 | | 2025-09-04 19:53:47.463646+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-09-05 07:33:18.334347+00 | | |
| public | m_exb | 27331 | 395 | 0.00 | 1.00 | | 2025-09-03 18:18:08.890095+00 | | |
| public | m_favorite | 215552 | 187 | 0.00 | 0.00 | | 2025-09-04 08:21:15.96912+00 | | |
| public | m_favorite_group | 114429 | 419 | 0.00 | 0.00 | | 2025-09-01 11:47:17.582229+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-09-04 02:30:46.854961+00 | | |
| public | m_group | 28067 | 2128 | 0.00 | 7.00 | | 2025-09-01 09:12:19.246068+00 | | 2025-09-04 14:40:34.451757+00 |
| public | m_holiday | 43859 | 0 | 0.00 | 0.00 | | 2025-09-02 19:18:17.411059+00 | | |
| public | m_lob | 24590 | 36 | 0.00 | 0.00 | | 2025-09-03 01:37:20.98757+00 | | |
| public | m_lob_log | 2019 | 0 | 0.00 | 0.00 | | 2025-09-02 08:36:18.552889+00 | | |
| public | m_location | 44673 | 162 | 0.00 | 0.00 | | 2025-09-04 12:56:24.911296+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 | 132939 | 18048 | 0.00 | 11.00 | | 2025-09-01 22:34:35.261922+00 | | 2025-09-05 10:46:19.421502+00 |
| public | m_pot | 203454 | 15777 | 0.00 | 7.00 | | 2025-09-04 04:42:36.799715+00 | | 2025-09-05 06:39:48.329991+00 |
| public | m_pot_profile | 52690 | 9 | 0.00 | 0.00 | | 2025-09-03 05:08:34.396624+00 | | |
| public | m_provider_user | 84 | 0 | 0.00 | 0.00 | | 2025-09-04 03:16:19.872149+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 | 15994 | 3101 | 0.00 | 16.00 | | 2025-09-04 03:25:49.908709+00 | | 2025-09-05 01:27:38.193595+00 |
| public | m_setting_log | 36405 | 0 | 0.00 | 0.00 | | 2025-09-03 02:06:25.012167+00 | | 2025-09-05 20:12:07.582143+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 | 121618 | 14961 | 0.00 | 10.00 | | 2025-09-05 13:44:07.708997+00 | | 2025-09-05 13:46:07.27289+00 |
| public | m_user | 33227 | 844 | 0.00 | 2.00 | | 2025-09-01 23:58:32.019978+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 7848 | 3 | 0.00 | 0.00 | | 2025-09-04 05:35:49.004247+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-09-04 08:48:08.033803+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-05 05:44:18.944772+00 | | |
| public | r_location_zone | 54172 | 252 | 0.00 | 0.00 | | 2025-09-04 19:53:47.444673+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8347 | 210 | 0.00 | 2.00 | | 2025-09-02 09:38:19.28621+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 11616 | 110 | 0.00 | 0.00 | | 2025-09-02 07:51:32.134264+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 439181 | 72 | 0.00 | 0.00 | | 2025-09-05 07:33:18.299881+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-09-04 05:45:01.136281+00 | | |
| public | r_pot_tx | 70037 | 427 | 0.00 | 0.00 | | 2025-09-02 15:03:22.660988+00 | | |
| public | r_pot_user | 20671 | 183 | 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 | 4423 | 0 | 0.00 | 0.00 | | 2025-09-05 00:50:53.857911+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-01 09:12:19.271531+00 | | |
| public | r_user_region | 21513 | 195 | 0.00 | 0.00 | | 2025-09-03 02:11:18.462933+00 | | |
| public | r_user_site | 6676 | 3 | 0.00 | 0.00 | | 2025-09-04 00:14:09.27485+00 | | |
| public | r_zone_category | 4971 | 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-05 11:13:04.780161+00 | | |
| public | t_attendance | 3198667 | 7798 | 0.00 | 0.00 | | 2025-09-05 00:51:47.325111+00 | | |
| public | t_general | 4303 | 0 | 0.00 | 0.00 | | 2025-09-05 05:41:18.882554+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 | 898837 | 0 | 0.00 | 0.00 | | 2025-09-04 03:53:11.291263+00 | | |
| public | t_mobile_status_history | 1991464 | 0 | 0.00 | 0.00 | | 2025-09-03 00:37:09.413143+00 | | 2025-09-04 10:03:21.422779+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.388001+00 | | |
| public | t_notify_history | 6509413 | 5961 | 0.00 | 0.00 | | 2025-09-04 04:09:58.963035+00 | | |
| public | t_operation_log | 22148623 | 45 | 0.00 | 0.00 | | 2025-09-02 09:17:33.174535+00 | | |
| public | t_plan | 27614486 | 5345 | 0.00 | 0.00 | | 2025-09-05 22:18:30.908913+00 | | 2025-09-03 04:16:16.758944+00 |
| public | t_plan_cancel_history | 605717 | 65260 | 0.00 | 9.00 | | 2025-09-03 04:12:22.465704+00 | | |
| public | t_plan_detail | 47678349 | 1653878 | 0.00 | 3.00 | | 2025-09-03 00:29:42.943932+00 | | 2025-09-05 05:11:15.515885+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-09-04 05:45:01.117046+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-09-04 05:45:01.095831+00 | | |
| public | t_plan_sync | 66360 | 9696 | 0.00 | 12.00 | | 2025-09-05 23:46:45.496231+00 | | 2025-09-06 00:37:10.289455+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 | 143405 | 22631 | 0.00 | 13.00 | | 2025-09-06 00:50:47.28244+00 | 2025-09-05 13:30:02.643583+00 | 2025-09-06 00:51:41.999857+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-04 00:14:07.256432+00 | | |
| public | t_terminal | 20972 | 3732 | 0.00 | 15.00 | | 2025-09-05 18:21:56.413623+00 | | 2025-09-06 00:47:59.546104+00 |
| public | t_terminal_log | 28478101 | 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 | 98 | 37 | 0.00 | 27.00 | | 2025-09-03 05:56:44.69118+00 | | 2025-09-04 01:23:28.565844+00 |
| public | w_latest_mobile_device | 56797 | 13 | 0.00 | 0.00 | | 2025-09-05 13:44:09.460437+00 | | 2025-08-31 11:26:59.109828+00 |
| public | w_latest_mobile_status | 55767 | 4558 | 0.00 | 7.00 | | 2025-09-05 08:49:11.435621+00 | | 2025-09-05 12:44:47.126583+00 |
| public | w_latest_position | 79241 | 9508 | 0.00 | 10.00 | | 2025-09-06 00:48:57.736039+00 | | 2025-09-06 00:50:47.687671+00 |
| public | w_latest_presence | 245890 | 122496 | 0.00 | 33.00 | | 2025-09-06 00:51:57.65648+00 | | 2025-09-06 00:52:00.061897+00 |
| public | w_latest_sensor | 386 | 239 | 0.00 | 38.00 | | 2025-09-06 00:51:42.014876+00 | | 2025-09-06 00:51:42.127934+00 |
| public | w_lock | 18472 | 2 | 0.00 | 0.00 | | 2025-09-01 10:22:51.233301+00 | | |
| public | w_master_update | 112 | 71 | 0.00 | 38.00 | | 2025-09-05 14:40:35.013569+00 | | 2025-09-05 22:18:56.533384+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-04 01:09:48.517218+00 | | |
| public | w_plan_sync_retry | 0 | 34 | 0 | 100.00 | | 2025-09-05 08:30:35.221641+00 | | 2025-09-05 10:26:24.147848+00 |
| public | w_plan_with_detail | 27527954 | 716936 | 0.00 | 2.00 | | 2025-09-04 03:15:51.568027+00 | | 2025-09-03 04:20:15.310293+00 |