| 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 | 57061041 | 0 | 0.00 | 0.00 | | 2025-09-08 00:28:06.649082+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-09-08 12:43:52.287603+00 | | |
| e202507 | t_position_history | 611252323 | 0 | 0.00 | 0.00 | | 2025-09-09 00:04:01.807572+00 | | |
| e202507 | t_presence_history | 55790665 | 0 | 0.00 | 0.00 | | 2025-09-08 21:09:44.284807+00 | | |
| e202507 | t_sensor_history | 11690422 | 0 | 0.00 | 0.00 | | 2025-09-03 21:30:38.187021+00 | | |
| e202508 | a_proximity_sum | 32424297 | 0 | 0.00 | 0.00 | | 2025-09-08 02:00:56.422554+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36270075 | 0 | 0.00 | 0.00 | | 2025-09-08 07:37:28.810808+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 581411759 | 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 | 54679149 | 0 | 0.00 | 0.00 | | 2025-09-08 03:00:47.6298+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 | 8887424 | 0 | 0.00 | 0.00 | | 2025-09-08 15:14:22.981448+00 | | 2025-09-08 17:56:38.863371+00 |
| e202509 | a_stay_time | 12009335 | 0 | 0.00 | 0.00 | | 2025-09-08 15:11:30.147146+00 | | 2025-09-08 17:17:54.696305+00 |
| e202509 | t_position_history | 176547573 | 0 | 0.00 | 0.00 | | 2025-09-08 05:57:58.377944+00 | | 2025-09-08 06:45:35.233783+00 |
| e202509 | t_presence_history | 23471121 | 658068 | 0.00 | 2.00 | | 2025-09-09 00:53:56.263817+00 | | 2025-09-09 00:43:57.479342+00 |
| e202509 | t_sensor_history | 3262728 | 0 | 0.00 | 0.00 | | 2025-09-08 16:57:40.146831+00 | | 2025-09-08 19:48:21.012603+00 |
| public | __digdag_status | 32 | 4 | 0.00 | 11.00 | | 2025-09-08 00:13:05.632803+00 | | 2025-09-06 12:30:47.783954+00 |
| public | a_attendance_sum | 151923 | 24845 | 0.00 | 14.00 | | 2025-09-08 00:45:44.916862+00 | | 2025-09-09 00:37:51.376843+00 |
| public | a_plan_actual | 1055117 | 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 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:54.715338+00 | | |
| public | l_auth | 176 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:54.640895+00 | | |
| public | l_category | 2696 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:55.985284+00 | | |
| public | l_group | 36456 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:58.006518+00 | | |
| public | l_lob | 1954 | 3 | 0.00 | 0.00 | | 2025-09-07 22:00:31.786762+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 104838 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:55.816882+00 | | |
| public | l_location_zone | 99205 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:55.15422+00 | | |
| public | l_outside | 454 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:54.655954+00 | | |
| public | l_pot | 437217 | 172 | 0.00 | 0.00 | | 2025-09-08 17:17:02.278545+00 | | |
| public | l_pot_category | 13604 | 4 | 0.00 | 0.00 | | 2025-09-08 17:16:55.966217+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 230304 | 101 | 0.00 | 0.00 | | 2025-09-08 17:16:57.828943+00 | | |
| public | l_pot_tx | 101436 | 67 | 0.00 | 0.00 | | 2025-09-08 17:16:56.698936+00 | | |
| public | l_role | 773 | 0 | 0.00 | 0.00 | | 2025-09-08 17:15:54.316985+00 | | |
| public | l_role_feature | 6848 | 0 | 0.00 | 0.00 | | 2025-09-08 17:15:54.304525+00 | | |
| public | l_site | 257 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:54.73031+00 | | |
| public | l_tx | 135429 | 0 | 0.00 | 0.00 | | 2025-09-08 23:33:21.459577+00 | | 2025-09-05 13:46:26.432571+00 |
| public | l_user | 63307 | 73 | 0.00 | 0.00 | | 2025-09-08 17:15:54.234464+00 | | 2025-09-05 09:09:18.220322+00 |
| public | l_zone | 9790 | 0 | 0.00 | 0.00 | | 2025-09-08 17:16:55.21462+00 | | |
| public | l_zone_category | 4984 | 0 | 0.00 | 0.00 | | 2025-09-08 17:15:53.610457+00 | | |
| public | m_area | 785 | 1 | 0.00 | 0.00 | | 2025-09-04 19:53:47.510816+00 | | |
| public | m_auth | 142 | 6 | 0.00 | 4.00 | | 2025-09-04 00:14:09.152382+00 | | |
| public | m_category | 2433 | 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 | 215765 | 419 | 0.00 | 0.00 | | 2025-09-04 08:21:15.96912+00 | | |
| public | m_favorite_group | 114679 | 58 | 0.00 | 0.00 | | 2025-09-06 05:51:13.45764+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-09-04 02:30:46.854961+00 | | |
| public | m_group | 28071 | 1201 | 0.00 | 4.00 | | 2025-09-06 01:18:38.658039+00 | | 2025-09-08 14:40:58.306511+00 |
| public | m_holiday | 43937 | 0 | 0.00 | 0.00 | | 2025-09-08 03:38:53.597851+00 | | |
| public | m_lob | 24585 | 13 | 0.00 | 0.00 | | 2025-09-08 06:48:59.455649+00 | | |
| public | m_lob_log | 2034 | 0 | 0.00 | 0.00 | | 2025-09-07 23:32:32.875571+00 | | |
| public | m_location | 44794 | 903 | 0.00 | 1.00 | | 2025-09-04 12:56:24.911296+00 | | 2025-08-29 11:38:48.027813+00 |
| public | m_notify_template | 1231 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.335375+00 | | |
| public | m_outside | 377 | 8 | 0.00 | 2.00 | | 2025-09-07 06:59:04.858578+00 | | |
| public | m_personal_setting | 133143 | 16696 | 0.00 | 11.00 | | 2025-09-06 13:20:39.169712+00 | | 2025-09-09 00:31:45.369941+00 |
| public | m_pot | 203538 | 21475 | 0.00 | 9.00 | | 2025-09-04 04:42:36.799715+00 | | 2025-09-09 00:10:07.385955+00 |
| public | m_pot_profile | 52674 | 0 | 0.00 | 0.00 | | 2025-09-08 11:01:36.882003+00 | | |
| public | m_provider_user | 85 | 3 | 0.00 | 3.00 | | 2025-09-04 03:16:19.872149+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.452544+00 | | |
| public | m_role | 776 | 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 | 26430 | 1278 | 0.00 | 4.00 | | 2025-09-08 06:05:52.004705+00 | | 2025-09-07 20:20:47.637575+00 |
| public | m_setting_log | 36547 | 1500 | 0.00 | 3.00 | | 2025-09-08 03:01:07.510349+00 | | 2025-09-08 11:25:18.798653+00 |
| public | m_site | 189 | 1 | 0.00 | 0.00 | | 2025-09-04 00:14:09.010676+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-09-04 00:14:09.49419+00 | | |
| public | m_tx | 121690 | 11795 | 0.00 | 8.00 | | 2025-09-08 00:45:34.811526+00 | | 2025-09-08 04:06:24.656094+00 |
| public | m_user | 36243 | 132 | 0.00 | 0.00 | | 2025-09-06 17:29:02.142298+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 7853 | 9 | 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 | 215 | 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 | 568 | 0 | 0.00 | 0.00 | | 2025-09-05 05:44:18.944772+00 | | |
| public | r_location_zone | 54264 | 253 | 0.00 | 0.00 | | 2025-09-04 19:53:47.444673+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8186 | 6 | 0.00 | 0.00 | | 2025-09-08 00:28:04.397293+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 11630 | 27 | 0.00 | 0.00 | | 2025-09-07 22:08:45.308061+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 439076 | 375 | 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 | 70077 | 112 | 0.00 | 0.00 | | 2025-09-08 02:48:38.40331+00 | | |
| public | r_pot_user | 20672 | 2 | 0.00 | 0.00 | | 2025-09-08 07:18:35.477781+00 | | |
| public | r_provider_tenant | 944 | 0 | 0.00 | 0.00 | | 2025-09-08 07:33:06.10313+00 | | 2025-09-08 07:32:05.893484+00 |
| public | r_role_feature | 6045 | 4 | 0.00 | 0.00 | | 2025-09-06 06:42:00.752074+00 | | |
| public | r_tenant_feature | 4485 | 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-06 01:18:38.684822+00 | | |
| public | r_user_region | 21514 | 2 | 0.00 | 0.00 | | 2025-09-08 07:18:28.251598+00 | | |
| public | r_user_site | 6676 | 4 | 0.00 | 0.00 | | 2025-09-04 00:14:09.27485+00 | | |
| public | r_zone_category | 4952 | 0 | 0.00 | 0.00 | | 2025-09-07 23:32:32.841277+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-05 11:13:04.780161+00 | | |
| public | t_attendance | 3214746 | 19366 | 0.00 | 0.00 | | 2025-09-05 00:51:47.325111+00 | | |
| public | t_general | 4315 | 2 | 0.00 | 0.00 | | 2025-09-05 05:41:18.882554+00 | | |
| public | t_general_20250618 | 3305 | 0 | 0.00 | 0.00 | | 2025-09-07 06:30:48.325152+00 | | |
| public | t_job | 31 | 0 | 0.00 | 0.00 | | 2025-09-07 22:03:31.056353+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 900289 | 0 | 0.00 | 0.00 | | 2025-09-04 03:53:11.291263+00 | | |
| public | t_mobile_status_history | 2004678 | 0 | 0.00 | 0.00 | | 2025-09-08 06:05:54.597934+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 | 6536775 | 10894 | 0.00 | 0.00 | | 2025-09-04 04:09:58.963035+00 | | |
| public | t_operation_log | 22141860 | 11 | 0.00 | 0.00 | | 2025-09-08 00:13:05.553378+00 | | |
| public | t_plan | 27967317 | 696635 | 0.00 | 2.00 | | 2025-09-05 22:18:30.908913+00 | | 2025-09-08 00:24:09.127125+00 |
| public | t_plan_cancel_history | 610942 | 3252 | 0.00 | 0.00 | | 2025-09-08 09:22:15.069517+00 | | |
| public | t_plan_detail | 47958342 | 778079 | 0.00 | 1.00 | | 2025-09-08 06:05:42.975431+00 | | 2025-09-09 00:10:02.204697+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 | 66382 | 9252 | 0.00 | 12.00 | | 2025-09-09 00:20:18.605418+00 | | 2025-09-09 00:39:50.612191+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 | 154760 | 41058 | 0.00 | 20.00 | | 2025-09-09 00:56:19.46369+00 | 2025-09-08 13:30:02.511482+00 | 2025-09-09 00:57:14.089024+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-04 00:14:07.256432+00 | | |
| public | t_terminal | 20987 | 2561 | 0.00 | 10.00 | | 2025-09-08 19:01:58.547105+00 | | 2025-09-09 00:38:52.767479+00 |
| public | t_terminal_log | 28696543 | 0 | 0.00 | 0.00 | | 2025-09-07 18:11:12.886005+00 | | |
| public | temp_pivot_table | 240042 | 0 | 0.00 | 0.00 | | 2025-09-08 11:01:38.98329+00 | | |
| public | w_arrival_notify | 100 | 4 | 0.00 | 3.00 | | 2025-09-08 12:43:52.15648+00 | | 2025-09-07 23:31:32.451321+00 |
| public | w_latest_mobile_device | 56872 | 512 | 0.00 | 0.00 | | 2025-09-05 13:44:09.460437+00 | | 2025-09-08 00:31:05.499609+00 |
| public | w_latest_mobile_status | 55840 | 10665 | 0.00 | 16.00 | | 2025-09-08 08:13:54.634977+00 | | 2025-09-09 00:31:46.222744+00 |
| public | w_latest_position | 79295 | 31370 | 0.00 | 28.00 | | 2025-09-09 00:57:14.259284+00 | | 2025-09-09 00:57:14.439753+00 |
| public | w_latest_presence | 228122 | 196811 | 0.00 | 46.00 | | 2025-09-09 00:57:32.998123+00 | | 2025-09-09 00:57:34.613502+00 |
| public | w_latest_sensor | 386 | 297 | 0.00 | 43.00 | | 2025-09-09 00:57:14.459453+00 | | 2025-09-09 00:57:14.570764+00 |
| public | w_lock | 18480 | 0 | 0.00 | 0.00 | | 2025-09-06 03:45:47.195658+00 | | |
| public | w_master_update | 113 | 29 | 0.00 | 20.00 | | 2025-09-09 00:33:51.169811+00 | | 2025-09-09 00:47:45.429333+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-04 01:09:48.517218+00 | | |
| public | w_plan_sync_retry | 0 | 12 | 0 | 100.00 | | 2025-09-08 22:40:52.525964+00 | | 2025-09-08 22:35:52.228495+00 |
| public | w_plan_with_detail | 28030803 | 1210104 | 0.00 | 4.00 | | 2025-09-04 03:15:51.568027+00 | | 2025-09-08 00:19:05.993686+00 |