| 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 |
|---|
| e202601 | a_proximity_sum | 404604 | 0 | 0.00 | 0.00 | | 2026-02-27 01:14:14.473696+00 | | 2026-01-30 16:01:28.832658+00 |
| e202601 | a_stay_time | 39834 | 0 | 0.00 | 0.00 | | 2026-02-27 01:14:14.632377+00 | | 2026-01-29 16:00:46.96603+00 |
| e202601 | t_position_history | 58075328 | 0 | 0.00 | 0.00 | | 2026-02-26 14:06:54.026282+00 | | 2026-01-29 15:26:50.033927+00 |
| e202601 | t_presence_history | 6463226 | 0 | 0.00 | 0.00 | | 2026-02-24 07:57:26.099339+00 | | 2026-01-31 14:52:46.63529+00 |
| e202601 | t_sensor_history | 2918156 | 0 | 0.00 | 0.00 | | 2026-02-26 14:05:35.404351+00 | | 2026-01-29 02:08:53.713488+00 |
| e202602 | a_proximity_sum | 648832 | 0 | 0.00 | 0.00 | | 2026-03-25 14:35:22.968107+00 | | 2026-02-27 16:00:51.305601+00 |
| e202602 | a_stay_time | 146809 | 0 | 0.00 | 0.00 | | 2026-03-25 14:34:50.813068+00 | | 2026-02-26 16:00:26.662+00 |
| e202602 | t_position_history | 55824485 | 0 | 0.00 | 0.00 | | 2026-03-25 05:48:55.448021+00 | | 2026-02-28 14:53:45.644772+00 |
| e202602 | t_presence_history | 6288534 | 401584 | 0.00 | 6.00 | | 2026-02-27 08:36:17.373877+00 | | 2026-02-28 14:51:43.600646+00 |
| e202602 | t_sensor_history | 2653523 | 0 | 0.00 | 0.00 | | 2026-03-25 05:47:04.908462+00 | | 2026-02-28 08:50:19.509107+00 |
| e202603 | a_proximity_sum | 690685 | 0 | 0.00 | 0.00 | | 2026-03-24 16:02:21.731739+00 | | 2026-03-26 16:01:03.899439+00 |
| e202603 | a_stay_time | 173735 | 0 | 0.00 | 0.00 | | 2026-03-24 16:01:20.834487+00 | | 2026-03-26 16:01:03.655805+00 |
| e202603 | t_position_history | 67595242 | 0 | 0.00 | 0.00 | | 2026-03-27 21:33:38.361384+00 | | 2026-03-26 23:29:05.006447+00 |
| e202603 | t_presence_history | 6544596 | 360161 | 0.00 | 5.00 | | 2026-03-27 08:19:34.788154+00 | | 2026-03-28 00:23:11.721824+00 |
| e202603 | t_sensor_history | 2566001 | 0 | 0.00 | 0.00 | | 2026-03-27 08:48:09.451529+00 | | 2026-03-25 08:46:00.252239+00 |
| public | __digdag_status | 6 | 34 | 5.00 | 85.00 | | 2026-03-09 12:32:45.92338+00 | | 2026-03-15 12:32:34.209567+00 |
| public | a_attendance_sum | 1150 | 179 | 0.00 | 13.00 | | 2026-02-17 05:53:02.374909+00 | | 2026-02-24 07:18:51.547612+00 |
| public | a_plan_actual | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.991342+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.98963+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.989792+00 | | |
| public | area_history | 248 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.24764+00 | | 2025-12-20 12:48:14.707882+00 |
| public | l_area | 120 | 2 | 0.00 | 1.00 | | 2026-02-17 05:53:02.244733+00 | | 2025-12-20 12:48:14.70532+00 |
| public | l_auth | 57 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.454585+00 | | 2025-12-20 12:48:14.701558+00 |
| public | l_category | 77 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.469664+00 | | 2026-01-27 06:02:59.041017+00 |
| public | l_group | 206 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.227194+00 | | 2025-12-20 12:48:14.671637+00 |
| public | l_lob | 86 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.31453+00 | | 2025-12-20 12:46:11.114707+00 |
| public | l_location | 5643 | 402 | 0.00 | 6.00 | | 2026-03-05 00:35:01.476442+00 | | 2026-03-05 05:25:04.688354+00 |
| public | l_location_zone | 3806 | 0 | 0.00 | 0.00 | | 2026-03-26 02:29:05.910046+00 | | 2026-03-05 01:00:01.594849+00 |
| public | l_outside | 2 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.978714+00 | | |
| public | l_pot | 66218 | 335 | 0.00 | 0.00 | | 2026-02-26 04:02:16.920895+00 | | 2025-12-20 12:51:08.665856+00 |
| public | l_pot_category | 106 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.981936+00 | | 2026-03-07 03:51:46.218867+00 |
| public | l_pot_group | 12518 | 30 | 0.00 | 0.00 | | 2026-02-17 05:53:02.212455+00 | | 2025-12-20 12:48:14.655001+00 |
| public | l_pot_tx | 4458 | 18 | 0.00 | 0.00 | | 2026-02-17 05:53:01.357671+00 | | 2025-12-20 12:48:13.461924+00 |
| public | l_role | 16 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.291424+00 | | |
| public | l_role_feature | 414 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.281361+00 | | 2025-12-20 12:48:14.736886+00 |
| public | l_site | 7 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.299102+00 | | |
| public | l_tx | 6480 | 0 | 0.00 | 0.00 | | 2026-03-22 11:56:22.999462+00 | | 2026-03-09 02:56:51.205117+00 |
| public | l_user | 111 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.220341+00 | | 2025-12-20 12:48:14.661693+00 |
| public | l_zone | 263 | 3 | 0.00 | 1.00 | | 2026-02-06 08:33:07.411166+00 | | 2026-02-06 08:33:07.418396+00 |
| public | l_zone_category | 157 | 2 | 0.00 | 1.00 | | 2026-02-17 05:53:02.254081+00 | | 2026-02-06 02:34:03.992045+00 |
| public | m_area | 106 | 2 | 0.00 | 1.00 | | 2026-02-17 05:53:02.240146+00 | | 2025-12-20 12:48:14.699133+00 |
| public | m_auth | 57 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:03.084481+00 | | 2025-12-20 12:49:11.870148+00 |
| public | m_category | 219 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:03.141744+00 | | 2025-12-20 12:49:11.912928+00 |
| public | m_env | 7 | 1 | 0.00 | 12.00 | | 2026-02-17 05:53:03.08785+00 | | |
| public | m_exb | 1421 | 62 | 0.00 | 4.00 | | 2026-02-17 05:53:03.133266+00 | | 2026-02-09 00:33:58.911481+00 |
| public | m_favorite | 781 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:03.008829+00 | | 2025-12-20 12:49:11.854007+00 |
| public | m_favorite_group | 3267 | 6 | 0.00 | 0.00 | | 2026-02-17 05:53:02.346619+00 | | 2025-12-20 12:48:12.961797+00 |
| public | m_feature | 173 | 1 | 0.00 | 0.00 | | 2026-02-17 05:53:03.012936+00 | | 2025-12-20 12:49:11.860448+00 |
| public | m_group | 240 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.033297+00 | | 2025-12-20 12:48:14.012956+00 |
| public | m_holiday | 243 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.457655+00 | | 2025-12-20 12:48:14.711222+00 |
| public | m_lob | 788 | 0 | 0.00 | 0.00 | | 2026-02-17 05:52:49.887142+00 | | 2025-12-20 12:46:21.252941+00 |
| public | m_lob_log | 59 | 0 | 0.00 | 0.00 | | 2026-02-17 05:52:49.888073+00 | | 2025-12-20 12:49:10.380453+00 |
| public | m_location | 2905 | 446 | 0.00 | 13.00 | | 2026-02-17 06:53:15.021586+00 | | 2026-03-05 03:13:23.587884+00 |
| public | m_notify_template | 73 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.447151+00 | | 2025-12-20 12:48:14.695514+00 |
| public | m_outside | 7 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.307786+00 | | |
| public | m_personal_setting | 2119 | 6 | 0.00 | 0.00 | | 2026-03-27 16:01:56.322337+00 | | 2026-03-27 08:50:06.222015+00 |
| public | m_pot | 34146 | 416 | 0.00 | 1.00 | | 2026-02-26 04:02:15.893763+00 | | 2026-02-26 04:02:16.531902+00 |
| public | m_pot_profile | 24 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.461026+00 | | |
| public | m_provider_user | 44 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.301858+00 | | |
| public | m_region | 13 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.310312+00 | | |
| public | m_role | 35 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.270791+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.974164+00 | | |
| public | m_setting | 496 | 78 | 0.00 | 13.00 | | 2026-03-25 20:46:33.188186+00 | | 2026-03-27 06:18:04.775206+00 |
| public | m_setting_log | 2144 | 464 | 0.00 | 17.00 | | 2026-03-14 12:32:20.322288+00 | | 2026-03-24 12:32:18.742314+00 |
| public | m_site | 23 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.263138+00 | | |
| public | m_tenant | 6 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.475429+00 | | |
| public | m_tx | 6217 | 0 | 0.00 | 0.00 | | 2026-03-09 02:57:51.334486+00 | | 2026-03-09 02:57:51.357677+00 |
| public | m_user | 119 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.042792+00 | | 2025-12-20 12:48:14.026248+00 |
| public | m_zone | 260 | 4 | 0.00 | 1.00 | | 2026-02-06 08:33:07.399154+00 | | 2026-02-06 08:33:07.407408+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.984943+00 | | |
| public | r_auth_zone | 9 | 0 | 0.00 | 0.00 | | 2026-02-06 08:33:07.421163+00 | | 2026-02-06 08:32:07.413614+00 |
| public | r_exb_sensor | 99 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.472526+00 | | 2025-12-20 12:48:14.727672+00 |
| public | r_group_auth | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.984818+00 | | |
| public | r_location_zone | 1102 | 8 | 0.00 | 0.00 | | 2026-03-05 01:03:01.675017+00 | | 2026-03-05 01:03:01.681954+00 |
| public | r_pot_auth | 508 | 6 | 0.00 | 1.00 | | 2026-02-06 08:33:07.395862+00 | | 2026-02-06 08:32:07.408063+00 |
| public | r_pot_category | 106 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.984628+00 | | 2026-03-07 03:51:46.220877+00 |
| public | r_pot_group | 6026 | 30 | 0.00 | 0.00 | | 2026-02-17 05:53:01.405423+00 | | 2025-12-20 12:48:13.514096+00 |
| public | r_pot_plan_permission_group | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.993009+00 | | |
| public | r_pot_tx | 2402 | 18 | 0.00 | 0.00 | | 2026-02-17 05:53:02.027281+00 | | 2026-01-26 00:57:05.764749+00 |
| public | r_pot_user | 25 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.287171+00 | | |
| public | r_provider_tenant | 22 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.304208+00 | | |
| public | r_role_feature | 426 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.233989+00 | | 2025-12-20 12:48:14.68726+00 |
| public | r_tenant_feature | 98 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.973722+00 | | 2025-12-20 12:48:14.730432+00 |
| public | r_tx_sensor | 139 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.256889+00 | | 2025-12-20 12:48:14.72485+00 |
| public | r_user_region | 56 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.259571+00 | | 2026-02-05 08:47:29.324871+00 |
| public | r_user_site | 40 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.284257+00 | | |
| public | r_zone_category | 106 | 1 | 0.00 | 0.00 | | 2026-02-17 05:53:02.267905+00 | | 2026-02-06 02:34:03.994728+00 |
| public | t_ai_history | 70 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.402197+00 | | 2025-12-20 12:48:14.71656+00 |
| public | t_attendance | 28554 | 204 | 0.00 | 0.00 | | 2026-03-23 04:22:21.693938+00 | | 2026-03-27 00:05:01.757064+00 |
| public | t_general | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.989432+00 | | |
| public | t_job | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.993703+00 | | |
| public | t_mobile_device_history | 4847 | 0 | 0.00 | 0.00 | | 2026-03-26 20:13:39.188582+00 | | 2026-02-27 05:59:24.898605+00 |
| public | t_mobile_status_history | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.991725+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.985035+00 | | |
| public | t_notify_history | 7685 | 239 | 0.00 | 3.00 | | 2026-02-17 05:53:02.970815+00 | | 2026-03-10 03:46:13.747151+00 |
| public | t_operation_log | 132349 | 0 | 0.00 | 0.00 | | 2026-03-11 23:33:36.613651+00 | | 2026-02-24 05:42:51.180147+00 |
| public | t_plan | 6277818 | 35410 | 0.00 | 0.00 | | 2026-03-27 09:31:30.509089+00 | | 2026-03-27 06:18:10.160676+00 |
| public | t_plan_cancel_history | 7319 | 0 | 0.00 | 0.00 | | 2026-03-27 08:09:35.65422+00 | | 2026-03-19 06:26:02.98842+00 |
| public | t_plan_detail | 13550847 | 2240305 | 0.00 | 14.00 | | 2026-03-19 00:14:55.289189+00 | | 2026-03-27 09:12:06.492115+00 |
| public | t_plan_permission | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.991834+00 | | |
| public | t_plan_permission_group | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.9929+00 | | |
| public | t_plan_sync | 31456 | 43 | 0.00 | 0.00 | | 2026-03-27 23:28:10.979002+00 | | 2026-03-27 23:20:10.692569+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:03.051179+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:03.04802+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:03.046608+00 | | |
| public | t_recv_position_history | 10033 | 329 | 0.00 | 3.00 | | 2026-02-24 07:34:51.494936+00 | | 2026-02-24 07:38:51.563217+00 |
| public | t_safr_event_history | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:03.033734+00 | | |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:03.045976+00 | | |
| public | t_terminal | 54 | 38 | 0.00 | 41.00 | | 2026-03-21 10:14:30.305671+00 | | 2026-03-28 00:40:11.283892+00 |
| public | w_arrival_notify | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:03.030631+00 | | |
| public | w_latest_mobile_device | 775 | 27 | 0.00 | 3.00 | | 2026-02-17 05:53:03.077549+00 | | 2026-03-12 08:06:41.163367+00 |
| public | w_latest_mobile_status | 727 | 3 | 0.00 | 0.00 | | 2026-03-27 16:01:56.335539+00 | | 2026-03-27 10:01:03.029047+00 |
| public | w_latest_position | 3921 | 1150 | 0.00 | 22.00 | | 2026-03-28 00:55:11.391923+00 | | 2026-03-28 00:55:11.415565+00 |
| public | w_latest_presence | 26128 | 4267 | 0.00 | 14.00 | | 2026-03-28 00:54:11.349244+00 | | 2026-03-28 00:55:11.375509+00 |
| public | w_latest_sensor | 1639 | 291 | 0.00 | 15.00 | | 2026-03-28 00:47:11.251572+00 | | 2026-03-28 00:54:11.30374+00 |
| public | w_lock | 222 | 0 | 0.00 | 0.00 | | 2026-03-09 07:00:13.14937+00 | | 2025-12-20 12:48:14.740544+00 |
| public | w_master_update | 6 | 0 | 0.00 | 0.00 | | 2026-03-27 22:01:50.013147+00 | | 2026-03-25 04:02:28.374002+00 |
| public | w_migration | 29 | 0 | 0.00 | 0.00 | | 2026-02-17 05:53:02.294079+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2026-02-17 05:53:02.990449+00 | | |
| public | w_plan_with_detail | 6272973 | 151309 | 0.00 | 2.00 | | 2026-03-27 07:20:57.905157+00 | | 2026-03-27 04:57:06.226112+00 |