| 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 |
|---|
| e202408 | a_proximity_sum | 696334 | 0 | 0.00 | 0.00 | | 2024-10-23 05:05:14.726333+00 | | |
| e202408 | a_stay_time | 2193491 | 0 | 0.00 | 0.00 | | 2024-10-24 06:16:41.971728+00 | | |
| e202408 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-22 09:00:43.977145+00 | | |
| e202408 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-22 09:00:43.910163+00 | | |
| e202408 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-22 09:04:32.088993+00 | | |
| e202408 | t_position_history | 27712893 | 0 | 0.00 | 0.00 | | 2024-10-23 08:29:42.311325+00 | | |
| e202408 | t_presence_history | 5120369 | 0 | 0.00 | 0.00 | | 2024-10-23 02:22:09.056223+00 | | |
| e202408 | t_sensor_history | 1196033 | 0 | 0.00 | 0.00 | | 2024-10-25 08:55:40.607438+00 | | |
| e202409 | a_proximity_sum | 881183 | 0 | 0.00 | 0.00 | | 2024-10-24 06:28:40.754451+00 | | |
| e202409 | a_stay_time | 2549850 | 0 | 0.00 | 0.00 | | 2024-10-23 06:13:12.199913+00 | | |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-23 07:39:13.00901+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-23 07:39:12.668384+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-23 07:39:12.65064+00 | | |
| e202409 | t_position_history | 30787929 | 0 | 0.00 | 0.00 | | 2024-10-29 01:17:53.199012+00 | | |
| e202409 | t_presence_history | 6027245 | 0 | 0.00 | 0.00 | | 2024-10-23 19:40:41.836733+00 | | |
| e202409 | t_sensor_history | 1163403 | 0 | 0.00 | 0.00 | | 2024-10-23 04:19:21.634993+00 | | |
| e202410 | a_proximity_sum | 934959 | 0 | 0.00 | 0.00 | | 2024-10-28 09:36:37.354214+00 | | 2024-10-28 15:31:31.424719+00 |
| e202410 | a_stay_time | 2835486 | 0 | 0.00 | 0.00 | | 2024-10-28 09:36:46.005156+00 | | 2024-10-28 15:30:32.251738+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-23 13:25:55.121278+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-23 13:25:55.091311+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-23 13:25:55.102664+00 | | |
| e202410 | t_position_history | 34889061 | 0 | 0.00 | 0.00 | | 2024-10-26 21:39:52.653923+00 | | 2024-10-29 23:37:01.175338+00 |
| e202410 | t_presence_history | 7548617 | 567409 | 0.00 | 6.00 | | 2024-10-30 01:28:28.613443+00 | | 2024-10-30 01:26:19.292661+00 |
| e202410 | t_sensor_history | 1223966 | 0 | 0.00 | 0.00 | | 2024-10-26 04:54:00.361152+00 | | 2024-10-29 03:22:14.031407+00 |
| public | __digdag_status | 6 | 36 | 6.00 | 85.00 | | 2024-10-26 13:10:33.422244+00 | | 2024-10-28 21:50:48.164429+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-10-21 05:49:05.680757+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:55.147438+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-28 08:14:35.379014+00 | | |
| public | b_attendance_group | 486951 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.372943+00 | | |
| public | b_attendance_hour | 7304213 | 0 | 0.00 | 0.00 | | 2024-10-28 11:23:46.743681+00 | | |
| public | b_attendance_pot | 270687 | 0 | 0.00 | 0.00 | | 2024-10-24 16:17:19.106803+00 | | 2024-10-24 18:41:00.274672+00 |
| public | b_attendance_pot_hour | 4193048 | 0 | 0.00 | 0.00 | | 2024-10-24 05:08:57.742587+00 | | 2024-10-24 18:41:04.314104+00 |
| public | b_check_in | 3930986 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:31.544344+00 | | |
| public | b_check_in_hour | 58975816 | 0 | 0.00 | 0.00 | | 2024-10-28 11:24:04.27664+00 | | |
| public | b_check_in_pot | 147192 | 0 | 0.00 | 0.00 | | 2024-10-25 02:17:18.464078+00 | | 2024-10-22 18:20:35.817639+00 |
| public | b_check_in_pot_hour | 2818534 | 0 | 0.00 | 0.00 | | 2024-10-24 07:00:42.188658+00 | | 2024-10-19 18:26:52.270677+00 |
| public | b_proximity_group | 32970139 | 0 | 0.00 | 0.00 | | 2024-10-28 12:11:21.020351+00 | | |
| public | b_proximity_info | 29419385 | 0 | 0.00 | 0.00 | | 2024-10-25 02:16:16.54021+00 | | |
| public | b_seat_reserve | 886941 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:26.31841+00 | | |
| public | b_seat_reserve_hour | 16647655 | 0 | 0.00 | 0.00 | | 2024-10-28 08:14:35.244134+00 | | |
| public | b_usage | 996250 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.850154+00 | | |
| public | b_usage_hour | 18228752 | 0 | 0.00 | 0.00 | | 2024-10-28 11:14:40.66615+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-28 08:20:37.601081+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-28 08:20:37.583442+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-28 08:21:00.98664+00 | | |
| public | m_area | 93 | 0 | 0.00 | 0.00 | | 2024-10-28 12:33:18.585557+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-10-28 11:28:05.307697+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.941145+00 | | |
| public | m_exb | 4297 | 0 | 0.00 | 0.00 | | 2024-10-28 00:31:57.781913+00 | | |
| public | m_favorite | 35390 | 106 | 0.00 | 0.00 | | 2024-10-27 09:43:20.750605+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 7497 | 0 | 0.00 | 0.00 | | 2024-10-30 01:37:29.427463+00 | | 2024-10-25 08:55:40.648705+00 |
| public | m_feature | 165 | 0 | 0.00 | 0.00 | | 2024-10-28 12:42:32.844822+00 | | |
| public | m_group | 2320 | 0 | 0.00 | 0.00 | | 2024-10-27 18:33:14.838391+00 | | |
| public | m_holiday | 5588 | 0 | 0.00 | 0.00 | | 2024-10-28 08:20:37.621813+00 | | |
| public | m_lob | 1171 | 2 | 0.00 | 0.00 | | 2024-10-27 18:33:15.040979+00 | | |
| public | m_location | 5434 | 0 | 0.00 | 0.00 | | 2024-10-27 18:33:14.965317+00 | | |
| public | m_notify_template | 124 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.904151+00 | | |
| public | m_outside | 63 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.163872+00 | | |
| public | m_pot | 28276 | 219 | 0.00 | 0.00 | | 2024-10-30 01:28:49.48096+00 | | 2024-10-30 00:15:42.888146+00 |
| public | m_pot_profile | 671 | 9 | 0.00 | 1.00 | | 2024-10-28 11:23:43.470573+00 | | |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.118745+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 12:32:17.633999+00 | | |
| public | m_role | 79 | 0 | 0.00 | 0.00 | | 2024-10-28 12:33:18.568388+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:30.439106+00 | | |
| public | m_setting | 2288 | 503 | 0.00 | 18.00 | | 2024-10-27 19:22:22.248284+00 | | 2024-10-29 07:58:57.519703+00 |
| public | m_setting_log | 4794 | 866 | 0.00 | 15.00 | | 2024-10-25 12:30:21.440925+00 | | 2024-10-29 12:30:20.193126+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.885637+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.082778+00 | | |
| public | m_tx | 38509 | 2 | 0.00 | 0.00 | | 2024-10-27 03:50:28.181989+00 | | 2024-10-17 11:05:09.379783+00 |
| public | m_user | 3252 | 0 | 0.00 | 0.00 | | 2024-10-28 23:56:22.596594+00 | | |
| public | m_zone | 751 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.23092+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-28 11:43:25.973878+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:30.418866+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.187193+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:25.984069+00 | | |
| public | r_location_zone | 6026 | 0 | 0.00 | 0.00 | | 2024-10-23 01:46:03.830481+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-10-28 11:28:05.330443+00 | | |
| public | r_pot_category | 991 | 0 | 0.00 | 0.00 | | 2024-10-28 11:27:05.306361+00 | | |
| public | r_pot_group | 11700 | 867 | 0.00 | 6.00 | | 2024-10-29 23:12:54.37448+00 | | 2024-10-29 23:33:40.69324+00 |
| public | r_pot_tx | 9624 | 12 | 0.00 | 0.00 | | 2024-10-22 07:55:20.160319+00 | | |
| public | r_pot_user | 3023 | 0 | 0.00 | 0.00 | | 2024-10-28 23:56:22.497034+00 | | |
| public | r_provider_tenant | 161 | 0 | 0.00 | 0.00 | | 2024-10-24 13:27:47.373242+00 | | |
| public | r_role_feature | 598 | 0 | 0.00 | 0.00 | | 2024-10-27 13:31:54.74472+00 | | |
| public | r_tenant_feature | 645 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.101252+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.208593+00 | | |
| public | r_user_region | 3081 | 0 | 0.00 | 0.00 | | 2024-10-28 23:56:22.536161+00 | | |
| public | r_user_site | 356 | 0 | 0.00 | 0.00 | | 2024-10-25 01:57:04.488697+00 | | |
| public | r_zone_category | 684 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.135814+00 | | |
| public | t_ai_history | 33 | 0 | 0.00 | 0.00 | | 2024-10-29 11:21:06.475001+00 | | |
| public | t_attendance | 520626 | 1818 | 0.00 | 0.00 | | 2024-10-28 12:33:25.971598+00 | | |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-10-28 12:32:17.617736+00 | | |
| public | t_mobile_device_history | 96494 | 0 | 0.00 | 0.00 | | 2024-10-28 08:45:04.064105+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:36.915455+00 | | |
| public | t_notify_history | 532319 | 2061 | 0.00 | 0.00 | | 2024-10-28 12:32:19.904995+00 | | 2024-10-24 15:03:15.635118+00 |
| public | t_operation_log | 2437912 | 0 | 0.00 | 0.00 | | 2024-10-28 08:31:04.238095+00 | | |
| public | t_plan | 4060557 | 135026 | 0.00 | 3.00 | | 2024-10-28 01:39:53.550293+00 | | 2024-10-29 21:03:39.044527+00 |
| public | t_plan_detail | 4913130 | 378308 | 0.00 | 7.00 | | 2024-10-22 00:17:42.365363+00 | | 2024-10-29 04:04:22.793788+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-10-21 04:31:29.420299+00 | | |
| public | t_plan_sync | 233292 | 27691 | 0.00 | 10.00 | | 2024-10-24 10:49:15.456696+00 | | 2024-10-29 09:18:07.942033+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:55.066068+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:14:33.256327+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-28 11:27:05.267224+00 | | |
| public | t_recv_position_history | 6839 | 3208 | 0.00 | 31.00 | | 2024-10-30 01:44:30.132846+00 | 2024-10-29 12:42:01.275954+00 | 2024-10-30 01:44:30.163078+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:16:33.309088+00 | | |
| public | t_terminal | 22572 | 1752 | 0.00 | 7.00 | | 2024-10-23 01:49:04.40845+00 | | 2024-10-29 21:10:36.928343+00 |
| public | t_terminal_log | 4910353 | 0 | 0.00 | 0.00 | | 2024-10-28 08:18:00.652956+00 | | |
| public | w_arrival_notify | 2 | 2 | 1.00 | 50.00 | | 2024-10-28 08:21:01.038349+00 | | |
| public | w_latest_position | 10683 | 2253 | 0.00 | 17.00 | | 2024-10-30 01:44:30.044384+00 | | 2024-10-30 01:44:30.072885+00 |
| public | w_latest_presence | 17149 | 30178 | 1.00 | 63.00 | | 2024-10-30 01:44:30.28825+00 | | 2024-10-30 01:44:30.398348+00 |
| public | w_latest_sensor | 163 | 23 | 0.00 | 12.00 | | 2024-10-30 01:44:30.024623+00 | | 2024-10-30 01:43:30.214294+00 |
| public | w_lock | 1052 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:54.791118+00 | | |
| public | w_master_update | 17 | 17 | 1.00 | 50.00 | | 2024-10-29 09:40:31.661356+00 | | 2024-10-28 09:30:49.316997+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_with_detail | 4050800 | 163869 | 0.00 | 3.00 | | 2024-10-27 11:32:59.532396+00 | | 2024-10-29 16:59:03.742098+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-10-21 04:18:12.159276+00 | | |