| 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 |
|---|
| e202506 | a_proximity_sum | 31875067 | 0 | 0.00 | 0.00 | | 2025-08-20 23:24:14.839377+00 | | |
| e202506 | a_stay_time | 42842031 | 0 | 0.00 | 0.00 | | 2025-08-20 05:01:45.939519+00 | | |
| e202506 | t_position_history | 547026656 | 0 | 0.00 | 0.00 | | 2025-08-22 01:32:34.366317+00 | | |
| e202506 | t_presence_history | 67840699 | 0 | 0.00 | 0.00 | | 2025-08-21 04:04:43.167384+00 | | |
| e202506 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202507 | a_proximity_sum | 57061220 | 0 | 0.00 | 0.00 | | 2025-08-22 11:00:08.053041+00 | | |
| e202507 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202507 | t_position_history | 2 | 0 | 0.00 | 0.00 | | | | |
| e202507 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202507 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202508 | a_proximity_sum | 26832672 | 0 | 0.00 | 0.00 | | 2025-08-22 16:11:01.124689+00 | | 2025-08-21 18:06:30.73464+00 |
| e202508 | a_stay_time | 26257138 | 0 | 0.00 | 0.00 | | 2025-08-21 17:38:14.945368+00 | | 2025-08-22 17:16:18.58493+00 |
| e202508 | t_position_history | 433109246 | 4 | 0.00 | 0.00 | | 2025-08-21 07:52:01.664096+00 | | 2025-08-22 12:06:48.471877+00 |
| e202508 | t_presence_history | 39712411 | 2212372 | 0.00 | 5.00 | | 2025-08-24 00:40:37.703675+00 | | 2025-08-24 00:40:38.342767+00 |
| e202508 | t_sensor_history | 9066136 | 0 | 0.00 | 0.00 | | 2025-08-21 07:58:17.099633+00 | | 2025-08-23 20:34:11.822404+00 |
| public | __digdag_status | 33 | 7 | 0.00 | 17.00 | | 2025-08-22 10:06:05.83482+00 | | |
| public | a_attendance_sum | 144957 | 21940 | 0.00 | 13.00 | | 2025-08-21 23:47:10.18321+00 | | 2025-08-22 11:27:45.225678+00 |
| public | a_plan_actual | 891198 | 2 | 0.00 | 0.00 | | 2025-08-20 03:53:13.715266+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| public | aaa | 0 | 0 | 0 | 0 | | | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-08-20 22:22:03.424818+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-08-20 09:15:37.973017+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-08-20 10:33:04.921351+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.148493+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-08-20 10:33:04.940405+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-08-20 10:33:04.959906+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.185826+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.127309+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-08-20 10:33:02.495433+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.207216+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-08-20 09:14:48.227509+00 | | |
| public | l_area | 4 | 4 | 1.00 | 50.00 | | | | |
| public | l_auth | 0 | 0 | 0 | 0 | | | | |
| public | l_category | 11 | 0 | 0.00 | 0.00 | | | | |
| public | l_group | 154 | 162 | 1.00 | 51.00 | | | | |
| public | l_location | 734 | 718 | 0.00 | 49.00 | | | | |
| public | l_location_zone | 1480 | 1641 | 1.00 | 52.00 | | | | |
| public | l_outside | 0 | 0 | 0 | 0 | | | | |
| public | l_pot | 7129 | 3622 | 0.00 | 33.00 | | | | |
| public | l_pot_category | 401 | 394 | 0.00 | 49.00 | | | | |
| public | l_pot_group | 3560 | 448 | 0.00 | 11.00 | | | | |
| public | l_pot_tx | 835 | 869 | 1.00 | 50.00 | | | | |
| public | l_role | 4 | 0 | 0.00 | 0.00 | | | | |
| public | l_role_feature | 35 | 7 | 0.00 | 16.00 | | | | |
| public | l_site | 1 | 0 | 0.00 | 0.00 | | | | |
| public | l_tx | 140558 | 18847 | 0.00 | 11.00 | | 2025-08-22 12:04:58.343131+00 | | 2025-08-22 12:10:45.995975+00 |
| public | l_user | 668 | 796 | 1.00 | 54.00 | | | | |
| public | l_zone | 20 | 4 | 0.00 | 16.00 | | | | |
| public | l_zone_category | 48 | 0 | 0.00 | 0.00 | | | | |
| public | m_area | 782 | 5 | 0.00 | 0.00 | | 2025-08-20 06:48:09.780375+00 | | |
| public | m_auth | 0 | 0 | 0 | 0 | | | | |
| public | m_category | 2432 | 1 | 0.00 | 0.00 | | 2025-08-20 06:48:09.750743+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-08-21 01:07:59.420833+00 | | |
| public | m_exb | 0 | 38 | 0 | 100.00 | | | | |
| public | m_favorite | 232443 | 440 | 0.00 | 0.00 | | 2025-08-20 01:53:29.620797+00 | | |
| public | m_favorite_group | 112470 | 31 | 0.00 | 0.00 | | 2025-08-21 10:03:27.740203+00 | | |
| public | m_feature | 0 | 0 | 0 | 0 | | | | |
| public | m_group | 27894 | 1369 | 0.00 | 4.00 | | 2025-08-21 07:52:49.953942+00 | | 2025-08-23 14:40:44.060971+00 |
| public | m_holiday | 44100 | 0 | 0.00 | 0.00 | | 2025-08-22 23:30:04.392057+00 | | |
| public | m_lob | 24500 | 0 | 0.00 | 0.00 | | 2025-08-23 09:15:30.702631+00 | | |
| public | m_lob_log | 1963 | 0 | 0.00 | 0.00 | | 2025-08-22 09:20:42.931174+00 | | |
| public | m_location | 44525 | 1329 | 0.00 | 2.00 | | 2025-08-20 05:02:47.018286+00 | | |
| public | m_notify_template | 6 | 0 | 0.00 | 0.00 | | | | |
| public | m_outside | 372 | 0 | 0.00 | 0.00 | | 2025-08-22 04:46:03.341714+00 | | |
| public | m_personal_setting | 131676 | 14561 | 0.00 | 9.00 | | 2025-08-21 19:33:40.885074+00 | | 2025-08-23 02:33:16.070091+00 |
| public | m_pot | 199463 | 20158 | 0.00 | 9.00 | | 2025-08-19 17:13:11.148703+00 | | 2025-08-23 14:40:42.674661+00 |
| public | m_pot_profile | 53038 | 0 | 0.00 | 0.00 | | 2025-08-23 23:38:21.181987+00 | | |
| public | m_provider_user | 1 | 5 | 5.00 | 83.00 | | | | |
| public | m_region | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_role | 4 | 0 | 0.00 | 0.00 | | | | |
| public | m_sensor | 0 | 0 | 0 | 0 | | | | |
| public | m_setting | 29090 | 789 | 0.00 | 2.00 | | 2025-08-23 12:17:28.130097+00 | | 2025-08-22 23:11:02.898601+00 |
| public | m_setting_log | 35828 | 1648 | 0.00 | 4.00 | | | | 2025-08-23 00:14:06.750304+00 |
| public | m_site | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_tenant | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_tx | 173813 | 7087 | 0.00 | 3.00 | | 2025-08-22 12:35:17.390339+00 | | 2025-08-22 12:25:16.292051+00 |
| public | m_user | 37224 | 267 | 0.00 | 0.00 | | 2025-08-21 22:44:12.102824+00 | | |
| public | m_zone | 7845 | 30 | 0.00 | 0.00 | | 2025-08-19 21:58:45.253055+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | | | |
| public | r_auth_zone | 213 | 0 | 0.00 | 0.00 | | 2025-08-20 02:26:29.924536+00 | | |
| public | r_exb_sensor | 0 | 0 | 0 | 0 | | | | |
| public | r_group_auth | 555 | 0 | 0.00 | 0.00 | | 2025-08-20 23:24:14.768288+00 | | |
| public | r_location_zone | 54256 | 1521 | 0.00 | 2.00 | | 2025-08-20 06:48:09.729389+00 | | |
| public | r_pot_auth | 8151 | 0 | 0.00 | 0.00 | | 2025-08-22 11:00:03.096581+00 | | |
| public | r_pot_category | 11691 | 7 | 0.00 | 0.00 | | 2025-08-22 08:17:59.140943+00 | | |
| public | r_pot_group | 433545 | 384 | 0.00 | 0.00 | | 2025-08-21 01:07:57.767321+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-08-19 22:31:53.780118+00 | | |
| public | r_pot_tx | 69622 | 6 | 0.00 | 0.00 | | 2025-08-22 20:33:36.735896+00 | | |
| public | r_pot_user | 20702 | 0 | 0.00 | 0.00 | | 2025-08-23 10:51:31.733432+00 | | |
| public | r_provider_tenant | 4 | 20 | 5.00 | 83.00 | | | | |
| public | r_role_feature | 6083 | 0 | 0.00 | 0.00 | | 2025-08-21 10:26:45.980237+00 | | |
| public | r_tenant_feature | 4440 | 0 | 0.00 | 0.00 | | 2025-08-20 09:14:45.668323+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-08-21 07:52:49.98141+00 | | |
| public | r_user_region | 21550 | 0 | 0.00 | 0.00 | | 2025-08-23 10:51:30.848351+00 | | |
| public | r_user_site | 4 | 1 | 0.00 | 20.00 | | | | |
| public | r_zone_category | 5001 | 0 | 0.00 | 0.00 | | 2025-08-22 09:20:42.903478+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-08-21 03:46:39.658808+00 | | |
| public | t_attendance | 3150236 | 22751 | 0.00 | 0.00 | | 2025-08-20 09:15:37.943742+00 | | |
| public | t_general | 4137 | 5 | 0.00 | 0.00 | | 2025-08-20 22:05:44.811173+00 | | |
| public | t_general_20250618 | 3464 | 0 | 0.00 | 0.00 | | 2025-08-22 03:33:57.005639+00 | | |
| public | t_mobile_device_history | 4530 | 0 | 0.00 | 0.00 | | | | |
| public | t_mobile_status_history | 1788643 | 0 | 0.00 | 0.00 | | 2025-08-23 06:06:30.852064+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 50337 | 10031 | 0.00 | 16.00 | | | | |
| public | t_operation_log | 21771200 | 6 | 0.00 | 0.00 | | 2025-08-22 10:06:05.76108+00 | | |
| public | t_plan | 26982144 | 616166 | 0.00 | 2.00 | | 2025-08-21 06:52:35.985713+00 | | 2025-08-22 08:10:00.726417+00 |
| public | t_plan_cancel_history | 578686 | 0 | 0.00 | 0.00 | | 2025-08-23 19:31:59.762045+00 | | |
| public | t_plan_detail | 46127905 | 32367 | 0.00 | 0.00 | | 2025-08-23 05:32:06.733415+00 | | 2025-08-21 09:32:21.407526+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-08-19 22:31:53.758287+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-08-19 22:31:53.737747+00 | | |
| public | t_plan_sync | 62489 | 9850 | 0.00 | 13.00 | | 2025-08-23 20:01:03.258769+00 | | 2025-08-24 00:34:54.737625+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | | | |
| public | t_recv_position_history | 141397 | 38295 | 0.00 | 21.00 | | 2025-08-24 00:47:58.500372+00 | 2025-08-23 13:30:04.25938+00 | 2025-08-24 00:48:54.76052+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 20893 | 3534 | 0.00 | 14.00 | | 2025-08-23 16:23:43.148766+00 | | 2025-08-24 00:24:49.300435+00 |
| public | t_terminal_log | 27512287 | 0 | 0.00 | 0.00 | | 2025-08-22 07:29:31.594021+00 | | |
| public | temp_pivot_table | 240255 | 0 | 0.00 | 0.00 | | 2025-08-23 23:38:27.7035+00 | | |
| public | w_arrival_notify | 97 | 64 | 0.00 | 39.00 | | | | 2025-08-21 04:51:48.10795+00 |
| public | w_latest_mobile_device | 56207 | 272 | 0.00 | 0.00 | | 2025-08-21 04:52:51.565861+00 | | |
| public | w_latest_mobile_status | 55175 | 5090 | 0.00 | 8.00 | | 2025-08-22 08:35:59.826618+00 | | 2025-08-23 07:24:30.018301+00 |
| public | w_latest_position | 78892 | 10626 | 0.00 | 11.00 | | 2025-08-24 00:43:55.594692+00 | | 2025-08-24 00:48:54.88995+00 |
| public | w_latest_presence | 228549 | 113880 | 0.00 | 33.00 | | 2025-08-24 00:49:08.73321+00 | | 2025-08-24 00:49:09.095185+00 |
| public | w_latest_sensor | 386 | 221 | 0.00 | 36.00 | | 2025-08-24 00:48:54.903414+00 | | 2025-08-24 00:48:55.015958+00 |
| public | w_lock | 18232 | 0 | 0.00 | 0.00 | | 2025-08-21 08:54:17.336319+00 | | |
| public | w_master_update | 197 | 11 | 0.00 | 5.00 | | 2025-08-23 23:38:27.547918+00 | | 2025-08-23 22:19:14.087443+00 |
| public | w_migration | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_sync_retry | 0 | 49 | 0 | 100.00 | | 2025-08-22 02:30:46.61229+00 | | 2025-08-23 02:13:20.647583+00 |
| public | w_plan_with_detail | 27017406 | 1230841 | 0.00 | 4.00 | | | | 2025-08-22 08:02:53.881533+00 |