| 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 |
|---|
| e202501 | a_proximity_sum | 31254285 | 0 | 0.00 | 0.00 | | 2025-03-23 08:02:32.121664+00 | | |
| e202501 | a_stay_time | 32818895 | 0 | 0.00 | 0.00 | | 2025-03-25 08:07:53.250587+00 | | |
| e202501 | t_position_history | 432237550 | 0 | 0.00 | 0.00 | | 2025-03-21 01:10:26.685875+00 | | |
| e202501 | t_presence_history | 45584030 | 0 | 0.00 | 0.00 | | 2025-03-25 19:41:23.921195+00 | | |
| e202501 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202502 | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202502 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202502 | t_position_history | 1823 | 0 | 0.00 | 0.00 | | | | |
| e202502 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202502 | t_sensor_history | 9718192 | 0 | 0.00 | 0.00 | | 2025-03-23 14:29:13.704066+00 | | |
| e202503 | a_proximity_sum | 27520482 | 0 | 0.00 | 0.00 | | 2025-03-26 17:56:54.018776+00 | | 2025-03-26 15:56:05.543092+00 |
| e202503 | a_stay_time | 31904250 | 0 | 0.00 | 0.00 | | 2025-03-25 01:56:22.320193+00 | | 2025-03-25 17:55:54.228373+00 |
| e202503 | t_position_history | 396365170 | 284 | 0.00 | 0.00 | | 2025-03-25 00:13:30.185876+00 | | 2025-03-25 09:38:05.731224+00 |
| e202503 | t_presence_history | 43565871 | 2350715 | 0.00 | 5.00 | | 2025-03-27 00:42:41.474315+00 | | 2025-03-27 00:31:19.092057+00 |
| e202503 | t_sensor_history | 11286532 | 0 | 0.00 | 0.00 | | 2025-03-25 17:22:15.106946+00 | | 2025-03-25 00:50:48.704569+00 |
| public | __digdag_status | 34 | 27 | 0.00 | 44.00 | | 2025-03-24 12:35:00.943482+00 | | 2025-03-24 03:31:00.678379+00 |
| public | a_attendance_sum | 126847 | 16236 | 0.00 | 11.00 | | 2025-03-27 00:47:46.680421+00 | | 2025-03-27 00:43:46.356965+00 |
| public | a_plan_actual | 222079 | 0 | 0.00 | 0.00 | | | | 2025-03-25 19:56:18.591927+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-03-24 01:28:34.606889+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-03-23 13:11:27.718806+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-03-23 13:11:28.751146+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-03-23 13:10:58.96082+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-03-23 13:11:28.771834+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-03-23 13:11:28.796362+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-03-23 13:10:58.981965+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-03-23 13:10:58.784376+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-03-23 13:11:27.740374+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-03-23 13:10:59.002535+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-03-23 13:10:59.0231+00 | | |
| public | m_area | 689 | 12 | 0.00 | 1.00 | | 2025-03-23 06:18:38.51959+00 | | |
| public | m_auth | 0 | 0 | 0 | 0 | | | | |
| public | m_category | 2064 | 0 | 0.00 | 0.00 | | 2025-03-23 06:18:38.489228+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-03-24 10:02:35.673864+00 | | |
| public | m_exb | 22110 | 1197 | 0.00 | 5.00 | | | | 2025-03-25 07:09:44.856291+00 |
| public | m_favorite | 227428 | 829 | 0.00 | 0.00 | | 2025-03-22 04:12:53.416117+00 | | |
| public | m_favorite_group | 90298 | 34 | 0.00 | 0.00 | | 2025-03-25 09:37:57.24877+00 | | |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-03-21 04:59:01.750479+00 | | |
| public | m_group | 18945 | 146 | 0.00 | 0.00 | | 2025-03-25 11:23:36.756429+00 | | |
| public | m_holiday | 0 | 0 | 0 | 0 | | | | |
| public | m_lob | 102 | 59 | 0.00 | 36.00 | | | | |
| public | m_lob_log | 26 | 0 | 0.00 | 0.00 | | | | |
| public | m_location | 38008 | 0 | 0.00 | 0.00 | | 2025-03-26 06:13:44.876331+00 | | |
| public | m_notify_template | 1 | 6 | 6.00 | 85.00 | | | | |
| public | m_outside | 331 | 0 | 0.00 | 0.00 | | 2025-03-26 13:20:43.51379+00 | | |
| public | m_pot | 169071 | 19655 | 0.00 | 10.00 | | 2025-03-26 05:46:17.012337+00 | | 2025-03-27 00:04:05.990506+00 |
| public | m_pot_profile | 90 | 26 | 0.00 | 22.00 | | | | |
| public | m_provider_user | 74 | 1 | 0.00 | 1.00 | | 2025-03-21 05:42:11.837363+00 | | |
| public | m_region | 0 | 0 | 0 | 0 | | | | |
| public | m_role | 0 | 2 | 0 | 100.00 | | | | |
| public | m_sensor | 0 | 0 | 0 | 0 | | | | |
| public | m_setting | 13247 | 1729 | 0.00 | 11.00 | | 2025-03-25 19:07:18.820614+00 | | 2025-03-26 14:58:50.353541+00 |
| public | m_setting_log | 30794 | 0 | 0.00 | 0.00 | | 2025-03-26 01:55:24.143298+00 | | 2025-03-26 21:36:09.683799+00 |
| public | m_site | 0 | 1 | 0 | 100.00 | | | | |
| public | m_tenant | 0 | 0 | 0 | 0 | | | | |
| public | m_tx | 101117 | 16543 | 0.00 | 14.00 | | 2025-03-25 01:22:15.072316+00 | | 2025-03-26 03:40:36.22233+00 |
| public | m_user | 31435 | 43 | 0.00 | 0.00 | | 2025-03-26 01:55:48.204043+00 | | |
| public | m_zone | 5964 | 31 | 0.00 | 0.00 | | 2025-03-21 12:36:14.975171+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | | | |
| public | r_auth_zone | 213 | 0 | 0.00 | 0.00 | | 2025-03-22 08:11:32.813797+00 | | |
| public | r_exb_sensor | 0 | 0 | 0 | 0 | | | | |
| public | r_group_auth | 501 | 124 | 0.00 | 19.00 | | 2025-03-24 07:04:53.845365+00 | | 2025-03-26 03:04:45.736116+00 |
| public | r_location_zone | 47997 | 387 | 0.00 | 0.00 | | 2025-03-22 21:50:16.847807+00 | | |
| public | r_pot_auth | 3039 | 0 | 0.00 | 0.00 | | 2025-03-26 03:49:32.682598+00 | | |
| public | r_pot_category | 8356 | 0 | 0.00 | 0.00 | | 2025-03-26 20:16:04.927235+00 | | 2025-03-26 20:01:58.615982+00 |
| public | r_pot_group | 162578 | 3273 | 0.00 | 1.00 | | 2025-03-27 00:43:45.273605+00 | | 2025-03-27 00:07:01.158765+00 |
| public | r_pot_tx | 151 | 589 | 3.00 | 79.00 | | | | |
| public | r_pot_user | 40 | 64 | 1.00 | 61.00 | | | | |
| public | r_provider_tenant | 1 | 7 | 7.00 | 87.00 | | | | |
| public | r_role_feature | 5457 | 1 | 0.00 | 0.00 | | 2025-03-25 11:23:36.552259+00 | | |
| public | r_tenant_feature | 3958 | 2 | 0.00 | 0.00 | | 2025-03-23 13:10:52.85292+00 | | |
| public | r_tx_sensor | 359 | 0 | 0.00 | 0.00 | | 2025-03-25 06:41:40.215019+00 | | |
| public | r_user_region | 44 | 62 | 1.00 | 58.00 | | | | |
| public | r_user_site | 2 | 7 | 3.00 | 77.00 | | | | |
| public | r_zone_category | 32 | 32 | 1.00 | 50.00 | | | | |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-03-24 23:31:12.966693+00 | | |
| public | t_attendance | 2168096 | 24263 | 0.00 | 1.00 | | 2025-03-23 13:11:27.694467+00 | | |
| public | t_general | 30 | 7 | 0.00 | 18.00 | | | | |
| public | t_mobile_device_history | 810650 | 0 | 0.00 | 0.00 | | 2025-03-22 12:31:57.212142+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 4755078 | 10017 | 0.00 | 0.00 | | 2025-03-21 08:10:33.94643+00 | | |
| public | t_operation_log | 211569 | 832 | 0.00 | 0.00 | | | | |
| public | t_plan | 19609574 | 662444 | 0.00 | 3.00 | | 2025-03-25 03:52:15.76498+00 | | 2025-03-25 00:37:00.480192+00 |
| public | t_plan_cancel_history | 325867 | 17560 | 0.00 | 5.00 | | 2025-03-26 05:31:59.524827+00 | | |
| public | t_plan_detail | 33588631 | 3146217 | 0.00 | 8.00 | | | | 2025-03-26 23:59:55.44555+00 |
| public | t_plan_sync | 45896 | 5103 | 0.00 | 10.00 | | 2025-03-27 00:43:45.720137+00 | | 2025-03-27 00:43:46.010784+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 | 121908 | 20340 | 0.00 | 14.00 | | 2025-03-27 00:54:12.10753+00 | 2025-03-26 13:30:08.198248+00 | 2025-03-27 00:54:12.72506+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 145864 | 12306 | 0.00 | 7.00 | | | | 2025-03-26 18:46:52.510488+00 |
| public | t_terminal_log | 17647588 | 0 | 0.00 | 0.00 | | 2025-03-27 00:52:44.370841+00 | | |
| public | temp_pivot_table | 0 | 0 | 0 | 0 | | | | |
| public | w_arrival_notify | 87 | 28 | 0.00 | 24.00 | | 2025-03-24 15:01:38.191623+00 | | 2025-03-24 15:00:37.742087+00 |
| public | w_latest_position | 64124 | 6641 | 0.00 | 9.00 | | 2025-03-27 00:54:12.877762+00 | | 2025-03-27 00:54:13.022593+00 |
| public | w_latest_presence | 191890 | 214069 | 1.00 | 52.00 | | 2025-03-27 00:53:20.976737+00 | | 2025-03-27 00:53:23.674611+00 |
| public | w_latest_sensor | 386 | 214 | 0.00 | 35.00 | | 2025-03-27 00:54:13.7183+00 | | 2025-03-27 00:54:13.831426+00 |
| public | w_lock | 15940 | 0 | 0.00 | 0.00 | | 2025-03-25 08:54:38.045793+00 | | |
| public | w_master_update | 183 | 30 | 0.00 | 14.00 | | 2025-03-27 00:31:18.371973+00 | | 2025-03-27 00:29:18.25233+00 |
| public | w_migration | 737 | 0 | 0.00 | 0.00 | | 2025-03-20 23:11:06.676509+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_with_detail | 19601597 | 1190618 | 0.00 | 5.00 | | 2025-03-21 06:08:57.378659+00 | | 2025-03-25 00:36:48.898898+00 |