| 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 | 30539341 | 0 | 0.00 | 0.00 | | 2024-04-10 01:28:52.248958+00 | | 2024-02-28 18:03:25.795511+00 |
| e202402 | a_stay_time | 17176554 | 0 | 0.00 | 0.00 | | 2024-04-10 01:28:52.181332+00 | | 2024-02-28 16:55:43.897188+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-18 02:04:55.010212+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-18 02:04:55.02143+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-18 02:04:54.998917+00 | | |
| e202402 | t_position_history | 355399949 | 0 | 0.00 | 0.00 | | 2024-04-11 07:25:46.544671+00 | | 2024-02-28 06:24:03.251416+00 |
| e202402 | t_presence_history | 40155308 | 0 | 0.00 | 0.00 | | 2024-04-19 02:49:32.10574+00 | | 2024-03-11 14:49:28.789296+00 |
| e202402 | t_sensor_history | 15047880 | 0 | 0.00 | 0.00 | | 2024-04-10 03:59:00.061825+00 | | 2024-02-28 11:55:22.157867+00 |
| e202403 | a_proximity_sum | 41119908 | 0 | 0.00 | 0.00 | | 2024-04-06 10:48:59.929252+00 | | 2024-03-30 16:19:49.867598+00 |
| e202403 | a_stay_time | 19568077 | 0 | 0.00 | 0.00 | | 2024-04-10 18:30:24.131815+00 | | 2024-03-29 15:10:19.442279+00 |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-09 03:20:52.531975+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-09 03:20:52.542919+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-09 03:20:52.520997+00 | | |
| e202403 | t_position_history | 389454187 | 0 | 0.00 | 0.00 | | 2024-04-09 11:01:19.466708+00 | | 2024-03-29 13:58:09.948045+00 |
| e202403 | t_presence_history | 38893088 | 0 | 0.00 | 0.00 | | 2024-04-20 18:49:21.79831+00 | | 2024-03-31 14:59:48.915433+00 |
| e202403 | t_sensor_history | 15240023 | 0 | 0.00 | 0.00 | | 2024-04-08 06:07:02.135974+00 | | 2024-03-30 16:18:49.861644+00 |
| e202404 | a_proximity_sum | 27998287 | 0 | 0.00 | 0.00 | | 2024-04-19 15:12:36.472921+00 | | 2024-04-19 16:21:36.002084+00 |
| e202404 | a_stay_time | 14968845 | 2 | 0.00 | 0.00 | | 2024-04-18 17:42:09.911324+00 | | 2024-04-19 15:07:12.177096+00 |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-17 07:45:10.378889+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-17 07:45:10.356299+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-17 07:45:10.367364+00 | | |
| e202404 | t_position_history | 299951617 | 0 | 0.00 | 0.00 | | 2024-04-19 01:20:03.008208+00 | | 2024-04-19 03:19:45.631363+00 |
| e202404 | t_presence_history | 27292277 | 1817392 | 0.00 | 6.00 | | 2024-04-21 00:48:07.792377+00 | | 2024-04-21 00:48:13.631621+00 |
| e202404 | t_sensor_history | 6090907 | 0 | 0.00 | 0.00 | | 2024-04-19 04:30:41.755947+00 | | 2024-04-20 06:10:27.63228+00 |
| public | __digdag_status | 31 | 13 | 0.00 | 29.00 | | 2024-04-20 03:30:15.529953+00 | | 2024-04-19 08:30:49.004883+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.142519+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.130564+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:07.811079+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:08.931416+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.431756+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:08.946782+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:08.965655+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.449592+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.416347+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-04-12 12:23:07.882149+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.471334+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-04-12 12:22:46.492484+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.944734+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.933308+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.921818+00 | | |
| public | m_area | 652 | 31 | 0.00 | 4.00 | | 2024-04-12 04:40:21.968008+00 | | 2024-04-09 02:54:59.648083+00 |
| public | m_auth | 115 | 20 | 0.00 | 14.00 | | 2024-04-09 06:15:04.163842+00 | | 2024-04-11 07:50:05.160199+00 |
| public | m_category | 1708 | 9 | 0.00 | 0.00 | | 2024-04-12 04:40:22.036846+00 | | 2024-03-26 09:54:33.731031+00 |
| public | m_exb | 20332 | 2965 | 0.00 | 12.00 | | 2024-04-14 11:07:30.845914+00 | | 2024-04-16 06:22:35.710103+00 |
| public | m_favorite | 150668 | 1496 | 0.00 | 0.00 | | 2024-04-10 03:58:59.93128+00 | | 2024-04-16 09:39:37.123302+00 |
| public | m_feature | 154 | 0 | 0.00 | 0.00 | | 2024-04-10 01:28:43.126195+00 | | |
| public | m_group | 14920 | 35 | 0.00 | 0.00 | | 2024-04-16 11:19:27.011374+00 | | 2024-04-12 05:03:22.848128+00 |
| public | m_holiday | 25444 | 0 | 0.00 | 0.00 | | 2024-04-20 03:40:38.977575+00 | | 2024-04-05 09:50:14.889678+00 |
| public | m_lob | 15197 | 0 | 0.00 | 0.00 | | 2024-04-21 00:01:33.953147+00 | | 2024-04-01 12:34:27.798233+00 |
| public | m_location | 35038 | 712 | 0.00 | 1.00 | | 2024-04-17 11:20:41.132292+00 | | 2024-04-14 12:02:40.239187+00 |
| public | m_notify_template | 741 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.361766+00 | | 2024-03-13 07:21:28.594642+00 |
| public | m_outside | 292 | 0 | 0.00 | 0.00 | | 2024-04-18 07:06:57.719941+00 | | 2024-04-15 08:25:45.503434+00 |
| public | m_pot | 188225 | 28715 | 0.00 | 13.00 | | 2024-04-17 00:08:16.218307+00 | | 2024-04-19 12:32:37.961907+00 |
| public | m_pot_profile | 35767 | 198 | 0.00 | 0.00 | | 2024-04-10 03:58:58.188534+00 | | 2024-04-11 07:45:26.966164+00 |
| public | m_provider_user | 68 | 4 | 0.00 | 5.00 | | 2024-04-10 03:11:23.861584+00 | | 2024-03-28 09:27:17.588147+00 |
| public | m_region | 102 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.439114+00 | | |
| public | m_role | 539 | 5 | 0.00 | 0.00 | | 2024-04-09 06:15:04.422069+00 | | 2024-03-28 02:18:51.575265+00 |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.291489+00 | | |
| public | m_setting | 16589 | 890 | 0.00 | 5.00 | | 2024-04-20 02:50:19.209142+00 | | 2024-04-19 19:54:59.909291+00 |
| public | m_setting_log | 25831 | 1114 | 0.00 | 4.00 | 2024-02-16 03:34:50.060418+00 | 2024-04-16 07:20:05.848242+00 | | 2024-04-20 09:16:31.132581+00 |
| public | m_site | 173 | 2 | 0.00 | 1.00 | | 2024-04-09 06:15:04.3252+00 | | |
| public | m_tenant | 101 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.589666+00 | | |
| public | m_tx | 121665 | 2944 | 0.00 | 2.00 | | 2024-04-19 09:03:50.989063+00 | | 2024-04-19 04:46:31.236589+00 |
| public | m_user | 29892 | 200 | 0.00 | 0.00 | | 2024-04-12 04:40:21.940349+00 | | 2024-03-31 23:57:54.486297+00 |
| public | m_zone | 4102 | 302 | 0.00 | 6.00 | | 2024-04-10 18:03:54.994245+00 | | 2024-04-11 06:49:28.039164+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:03.130511+00 | | |
| public | r_auth_zone | 212 | 23 | 0.00 | 9.00 | | 2024-04-11 08:26:06.282061+00 | | 2024-04-11 08:26:06.287685+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.384885+00 | | |
| public | r_group_auth | 493 | 13 | 0.00 | 2.00 | | 2024-04-09 11:33:39.288664+00 | | 2024-04-06 08:42:23.362461+00 |
| public | r_location_zone | 31686 | 916 | 0.00 | 2.00 | | 2024-04-19 00:24:19.603171+00 | | 2024-04-19 00:24:19.699344+00 |
| public | r_pot_auth | 730 | 3 | 0.00 | 0.00 | | 2024-04-17 11:30:37.656645+00 | | 2024-04-19 08:22:48.919153+00 |
| public | r_pot_category | 6623 | 0 | 0.00 | 0.00 | | 2024-04-20 20:37:54.651249+00 | | 2024-04-20 20:37:54.663108+00 |
| public | r_pot_group | 87001 | 13332 | 0.00 | 13.00 | | 2024-04-20 20:37:54.414156+00 | | 2024-04-21 00:31:34.955817+00 |
| public | r_pot_tx | 45374 | 2876 | 0.00 | 5.00 | | 2024-04-07 01:35:25.475693+00 | | 2024-04-18 09:44:26.05544+00 |
| public | r_pot_user | 19154 | 59 | 0.00 | 0.00 | | 2024-04-16 11:19:26.729123+00 | | 2024-04-17 23:42:33.756325+00 |
| public | r_provider_tenant | 1656 | 348 | 0.00 | 17.00 | | 2024-04-13 07:50:48.300068+00 | | 2024-04-19 05:37:48.404989+00 |
| public | r_role_feature | 5182 | 0 | 0.00 | 0.00 | | 2024-04-16 11:19:26.763414+00 | | 2024-03-28 04:53:44.604731+00 |
| public | r_tenant_feature | 3424 | 0 | 0.00 | 0.00 | | 2024-04-12 12:22:46.383656+00 | | 2024-03-22 05:38:31.850763+00 |
| public | r_tx_sensor | 451 | 0 | 0.00 | 0.00 | | 2024-04-18 00:41:03.14528+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19708 | 60 | 0.00 | 0.00 | | 2024-04-16 11:19:26.389066+00 | | 2024-04-11 09:40:20.304336+00 |
| public | r_user_site | 5283 | 178 | 0.00 | 3.00 | | 2024-04-09 06:15:04.269837+00 | | 2024-04-01 03:15:59.165625+00 |
| public | r_zone_category | 2760 | 60 | 0.00 | 2.00 | | 2024-04-19 00:38:18.926076+00 | | 2024-04-16 08:06:48.882529+00 |
| public | t_ai_history | 7 | 0 | 0.00 | 0.00 | | 2024-04-15 04:07:05.979278+00 | | |
| public | t_attendance | 881767 | 43003 | 0.00 | 4.00 | | 2024-04-12 12:23:07.799607+00 | | 2024-04-11 23:40:48.24496+00 |
| public | t_general | 1681 | 2 | 0.00 | 0.00 | | 2024-04-09 06:15:04.552323+00 | | 2024-04-04 01:01:17.018014+00 |
| public | t_mobile_device_history | 447059 | 0 | 0.00 | 0.00 | | 2024-04-11 12:01:27.468229+00 | | 2024-04-09 07:47:57.383332+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.405839+00 | | |
| public | t_notify_history | 2215741 | 62941 | 0.00 | 2.00 | | 2024-04-10 08:19:58.199137+00 | | 2024-04-19 00:57:19.930723+00 |
| public | t_operation_log | 8631276 | 38679 | 0.00 | 0.00 | | 2024-04-19 02:41:28.703166+00 | | 2024-04-19 20:20:50.146792+00 |
| public | t_plan | 10098531 | 1520435 | 0.00 | 13.00 | | 2024-04-17 01:10:30.83856+00 | | 2024-04-19 10:17:19.797858+00 |
| public | t_plan_detail | 16047778 | 3151640 | 0.00 | 16.00 | | 2024-04-17 06:05:19.147774+00 | | 2024-04-20 02:14:55.141949+00 |
| public | t_plan_sync | 46859 | 5745 | 0.00 | 10.00 | | 2024-04-21 00:48:12.999319+00 | | 2024-04-21 00:31:35.201315+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.613302+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:03.142748+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:04.465109+00 | | |
| public | t_recv_position_history | 91130 | 837630 | 9.00 | 90.00 | | 2024-04-21 00:50:13.078776+00 | 2024-04-20 13:30:02.378895+00 | 2024-04-21 00:50:13.495917+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-04-09 06:15:03.170371+00 | | |
| public | t_terminal | 41053 | 7490 | 0.00 | 15.00 | | 2024-04-10 23:19:49.664302+00 | | 2024-04-20 20:38:55.129549+00 |
| public | t_terminal_log | 6242887 | 0 | 0.00 | 0.00 | | 2024-04-18 12:46:08.341211+00 | | 2024-04-16 03:09:30.315128+00 |
| public | w_arrival_notify | 67 | 27 | 0.00 | 28.00 | | 2024-04-11 00:52:04.743404+00 | | 2024-04-12 00:44:08.105276+00 |
| public | w_latest_position | 47515 | 122579 | 2.00 | 72.00 | | 2024-04-21 00:50:14.643724+00 | | 2024-04-21 00:50:14.75559+00 |
| public | w_latest_presence | 176038 | 1888241 | 10.00 | 91.00 | 2024-01-18 12:30:06.016796+00 | 2024-04-21 00:50:14.148359+00 | 2024-01-18 12:30:06.178604+00 | 2024-04-21 00:50:14.564434+00 |
| public | w_latest_sensor | 443 | 4257 | 9.00 | 90.00 | | 2024-04-21 00:50:12.568431+00 | | 2024-04-21 00:50:12.686788+00 |
| public | w_lock | 12247 | 0 | 0.00 | 0.00 | | 2024-04-16 06:45:15.975536+00 | | 2024-04-05 09:40:14.085919+00 |
| public | w_master_update | 167 | 26 | 0.00 | 13.00 | | 2024-04-20 21:26:16.778526+00 | | 2024-04-20 21:06:53.354557+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-04-09 06:15:04.964568+00 | | |
| public | w_plan_with_detail | 10072362 | 402951 | 0.00 | 3.00 | | 2024-04-19 06:16:06.983479+00 | | 2024-04-19 06:04:45.074327+00 |