| 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 |
|---|
| e202402 | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202402 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-27 04:34:48.967559+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-27 05:41:01.097107+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-27 04:34:48.978137+00 | | |
| e202402 | t_position_history | 0 | 0 | 0 | 0 | | | | |
| e202402 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202402 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202403 | a_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202403 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202403 | t_position_history | 0 | 0 | 0 | 0 | | | | |
| e202403 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202403 | t_sensor_history | 0 | 0 | 0 | 0 | | | | |
| e202404 | a_proximity_sum | 50129 | 0 | 0.00 | 0.00 | | | | |
| e202404 | a_stay_time | 45442 | 0 | 0.00 | 0.00 | | | | |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-27 04:34:48.989022+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202404 | t_position_history | 884412 | 0 | 0.00 | 0.00 | | | | |
| e202404 | t_presence_history | 7242677 | 109352 | 0.00 | 1.00 | | 2024-04-28 01:41:49.249512+00 | | 2024-04-28 01:35:04.824163+00 |
| e202404 | t_sensor_history | 58575 | 0 | 0.00 | 0.00 | | | | |
| public | __digdag_status | 1 | 16 | 16.00 | 94.00 | | | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-27 04:21:48.124104+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-04-27 04:21:48.093268+00 | | |
| public | b_attendance_group | 392043 | 878 | 0.00 | 0.00 | | 2024-04-27 04:21:46.855858+00 | | |
| public | b_attendance_hour | 5825798 | 13536 | 0.00 | 0.00 | | 2024-04-27 12:54:23.1972+00 | | |
| public | b_attendance_pot | 114 | 0 | 0.00 | 0.00 | | | | |
| public | b_attendance_pot_hour | 1710 | 0 | 0.00 | 0.00 | | | | |
| public | b_check_in | 3085726 | 7956 | 0.00 | 0.00 | | 2024-04-27 16:05:34.07516+00 | | |
| public | b_check_in_hour | 46391910 | 116428 | 0.00 | 0.00 | | 2024-04-27 12:56:12.806505+00 | | |
| public | b_check_in_pot | 114 | 0 | 0.00 | 0.00 | | | | |
| public | b_check_in_pot_hour | 1710 | 0 | 0.00 | 0.00 | | | | |
| public | b_proximity_group | 40119624 | 115186 | 0.00 | 0.00 | | 2024-04-27 14:17:33.231406+00 | | |
| public | b_proximity_info | 31282721 | 8280 | 0.00 | 0.00 | | 2024-04-27 12:53:02.28603+00 | | |
| public | b_seat_reserve | 680848 | 1634 | 0.00 | 0.00 | | 2024-04-27 13:40:34.045315+00 | | |
| public | b_seat_reserve_hour | 12782860 | 29432 | 0.00 | 0.00 | | 2024-04-27 04:21:35.072132+00 | | |
| public | b_usage | 740025 | 1634 | 0.00 | 0.00 | | 2024-04-27 04:21:50.591384+00 | | |
| public | b_usage_hour | 13701374 | 29432 | 0.00 | 0.00 | | 2024-04-27 12:50:25.050434+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-27 04:29:03.365758+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-27 04:29:02.959444+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-27 04:29:03.355288+00 | | |
| public | m_area | 97 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.564157+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-04-27 12:54:23.426303+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.960543+00 | | |
| public | m_exb | 3790 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.607517+00 | | |
| public | m_favorite | 35458 | 0 | 0.00 | 0.00 | | 2024-04-27 12:59:13.478363+00 | | |
| public | m_feature | 156 | 0 | 0.00 | 0.00 | | 2024-04-27 16:20:56.956253+00 | | |
| public | m_group | 0 | 0 | 0 | 0 | | | | |
| public | m_holiday | 5843 | 0 | 0.00 | 0.00 | | 2024-04-27 04:29:06.076724+00 | | |
| public | m_lob | 2272 | 0 | 0.00 | 0.00 | | 2024-04-27 13:01:32.791772+00 | | |
| public | m_location | 5357 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.267369+00 | | |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.783768+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.283371+00 | | |
| public | m_pot | 23691 | 3492 | 0.00 | 12.00 | | 2024-04-27 13:10:34.315303+00 | | 2024-04-28 00:10:44.731613+00 |
| public | m_pot_profile | 661 | 0 | 0.00 | 0.00 | | 2024-04-27 12:54:04.853263+00 | | |
| public | m_provider_user | 58 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.082503+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.684008+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.644294+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-04-27 16:05:24.02556+00 | | |
| public | m_setting | 0 | 346 | 0 | 100.00 | | | | |
| public | m_setting_log | 4252 | 250 | 0.00 | 5.00 | | | | 2024-04-27 12:40:30.577351+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.756745+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.041341+00 | | |
| public | m_tx | 0 | 0 | 0 | 0 | | | | |
| public | m_user | 0 | 0 | 0 | 0 | | | | |
| public | m_zone | 742 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:51.002699+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-04-27 13:40:34.124404+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-04-27 16:05:24.007345+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.805478+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-04-27 13:40:31.711147+00 | | |
| public | r_location_zone | 3360 | 0 | 0.00 | 0.00 | | 2024-04-27 02:02:19.79073+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-04-27 12:54:23.448789+00 | | |
| public | r_pot_category | 971 | 0 | 0.00 | 0.00 | | 2024-04-27 13:01:32.850493+00 | | |
| public | r_pot_group | 10127 | 951 | 0.00 | 8.00 | | 2024-04-27 23:15:31.74089+00 | | 2024-04-27 23:35:10.891483+00 |
| public | r_pot_tx | 8170 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.913478+00 | | |
| public | r_pot_user | 0 | 0 | 0 | 0 | | | | |
| public | r_provider_tenant | 0 | 0 | 0 | 0 | | | | |
| public | r_role_feature | 692 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.628209+00 | | |
| public | r_tenant_feature | 537 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.062665+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:50.930547+00 | | |
| public | r_user_region | 0 | 0 | 0 | 0 | | | | |
| public | r_user_site | 0 | 0 | 0 | 0 | | | | |
| public | r_zone_category | 665 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:48.11318+00 | | |
| public | t_ai_history | 0 | 0 | 0 | 0 | | | | |
| public | t_attendance | 369080 | 654 | 0.00 | 0.00 | | 2024-04-27 16:18:45.457772+00 | | |
| public | t_general | 29 | 0 | 0.00 | 0.00 | | 2024-04-27 16:19:34.668406+00 | | |
| public | t_mobile_device_history | 74905 | 0 | 0.00 | 0.00 | | 2024-04-27 05:41:01.086457+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-04-27 04:21:50.815989+00 | | |
| public | t_notify_history | 439499 | 387 | 0.00 | 0.00 | | 2024-04-27 16:19:38.609136+00 | | |
| public | t_operation_log | 1772613 | 4340 | 0.00 | 0.00 | | 2024-04-27 05:18:08.194548+00 | | |
| public | t_plan | 4303841 | 8117 | 0.00 | 0.00 | | 2024-04-27 13:01:31.309676+00 | | |
| public | t_plan_detail | 5328745 | 9765 | 0.00 | 0.00 | | 2024-04-27 16:21:34.221521+00 | | |
| public | t_plan_sync | 16460 | 968 | 0.00 | 5.00 | | 2024-04-27 23:35:07.686807+00 | | 2024-04-28 00:51:12.624879+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-04-27 04:21:48.024881+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-04-27 12:49:49.511545+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-04-27 13:01:32.809222+00 | | |
| public | t_recv_position_history | 5568 | 1361 | 0.00 | 19.00 | | 2024-04-28 01:45:03.477236+00 | 2024-04-27 12:42:01.477479+00 | 2024-04-28 01:45:03.504516+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-04-27 12:51:25.4282+00 | | |
| public | t_terminal | 13796 | 2253 | 0.00 | 14.00 | | | | 2024-04-28 01:21:36.12502+00 |
| public | t_terminal_log | 3623720 | 0 | 0.00 | 0.00 | | 2024-04-27 04:22:00.269807+00 | | |
| public | w_arrival_notify | 1 | 0 | 0.00 | 0.00 | | 2024-04-27 04:34:49.021205+00 | | |
| public | w_latest_position | 10771 | 414 | 0.00 | 3.00 | | 2024-04-28 01:44:03.633535+00 | | 2024-04-28 01:44:03.657707+00 |
| public | w_latest_presence | 17178 | 11446 | 0.00 | 39.00 | | 2024-04-28 01:45:03.725428+00 | | 2024-04-28 01:45:03.80455+00 |
| public | w_latest_sensor | 113 | 51 | 0.00 | 31.00 | | 2024-04-28 01:44:03.38444+00 | | 2024-04-28 01:44:03.617208+00 |
| public | w_lock | 987 | 0 | 0.00 | 0.00 | | 2024-04-27 04:21:47.519344+00 | | |
| public | w_master_update | 0 | 38 | 0 | 100.00 | | | | |
| public | w_plan_with_detail | 3345452 | 9217 | 0.00 | 0.00 | | 2024-04-27 05:40:52.62014+00 | | |