| 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 |
|---|
| e202505 | a_proximity_sum | 2887444 | 0 | 0.00 | 0.00 | | 2025-06-23 10:56:24.422947+00 | | 2025-05-30 15:37:38.689728+00 |
| e202505 | a_stay_time | 6541462 | 0 | 0.00 | 0.00 | | 2025-06-26 01:45:13.937859+00 | | 2025-05-29 15:31:32.693656+00 |
| e202505 | t_position_history | 43287006 | 0 | 0.00 | 0.00 | | 2025-06-25 23:14:02.710017+00 | | 2025-05-29 00:56:19.646506+00 |
| e202505 | t_presence_history | 5511015 | 0 | 0.00 | 0.00 | | 2025-06-25 03:27:53.683893+00 | | 2025-05-31 14:51:24.959193+00 |
| e202505 | t_sensor_history | 1268458 | 0 | 0.00 | 0.00 | | 2025-06-25 00:38:38.389568+00 | | 2025-05-31 13:57:48.979362+00 |
| e202506 | a_proximity_sum | 5361710 | 0 | 0.00 | 0.00 | | 2025-06-30 15:49:43.352767+00 | | 2025-06-30 15:49:46.791104+00 |
| e202506 | a_stay_time | 7133769 | 0 | 0.00 | 0.00 | | 2025-06-26 15:36:14.768192+00 | | 2025-06-30 16:35:10.610483+00 |
| e202506 | t_position_history | 46934136 | 1 | 0.00 | 0.00 | | 2025-06-30 05:08:36.224961+00 | | 2025-06-27 11:21:31.975104+00 |
| e202506 | t_presence_history | 6090109 | 71440 | 0.00 | 1.00 | | 2025-06-30 14:56:53.424354+00 | | 2025-06-30 14:40:02.424042+00 |
| e202506 | t_sensor_history | 1171519 | 0 | 0.00 | 0.00 | | 2025-06-25 21:31:21.145561+00 | | 2025-06-29 20:49:50.948942+00 |
| e202507 | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-06-28 11:50:33.406895+00 | | |
| e202507 | a_stay_time | 0 | 0 | 0 | 0 | | 2025-06-28 12:06:37.259839+00 | | |
| e202507 | t_position_history | 675157 | 0 | 0.00 | 0.00 | | 2025-07-01 01:29:30.368377+00 | | 2025-07-01 01:44:30.413693+00 |
| e202507 | t_presence_history | 60094 | 70168 | 1.00 | 53.00 | | 2025-07-01 01:45:29.743778+00 | | 2025-07-01 01:45:30.08796+00 |
| e202507 | t_sensor_history | 17825 | 0 | 0.00 | 0.00 | | 2025-07-01 01:22:29.850575+00 | | 2025-07-01 00:51:45.245848+00 |
| public | __digdag_status | 6 | 26 | 4.00 | 81.00 | | 2025-06-28 13:10:04.791477+00 | | 2025-06-30 21:20:02.787451+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2025-06-30 04:11:05.675605+00 | | |
| public | a_plan_actual | 86897 | 0 | 0.00 | 0.00 | | 2025-06-23 06:51:29.312903+00 | | 2025-06-24 17:10:23.917658+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-06-27 17:38:55.372744+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-06-27 17:37:59.739666+00 | | |
| public | area_history | 181 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:46.153283+00 | | |
| public | b_attendance_group | 761244 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:58.865471+00 | | |
| public | b_attendance_hour | 12153979 | 0 | 0.00 | 0.00 | | 2025-06-28 09:36:33.277578+00 | | |
| public | b_attendance_pot | 883141 | 0 | 0.00 | 0.00 | | 2025-06-25 00:37:38.697587+00 | | 2025-06-20 18:35:37.836021+00 |
| public | b_attendance_pot_hour | 13743351 | 0 | 0.00 | 0.00 | | 2025-06-24 01:54:54.319458+00 | | 2025-06-20 18:36:38.97666+00 |
| public | b_check_in | 5418552 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:36.39146+00 | | |
| public | b_check_in_hour | 84535328 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:34.848402+00 | | |
| public | b_check_in_pot | 350728 | 0 | 0.00 | 0.00 | | 2025-06-25 23:18:00.03563+00 | | 2025-06-22 17:03:11.361067+00 |
| public | b_check_in_pot_hour | 7683204 | 0 | 0.00 | 0.00 | | 2025-06-24 09:52:20.88214+00 | | 2025-06-21 18:32:35.58719+00 |
| public | b_proximity_group | 52711782 | 0 | 0.00 | 0.00 | | 2025-06-28 09:36:29.612323+00 | | |
| public | b_proximity_info | 85809139 | 0 | 0.00 | 0.00 | | 2025-06-25 04:44:11.201378+00 | | 2025-06-23 17:50:34.820059+00 |
| public | b_seat_reserve | 1474022 | 0 | 0.00 | 0.00 | | 2025-06-28 09:36:10.134324+00 | | |
| public | b_seat_reserve_hour | 28428971 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:58.688213+00 | | |
| public | b_usage | 1689957 | 0 | 0.00 | 0.00 | | 2025-06-27 17:38:55.304009+00 | | |
| public | b_usage_hour | 31596014 | 0 | 0.00 | 0.00 | | 2025-06-28 09:36:17.213005+00 | | |
| public | l_area | 191 | 0 | 0.00 | 0.00 | | 2025-06-25 00:42:39.403612+00 | | 2025-05-27 10:20:10.564892+00 |
| public | l_auth | 13 | 0 | 0.00 | 0.00 | | 2025-06-25 00:42:39.342473+00 | | |
| public | l_category | 487 | 0 | 0.00 | 0.00 | | 2025-06-25 00:43:39.518095+00 | | 2025-05-27 10:20:10.789895+00 |
| public | l_group | 3197 | 34 | 0.00 | 1.00 | | 2025-06-25 00:43:39.933712+00 | | 2025-05-27 10:20:11.032762+00 |
| public | l_location | 7720 | 18 | 0.00 | 0.00 | | 2025-06-25 00:43:39.436817+00 | | 2025-05-27 10:23:10.473563+00 |
| public | l_location_zone | 5133 | 16 | 0.00 | 0.00 | | 2025-06-25 00:43:39.241698+00 | | 2025-05-27 10:21:10.104411+00 |
| public | l_outside | 92 | 0 | 0.00 | 0.00 | | 2025-06-25 00:42:39.376341+00 | | 2025-05-27 10:24:10.187977+00 |
| public | l_pot | 72354 | 98 | 0.00 | 0.00 | | 2025-06-25 00:43:40.626645+00 | | 2025-05-27 10:20:11.875509+00 |
| public | l_pot_category | 1116 | 0 | 0.00 | 0.00 | | 2025-06-25 00:43:39.503362+00 | | 2025-05-27 10:21:10.122155+00 |
| public | l_pot_group | 27497 | 48 | 0.00 | 0.00 | | 2025-06-25 00:43:39.836113+00 | | 2025-05-27 10:21:10.212154+00 |
| public | l_pot_tx | 12358 | 20 | 0.00 | 0.00 | | 2025-06-25 00:43:39.628445+00 | | 2025-05-27 10:20:10.837915+00 |
| public | l_role | 80 | 0 | 0.00 | 0.00 | | 2025-06-25 00:42:39.317457+00 | | 2025-05-27 10:20:10.547091+00 |
| public | l_role_feature | 676 | 0 | 0.00 | 0.00 | | 2025-06-25 00:42:39.283326+00 | | 2025-05-27 10:21:10.078282+00 |
| public | l_site | 35 | 0 | 0.00 | 0.00 | | 2025-06-25 00:43:39.145524+00 | | |
| public | l_tx | 18988 | 3448 | 0.00 | 15.00 | | 2025-06-28 12:26:03.586915+00 | | 2025-06-28 12:27:03.194639+00 |
| public | l_user | 3757 | 14 | 0.00 | 0.00 | | 2025-06-25 00:42:39.247857+00 | | 2025-05-27 10:20:10.53188+00 |
| public | l_zone | 1072 | 0 | 0.00 | 0.00 | | 2025-06-25 00:43:39.310853+00 | | 2025-05-27 10:20:10.594027+00 |
| public | l_zone_category | 779 | 0 | 0.00 | 0.00 | | 2025-06-25 00:42:39.188559+00 | | 2025-05-27 10:20:10.46805+00 |
| public | m_area | 90 | 1 | 0.00 | 1.00 | | 2025-06-28 09:38:46.117867+00 | | |
| public | m_auth | 10 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:35.583493+00 | | |
| public | m_category | 431 | 0 | 0.00 | 0.00 | | 2025-06-27 17:38:00.181354+00 | | |
| public | m_env | 0 | 0 | 0 | 0 | | 2025-06-29 01:32:40.27814+00 | | |
| public | m_exb | 2726 | 0 | 0.00 | 0.00 | | 2025-06-24 01:03:34.912524+00 | | |
| public | m_favorite | 39789 | 435 | 0.00 | 1.00 | | 2025-06-26 23:40:58.247232+00 | | 2025-06-25 04:29:36.792109+00 |
| public | m_favorite_group | 9064 | 18 | 0.00 | 0.00 | | 2025-06-30 02:34:35.604928+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:46.096994+00 | | |
| public | m_group | 2015 | 0 | 0.00 | 0.00 | | 2025-06-30 22:23:33.32651+00 | | 2025-05-27 09:50:51.924555+00 |
| public | m_holiday | 6703 | 0 | 0.00 | 0.00 | | 2025-06-27 17:38:03.676149+00 | | |
| public | m_lob | 1938 | 11 | 0.00 | 0.00 | | 2025-06-26 21:26:30.098531+00 | | 2025-05-20 10:00:55.820078+00 |
| public | m_lob_log | 656 | 0 | 0.00 | 0.00 | | 2025-06-23 06:51:28.955101+00 | | |
| public | m_location | 5170 | 17 | 0.00 | 0.00 | | 2025-06-27 02:20:48.770955+00 | | |
| public | m_notify_template | 165 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:59.815647+00 | | |
| public | m_outside | 69 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:59.785232+00 | | |
| public | m_personal_setting | 13834 | 2385 | 0.00 | 14.00 | | 2025-06-29 23:54:41.55088+00 | | 2025-07-01 01:19:29.848232+00 |
| public | m_pot | 27688 | 3175 | 0.00 | 10.00 | | 2025-07-01 00:10:04.128591+00 | | 2025-07-01 00:10:04.992166+00 |
| public | m_pot_profile | 4176 | 6 | 0.00 | 0.00 | | 2025-06-27 04:49:44.748667+00 | | 2025-06-24 00:20:07.495239+00 |
| public | m_provider_user | 64 | 2 | 0.00 | 3.00 | | 2025-06-27 17:37:59.72805+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:44.82718+00 | | |
| public | m_role | 82 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:44.758193+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:35.658377+00 | | |
| public | m_setting | 2438 | 298 | 0.00 | 10.00 | | 2025-06-29 09:31:52.459442+00 | | 2025-06-30 17:08:35.11111+00 |
| public | m_setting_log | 5179 | 724 | 0.00 | 12.00 | | 2025-06-26 12:30:44.075418+00 | | 2025-06-30 12:30:24.183048+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:59.831493+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:59.675492+00 | | |
| public | m_tx | 16915 | 8 | 0.00 | 0.00 | | 2025-06-28 12:28:02.460409+00 | | 2025-06-28 12:28:02.573394+00 |
| public | m_user | 3749 | 0 | 0.00 | 0.00 | | 2025-06-30 17:43:49.74881+00 | | 2025-06-20 07:28:54.605204+00 |
| public | m_zone | 848 | 12 | 0.00 | 1.00 | | 2025-06-27 17:38:00.15527+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-06-28 09:36:10.145938+00 | | |
| public | r_auth_zone | 17 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:35.637399+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-06-27 17:38:55.327207+00 | | |
| public | r_group_auth | 379 | 0 | 0.00 | 0.00 | | 2025-06-28 09:36:09.785586+00 | | |
| public | r_location_zone | 7881 | 14 | 0.00 | 0.00 | | 2025-06-23 08:21:47.620881+00 | | |
| public | r_pot_auth | 57 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:35.613815+00 | | |
| public | r_pot_category | 923 | 0 | 0.00 | 0.00 | | 2025-06-24 05:56:28.88639+00 | | |
| public | r_pot_group | 52924 | 56 | 0.00 | 0.00 | | 2025-06-23 08:13:04.307638+00 | | |
| public | r_pot_tx | 12117 | 24 | 0.00 | 0.00 | | 2025-06-23 00:07:00.907862+00 | | |
| public | r_pot_user | 2911 | 8 | 0.00 | 0.00 | | 2025-06-28 09:36:17.241583+00 | | |
| public | r_provider_tenant | 147 | 0 | 0.00 | 0.00 | | 2025-06-27 00:19:44.498052+00 | | |
| public | r_role_feature | 614 | 0 | 0.00 | 0.00 | | 2025-06-27 01:19:12.957936+00 | | |
| public | r_tenant_feature | 669 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:59.696414+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2025-06-27 17:38:55.361222+00 | | |
| public | r_user_region | 2970 | 8 | 0.00 | 0.00 | | 2025-06-28 09:38:36.417525+00 | | |
| public | r_user_site | 362 | 7 | 0.00 | 1.00 | | 2025-06-23 10:03:33.528628+00 | | 2025-06-20 07:28:54.28563+00 |
| public | r_zone_category | 730 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:59.762671+00 | | |
| public | t_ai_history | 38 | 0 | 0.00 | 0.00 | | 2025-06-29 13:32:33.345345+00 | | |
| public | t_attendance | 809721 | 1529 | 0.00 | 0.00 | | 2025-06-28 09:38:44.739992+00 | | |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2025-06-28 09:38:44.811454+00 | | |
| public | t_mobile_device_history | 178929 | 0 | 0.00 | 0.00 | | 2025-06-26 05:18:08.26857+00 | | |
| public | t_mobile_status_history | 0 | 0 | 0 | 0 | | 2025-06-29 11:35:21.999766+00 | | |
| public | t_news | 1 | 0 | 0.00 | 0.00 | | 2025-06-27 17:38:55.338755+00 | | |
| public | t_notify_history | 780271 | 483 | 0.00 | 0.00 | | 2025-06-28 09:38:46.077149+00 | | |
| public | t_operation_log | 2879020 | 4 | 0.00 | 0.00 | | 2025-06-27 17:39:12.763446+00 | | |
| public | t_plan | 7096455 | 229073 | 0.00 | 3.00 | | 2025-06-27 05:38:35.944708+00 | | 2025-06-26 03:46:47.263536+00 |
| public | t_plan_cancel_history | 92281 | 3 | 0.00 | 0.00 | | 2025-06-27 02:19:49.264101+00 | | |
| public | t_plan_detail | 7874925 | 98290 | 0.00 | 1.00 | | 2025-06-30 16:34:55.376963+00 | | 2025-06-30 22:20:13.809417+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2025-06-30 02:56:28.29897+00 | | |
| public | t_plan_sync | 234848 | 29106 | 0.00 | 11.00 | | 2025-06-25 01:15:15.205182+00 | | 2025-06-30 09:27:04.932007+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2025-06-27 17:37:59.658335+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-06-28 09:36:10.18295+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-06-28 09:38:44.847814+00 | | |
| public | t_recv_position_history | 14517 | 16357 | 1.00 | 52.00 | | 2025-07-01 01:45:30.197972+00 | 2025-06-30 12:42:01.207851+00 | 2025-07-01 01:45:30.300854+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-06-28 09:36:17.282889+00 | | |
| public | t_terminal | 32718 | 3824 | 0.00 | 10.00 | | 2025-06-25 08:46:16.731971+00 | | 2025-06-30 17:19:36.28671+00 |
| public | t_terminal_log | 6677603 | 0 | 0.00 | 0.00 | | 2025-06-27 17:38:03.658878+00 | | |
| public | w_arrival_notify | 2 | 3 | 1.00 | 60.00 | | 2025-06-27 17:38:03.6918+00 | | 2025-06-24 15:00:42.827202+00 |
| public | w_latest_mobile_device | 5824 | 72 | 0.00 | 1.00 | | 2025-06-29 11:35:22.194296+00 | | 2025-06-27 02:59:22.207877+00 |
| public | w_latest_mobile_status | 5695 | 860 | 0.00 | 13.00 | | 2025-06-30 23:45:42.000316+00 | | 2025-07-01 01:44:30.489294+00 |
| public | w_latest_position | 13277 | 6581 | 0.00 | 33.00 | | 2025-07-01 01:45:30.123792+00 | | 2025-07-01 01:45:30.168357+00 |
| public | w_latest_presence | 18737 | 96246 | 5.00 | 83.00 | | 2025-07-01 01:45:30.360609+00 | | 2025-07-01 01:45:30.495061+00 |
| public | w_latest_sensor | 113 | 70 | 0.00 | 38.00 | | 2025-07-01 01:42:29.586648+00 | | 2025-07-01 01:43:29.857213+00 |
| public | w_lock | 1164 | 0 | 0.00 | 0.00 | | 2025-06-27 17:37:59.288082+00 | | |
| public | w_master_update | 17 | 37 | 2.00 | 68.00 | | 2025-06-30 07:05:46.674944+00 | | 2025-07-01 01:31:29.23122+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-06-25 23:11:13.978248+00 | | |
| public | w_plan_with_detail | 7085144 | 266152 | 0.00 | 3.00 | | 2025-06-27 00:23:42.482467+00 | | 2025-06-26 03:46:50.117769+00 |