| 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 |
|---|
| e202604 | a_proximity_sum | 804891 | 0 | 0.00 | 0.00 | | 2026-05-20 00:07:06.244436+00 | | 2026-04-30 16:00:52.685835+00 |
| e202604 | a_stay_time | 180219 | 0 | 0.00 | 0.00 | | 2026-05-20 00:07:02.855112+00 | | 2026-04-28 16:01:26.557116+00 |
| e202604 | t_position_history | 87414827 | 0 | 0.00 | 0.00 | | 2026-05-18 07:46:54.587311+00 | | 2026-04-29 18:37:04.210671+00 |
| e202604 | t_presence_history | 7220711 | 0 | 0.00 | 0.00 | | 2026-06-03 12:12:00.889561+00 | | 2026-04-30 12:37:51.031864+00 |
| e202604 | t_sensor_history | 2596543 | 0 | 0.00 | 0.00 | | 2026-05-18 07:44:51.566375+00 | | 2026-04-29 15:03:02.602269+00 |
| 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 | 77472522 | 1 | 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 | 518234 | 0 | 0.00 | 0.00 | | 2026-06-22 16:01:51.990918+00 | | 2026-06-24 16:00:58.978435+00 |
| e202606 | a_stay_time | 134523 | 0 | 0.00 | 0.00 | | 2026-06-22 16:00:51.732893+00 | | 2026-06-23 16:00:55.365551+00 |
| e202606 | t_position_history | 63257659 | 81 | 0.00 | 0.00 | | 2026-06-24 07:44:28.032412+00 | | 2026-06-23 12:27:14.857383+00 |
| e202606 | t_presence_history | 6884725 | 422805 | 0.00 | 5.00 | | 2026-06-25 00:04:46.119564+00 | | 2026-06-25 00:42:55.422972+00 |
| e202606 | t_sensor_history | 2063771 | 0 | 0.00 | 0.00 | | 2026-06-24 16:06:00.513431+00 | | 2026-06-23 23:39:51.762674+00 |
| public | __digdag_status | 6 | 0 | 0.00 | 0.00 | | 2026-06-24 12:32:57.202314+00 | | 2026-06-10 12:32:49.485397+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 | 3815 | 16 | 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 | 79301 | 2648 | 0.00 | 3.00 | | 2026-06-02 11:02:11.383565+00 | | 2026-06-22 04:03:48.396897+00 |
| public | l_pot_category | 108 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.054191+00 | | 2026-03-07 03:51:46.218867+00 |
| public | l_pot_group | 12620 | 42 | 0.00 | 0.00 | | 2026-05-15 21:16:21.468122+00 | | 2025-12-20 12:48:14.655001+00 |
| public | l_pot_tx | 4705 | 64 | 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 | 6584 | 148 | 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 | 263 | 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 | 157 | 0 | 0.00 | 0.00 | | 2026-05-18 07:46:01.950353+00 | | 2026-02-06 02:34:03.992045+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 | 777 | 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 | 3385 | 14 | 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 | 799 | 2 | 0.00 | 0.00 | | 2026-05-24 09:41:21.753982+00 | | 2025-12-20 12:46:21.252941+00 |
| public | m_lob_log | 64 | 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 | 40 | 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 | 45 | 0.00 | 2.00 | | 2026-06-22 00:21:35.861168+00 | | 2026-06-24 02:59:52.78617+00 |
| public | m_pot | 36078 | 2477 | 0.00 | 6.00 | | 2026-05-14 00:57:10.653627+00 | | 2026-06-22 04:03:47.02519+00 |
| public | m_pot_profile | 26 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.029763+00 | | |
| public | m_provider_user | 49 | 0 | 0.00 | 0.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 | 113 | 0.00 | 18.00 | | 2026-06-21 22:42:09.229432+00 | | 2026-06-24 16:19:58.889784+00 |
| public | m_setting_log | 2168 | 144 | 0.00 | 6.00 | | 2026-06-20 12:32:44.26639+00 | | 2026-06-24 12:32:57.199834+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 | 6321 | 0 | 0.00 | 0.00 | | 2026-06-24 09:20:55.903164+00 | | 2026-06-24 09:19:55.884313+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 | 260 | 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 | 1102 | 6 | 0.00 | 0.00 | | 2026-06-23 06:19:33.155984+00 | | 2026-03-05 01:03:01.681954+00 |
| public | r_pot_auth | 522 | 53 | 0.00 | 9.00 | | 2026-05-07 10:27:35.79812+00 | | 2026-06-02 09:35:26.651593+00 |
| public | r_pot_category | 108 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.054956+00 | | 2026-03-07 03:51:46.220877+00 |
| public | r_pot_group | 6011 | 40 | 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 | 2516 | 63 | 0.00 | 2.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 | 106 | 0 | 0.00 | 0.00 | | 2026-05-18 07:46:01.951132+00 | | 2026-02-06 02:34:03.994728+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 | 30395 | 328 | 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 | 5096 | 0 | 0.00 | 0.00 | | 2026-04-28 00:48:48.388724+00 | | 2026-02-27 05:59:24.898605+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 | 8457 | 76 | 0.00 | 0.00 | | 2026-04-30 08:38:48.259083+00 | | 2026-05-28 06:16:14.467357+00 |
| public | t_operation_log | 156393 | 0 | 0.00 | 0.00 | | 2026-06-17 09:11:37.477911+00 | | 2026-05-19 00:19:10.365836+00 |
| public | t_plan | 2991769 | 388961 | 0.00 | 11.00 | | 2026-06-24 01:37:13.36488+00 | | 2026-06-24 08:09:00.085452+00 |
| public | t_plan_cancel_history | 8810 | 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 | 7574152 | 996243 | 0.00 | 11.00 | | 2026-06-24 08:00:13.411382+00 | | 2026-06-24 23:50:56.327663+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 | 34873 | 5776 | 0.00 | 14.00 | | 2026-06-24 14:01:58.01602+00 | | 2026-06-24 23:27:54.56014+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 | 30 | 3.00 | 75.00 | | 2026-06-25 00:25:54.739825+00 | | 2026-06-25 00:47:55.10242+00 |
| public | t_terminal_log | 22275 | 0 | 0.00 | 0.00 | | 2026-06-24 03:38:53.216493+00 | | 2026-06-23 19:47:57.853397+00 |
| public | w_arrival_notify | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.110007+00 | | |
| public | w_latest_mobile_device | 778 | 11 | 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 | 731 | 71 | 0.00 | 8.00 | | 2026-04-30 03:47:25.613365+00 | | 2026-06-24 05:03:53.940845+00 |
| public | w_latest_position | 3959 | 1147 | 0.00 | 22.00 | | 2026-06-25 00:54:54.85945+00 | | 2026-06-25 00:54:54.883528+00 |
| public | w_latest_presence | 28743 | 9392 | 0.00 | 24.00 | | 2026-06-25 00:54:54.758974+00 | | 2026-06-25 00:54:54.838539+00 |
| public | w_latest_sensor | 1639 | 357 | 0.00 | 17.00 | | 2026-06-25 00:48:54.656021+00 | | 2026-06-25 00:52:54.683777+00 |
| public | w_lock | 240 | 7 | 0.00 | 2.00 | | 2026-04-21 07:26:31.480425+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-06-23 14:02:11.933793+00 | | 2026-06-24 06:05:54.550544+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 | 2979396 | 456678 | 0.00 | 13.00 | | 2026-06-24 00:13:07.936734+00 | | 2026-06-24 08:35:01.574007+00 |