| 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 |
|---|
| e202605 | a_proximity_sum | 569250 | 0 | 0.00 | 0.00 | | 2026-05-26 16:02:10.552953+00 | | 2026-05-29 16:01:29.86184+00 |
| e202605 | a_stay_time | 138831 | 0 | 0.00 | 0.00 | | 2026-05-26 16:01:10.272795+00 | | 2026-05-29 16:00:29.755534+00 |
| e202605 | t_position_history | 77472525 | 2 | 0.00 | 0.00 | | 2026-05-30 11:09:28.286638+00 | | 2026-05-29 20:19:35.182702+00 |
| e202605 | t_presence_history | 6236331 | 42034 | 0.00 | 0.00 | | 2026-05-30 19:09:39.434615+00 | | 2026-05-31 13:01:34.465051+00 |
| e202605 | t_sensor_history | 2645636 | 0 | 0.00 | 0.00 | | 2026-05-29 21:34:33.304161+00 | | 2026-05-31 01:27:28.183641+00 |
| e202606 | a_proximity_sum | 644148 | 0 | 0.00 | 0.00 | | 2026-06-27 16:01:13.901105+00 | | 2026-06-30 16:01:39.145771+00 |
| e202606 | a_stay_time | 166092 | 0 | 0.00 | 0.00 | | 2026-06-27 16:00:13.457171+00 | | 2026-06-29 16:01:09.523109+00 |
| e202606 | t_position_history | 77491046 | 1409 | 0.00 | 0.00 | | 2026-06-28 05:28:05.404761+00 | | 2026-06-28 19:23:11.322801+00 |
| e202606 | t_presence_history | 8378927 | 479396 | 0.00 | 5.00 | | 2026-06-30 08:08:20.723442+00 | | 2026-06-30 13:29:30.115663+00 |
| e202606 | t_sensor_history | 2541897 | 0 | 0.00 | 0.00 | | 2026-06-29 19:43:14.618122+00 | | 2026-06-28 21:43:09.870529+00 |
| e202607 | a_proximity_sum | 282991 | 0 | 0.00 | 0.00 | | 2026-07-09 16:01:51.685477+00 | | 2026-07-09 16:01:51.853439+00 |
| e202607 | a_stay_time | 57674 | 0 | 0.00 | 0.00 | | 2026-07-08 16:00:38.966414+00 | | 2026-07-09 16:00:51.541367+00 |
| e202607 | t_position_history | 24342424 | 1212 | 0.00 | 0.00 | | 2026-07-09 05:18:53.659734+00 | | 2026-07-09 16:18:52.705239+00 |
| e202607 | t_presence_history | 2781165 | 321467 | 0.00 | 10.00 | | 2026-07-10 00:01:49.147038+00 | | 2026-07-10 00:47:21.982985+00 |
| e202607 | t_sensor_history | 790003 | 0 | 0.00 | 0.00 | | 2026-07-08 10:16:36.709412+00 | | 2026-07-09 20:00:28.073819+00 |
| public | __digdag_status | 6 | 30 | 5.00 | 83.00 | | 2026-06-24 12:32:57.202314+00 | | 2026-06-27 12:32:12.218104+00 |
| public | a_attendance_sum | 1150 | 0 | 0.00 | 0.00 | | 2026-05-13 23:39:19.047964+00 | | 2026-02-24 07:18:51.547612+00 |
| public | a_plan_actual | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.062835+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.061956+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.062123+00 | | |
| public | area_history | 248 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.853674+00 | | 2025-12-20 12:48:14.707882+00 |
| public | l_area | 120 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.846179+00 | | 2025-12-20 12:48:14.70532+00 |
| public | l_auth | 57 | 0 | 0.00 | 0.00 | | 2026-05-14 15:29:06.138652+00 | | 2025-12-20 12:48:14.701558+00 |
| public | l_category | 77 | 0 | 0.00 | 0.00 | | 2026-05-17 02:45:45.241471+00 | | 2026-01-27 06:02:59.041017+00 |
| public | l_group | 206 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.83002+00 | | 2025-12-20 12:48:14.671637+00 |
| public | l_lob | 86 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.927788+00 | | 2025-12-20 12:46:11.114707+00 |
| public | l_location | 5775 | 37 | 0.00 | 0.00 | | 2026-06-23 03:23:14.51998+00 | | 2026-03-05 05:25:04.688354+00 |
| public | l_location_zone | 3851 | 17 | 0.00 | 0.00 | | 2026-05-10 18:21:47.535244+00 | | 2026-03-05 01:00:01.594849+00 |
| public | l_outside | 2 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.053323+00 | | |
| public | l_pot | 87547 | 495 | 0.00 | 0.00 | | 2026-07-05 15:30:34.78431+00 | | 2026-07-01 04:02:46.784558+00 |
| public | l_pot_category | 219 | 1 | 0.00 | 0.00 | | 2026-05-24 09:41:22.054191+00 | | 2026-07-03 06:39:34.621686+00 |
| public | l_pot_group | 12770 | 104 | 0.00 | 0.00 | | 2026-05-15 21:16:21.468122+00 | | 2025-12-20 12:48:14.655001+00 |
| public | l_pot_tx | 4874 | 107 | 0.00 | 2.00 | | 2026-05-15 18:53:00.172611+00 | | 2026-07-03 06:39:34.618578+00 |
| public | l_role | 16 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.899781+00 | | |
| public | l_role_feature | 414 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.885863+00 | | 2025-12-20 12:48:14.736886+00 |
| public | l_site | 7 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.90516+00 | | |
| public | l_tx | 6545 | 0 | 0.00 | 0.00 | | 2026-07-06 12:07:52.314788+00 | | 2026-06-24 09:19:55.67445+00 |
| public | l_user | 111 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.824335+00 | | 2025-12-20 12:48:14.661693+00 |
| public | l_zone | 281 | 0 | 0.00 | 0.00 | | 2026-05-13 15:22:34.407857+00 | | 2026-02-06 08:33:07.418396+00 |
| public | l_zone_category | 175 | 0 | 0.00 | 0.00 | | 2026-05-18 07:46:01.950353+00 | | 2026-06-29 01:39:11.67839+00 |
| public | m_area | 106 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.843217+00 | | 2025-12-20 12:48:14.699133+00 |
| public | m_auth | 57 | 0 | 0.00 | 0.00 | | 2026-05-14 15:29:06.139649+00 | | 2025-12-20 12:49:11.870148+00 |
| public | m_category | 219 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.13913+00 | | 2025-12-20 12:49:11.912928+00 |
| public | m_env | 10 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.132625+00 | | |
| public | m_exb | 1421 | 0 | 0.00 | 0.00 | | 2026-05-16 14:17:40.151592+00 | | 2026-02-09 00:33:58.911481+00 |
| public | m_favorite | 778 | 2 | 0.00 | 0.00 | | 2026-05-24 09:41:22.09419+00 | | 2025-12-20 12:49:11.854007+00 |
| public | m_favorite_group | 3411 | 20 | 0.00 | 0.00 | | 2026-05-24 09:41:22.014467+00 | | 2026-05-29 14:01:28.764425+00 |
| public | m_feature | 174 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.109874+00 | | 2025-12-20 12:49:11.860448+00 |
| public | m_group | 240 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.81387+00 | | 2025-12-20 12:48:14.012956+00 |
| public | m_holiday | 243 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.026937+00 | | 2025-12-20 12:48:14.711222+00 |
| public | m_lob | 802 | 4 | 0.00 | 0.00 | | 2026-05-24 09:41:21.753982+00 | | 2025-12-20 12:46:21.252941+00 |
| public | m_lob_log | 65 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.755034+00 | | 2025-12-20 12:49:10.380453+00 |
| public | m_location | 2822 | 39 | 0.00 | 1.00 | | 2026-05-13 19:36:26.605745+00 | | 2026-03-05 03:13:23.587884+00 |
| public | m_notify_template | 73 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.026306+00 | | 2025-12-20 12:48:14.695514+00 |
| public | m_outside | 7 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.915475+00 | | |
| public | m_personal_setting | 2131 | 57 | 0.00 | 2.00 | | 2026-06-22 00:21:35.861168+00 | | 2026-07-09 09:06:47.595568+00 |
| public | m_pot | 36333 | 803 | 0.00 | 2.00 | | 2026-07-01 04:02:45.228777+00 | | 2026-07-01 04:02:45.850603+00 |
| public | m_pot_profile | 26 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.029763+00 | | |
| public | m_provider_user | 50 | 3 | 0.00 | 5.00 | | 2026-05-24 09:41:21.912214+00 | | |
| public | m_region | 13 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.920303+00 | | |
| public | m_role | 35 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.872625+00 | | |
| public | m_sensor | 16 | 1 | 0.00 | 5.00 | | 2026-05-24 09:41:22.03827+00 | | |
| public | m_setting | 493 | 61 | 0.00 | 11.00 | | 2026-07-08 11:37:36.685541+00 | | 2026-07-08 14:06:37.857989+00 |
| public | m_setting_log | 2181 | 176 | 0.00 | 7.00 | | 2026-07-04 12:32:49.758912+00 | | 2026-07-06 12:33:01.227882+00 |
| public | m_site | 23 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.867139+00 | | |
| public | m_tenant | 6 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.034814+00 | | |
| public | m_tx | 6332 | 1 | 0.00 | 0.00 | | 2026-06-25 03:54:14.21237+00 | | 2026-06-25 03:54:14.237712+00 |
| public | m_user | 119 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.822455+00 | | 2025-12-20 12:48:14.026248+00 |
| public | m_zone | 278 | 0 | 0.00 | 0.00 | | 2026-05-13 15:08:44.13421+00 | | 2026-02-06 08:33:07.407408+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.055282+00 | | |
| public | r_auth_zone | 9 | 0 | 0.00 | 0.00 | | 2026-05-14 15:32:36.052923+00 | | 2026-02-06 08:32:07.413614+00 |
| public | r_exb_sensor | 99 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.030564+00 | | 2025-12-20 12:48:14.727672+00 |
| public | r_group_auth | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.055143+00 | | |
| public | r_location_zone | 1137 | 7 | 0.00 | 0.00 | | 2026-06-23 06:19:33.155984+00 | | 2026-03-05 01:03:01.681954+00 |
| public | r_pot_auth | 530 | 68 | 0.00 | 11.00 | | 2026-05-07 10:27:35.79812+00 | | 2026-06-30 09:41:10.553189+00 |
| public | r_pot_category | 218 | 1 | 0.00 | 0.00 | | 2026-05-24 09:41:22.054956+00 | | 2026-07-03 06:39:34.624371+00 |
| public | r_pot_group | 6112 | 89 | 0.00 | 1.00 | | 2026-05-17 17:24:13.634071+00 | | 2025-12-20 12:48:13.514096+00 |
| public | r_pot_plan_permission_group | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.069429+00 | | |
| public | r_pot_tx | 2642 | 106 | 0.00 | 3.00 | | 2026-05-17 12:31:50.913075+00 | | 2026-06-24 04:00:53.436337+00 |
| public | r_pot_user | 25 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.890892+00 | | |
| public | r_provider_tenant | 28 | 2 | 0.00 | 6.00 | | 2026-05-24 09:41:21.914862+00 | | |
| public | r_role_feature | 426 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.842473+00 | | 2025-12-20 12:48:14.68726+00 |
| public | r_tenant_feature | 98 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.035408+00 | | 2025-12-20 12:48:14.730432+00 |
| public | r_tx_sensor | 139 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.860112+00 | | 2025-12-20 12:48:14.72485+00 |
| public | r_user_region | 56 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.866243+00 | | 2026-02-05 08:47:29.324871+00 |
| public | r_user_site | 40 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.886473+00 | | |
| public | r_zone_category | 124 | 0 | 0.00 | 0.00 | | 2026-05-18 07:46:01.951132+00 | | 2026-06-29 01:37:11.651234+00 |
| public | t_ai_history | 70 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.022933+00 | | 2025-12-20 12:48:14.71656+00 |
| public | t_attendance | 30698 | 637 | 0.00 | 2.00 | | 2026-06-11 08:23:35.752662+00 | | 2026-05-29 00:01:37.286496+00 |
| public | t_general | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.061758+00 | | |
| public | t_job | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.07001+00 | | |
| public | t_mobile_device_history | 5177 | 0 | 0.00 | 0.00 | | 2026-07-01 19:18:43.41623+00 | | 2026-06-29 01:21:11.490301+00 |
| public | t_mobile_status_history | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.063238+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.055375+00 | | |
| public | t_notify_history | 8620 | 50 | 0.00 | 0.00 | | 2026-06-27 19:13:08.877679+00 | | 2026-05-28 06:16:14.467357+00 |
| public | t_operation_log | 158750 | 1 | 0.00 | 0.00 | | 2026-06-29 07:05:14.505689+00 | | 2026-05-19 00:19:10.365836+00 |
| public | t_plan | 3249961 | 18506 | 0.00 | 0.00 | | 2026-07-10 00:41:54.484068+00 | | 2026-07-10 00:06:37.676698+00 |
| public | t_plan_cancel_history | 9063 | 1 | 0.00 | 0.00 | | 2026-06-22 01:52:28.132826+00 | | 2026-07-09 02:56:44.617989+00 |
| public | t_plan_detail | 8029356 | 1001171 | 0.00 | 11.00 | | 2026-07-09 08:33:07.703909+00 | | 2026-07-10 00:06:31.747536+00 |
| public | t_plan_permission | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.063343+00 | | |
| public | t_plan_permission_group | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.069314+00 | | |
| public | t_plan_sync | 35043 | 5216 | 0.00 | 12.00 | | 2026-07-09 22:01:28.90519+00 | | 2026-07-09 23:33:29.786503+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.124501+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.12422+00 | | |
| public | t_recv_position_history | 9451 | 0 | 0.00 | 0.00 | | 2026-06-03 19:09:16.451581+00 | | 2026-02-24 07:38:51.563217+00 |
| public | t_safr_event_history | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.113915+00 | | |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.122974+00 | | |
| public | t_terminal | 9 | 46 | 5.00 | 83.00 | | 2026-07-10 00:01:29.761934+00 | | 2026-07-10 00:25:30.031168+00 |
| public | t_terminal_log | 42710 | 672 | 0.00 | 1.00 | | 2026-07-03 09:06:01.62224+00 | | 2026-07-08 23:56:43.483109+00 |
| public | w_arrival_notify | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.110007+00 | | |
| public | w_latest_mobile_device | 782 | 19 | 0.00 | 2.00 | | 2026-05-15 01:16:01.581937+00 | | 2026-06-09 22:05:41.349181+00 |
| public | w_latest_mobile_status | 735 | 44 | 0.00 | 5.00 | | 2026-06-30 09:23:01.926884+00 | | 2026-07-09 11:16:48.874147+00 |
| public | w_latest_position | 3962 | 2232 | 0.00 | 36.00 | | 2026-07-10 00:54:21.419619+00 | | 2026-07-10 00:54:21.442958+00 |
| public | w_latest_presence | 28930 | 14465 | 0.00 | 33.00 | | 2026-07-10 00:54:21.317431+00 | | 2026-07-10 00:54:21.398025+00 |
| public | w_latest_sensor | 1639 | 332 | 0.00 | 16.00 | | 2026-07-10 00:41:21.186623+00 | | 2026-07-10 00:53:21.267226+00 |
| public | w_lock | 240 | 0 | 0.00 | 0.00 | | 2026-06-30 07:01:00.581665+00 | | 2026-06-24 10:10:56.173414+00 |
| public | w_lock_position | 0 | 0 | 0 | 0 | | | | |
| public | w_master_update | 6 | 17 | 2.00 | 73.00 | | 2026-07-09 07:40:46.850062+00 | | 2026-07-09 07:45:46.891223+00 |
| public | w_migration | 29 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.903877+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.062684+00 | | |
| public | w_plan_with_detail | 3117651 | 318978 | 0.00 | 9.00 | | 2026-07-09 07:04:58.700043+00 | | 2026-07-10 00:26:35.179301+00 |