| 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 |
|---|---|---|---|---|---|---|---|---|---|
| e202310 | a_proximity_sum | 6281830 | 36700 | 0.00 | 0.00 | ||||
| e202310 | a_stay_time | 2029664 | 10922 | 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 | 35718495 | 253626 | 0.00 | 0.00 | ||||
| e202310 | t_presence_history | 6554658 | 1209432462 | 184.00 | 99.00 | ||||
| e202310 | t_sensor_history | 2076809 | 4 | 0.00 | 0.00 | ||||
| e202311 | a_proximity_sum | 513156 | 18 | 0.00 | 0.00 | ||||
| e202311 | a_stay_time | 2007402 | 573 | 0.00 | 0.00 | ||||
| e202311 | l_position_history | 0 | 0 | 0 | 0 | ||||
| e202311 | l_proximity_sum | 0 | 0 | 0 | 0 | ||||
| e202311 | l_stay_time | 0 | 0 | 0 | 0 | ||||
| e202311 | t_position_history | 34857097 | 0 | 0.00 | 0.00 | ||||
| e202311 | t_presence_history | 6297156 | 1263772314 | 200.00 | 99.00 | ||||
| e202311 | t_sensor_history | 1717515 | 0 | 0.00 | 0.00 | ||||
| e202312 | a_proximity_sum | 51246 | 0 | 0.00 | 0.00 | ||||
| e202312 | a_stay_time | 110768 | 0 | 0.00 | 0.00 | ||||
| e202312 | l_position_history | 0 | 0 | 0 | 0 | ||||
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | ||||
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | ||||
| e202312 | t_position_history | 2589926 | 0 | 0.00 | 0.00 | ||||
| e202312 | t_presence_history | 451304 | 85562962 | 189.00 | 99.00 | ||||
| e202312 | t_sensor_history | 157598 | 0 | 0.00 | 0.00 | ||||
| public | __digdag_status | 0 | 486 | 0 | 100.00 | ||||
| public | a_proximity_sum | 0 | 0 | 0 | 0 | ||||
| public | a_stay_time | 0 | 0 | 0 | 0 | ||||
| public | b_attendance_group | 86774 | 34056 | 0.00 | 28.00 | ||||
| public | b_attendance_hour | 1179316 | 745586 | 0.00 | 38.00 | ||||
| public | b_attendance_pot | 0 | 0 | 0 | 0 | ||||
| public | b_attendance_pot_hour | 0 | 0 | 0 | 0 | ||||
| public | b_check_in | 867348 | 35435 | 0.00 | 3.00 | ||||
| public | b_check_in_hour | 12662555 | 767190 | 0.00 | 5.00 | ||||
| public | b_proximity_group | 11572212 | 1669486 | 0.00 | 12.00 | ||||
| public | b_proximity_info | 14287692 | 260362 | 0.00 | 1.00 | ||||
| public | b_seat_reserve | 184188 | 960 | 0.00 | 0.00 | ||||
| public | b_seat_reserve_hour | 3382003 | 16282 | 0.00 | 0.00 | ||||
| public | b_usage | 181207 | 33668 | 0.00 | 15.00 | ||||
| public | b_usage_hour | 3165938 | 737321 | 0.00 | 18.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 | 10 | 14 | 1.00 | 58.00 | ||||
| public | m_auth | 0 | 0 | 0 | 0 | ||||
| public | m_category | 43 | 61 | 1.00 | 58.00 | ||||
| public | m_exb | 97 | 797 | 8.00 | 89.00 | ||||
| public | m_favorite | 4784 | 429 | 0.00 | 8.00 | ||||
| public | m_feature | 8 | 17 | 2.00 | 68.00 | ||||
| public | m_group | 40 | 595 | 14.00 | 93.00 | ||||
| public | m_holiday | 1350 | 0 | 0.00 | 0.00 | ||||
| public | m_lob | 68 | 79 | 1.00 | 53.00 | ||||
| public | m_location | 140 | 1310 | 9.00 | 90.00 | ||||
| public | m_notify_template | 11 | 9 | 0.00 | 45.00 | ||||
| public | m_outside | 8 | 6 | 0.00 | 42.00 | ||||
| public | m_pot | 335 | 43276 | 129.00 | 99.00 | ||||
| public | m_pot_profile | 40 | 71 | 1.00 | 63.00 | ||||
| public | m_provider_user | 0 | 2 | 0 | 100.00 | ||||
| public | m_region | 1 | 2 | 2.00 | 66.00 | ||||
| public | m_role | 5 | 5 | 1.00 | 50.00 | ||||
| public | m_sensor | 0 | 0 | 0 | 0 | ||||
| public | m_setting | 288 | 24596 | 85.00 | 98.00 | ||||
| public | m_setting_log | 162 | 31280 | 193.00 | 99.00 | ||||
| public | m_site | 1 | 1 | 1.00 | 50.00 | ||||
| public | m_tenant | 1 | 2 | 2.00 | 66.00 | ||||
| public | m_tx | 550 | 141649 | 257.00 | 99.00 | ||||
| public | m_user | 295 | 516 | 1.00 | 63.00 | ||||
| public | m_zone | 207 | 522 | 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 | 16 | 6 | 0.00 | 27.00 | ||||
| public | r_location_zone | 305 | 3680 | 12.00 | 92.00 | ||||
| public | r_pot_auth | 0 | 15 | 0 | 100.00 | ||||
| public | r_pot_category | 10 | 74 | 7.00 | 88.00 | ||||
| public | r_pot_group | 0 | 1549581 | 0 | 100.00 | ||||
| public | r_pot_tx | 280 | 3766 | 13.00 | 93.00 | ||||
| public | r_pot_user | 257 | 341 | 1.00 | 57.00 | ||||
| public | r_role_feature | 216 | 70 | 0.00 | 24.00 | ||||
| public | r_tenant_feature | 69 | 48 | 0.00 | 41.00 | ||||
| public | r_tx_sensor | 0 | 0 | 0 | 0 | ||||
| public | r_user_region | 255 | 548 | 2.00 | 68.00 | ||||
| public | r_user_site | 219 | 256 | 1.00 | 53.00 | ||||
| public | r_zone_category | 200 | 118 | 0.00 | 37.00 | ||||
| public | t_attendance | 80229 | 82273 | 1.00 | 50.00 | ||||
| public | t_general | 0 | 2 | 0 | 100.00 | ||||
| public | t_mobile_device_history | 16908 | 47 | 0.00 | 0.00 | ||||
| public | t_news | 0 | 0 | 0 | 0 | ||||
| public | t_notify_history | 99674 | 29915 | 0.00 | 23.00 | ||||
| public | t_operation_log | 409309 | 48556 | 0.00 | 10.00 | ||||
| public | t_plan | 927647 | 1153707 | 1.00 | 55.00 | ||||
| public | t_plan_detail | 1047162 | 934742 | 0.00 | 47.00 | ||||
| public | t_plan_sync | 477 | 189638 | 397.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 | 6934 | 2173397 | 313.00 | 99.00 | 2023-12-03 12:42:01.888248+00 | |||
| public | t_sensor_history | 0 | 0 | 0 | 0 | ||||
| public | t_terminal | 4583 | 31583 | 6.00 | 87.00 | ||||
| public | t_terminal_log | 998311 | 0 | 0.00 | 0.00 | ||||
| public | w_arrival_notify | 0 | 78 | 0 | 100.00 | ||||
| public | w_latest_position | 342 | 5044564 | 14750.00 | 99.00 | ||||
| public | w_latest_presence | 16233 | 15937965 | 981.00 | 99.00 | 2023-12-03 12:42:07.256442+00 | 2023-12-03 12:42:07.290068+00 | ||
| public | w_latest_sensor | 0 | 241550 | 0 | 100.00 | ||||
| public | w_lock | 107 | 0 | 0.00 | 0.00 | ||||
| public | w_master_update | 1 | 73 | 73.00 | 98.00 | ||||
| public | w_plan_with_detail | 927669 | 1634596 | 1.00 | 63.00 |