| 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 |
|---|---|---|---|---|---|---|---|---|---|
| e202308 | a_proximity_sum | 57135 | 0 | 0.00 | 0.00 | ||||
| e202308 | a_stay_time | 221592 | 0 | 0.00 | 0.00 | ||||
| e202308 | l_position_history | 0 | 0 | 0 | 0 | ||||
| e202308 | l_proximity_sum | 0 | 0 | 0 | 0 | ||||
| e202308 | l_stay_time | 0 | 0 | 0 | 0 | ||||
| e202308 | t_position_history | 3071185 | 0 | 0.00 | 0.00 | ||||
| e202308 | t_presence_history | 596525 | 90641854 | 151.00 | 99.00 | ||||
| e202308 | t_sensor_history | 175742 | 0 | 0.00 | 0.00 | ||||
| e202309 | a_proximity_sum | 384445 | 3845 | 0.00 | 0.00 | ||||
| e202309 | a_stay_time | 1788030 | 5025 | 0.00 | 0.00 | ||||
| e202309 | l_position_history | 0 | 0 | 0 | 0 | ||||
| e202309 | l_proximity_sum | 0 | 0 | 0 | 0 | ||||
| e202309 | l_stay_time | 0 | 0 | 0 | 0 | ||||
| e202309 | t_position_history | 30509590 | 93340 | 0.00 | 0.00 | ||||
| e202309 | t_presence_history | 6293950 | 1196785748 | 190.00 | 99.00 | ||||
| e202309 | t_sensor_history | 2389396 | 10 | 0.00 | 0.00 | ||||
| e202310 | a_proximity_sum | 244277 | 0 | 0.00 | 0.00 | ||||
| e202310 | a_stay_time | 1164313 | 0 | 0.00 | 0.00 | ||||
| e202310 | l_position_history | 0 | 0 | 0 | 0 | ||||
| e202310 | l_proximity_sum | 0 | 0 | 0 | 0 | ||||
| e202310 | l_stay_time | 0 | 0 | 0 | 0 | ||||
| e202310 | t_position_history | 20564337 | 0 | 0.00 | 0.00 | ||||
| e202310 | t_presence_history | 3874845 | 616735700 | 159.00 | 99.00 | ||||
| e202310 | t_sensor_history | 1304466 | 4 | 0.00 | 0.00 | ||||
| public | __digdag_status | 0 | 264 | 0 | 100.00 | ||||
| public | a_proximity_sum | 0 | 0 | 0 | 0 | ||||
| public | a_stay_time | 0 | 0 | 0 | 0 | ||||
| public | b_attendance_group | 62919 | 246 | 0.00 | 0.00 | ||||
| public | b_attendance_hour | 1008708 | 4217 | 0.00 | 0.00 | ||||
| public | b_attendance_pot | 0 | 0 | 0 | 0 | ||||
| public | b_attendance_pot_hour | 0 | 0 | 0 | 0 | ||||
| public | b_check_in | 468095 | 517 | 0.00 | 0.00 | ||||
| public | b_check_in_hour | 6972763 | 8909 | 0.00 | 0.00 | ||||
| public | b_proximity_group | 6928742 | 1014 | 0.00 | 0.00 | ||||
| public | b_proximity_info | 1369508 | 6040 | 0.00 | 0.00 | ||||
| public | b_seat_reserve | 96293 | 213 | 0.00 | 0.00 | ||||
| public | b_seat_reserve_hour | 1772140 | 3651 | 0.00 | 0.00 | ||||
| public | b_usage | 112438 | 213 | 0.00 | 0.00 | ||||
| public | b_usage_hour | 2050030 | 3651 | 0.00 | 0.00 | ||||
| public | l_position_history | 0 | 0 | 0 | 0 | ||||
| public | l_proximity_sum | 0 | 0 | 0 | 0 | ||||
| public | l_stay_time | 0 | 0 | 0 | 0 | ||||
| public | m_area | 6 | 12 | 2.00 | 66.00 | ||||
| public | m_auth | 0 | 0 | 0 | 0 | ||||
| public | m_category | 40 | 38 | 0.00 | 48.00 | ||||
| public | m_exb | 104 | 347 | 3.00 | 76.00 | ||||
| public | m_favorite | 2939 | 191 | 0.00 | 6.00 | ||||
| public | m_feature | 6 | 17 | 2.00 | 73.00 | ||||
| public | m_group | 129 | 275 | 2.00 | 68.00 | ||||
| public | m_holiday | 1350 | 0 | 0.00 | 0.00 | ||||
| public | m_lob | 30 | 36 | 1.00 | 54.00 | ||||
| public | m_location | 126 | 643 | 5.00 | 83.00 | ||||
| public | m_notify_template | 11 | 0 | 0.00 | 0.00 | ||||
| public | m_outside | 5 | 2 | 0.00 | 28.00 | ||||
| public | m_pot | 972 | 28316 | 29.00 | 96.00 | ||||
| public | m_pot_profile | 35 | 24 | 0.00 | 40.00 | ||||
| public | m_provider_user | 1 | 0 | 0.00 | 0.00 | ||||
| public | m_region | 1 | 1 | 1.00 | 50.00 | ||||
| public | m_role | 4 | 2 | 0.00 | 33.00 | ||||
| public | m_sensor | 0 | 0 | 0 | 0 | ||||
| public | m_setting | 181 | 12875 | 71.00 | 98.00 | ||||
| public | m_setting_log | 581 | 12572 | 21.00 | 95.00 | ||||
| public | m_site | 1 | 0 | 0.00 | 0.00 | ||||
| public | m_tenant | 1 | 0 | 0.00 | 0.00 | ||||
| public | m_tx | 393 | 76774 | 195.00 | 99.00 | ||||
| public | m_user | 208 | 289 | 1.00 | 58.00 | ||||
| public | m_zone | 203 | 508 | 2.00 | 71.00 | ||||
| public | r_auth_group | 0 | 0 | 0 | 0 | ||||
| public | r_auth_zone | 0 | 0 | 0 | 0 | ||||
| public | r_exb_sensor | 0 | 0 | 0 | 0 | ||||
| public | r_group_auth | 10 | 6 | 0.00 | 37.00 | ||||
| public | r_location_zone | 197 | 1653 | 8.00 | 89.00 | ||||
| public | r_pot_auth | 0 | 14 | 0 | 100.00 | ||||
| public | r_pot_category | 9 | 60 | 6.00 | 86.00 | ||||
| public | r_pot_group | 339 | 802398 | 2366.00 | 99.00 | ||||
| public | r_pot_tx | 338 | 3206 | 9.00 | 90.00 | ||||
| public | r_pot_user | 180 | 111 | 0.00 | 38.00 | ||||
| public | r_role_feature | 226 | 24 | 0.00 | 9.00 | ||||
| public | r_tenant_feature | 59 | 9 | 0.00 | 13.00 | ||||
| public | r_tx_sensor | 0 | 0 | 0 | 0 | ||||
| public | r_user_region | 180 | 315 | 1.00 | 63.00 | ||||
| public | r_user_site | 137 | 51 | 0.00 | 27.00 | ||||
| public | r_zone_category | 202 | 49 | 0.00 | 19.00 | ||||
| public | t_attendance | 42146 | 42212 | 1.00 | 50.00 | ||||
| public | t_general | 0 | 2 | 0 | 100.00 | ||||
| public | t_mobile_device_history | 10124 | 12 | 0.00 | 0.00 | ||||
| public | t_news | 0 | 0 | 0 | 0 | ||||
| public | t_notify_history | 50561 | 13873 | 0.00 | 21.00 | ||||
| public | t_operation_log | 242836 | 1509 | 0.00 | 0.00 | ||||
| public | t_plan | 499145 | 611534 | 1.00 | 55.00 | ||||
| public | t_plan_detail | 594072 | 505837 | 0.00 | 45.00 | ||||
| public | t_plan_sync | 304 | 90145 | 296.00 | 99.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 | 6621 | 2175124 | 328.00 | 99.00 | 2023-10-18 12:42:01.53903+00 | |||
| public | t_sensor_history | 0 | 0 | 0 | 0 | ||||
| public | t_terminal | 2404 | 13035 | 5.00 | 84.00 | ||||
| public | t_terminal_log | 513551 | 0 | 0.00 | 0.00 | ||||
| public | w_arrival_notify | 0 | 42 | 0 | 100.00 | ||||
| public | w_latest_position | 254 | 1836232 | 7229.00 | 99.00 | ||||
| public | w_latest_presence | 12027 | 27547357 | 2290.00 | 99.00 | 2023-10-18 12:42:31.58653+00 | 2023-10-18 12:42:31.6491+00 | ||
| public | w_latest_sensor | 0 | 126666 | 0 | 100.00 | ||||
| public | w_lock | 79 | 0 | 0.00 | 0.00 | ||||
| public | w_master_update | 1 | 196 | 196.00 | 99.00 | ||||
| public | w_plan_with_detail | 499142 | 980669 | 1.00 | 66.00 |