| 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 | 0 | 0 | 0 | 0 | | | | |
| 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 | 0 | 0 | 0 | 0 | | | | |
| 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 | 25272758 | 0 | 0.00 | 0.00 | | 2025-08-20 03:18:44.34959+00 | | 2025-08-21 18:06:30.73464+00 |
| e202508 | a_stay_time | 24257068 | 0 | 0.00 | 0.00 | | 2025-08-21 17:38:14.945368+00 | | 2025-08-21 16:05:44.035943+00 |
| e202508 | t_position_history | 400240386 | 20 | 0.00 | 0.00 | | 2025-08-21 07:52:01.664096+00 | | 2025-08-21 02:42:25.082255+00 |
| e202508 | t_presence_history | 36791195 | 3518103 | 0.00 | 8.00 | | 2025-08-22 00:33:42.031614+00 | | 2025-08-22 00:35:05.939364+00 |
| e202508 | t_sensor_history | 8282799 | 0 | 0.00 | 0.00 | | 2025-08-21 07:58:17.099633+00 | | 2025-08-21 18:06:29.911819+00 |
| public | __digdag_status | 0 | 9 | 0 | 100.00 | | | | |
| public | a_attendance_sum | 144917 | 12575 | 0.00 | 7.00 | | 2025-08-21 23:47:10.18321+00 | | 2025-08-22 00:49:00.731687+00 |
| public | a_plan_actual | 882897 | 1 | 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 | 0 | 0 | 0 | 0 | | | | |
| public | l_auth | 0 | 0 | 0 | 0 | | | | |
| public | l_category | 11 | 0 | 0.00 | 0.00 | | | | |
| public | l_group | 17 | 24 | 1.00 | 58.00 | | | | |
| public | l_location | 463 | 448 | 0.00 | 49.00 | | | | |
| public | l_location_zone | 767 | 821 | 1.00 | 51.00 | | | | |
| public | l_outside | 0 | 0 | 0 | 0 | | | | |
| public | l_pot | 4423 | 1009 | 0.00 | 18.00 | | | | |
| public | l_pot_category | 256 | 316 | 1.00 | 55.00 | | | | |
| public | l_pot_group | 400 | 335 | 0.00 | 45.00 | | | | |
| public | l_pot_tx | 640 | 649 | 1.00 | 50.00 | | | | |
| public | l_role | 3 | 0 | 0.00 | 0.00 | | | | |
| public | l_role_feature | 28 | 7 | 0.00 | 20.00 | | | | |
| public | l_site | 1 | 0 | 0.00 | 0.00 | | | | |
| public | l_tx | 140506 | 19569 | 0.00 | 12.00 | | 2025-08-20 01:26:20.688665+00 | | 2025-08-20 09:28:20.6952+00 |
| public | l_user | 385 | 516 | 1.00 | 57.00 | | | | |
| public | l_zone | 2 | 1 | 0.00 | 33.00 | | | | |
| public | l_zone_category | 33 | 0 | 0.00 | 0.00 | | | | |
| public | m_area | 782 | 1 | 0.00 | 0.00 | | 2025-08-20 06:48:09.780375+00 | | |
| public | m_auth | 0 | 0 | 0 | 0 | | | | |
| public | m_category | 2432 | 0 | 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 | 26 | 0 | 100.00 | | | | |
| public | m_favorite | 232330 | 275 | 0.00 | 0.00 | | 2025-08-20 01:53:29.620797+00 | | |
| public | m_favorite_group | 112324 | 4 | 0.00 | 0.00 | | 2025-08-21 10:03:27.740203+00 | | |
| public | m_feature | 0 | 0 | 0 | 0 | | | | |
| public | m_group | 27757 | 845 | 0.00 | 2.00 | | 2025-08-21 07:52:49.953942+00 | | 2025-08-21 14:40:45.694865+00 |
| public | m_holiday | 167 | 0 | 0.00 | 0.00 | | | | |
| public | m_lob | 54 | 18 | 0.00 | 25.00 | | | | |
| public | m_lob_log | 11 | 0 | 0.00 | 0.00 | | | | |
| public | m_location | 44516 | 766 | 0.00 | 1.00 | | 2025-08-20 05:02:47.018286+00 | | |
| public | m_notify_template | 6 | 0 | 0.00 | 0.00 | | | | |
| public | m_outside | 0 | 0 | 0 | 0 | | | | |
| public | m_personal_setting | 131581 | 12799 | 0.00 | 8.00 | | 2025-08-21 19:33:40.885074+00 | | 2025-08-22 00:34:05.429204+00 |
| public | m_pot | 199044 | 11266 | 0.00 | 5.00 | | 2025-08-19 17:13:11.148703+00 | | 2025-08-21 14:40:44.390559+00 |
| public | m_pot_profile | 89 | 7 | 0.00 | 7.00 | | | | |
| public | m_provider_user | 1 | 5 | 5.00 | 83.00 | | | | |
| public | m_region | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_role | 3 | 0 | 0.00 | 0.00 | | | | |
| public | m_sensor | 0 | 0 | 0 | 0 | | | | |
| public | m_setting | 25933 | 846 | 0.00 | 3.00 | | 2025-08-21 11:35:00.37485+00 | | 2025-08-21 08:13:42.869566+00 |
| public | m_setting_log | 35997 | 0 | 0.00 | 0.00 | | | | 2025-08-21 21:00:28.139317+00 |
| public | m_site | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_tenant | 1 | 0 | 0.00 | 0.00 | | | | |
| public | m_tx | 120706 | 17157 | 0.00 | 12.00 | | 2025-08-20 09:29:00.22237+00 | | 2025-08-21 08:45:55.566971+00 |
| public | m_user | 37042 | 29 | 0.00 | 0.00 | | 2025-08-21 22:44:12.102824+00 | | |
| public | m_zone | 7830 | 23 | 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 | 554 | 0 | 0.00 | 0.00 | | 2025-08-20 23:24:14.768288+00 | | |
| public | r_location_zone | 54362 | 702 | 0.00 | 1.00 | | 2025-08-20 06:48:09.729389+00 | | |
| public | r_pot_auth | 4 | 1 | 0.00 | 20.00 | | | | |
| public | r_pot_category | 0 | 316 | 0 | 100.00 | | | | |
| public | r_pot_group | 430498 | 271 | 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 | 115 | 661 | 5.00 | 85.00 | | | | |
| public | r_pot_user | 40 | 114 | 2.00 | 74.00 | | | | |
| public | r_provider_tenant | 4 | 20 | 5.00 | 83.00 | | | | |
| public | r_role_feature | 6076 | 0 | 0.00 | 0.00 | | 2025-08-21 10:26:45.980237+00 | | |
| public | r_tenant_feature | 4435 | 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 | 39 | 114 | 2.00 | 74.00 | | | | |
| public | r_user_site | 3 | 1 | 0.00 | 25.00 | | | | |
| public | r_zone_category | 33 | 0 | 0.00 | 0.00 | | | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-08-21 03:46:39.658808+00 | | |
| public | t_attendance | 3145360 | 13542 | 0.00 | 0.00 | | 2025-08-20 09:15:37.943742+00 | | |
| public | t_general | 4129 | 0 | 0.00 | 0.00 | | 2025-08-20 22:05:44.811173+00 | | |
| public | t_general_20250618 | 0 | 0 | 0 | 0 | | | | |
| public | t_mobile_device_history | 3641 | 0 | 0.00 | 0.00 | | | | |
| public | t_mobile_status_history | 31267 | 0 | 0.00 | 0.00 | | | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 39831 | 7506 | 0.00 | 15.00 | | | | |
| public | t_operation_log | 126856 | 53 | 0.00 | 0.00 | | | | |
| public | t_plan | 26617750 | 280124 | 0.00 | 1.00 | | 2025-08-21 06:52:35.985713+00 | | |
| public | t_plan_cancel_history | 5082 | 50122 | 9.00 | 90.00 | | | | |
| public | t_plan_detail | 46091728 | 2568498 | 0.00 | 5.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 | 101348 | 3322 | 0.00 | 3.00 | | 2025-08-22 00:35:05.295621+00 | | 2025-08-22 00:19:33.951538+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 | 154301 | 30110 | 0.00 | 16.00 | | 2025-08-22 00:51:04.790837+00 | 2025-08-21 13:30:05.427501+00 | 2025-08-22 00:51:05.121635+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 20884 | 3948 | 0.00 | 15.00 | | 2025-08-20 19:53:33.694067+00 | | 2025-08-22 00:14:29.368711+00 |
| public | t_terminal_log | 187418 | 0 | 0.00 | 0.00 | | | | |
| public | temp_pivot_table | 0 | 0 | 0 | 0 | | | | |
| public | w_arrival_notify | 97 | 57 | 0.00 | 37.00 | | | | 2025-08-21 04:51:48.10795+00 |
| public | w_latest_mobile_device | 56177 | 283 | 0.00 | 0.00 | | 2025-08-21 04:52:51.565861+00 | | |
| public | w_latest_mobile_status | 55144 | 10842 | 0.00 | 16.00 | | 2025-08-21 06:59:24.977574+00 | | 2025-08-22 00:09:28.154287+00 |
| public | w_latest_position | 78864 | 20226 | 0.00 | 20.00 | | 2025-08-22 00:51:05.268686+00 | | 2025-08-22 00:51:05.396131+00 |
| public | w_latest_presence | 278124 | 172153 | 0.00 | 38.00 | | 2025-08-22 00:51:20.308568+00 | | 2025-08-22 00:51:20.685619+00 |
| public | w_latest_sensor | 386 | 270 | 0.00 | 41.00 | | 2025-08-22 00:51:05.41362+00 | | 2025-08-22 00:51:05.526473+00 |
| public | w_lock | 18183 | 0 | 0.00 | 0.00 | | 2025-08-21 08:54:17.336319+00 | | |
| public | w_master_update | 192 | 73 | 0.00 | 27.00 | | 2025-08-22 00:37:04.366843+00 | | 2025-08-22 00:34:04.841857+00 |
| public | w_migration | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_sync_retry | 0 | 34 | 0 | 100.00 | | 2025-08-21 11:25:59.319638+00 | | 2025-08-21 23:20:57.000466+00 |
| public | w_plan_with_detail | 166427 | 958067 | 5.00 | 85.00 | | | | |