| 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 |
|---|
| e202603 | a_proximity_sum | 779029 | 0 | 0.00 | 0.00 | | 2026-04-14 16:13:23.620045+00 | | 2026-03-30 16:01:15.628979+00 |
| e202603 | a_stay_time | 194118 | 0 | 0.00 | 0.00 | | 2026-04-14 16:12:49.675329+00 | | 2026-03-30 16:01:14.40279+00 |
| e202603 | t_position_history | 81395631 | 1 | 0.00 | 0.00 | | 2026-04-14 00:15:35.517704+00 | | 2026-03-30 19:06:29.421208+00 |
| e202603 | t_presence_history | 7232233 | 0 | 0.00 | 0.00 | | 2026-04-14 00:22:33.5663+00 | | 2026-03-31 13:45:29.247853+00 |
| e202603 | t_sensor_history | 2892460 | 0 | 0.00 | 0.00 | | 2026-04-14 00:13:25.307528+00 | | 2026-03-31 02:58:03.790497+00 |
| 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 | 7255846 | 534623 | 0.00 | 6.00 | | 2026-04-30 00:40:09.258956+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 | 464895 | 0 | 0.00 | 0.00 | | 2026-05-26 16:02:10.552953+00 | | 2026-05-25 16:01:38.396274+00 |
| e202605 | a_stay_time | 114391 | 0 | 0.00 | 0.00 | | 2026-05-26 16:01:10.272795+00 | | 2026-05-25 16:00:38.363438+00 |
| e202605 | t_position_history | 66076560 | 13928 | 0.00 | 0.00 | | 2026-05-25 14:06:17.841264+00 | | 2026-05-24 18:25:40.134763+00 |
| e202605 | t_presence_history | 5169937 | 319787 | 0.00 | 5.00 | | 2026-05-27 00:10:45.458965+00 | | 2026-05-27 00:52:08.740105+00 |
| e202605 | t_sensor_history | 2254028 | 0 | 0.00 | 0.00 | | 2026-05-25 04:25:54.873485+00 | | 2026-05-25 10:37:59.372896+00 |
| public | __digdag_status | 7 | 49 | 7.00 | 87.00 | | 2026-05-01 12:32:22.940384+00 | | 2026-05-24 12:32:13.566387+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 | 5644 | 0 | 0.00 | 0.00 | | 2026-04-17 18:29:54.217963+00 | | 2026-03-05 05:25:04.688354+00 |
| public | l_location_zone | 3806 | 0 | 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 | 75571 | 330 | 0.00 | 0.00 | | 2026-05-07 08:18:06.058959+00 | | 2026-04-20 11:03:01.008875+00 |
| public | l_pot_category | 107 | 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 | 12605 | 6 | 0.00 | 0.00 | | 2026-05-15 21:16:21.468122+00 | | 2025-12-20 12:48:14.655001+00 |
| public | l_pot_tx | 4618 | 5 | 0.00 | 0.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 | 6519 | 1 | 0.00 | 0.00 | | 2026-04-24 03:32:49.938807+00 | | 2026-03-09 02:56:51.205117+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 | 779 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.09419+00 | | 2025-12-20 12:49:11.854007+00 |
| public | m_favorite_group | 3363 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.014467+00 | | 2025-12-20 12:48:12.961797+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 | 801 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.753982+00 | | 2025-12-20 12:46:21.252941+00 |
| public | m_lob_log | 62 | 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 | 0 | 0.00 | 0.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 | 2128 | 90 | 0.00 | 4.00 | | 2026-04-29 14:39:48.784273+00 | | 2026-05-26 23:08:07.152964+00 |
| public | m_pot | 35755 | 156 | 0.00 | 0.00 | | 2026-05-14 00:57:10.653627+00 | | 2026-05-21 11:02:12.740406+00 |
| public | m_pot_profile | 26 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:22.029763+00 | | |
| public | m_provider_user | 47 | 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 | 495 | 118 | 0.00 | 19.00 | | 2026-05-23 22:23:56.632876+00 | | 2026-05-25 07:36:54.470682+00 |
| public | m_setting_log | 2161 | 108 | 0.00 | 4.00 | | 2026-05-23 12:32:15.239287+00 | | 2026-05-23 12:32:15.257355+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 | 6296 | 1 | 0.00 | 0.00 | | 2026-04-17 05:11:56.820814+00 | | 2026-04-17 05:11:56.846795+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 | 0 | 0.00 | 0.00 | | 2026-04-17 20:25:05.235721+00 | | 2026-03-05 01:03:01.681954+00 |
| public | r_pot_auth | 516 | 0 | 0.00 | 0.00 | | 2026-05-07 10:27:35.79812+00 | | 2026-02-06 08:32:07.408063+00 |
| public | r_pot_category | 107 | 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 | 6030 | 6 | 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 | 2488 | 4 | 0.00 | 0.00 | | 2026-05-17 12:31:50.913075+00 | | 2026-04-02 06:30:18.740519+00 |
| public | r_pot_user | 25 | 0 | 0.00 | 0.00 | | 2026-05-24 09:41:21.890892+00 | | |
| public | r_provider_tenant | 22 | 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 | 29787 | 679 | 0.00 | 2.00 | | 2026-04-23 02:28:54.531218+00 | | 2026-03-27 00:05:01.757064+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 | 5025 | 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 | 8257 | 60 | 0.00 | 0.00 | | 2026-04-30 08:38:48.259083+00 | | 2026-04-08 00:15:58.169975+00 |
| public | t_operation_log | 152600 | 1 | 0.00 | 0.00 | | 2026-05-22 00:52:17.046446+00 | | 2026-05-19 00:19:10.365836+00 |
| public | t_plan | 2987669 | 46713 | 0.00 | 1.00 | | 2026-05-27 00:22:25.5186+00 | | 2026-05-27 00:16:13.500127+00 |
| public | t_plan_cancel_history | 8338 | 1 | 0.00 | 0.00 | | 2026-04-29 12:23:47.825452+00 | | 2026-05-14 01:16:20.064589+00 |
| public | t_plan_detail | 7463050 | 894479 | 0.00 | 10.00 | | 2026-05-26 09:04:38.828599+00 | | 2026-05-26 23:52:09.406803+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 | 34057 | 5653 | 0.00 | 14.00 | | 2026-05-26 14:02:09.486323+00 | | 2026-05-26 23:29:07.650307+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-04-09 08:10:55.819436+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 | 54 | 27 | 0.00 | 33.00 | | 2026-04-28 17:53:27.273844+00 | | 2026-05-27 00:31:07.974322+00 |
| public | w_arrival_notify | 0 | 0 | 0 | 0 | | 2026-05-24 09:41:22.110007+00 | | |
| public | w_latest_mobile_device | 777 | 10 | 0.00 | 1.00 | | 2026-05-15 01:16:01.581937+00 | | 2026-04-27 06:17:37.363978+00 |
| public | w_latest_mobile_status | 730 | 59 | 0.00 | 7.00 | | 2026-04-30 03:47:25.613365+00 | | 2026-05-26 10:45:08.285331+00 |
| public | w_latest_position | 3924 | 693 | 0.00 | 15.00 | | 2026-05-27 00:55:08.069126+00 | | 2026-05-27 00:55:08.093023+00 |
| public | w_latest_presence | 27791 | 273 | 0.00 | 0.00 | | 2026-05-27 00:55:07.971729+00 | | 2026-05-27 00:55:08.04833+00 |
| public | w_latest_sensor | 1639 | 57 | 0.00 | 3.00 | | 2026-05-27 00:54:07.900992+00 | | 2026-05-27 00:55:07.913686+00 |
| public | w_lock | 223 | 0 | 0.00 | 0.00 | | 2026-04-21 07:26:31.480425+00 | | 2025-12-20 12:48:14.740544+00 |
| public | w_master_update | 6 | 51 | 8.00 | 89.00 | | 2026-05-20 07:17:35.427023+00 | | 2026-05-22 00:24:16.52498+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 | 2853477 | 558450 | 0.00 | 16.00 | | 2026-05-25 13:48:24.256161+00 | | 2026-05-27 00:19:13.022588+00 |