| 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 | 47407727 | 0 | 0.00 | 0.00 | | 2025-08-24 02:01:16.763315+00 | | |
| e202507 | t_position_history | 610147766 | 0 | 0.00 | 0.00 | | 2025-08-24 12:10:03.540215+00 | | |
| e202507 | t_presence_history | 55790809 | 0 | 0.00 | 0.00 | | 2025-08-24 07:46:06.862831+00 | | |
| e202507 | t_sensor_history | 11690430 | 0 | 0.00 | 0.00 | | 2025-08-25 00:39:33.248244+00 | | |
| e202508 | a_proximity_sum | 26891900 | 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 | 26320491 | 0 | 0.00 | 0.00 | | 2025-08-24 14:16:16.877187+00 | | 2025-08-22 17:16:18.58493+00 |
| e202508 | t_position_history | 444602966 | 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 | 40693028 | 7065345 | 0.00 | 14.00 | | 2025-08-25 00:12:11.260536+00 | | 2025-08-25 00:38:33.44764+00 |
| e202508 | t_sensor_history | 9458146 | 0 | 0.00 | 0.00 | | 2025-08-21 07:58:17.099633+00 | | 2025-08-23 20:34:11.822404+00 |
| public | __digdag_status | 32 | 12 | 0.00 | 27.00 | | 2025-08-22 10:06:05.83482+00 | | |
| public | a_attendance_sum | 192688 | 6084 | 0.00 | 3.00 | | 2025-08-25 00:37:36.698807+00 | | 2025-08-25 00:30:32.905761+00 |
| public | a_plan_actual | 891216 | 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 | 1524 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.162154+00 | | |
| public | l_auth | 172 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.109959+00 | | |
| public | l_category | 2696 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:47.411463+00 | | |
| public | l_group | 35204 | 2 | 0.00 | 0.00 | | 2025-08-24 05:40:49.728758+00 | | |
| public | l_location | 102826 | 1 | 0.00 | 0.00 | | 2025-08-24 05:40:47.253199+00 | | |
| public | l_location_zone | 99879 | 2 | 0.00 | 0.00 | | 2025-08-24 05:40:46.632324+00 | | |
| public | l_outside | 441 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.130419+00 | | |
| public | l_pot | 423238 | 84 | 0.00 | 0.00 | | 2025-08-24 05:40:55.59138+00 | | |
| public | l_pot_category | 12922 | 68 | 0.00 | 0.00 | | 2025-08-24 05:40:47.386698+00 | | |
| public | l_pot_group | 226936 | 3 | 0.00 | 0.00 | | 2025-08-24 05:40:49.401816+00 | | |
| public | l_pot_tx | 98843 | 58 | 0.00 | 0.00 | | 2025-08-24 05:40:48.158613+00 | | |
| public | l_role | 766 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:44.919122+00 | | |
| public | l_role_feature | 6203 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:44.903732+00 | | |
| public | l_site | 247 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.187691+00 | | |
| public | l_tx | 140571 | 19635 | 0.00 | 12.00 | | 2025-08-22 12:04:58.343131+00 | | 2025-08-22 12:10:45.995975+00 |
| public | l_user | 61490 | 126 | 0.00 | 0.00 | | 2025-08-24 05:40:44.807064+00 | | |
| public | l_zone | 9988 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:46.705754+00 | | |
| public | l_zone_category | 5428 | 0 | 0.00 | 0.00 | | 2025-08-24 05:40:43.879377+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 | 26653 | 0 | 0.00 | 0.00 | | 2025-08-24 23:53:07.74175+00 | | |
| public | m_favorite | 232497 | 490 | 0.00 | 0.00 | | 2025-08-20 01:53:29.620797+00 | | |
| public | m_favorite_group | 112520 | 34 | 0.00 | 0.00 | | 2025-08-21 10:03:27.740203+00 | | |
| public | m_feature | 0 | 0 | 0 | 0 | | | | |
| public | m_group | 27895 | 1497 | 0.00 | 5.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 | 24504 | 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 | 131699 | 16867 | 0.00 | 11.00 | | 2025-08-21 19:33:40.885074+00 | | 2025-08-25 00:12:33.30212+00 |
| public | m_pot | 199483 | 21471 | 0.00 | 9.00 | | 2025-08-19 17:13:11.148703+00 | | 2025-08-23 14:40:42.674661+00 |
| public | m_pot_profile | 53037 | 25 | 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 | 15816 | 2332 | 0.00 | 12.00 | | 2025-08-23 12:17:28.130097+00 | | 2025-08-24 22:32:03.66246+00 |
| public | m_setting_log | 35865 | 0 | 0.00 | 0.00 | | 2025-08-24 14:25:30.266674+00 | | 2025-08-24 06:45:00.643975+00 |
| public | m_site | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_tenant | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_tx | 173826 | 11555 | 0.00 | 6.00 | | 2025-08-22 12:35:17.390339+00 | | 2025-08-22 12:25:16.292051+00 |
| public | m_user | 37224 | 313 | 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 | 1523 | 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 | 11621 | 77 | 0.00 | 0.00 | | 2025-08-22 08:17:59.140943+00 | | |
| public | r_pot_group | 433542 | 389 | 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 | 69610 | 66 | 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 | 952 | 0 | 0.00 | 0.00 | | 2025-08-24 13:05:25.71702+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 | 3154783 | 23041 | 0.00 | 0.00 | | 2025-08-20 09:15:37.943742+00 | | |
| public | t_general | 4141 | 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 | 5464 | 0 | 0.00 | 0.00 | | | | |
| public | t_mobile_status_history | 1791243 | 0 | 0.00 | 0.00 | | 2025-08-23 06:06:30.852064+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 59159 | 11882 | 0.00 | 16.00 | | | | |
| public | t_operation_log | 21792440 | 13 | 0.00 | 0.00 | | 2025-08-22 10:06:05.76108+00 | | |
| public | t_plan | 27012466 | 756056 | 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 | 579516 | 2256 | 0.00 | 0.00 | | 2025-08-23 19:31:59.762045+00 | | |
| public | t_plan_detail | 46191128 | 499938 | 0.00 | 1.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 | 62490 | 6852 | 0.00 | 9.00 | | 2025-08-24 22:16:56.615544+00 | | 2025-08-25 00:40:32.587957+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 | 155321 | 44451 | 0.00 | 22.00 | | 2025-08-25 00:51:32.514944+00 | 2025-08-24 13:30:04.595594+00 | 2025-08-25 00:51:32.807348+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 20898 | 3518 | 0.00 | 14.00 | | 2025-08-24 16:21:51.674061+00 | | 2025-08-25 00:34:33.211778+00 |
| public | t_terminal_log | 27589016 | 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 | 102 | 4 | 0.00 | 3.00 | | 2025-08-24 02:01:16.786809+00 | | 2025-08-21 04:51:48.10795+00 |
| public | w_latest_mobile_device | 56216 | 506 | 0.00 | 0.00 | | 2025-08-21 04:52:51.565861+00 | | |
| public | w_latest_mobile_status | 55183 | 10498 | 0.00 | 15.00 | | 2025-08-22 08:35:59.826618+00 | | 2025-08-25 00:15:32.803189+00 |
| public | w_latest_position | 78900 | 33398 | 0.00 | 29.00 | | 2025-08-25 00:51:32.985322+00 | | 2025-08-25 00:51:33.113712+00 |
| public | w_latest_presence | 222336 | 214214 | 0.00 | 49.00 | | 2025-08-25 00:51:45.277537+00 | | 2025-08-25 00:51:45.64605+00 |
| public | w_latest_sensor | 386 | 295 | 0.00 | 43.00 | | 2025-08-25 00:51:33.13069+00 | | 2025-08-25 00:51:33.244434+00 |
| public | w_lock | 18292 | 0 | 0.00 | 0.00 | | 2025-08-21 08:54:17.336319+00 | | |
| public | w_master_update | 113 | 60 | 0.00 | 34.00 | | 2025-08-25 00:18:31.449304+00 | | 2025-08-25 00:47:32.964239+00 |
| public | w_migration | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_sync_retry | 2 | 17 | 8.00 | 89.00 | | 2025-08-24 05:10:50.371839+00 | | 2025-08-23 02:13:20.647583+00 |
| public | w_plan_with_detail | 27047728 | 1374526 | 0.00 | 4.00 | | | | 2025-08-22 08:02:53.881533+00 |