| 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 | 0 | 0 | 0 | 0 | | | | |
| e202501 | t_position_history | 432237550 | 0 | 0.00 | 0.00 | | 2025-03-21 01:10:26.685875+00 | | |
| e202501 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| 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 | 1514 | 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 | 24592141 | 971 | 0.00 | 0.00 | | | | 2025-03-24 17:37:05.465974+00 |
| e202503 | a_stay_time | 28213947 | 621 | 0.00 | 0.00 | | | | 2025-03-24 16:11:05.273574+00 |
| e202503 | t_position_history | 355397657 | 0 | 0.00 | 0.00 | | 2025-03-25 00:13:30.185876+00 | | 2025-03-23 22:30:33.613877+00 |
| e202503 | t_presence_history | 38740685 | 2867975 | 0.00 | 6.00 | | 2025-03-25 00:36:33.780378+00 | | 2025-03-25 00:44:47.107497+00 |
| e202503 | t_sensor_history | 10559779 | 0 | 0.00 | 0.00 | | | | 2025-03-25 00:50:48.704569+00 |
| public | __digdag_status | 33 | 4 | 0.00 | 10.00 | | 2025-03-24 12:35:00.943482+00 | | 2025-03-24 03:31:00.678379+00 |
| public | a_attendance_sum | 90454 | 16209 | 0.00 | 15.00 | | 2025-03-25 00:27:57.697051+00 | | 2025-03-25 00:41:36.415508+00 |
| public | a_plan_actual | 12247 | 0 | 0.00 | 0.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 | 0 | 0.00 | 0.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 | 392 | 781 | 1.00 | 66.00 | | | | |
| public | m_favorite | 227049 | 222 | 0.00 | 0.00 | | 2025-03-22 04:12:53.416117+00 | | |
| public | m_favorite_group | 232 | 65 | 0.00 | 21.00 | | | | |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-03-21 04:59:01.750479+00 | | |
| public | m_group | 10 | 2 | 0.00 | 16.00 | | | | |
| public | m_holiday | 0 | 0 | 0 | 0 | | | | |
| public | m_lob | 52 | 23 | 0.00 | 30.00 | | | | |
| public | m_lob_log | 12 | 0 | 0.00 | 0.00 | | | | |
| public | m_location | 14 | 395 | 28.00 | 96.00 | | | | |
| public | m_notify_template | 0 | 3 | 0 | 100.00 | | | | |
| public | m_outside | 0 | 0 | 0 | 0 | | | | |
| public | m_pot | 167213 | 4382 | 0.00 | 2.00 | | 2025-03-25 00:14:32.463114+00 | | 2025-03-25 00:14:34.078219+00 |
| public | m_pot_profile | 50 | 11 | 0.00 | 18.00 | | | | |
| public | m_provider_user | 74 | 0 | 0.00 | 0.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 | 20892 | 1587 | 0.00 | 7.00 | | 2025-03-23 20:18:18.929065+00 | | 2025-03-23 14:18:47.18928+00 |
| public | m_setting_log | 30589 | 1258 | 0.00 | 3.00 | | | | 2025-03-24 12:34:55.89564+00 |
| public | m_site | 0 | 1 | 0 | 100.00 | | | | |
| public | m_tenant | 0 | 0 | 0 | 0 | | | | |
| public | m_tx | 101037 | 9704 | 0.00 | 8.00 | | 2025-03-23 11:35:33.540017+00 | | 2025-03-25 00:50:40.577757+00 |
| public | m_user | 16 | 90 | 5.00 | 84.00 | | | | |
| public | m_zone | 5964 | 2 | 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 | 611 | 0 | 0.00 | 0.00 | | 2025-03-24 07:04:53.845365+00 | | |
| public | r_location_zone | 47864 | 125 | 0.00 | 0.00 | | 2025-03-22 21:50:16.847807+00 | | |
| public | r_pot_auth | 0 | 31 | 0 | 100.00 | | | | |
| public | r_pot_category | 7942 | 0 | 0.00 | 0.00 | | 2025-03-24 20:16:04.254903+00 | | 2025-03-24 20:01:48.305282+00 |
| public | r_pot_group | 160573 | 3253 | 0.00 | 1.00 | | 2025-03-25 00:36:57.077577+00 | | 2025-03-25 00:14:24.925213+00 |
| public | r_pot_tx | 66 | 351 | 5.00 | 84.00 | | | | |
| public | r_pot_user | 13 | 16 | 1.00 | 55.00 | | | | |
| public | r_provider_tenant | 0 | 0 | 0 | 0 | | | | |
| public | r_role_feature | 8 | 0 | 0.00 | 0.00 | | | | |
| public | r_tenant_feature | 3946 | 0 | 0.00 | 0.00 | | 2025-03-23 13:10:52.85292+00 | | |
| public | r_tx_sensor | 0 | 0 | 0 | 0 | | | | |
| public | r_user_region | 13 | 16 | 1.00 | 55.00 | | | | |
| public | r_user_site | 1 | 1 | 1.00 | 50.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 | 2152121 | 7966 | 0.00 | 0.00 | | 2025-03-23 13:11:27.694467+00 | | |
| public | t_general | 20 | 5 | 0.00 | 20.00 | | | | |
| public | t_mobile_device_history | 809086 | 0 | 0.00 | 0.00 | | 2025-03-22 12:31:57.212142+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 4724871 | 6355 | 0.00 | 0.00 | | 2025-03-21 08:10:33.94643+00 | | |
| public | t_operation_log | 112539 | 820 | 0.00 | 0.00 | | | | |
| public | t_plan | 19528839 | 1584416 | 0.00 | 7.00 | | | | 2025-03-25 00:37:00.480192+00 |
| public | t_plan_cancel_history | 323283 | 7469 | 0.00 | 2.00 | | 2025-03-24 08:26:14.577686+00 | | |
| public | t_plan_detail | 33321001 | 2523067 | 0.00 | 7.00 | | | | 2025-03-24 01:36:56.860695+00 |
| public | t_plan_sync | 45833 | 3995 | 0.00 | 8.00 | | 2025-03-25 00:37:00.93125+00 | | 2025-03-25 00:37:01.224083+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 | 119035 | 91096 | 0.00 | 43.00 | | 2025-03-25 00:50:46.973934+00 | 2025-03-24 13:30:07.595275+00 | 2025-03-25 00:50:47.634581+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 144766 | 8996 | 0.00 | 5.00 | | | | 2025-03-24 21:40:30.692845+00 |
| public | t_terminal_log | 210245 | 0 | 0.00 | 0.00 | | | | |
| public | temp_pivot_table | 0 | 0 | 0 | 0 | | | | |
| public | w_arrival_notify | 82 | 6 | 0.00 | 6.00 | | 2025-03-24 15:01:38.191623+00 | | 2025-03-24 15:00:37.742087+00 |
| public | w_latest_position | 63485 | 23196 | 0.00 | 26.00 | | 2025-03-25 00:50:47.767581+00 | | 2025-03-25 00:50:47.922716+00 |
| public | w_latest_presence | 216903 | 170798 | 0.00 | 44.00 | | 2025-03-25 00:50:56.79203+00 | | 2025-03-25 00:50:59.329071+00 |
| public | w_latest_sensor | 386 | 268 | 0.00 | 40.00 | | 2025-03-25 00:50:49.404878+00 | | 2025-03-25 00:50:49.518856+00 |
| public | w_lock | 12 | 0 | 0.00 | 0.00 | | | | |
| public | w_master_update | 184 | 37 | 0.00 | 16.00 | | 2025-03-25 00:15:49.915741+00 | | 2025-03-25 00:14:24.940832+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 | 19471772 | 722927 | 0.00 | 3.00 | | 2025-03-21 06:08:57.378659+00 | | 2025-03-25 00:36:48.898898+00 |