| 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 | 1793 | 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 | 26083483 | 971 | 0.00 | 0.00 | | | | 2025-03-24 17:37:05.465974+00 |
| e202503 | a_stay_time | 30082004 | 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 | 376779364 | 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 | 41268574 | 3706206 | 0.00 | 8.00 | | 2025-03-26 00:30:33.928081+00 | | 2025-03-26 00:47:45.75885+00 |
| e202503 | t_sensor_history | 10855145 | 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 | 15 | 0.00 | 30.00 | | 2025-03-24 12:35:00.943482+00 | | 2025-03-24 03:31:00.678379+00 |
| public | a_attendance_sum | 90989 | 15482 | 0.00 | 14.00 | | 2025-03-26 00:31:03.941149+00 | | 2025-03-26 00:51:41.505717+00 |
| public | a_plan_actual | 214957 | 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 | 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 | 22110 | 1195 | 0.00 | 5.00 | | | | 2025-03-25 07:09:44.856291+00 |
| public | m_favorite | 227212 | 502 | 0.00 | 0.00 | | 2025-03-22 04:12:53.416117+00 | | |
| public | m_favorite_group | 90173 | 11 | 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 | 18927 | 0 | 0.00 | 0.00 | | 2025-03-25 11:23:36.756429+00 | | |
| public | m_holiday | 0 | 0 | 0 | 0 | | | | |
| public | m_lob | 103 | 30 | 0.00 | 22.00 | | | | |
| public | m_lob_log | 17 | 0 | 0.00 | 0.00 | | | | |
| public | m_location | 154 | 570 | 3.00 | 78.00 | | | | |
| public | m_notify_template | 1 | 5 | 5.00 | 83.00 | | | | |
| public | m_outside | 0 | 0 | 0 | 0 | | | | |
| public | m_pot | 168104 | 26873 | 0.00 | 13.00 | | 2025-03-25 00:14:32.463114+00 | | 2025-03-26 00:47:44.918794+00 |
| public | m_pot_profile | 60 | 20 | 0.00 | 25.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 | 21299 | 342 | 0.00 | 1.00 | | 2025-03-25 19:07:18.820614+00 | | 2025-03-25 03:55:47.611622+00 |
| public | m_setting_log | 30703 | 0 | 0.00 | 0.00 | | | | 2025-03-25 18:12:33.856302+00 |
| public | m_site | 0 | 1 | 0 | 100.00 | | | | |
| public | m_tenant | 0 | 0 | 0 | 0 | | | | |
| public | m_tx | 150316 | 7832 | 0.00 | 4.00 | | 2025-03-25 01:22:15.072316+00 | | 2025-03-25 01:20:14.801009+00 |
| public | m_user | 54 | 250 | 4.00 | 82.00 | | | | |
| public | m_zone | 5964 | 4 | 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 | 47999 | 375 | 0.00 | 0.00 | | 2025-03-22 21:50:16.847807+00 | | |
| public | r_pot_auth | 35 | 33 | 0.00 | 48.00 | | | | |
| public | r_pot_category | 7945 | 0 | 0.00 | 0.00 | | 2025-03-25 20:15:28.904457+00 | | 2025-03-25 20:01:24.063558+00 |
| public | r_pot_group | 155888 | 3256 | 0.00 | 2.00 | | 2025-03-26 00:36:02.957353+00 | | 2025-03-26 00:10:34.944826+00 |
| public | r_pot_tx | 132 | 476 | 3.00 | 78.00 | | | | |
| public | r_pot_user | 43 | 45 | 1.00 | 51.00 | | | | |
| public | r_provider_tenant | 0 | 0 | 0 | 0 | | | | |
| 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 | 43 | 47 | 1.00 | 52.00 | | | | |
| public | r_user_site | 2 | 4 | 2.00 | 66.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 | 2160319 | 16231 | 0.00 | 0.00 | | 2025-03-23 13:11:27.694467+00 | | |
| public | t_general | 25 | 7 | 0.00 | 21.00 | | | | |
| public | t_mobile_device_history | 809903 | 0 | 0.00 | 0.00 | | 2025-03-22 12:31:57.212142+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | | | |
| public | t_notify_history | 4740121 | 6847 | 0.00 | 0.00 | | 2025-03-21 08:10:33.94643+00 | | |
| public | t_operation_log | 162221 | 825 | 0.00 | 0.00 | | | | |
| public | t_plan | 19543101 | 342759 | 0.00 | 1.00 | | 2025-03-25 03:52:15.76498+00 | | 2025-03-25 00:37:00.480192+00 |
| public | t_plan_cancel_history | 325045 | 48439 | 0.00 | 12.00 | | 2025-03-24 08:26:14.577686+00 | | |
| public | t_plan_detail | 33426603 | 2909062 | 0.00 | 8.00 | | | | 2025-03-25 06:08:06.212021+00 |
| public | t_plan_sync | 78946 | 5050 | 0.00 | 6.00 | | 2025-03-26 00:38:03.188086+00 | | 2025-03-26 00:36:03.27943+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 | 116690 | 158432 | 1.00 | 57.00 | | 2025-03-26 00:51:40.295606+00 | 2025-03-25 13:30:08.385342+00 | 2025-03-26 00:51:40.913169+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| public | t_terminal | 145332 | 10117 | 0.00 | 6.00 | | | | 2025-03-25 23:38:07.985744+00 |
| public | t_terminal_log | 264736 | 0 | 0.00 | 0.00 | | | | |
| public | temp_pivot_table | 0 | 0 | 0 | 0 | | | | |
| public | w_arrival_notify | 80 | 18 | 0.00 | 18.00 | | 2025-03-24 15:01:38.191623+00 | | 2025-03-24 15:00:37.742087+00 |
| public | w_latest_position | 64029 | 47427 | 0.00 | 42.00 | | 2025-03-26 00:51:41.013985+00 | | 2025-03-26 00:51:41.162204+00 |
| public | w_latest_presence | 221699 | 311303 | 1.00 | 58.00 | | 2025-03-26 00:51:41.771785+00 | | 2025-03-26 00:51:44.378229+00 |
| public | w_latest_sensor | 386 | 474 | 1.00 | 55.00 | | 2025-03-26 00:51:41.520037+00 | | 2025-03-26 00:51:41.630511+00 |
| public | w_lock | 15933 | 0 | 0.00 | 0.00 | | 2025-03-25 08:54:38.045793+00 | | |
| public | w_master_update | 184 | 43 | 0.00 | 18.00 | | 2025-03-25 23:38:04.824358+00 | | 2025-03-25 23:21:49.24928+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 | 19535125 | 964021 | 0.00 | 4.00 | | 2025-03-21 06:08:57.378659+00 | | 2025-03-25 00:36:48.898898+00 |