| 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 | 30539363 | 0 | 0.00 | 0.00 | | 2024-03-26 08:56:20.032178+00 | | 2024-02-28 18:03:25.795511+00 |
| e202402 | a_stay_time | 17176571 | 0 | 0.00 | 0.00 | | 2024-03-26 08:56:16.992938+00 | | 2024-02-28 16:55:43.897188+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-03 09:44:37.226311+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-03 09:44:37.237502+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-03 09:44:37.215061+00 | | |
| e202402 | t_position_history | 354528228 | 137463 | 0.00 | 0.00 | | 2024-03-27 18:01:22.325596+00 | | 2024-02-28 06:24:03.251416+00 |
| e202402 | t_presence_history | 40155397 | 14 | 0.00 | 0.00 | | 2024-04-04 11:00:06.764742+00 | | 2024-03-11 14:49:28.789296+00 |
| e202402 | t_sensor_history | 15047910 | 0 | 0.00 | 0.00 | | 2024-03-26 11:31:16.464119+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 | 19608318 | 0 | 0.00 | 0.00 | | 2024-03-27 05:15:16.43779+00 | | 2024-03-29 15:10:19.442279+00 |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-25 10:10:49.192616+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-25 10:10:49.209899+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-25 10:10:49.181192+00 | | |
| e202403 | t_position_history | 389335187 | 83469 | 0.00 | 0.00 | | 2024-03-26 01:54:15.45918+00 | | 2024-03-29 13:58:09.948045+00 |
| e202403 | t_presence_history | 38526400 | 5111363 | 0.00 | 11.00 | | 2024-03-31 14:02:47.830715+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 | 12793430 | 0 | 0.00 | 0.00 | | 2024-04-07 16:20:05.691407+00 | | 2024-04-08 16:22:12.070683+00 |
| e202404 | a_stay_time | 5961998 | 0 | 0.00 | 0.00 | | 2024-04-08 16:15:26.35486+00 | | 2024-04-08 15:55:45.284221+00 |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-04-02 22:45:41.454753+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-04-02 22:45:41.432424+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-04-02 22:45:41.443467+00 | | |
| e202404 | t_position_history | 119837677 | 0 | 0.00 | 0.00 | | 2024-04-07 16:36:47.375753+00 | | 2024-04-08 08:49:16.647372+00 |
| e202404 | t_presence_history | 11159416 | 1834337 | 0.00 | 14.00 | | 2024-04-09 00:27:38.024139+00 | | 2024-04-09 00:45:12.655692+00 |
| e202404 | t_sensor_history | 2481426 | 0 | 0.00 | 0.00 | | 2024-04-08 17:52:17.15624+00 | | 2024-04-08 21:09:22.145983+00 |
| public | __digdag_status | 31 | 32 | 1.00 | 50.00 | | 2024-04-06 08:30:17.77175+00 | | 2024-04-07 03:30:28.085854+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.153778+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.14206+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:31.926429+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:33.008567+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.385343+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:33.031529+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:33.052666+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.406523+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.363627+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:31.949184+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.427447+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-03-29 00:39:12.448466+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.669306+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.658032+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.646681+00 | | |
| public | m_area | 626 | 2 | 0.00 | 0.00 | | 2024-03-28 10:45:06.744765+00 | | 2024-03-08 02:07:46.986266+00 |
| public | m_auth | 114 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.174303+00 | | 2024-02-28 05:53:49.738173+00 |
| public | m_category | 1688 | 0 | 0.00 | 0.00 | | 2024-03-28 10:45:06.77351+00 | | 2024-03-26 09:54:33.731031+00 |
| public | m_exb | 18223 | 3656 | 0.00 | 16.00 | | 2024-03-29 06:00:59.833586+00 | | 2024-04-08 00:30:45.336722+00 |
| public | m_favorite | 147520 | 8406 | 0.00 | 5.00 | | 2024-03-26 11:31:13.565858+00 | | 2024-04-01 01:56:54.725127+00 |
| public | m_feature | 153 | 0 | 0.00 | 0.00 | | 2024-03-26 08:40:20.689186+00 | | |
| public | m_group | 14300 | 417 | 0.00 | 2.00 | | 2024-04-02 01:38:08.309514+00 | | 2024-04-01 03:01:59.40211+00 |
| public | m_holiday | 25618 | 0 | 0.00 | 0.00 | | 2024-04-05 09:30:10.243789+00 | | 2024-04-05 09:50:14.889678+00 |
| public | m_lob | 14897 | 9 | 0.00 | 0.00 | | 2024-04-06 04:23:13.702292+00 | | 2024-04-01 12:34:27.798233+00 |
| public | m_location | 32866 | 330 | 0.00 | 0.00 | | 2024-04-03 02:18:17.403694+00 | | 2024-03-31 02:07:17.750539+00 |
| public | m_notify_template | 733 | 3 | 0.00 | 0.00 | | 2024-03-25 13:40:49.372127+00 | | 2024-03-13 07:21:28.594642+00 |
| public | m_outside | 285 | 12 | 0.00 | 4.00 | | 2024-04-03 21:26:57.452703+00 | | |
| public | m_pot | 187164 | 27069 | 0.00 | 12.00 | | 2024-04-04 00:11:22.921712+00 | | 2024-04-09 00:37:11.152847+00 |
| public | m_pot_profile | 33771 | 131 | 0.00 | 0.00 | | 2024-03-26 11:31:12.040734+00 | | 2024-02-21 06:28:02.787527+00 |
| public | m_provider_user | 67 | 50 | 0.00 | 42.00 | | 2024-03-26 10:29:33.991099+00 | | 2024-03-28 09:27:17.588147+00 |
| public | m_region | 101 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.478152+00 | | |
| public | m_role | 528 | 6 | 0.00 | 1.00 | | 2024-03-25 13:40:49.452205+00 | | 2024-03-28 02:18:51.575265+00 |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.293842+00 | | |
| public | m_setting | 20925 | 814 | 0.00 | 3.00 | | 2024-04-08 23:42:22.695142+00 | | 2024-04-08 22:38:59.687824+00 |
| public | m_setting_log | 46528 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-04-08 12:48:25.854595+00 | | 2024-04-08 19:45:03.055992+00 |
| public | m_site | 171 | 2 | 0.00 | 1.00 | | 2024-03-25 13:40:49.322758+00 | | |
| public | m_tenant | 100 | 6 | 0.00 | 5.00 | | 2024-03-25 13:40:49.610812+00 | | |
| public | m_tx | 82959 | 5695 | 0.00 | 6.00 | | 2024-04-08 01:23:34.027486+00 | | 2024-04-08 09:44:46.650862+00 |
| public | m_user | 29944 | 1233 | 0.00 | 3.00 | | 2024-03-28 10:45:06.705657+00 | | 2024-03-31 23:57:54.486297+00 |
| public | m_zone | 5589 | 202 | 0.00 | 3.00 | | 2024-03-27 04:25:46.606328+00 | | 2024-03-25 01:53:48.454583+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:48.184698+00 | | |
| public | r_auth_zone | 216 | 0 | 0.00 | 0.00 | | 2024-04-07 11:40:57.939651+00 | | 2024-03-07 02:43:16.034776+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.395111+00 | | |
| public | r_group_auth | 474 | 54 | 0.00 | 10.00 | | 2024-03-26 01:54:59.165763+00 | | 2024-04-06 08:42:23.362461+00 |
| public | r_location_zone | 31220 | 4375 | 0.00 | 12.00 | | 2024-03-29 03:09:55.410858+00 | | 2024-03-29 08:31:19.876436+00 |
| public | r_pot_auth | 730 | 10 | 0.00 | 1.00 | | 2024-04-03 02:23:34.402244+00 | | 2024-04-03 01:46:35.460601+00 |
| public | r_pot_category | 6523 | 0 | 0.00 | 0.00 | | 2024-04-08 20:18:00.124744+00 | | 2024-04-08 20:01:32.357096+00 |
| public | r_pot_group | 89307 | 13124 | 0.00 | 12.00 | | 2024-04-08 22:00:57.594246+00 | | 2024-04-09 00:11:48.895377+00 |
| public | r_pot_tx | 44878 | 172 | 0.00 | 0.00 | | 2024-04-07 01:35:25.475693+00 | | 2024-04-02 07:09:48.055089+00 |
| public | r_pot_user | 19080 | 138 | 0.00 | 0.00 | | 2024-04-02 01:38:08.058024+00 | | 2024-03-31 23:55:53.935899+00 |
| public | r_provider_tenant | 1572 | 292 | 0.00 | 15.00 | | 2024-03-29 09:52:33.0692+00 | | 2024-04-05 07:15:50.881148+00 |
| public | r_role_feature | 5169 | 82 | 0.00 | 1.00 | | 2024-04-02 01:38:08.096262+00 | | 2024-03-28 04:53:44.604731+00 |
| public | r_tenant_feature | 3403 | 83 | 0.00 | 2.00 | | 2024-03-29 00:39:12.328913+00 | | 2024-03-22 05:38:31.850763+00 |
| public | r_tx_sensor | 451 | 0 | 0.00 | 0.00 | | 2024-04-03 08:14:02.763498+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19629 | 151 | 0.00 | 0.00 | | 2024-04-02 01:38:07.768083+00 | | 2024-03-31 23:54:53.833358+00 |
| public | r_user_site | 5237 | 715 | 0.00 | 12.00 | | 2024-03-25 13:40:49.273411+00 | | 2024-04-01 03:15:59.165625+00 |
| public | r_zone_category | 2730 | 9 | 0.00 | 0.00 | | 2024-04-04 08:21:25.91829+00 | | 2024-04-03 04:30:36.673395+00 |
| public | t_ai_history | 7 | 0 | 0.00 | 0.00 | | | | |
| public | t_attendance | 848999 | 55603 | 0.00 | 6.00 | | 2024-03-29 00:39:31.903418+00 | | 2024-04-03 09:01:03.706368+00 |
| public | t_general | 1616 | 4 | 0.00 | 0.00 | | 2024-03-25 13:40:49.587016+00 | | 2024-04-04 01:01:17.018014+00 |
| public | t_mobile_device_history | 429950 | 384 | 0.00 | 0.00 | | 2024-03-28 01:26:27.521731+00 | | 2024-03-13 04:08:59.7831+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.41662+00 | | |
| public | t_notify_history | 2150356 | 60159 | 0.00 | 2.00 | | 2024-03-26 22:58:42.878337+00 | | 2024-04-08 01:15:37.299082+00 |
| public | t_operation_log | 8377687 | 62745 | 0.00 | 0.00 | | 2024-04-04 10:49:21.50286+00 | | 2024-04-03 07:46:33.237938+00 |
| public | t_plan | 9890074 | 1494806 | 0.00 | 13.00 | | 2024-04-02 08:43:58.857668+00 | | 2024-04-08 11:41:52.060975+00 |
| public | t_plan_detail | 16601421 | 289873 | 0.00 | 1.00 | | 2024-04-08 08:36:56.383141+00 | | 2024-04-08 07:30:55.4075+00 |
| public | t_plan_sync | 25673 | 4180 | 0.00 | 14.00 | | 2024-04-09 00:31:58.487612+00 | | 2024-04-09 00:31:58.72584+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.635026+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:48.196542+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:49.496881+00 | | |
| public | t_recv_position_history | 120559 | 1154437 | 9.00 | 90.00 | | 2024-04-09 00:48:12.354186+00 | 2024-04-08 13:30:06.545639+00 | 2024-04-09 00:48:12.884435+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-03-25 13:40:48.22591+00 | | |
| public | t_terminal | 37020 | 6492 | 0.00 | 14.00 | | 2024-03-30 02:46:13.1222+00 | | 2024-04-08 23:09:34.418511+00 |
| public | t_terminal_log | 5990396 | 0 | 0.00 | 0.00 | | 2024-04-04 03:16:57.140766+00 | | 2024-03-23 15:22:08.14262+00 |
| public | w_arrival_notify | 65 | 24 | 0.00 | 26.00 | | 2024-03-27 07:59:06.94104+00 | | 2024-03-28 23:51:48.63331+00 |
| public | w_latest_position | 46916 | 343666 | 7.00 | 87.00 | | 2024-04-09 00:48:14.050043+00 | | 2024-04-09 00:48:14.18846+00 |
| public | w_latest_presence | 178509 | 1651422 | 9.00 | 90.00 | 2024-01-18 12:30:06.016796+00 | 2024-04-09 00:48:13.476482+00 | 2024-01-18 12:30:06.178604+00 | 2024-04-09 00:48:13.889484+00 |
| public | w_latest_sensor | 443 | 3679 | 8.00 | 89.00 | | 2024-04-09 00:48:11.693834+00 | | 2024-04-09 00:48:11.811914+00 |
| public | w_lock | 12184 | 0 | 0.00 | 0.00 | | 2024-04-01 17:38:05.101794+00 | | 2024-04-05 09:40:14.085919+00 |
| public | w_master_update | 96 | 46 | 0.00 | 32.00 | | 2024-04-09 00:31:58.042027+00 | | 2024-04-09 00:44:11.666748+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-03-25 13:40:49.690522+00 | | |
| public | w_plan_with_detail | 9913075 | 1311925 | 0.00 | 11.00 | | 2024-04-03 04:58:16.723467+00 | | 2024-04-08 07:11:34.48977+00 |