| 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 | 34885 | 0 | 0.00 | 0.00 | | 2026-07-01 16:01:24.143588+00 | | 2026-07-01 16:01:24.2294+00 |
| e202607 | a_stay_time | 8325 | 0 | 0.00 | 0.00 | | 2026-07-01 16:00:24.127832+00 | | 2026-07-01 16:00:24.151021+00 |
| e202607 | t_position_history | 3732030 | 32 | 0.00 | 0.00 | | 2026-07-01 21:25:37.979299+00 | | 2026-07-01 23:41:37.785684+00 |
| e202607 | t_presence_history | 465690 | 70413 | 0.00 | 13.00 | | 2026-07-02 00:38:39.004443+00 | | 2026-07-02 00:51:37.648906+00 |
| e202607 | t_sensor_history | 119225 | 0 | 0.00 | 0.00 | | 2026-07-01 23:52:37.16641+00 | | 2026-07-01 22:42:44.995167+00 |
| public | __digdag_status | 6 | 14 | 2.00 | 70.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 | 86336 | 9659 | 0.00 | 10.00 | | 2026-06-02 11:02:11.383565+00 | | 2026-07-01 04:02:46.784558+00 |
| public | l_pot_category | 110 | 1 | 0.00 | 0.00 | | 2026-05-24 09:41:22.054191+00 | | 2026-03-07 03:51:46.218867+00 |
| public | l_pot_group | 12645 | 61 | 0.00 | 0.00 | | 2026-05-15 21:16:21.468122+00 | | 2025-12-20 12:48:14.655001+00 |
| public | l_pot_tx | 4743 | 88 | 0.00 | 1.00 | | 2026-05-15 18:53:00.172611+00 | | 2026-03-31 02:56:00.228926+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 | 6591 | 184 | 0.00 | 2.00 | | 2026-04-24 03:32:49.938807+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 | 3391 | 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 | 800 | 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 | 2122 | 59 | 0.00 | 2.00 | | 2026-06-22 00:21:35.861168+00 | | 2026-07-01 07:24:37.047041+00 |
| public | m_pot | 36171 | 73 | 0.00 | 0.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 | 49 | 1 | 0.00 | 2.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 | 17 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.03827+00 | | |
| public | m_setting | 493 | 72 | 0.00 | 12.00 | | 2026-06-30 01:23:49.066655+00 | | 2026-06-30 04:18:50.652883+00 |
| public | m_setting_log | 2175 | 394 | 0.00 | 15.00 | | 2026-06-20 12:32:44.26639+00 | | 2026-06-28 12:32:39.209368+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 | 6328 | 0 | 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 | 529 | 67 | 0.00 | 11.00 | | 2026-05-07 10:27:35.79812+00 | | 2026-06-30 09:41:10.553189+00 |
| public | r_pot_category | 109 | 1 | 0.00 | 0.00 | | 2026-05-24 09:41:22.054956+00 | | 2026-03-07 03:51:46.220877+00 |
| public | r_pot_group | 6020 | 56 | 0.00 | 0.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 | 2530 | 87 | 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 | 29 | 0 | 0.00 | 0.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 | 30555 | 491 | 0.00 | 1.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 | 5164 | 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 | 8573 | 28 | 0.00 | 0.00 | | 2026-06-27 19:13:08.877679+00 | | 2026-05-28 06:16:14.467357+00 |
| public | t_operation_log | 157150 | 1 | 0.00 | 0.00 | | 2026-06-29 07:05:14.505689+00 | | 2026-05-19 00:19:10.365836+00 |
| public | t_plan | 3199097 | 6632 | 0.00 | 0.00 | | 2026-07-02 00:53:58.051593+00 | | 2026-07-01 10:27:35.779547+00 |
| public | t_plan_cancel_history | 8945 | 0 | 0.00 | 0.00 | | 2026-06-22 01:52:28.132826+00 | | 2026-05-14 01:16:20.064589+00 |
| public | t_plan_detail | 7910429 | 729610 | 0.00 | 8.00 | | 2026-07-01 23:58:44.208967+00 | | 2026-07-02 00:06:37.271267+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 | 34989 | 4946 | 0.00 | 12.00 | | 2026-07-01 22:01:35.89557+00 | | 2026-07-01 23:29:28.237535+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_proximity | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.123422+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 | 10 | 43 | 4.00 | 81.00 | | 2026-07-02 00:05:36.915285+00 | | 2026-07-02 00:15:37.065849+00 |
| public | t_terminal_log | 33168 | 0 | 0.00 | 0.00 | | 2026-06-28 05:13:05.258124+00 | | 2026-06-30 18:28:06.628051+00 |
| public | w_arrival_notify | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.110007+00 | | |
| public | w_latest_mobile_device | 779 | 13 | 0.00 | 1.00 | | 2026-05-15 01:16:01.581937+00 | | 2026-06-09 22:05:41.349181+00 |
| public | w_latest_mobile_status | 732 | 23 | 0.00 | 3.00 | | 2026-06-30 09:23:01.926884+00 | | 2026-07-01 08:25:37.623757+00 |
| public | w_latest_position | 3959 | 1745 | 0.00 | 30.00 | | 2026-07-02 00:54:37.218411+00 | | 2026-07-02 00:54:37.241855+00 |
| public | w_latest_presence | 28870 | 10083 | 0.00 | 25.00 | | 2026-07-02 00:54:37.112021+00 | | 2026-07-02 00:54:37.191438+00 |
| public | w_latest_sensor | 1639 | 38 | 0.00 | 2.00 | | 2026-07-02 00:54:37.024865+00 | | 2026-07-02 00:54:37.035261+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 | 22 | 3.00 | 78.00 | | 2026-06-30 09:44:10.751086+00 | | 2026-07-01 01:50:43.936992+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 | 3069946 | 290486 | 0.00 | 8.00 | | 2026-07-01 08:11:35.853552+00 | | 2026-07-01 23:24:32.230566+00 |