| 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 |
|---|
| e202312 | a_proximity_sum | 29521841 | 0 | 0.00 | 0.00 | | 2024-02-15 22:03:37.522655+00 | | 2023-12-29 12:50:02.455693+00 |
| e202312 | a_stay_time | 17019612 | 0 | 0.00 | 0.00 | | 2024-02-20 17:34:25.080978+00 | | 2023-12-29 15:07:06.176602+00 |
| e202312 | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-12 05:01:00.234143+00 | | |
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-12 05:01:00.222919+00 | | |
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-12 05:01:00.211887+00 | | |
| e202312 | t_position_history | 322261980 | 0 | 0.00 | 0.00 | | 2024-02-14 03:34:35.506232+00 | | 2023-12-30 17:24:31.17066+00 |
| e202312 | t_presence_history | 54449798 | 0 | 0.00 | 0.00 | | 2024-02-13 01:14:45.66407+00 | | 2023-12-31 14:43:53.221525+00 |
| e202312 | t_sensor_history | 11901023 | 0 | 0.00 | 0.00 | | 2024-02-19 17:55:54.93575+00 | | 2023-12-29 13:16:55.682719+00 |
| e202401 | a_proximity_sum | 27162829 | 0 | 0.00 | 0.00 | | 2024-02-11 00:58:33.180082+00 | | 2024-01-30 15:14:06.375164+00 |
| e202401 | a_stay_time | 17146869 | 4586 | 0.00 | 0.00 | | 2024-02-13 20:31:19.266219+00 | | 2024-01-30 15:11:06.159905+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-15 22:24:38.073172+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-15 22:24:38.095061+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-15 22:24:38.084163+00 | | |
| e202401 | t_position_history | 338289799 | 1224 | 0.00 | 0.00 | | 2024-02-12 05:00:24.254854+00 | | 2024-01-30 10:26:24.358574+00 |
| e202401 | t_presence_history | 36846669 | 0 | 0.00 | 0.00 | | 2024-02-22 04:31:29.436329+00 | | 2024-01-31 15:07:30.056064+00 |
| e202401 | t_sensor_history | 14216735 | 6847 | 0.00 | 0.00 | | 2024-02-08 17:46:32.326667+00 | | 2024-01-30 12:58:27.389928+00 |
| e202402 | a_proximity_sum | 21832721 | 0 | 0.00 | 0.00 | | 2024-02-21 18:02:14.740157+00 | | 2024-02-22 16:35:41.586461+00 |
| e202402 | a_stay_time | 13190521 | 0 | 0.00 | 0.00 | | 2024-02-21 15:09:03.206273+00 | | 2024-02-22 18:00:57.631037+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-19 21:38:26.548583+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-19 21:38:26.570626+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-19 21:38:26.55985+00 | | |
| e202402 | t_position_history | 273640219 | 0 | 0.00 | 0.00 | | 2024-02-22 10:06:50.095775+00 | | 2024-02-23 02:13:11.53758+00 |
| e202402 | t_presence_history | 31280022 | 5583112 | 0.00 | 15.00 | | 2024-02-23 07:39:57.732592+00 | | 2024-02-23 08:09:44.898394+00 |
| e202402 | t_sensor_history | 11471969 | 0 | 0.00 | 0.00 | | 2024-02-22 05:29:25.910771+00 | | 2024-02-21 20:50:20.92827+00 |
| public | __digdag_status | 57 | 12 | 0.00 | 17.00 | | 2024-02-23 06:20:48.635848+00 | | 2024-02-23 01:21:30.862143+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.520837+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.509469+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.762266+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:46.721109+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.679821+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:46.74147+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:46.761994+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.699948+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.658804+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.782862+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.721845+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-02-17 05:51:45.742002+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.930616+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.919325+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.907699+00 | | |
| public | m_area | 631 | 6 | 0.00 | 0.00 | | 2024-02-14 01:24:18.309229+00 | | 2024-01-18 08:43:32.882494+00 |
| public | m_auth | 91 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.535939+00 | | |
| public | m_category | 1578 | 0 | 0.00 | 0.00 | | 2024-02-14 01:24:18.339671+00 | | |
| public | m_exb | 18735 | 157 | 0.00 | 0.00 | | 2024-02-08 05:37:37.34489+00 | | 2024-01-31 23:41:48.109481+00 |
| public | m_favorite | 149237 | 1403 | 0.00 | 0.00 | | 2024-02-11 09:54:16.030888+00 | | 2024-01-18 07:33:40.519402+00 |
| public | m_feature | 151 | 0 | 0.00 | 0.00 | | 2024-02-11 06:10:09.806765+00 | | |
| public | m_group | 13490 | 18 | 0.00 | 0.00 | | 2024-02-18 02:30:02.227237+00 | | 2024-01-01 03:10:40.774873+00 |
| public | m_holiday | 15455 | 0 | 0.00 | 0.00 | | 2024-02-09 22:33:28.661294+00 | | 2024-02-01 01:01:41.977654+00 |
| public | m_lob | 18012 | 3 | 0.00 | 0.00 | | 2024-02-22 09:20:23.856942+00 | | 2024-01-26 12:24:11.753833+00 |
| public | m_location | 33056 | 137 | 0.00 | 0.00 | | 2024-02-12 00:48:39.7683+00 | | 2024-02-02 10:56:18.136784+00 |
| public | m_notify_template | 717 | 1 | 0.00 | 0.00 | | 2024-02-10 04:41:09.628021+00 | | 2023-12-25 06:37:18.875076+00 |
| public | m_outside | 276 | 2 | 0.00 | 0.00 | | 2024-02-20 04:10:40.596641+00 | | |
| public | m_pot | 250697 | 3080 | 0.00 | 1.00 | | 2024-02-22 23:52:41.704494+00 | | 2024-02-22 08:49:04.783414+00 |
| public | m_pot_profile | 33169 | 148 | 0.00 | 0.00 | | 2024-02-11 06:58:34.461014+00 | | 2024-02-21 06:28:02.787527+00 |
| public | m_provider_user | 65 | 61 | 0.00 | 48.00 | | 2024-02-13 12:11:21.140848+00 | | 2024-02-14 09:08:37.831676+00 |
| public | m_region | 97 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.742862+00 | | |
| public | m_role | 512 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.726033+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.555319+00 | | |
| public | m_setting | 18693 | 1770 | 0.00 | 8.00 | | 2024-02-23 06:04:48.062476+00 | | 2024-02-23 05:39:47.761926+00 |
| public | m_setting_log | 50677 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-02-23 05:39:49.82416+00 | | 2024-02-23 05:40:48.610627+00 |
| public | m_site | 168 | 2 | 0.00 | 1.00 | | 2024-02-10 04:41:09.589668+00 | | |
| public | m_tenant | 96 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.871427+00 | | |
| public | m_tx | 81940 | 1951 | 0.00 | 2.00 | | 2024-02-22 09:27:19.31851+00 | | 2024-02-22 09:27:19.451105+00 |
| public | m_user | 29074 | 2509 | 0.00 | 7.00 | | 2024-02-14 00:10:47.398573+00 | | 2024-02-21 08:40:30.943311+00 |
| public | m_zone | 5831 | 24 | 0.00 | 0.00 | | 2024-02-12 09:51:29.748897+00 | | 2024-02-08 08:37:07.646051+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.474147+00 | | |
| public | r_auth_zone | 196 | 24 | 0.00 | 10.00 | | 2024-02-08 06:22:21.421011+00 | | 2024-02-05 00:15:24.068372+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.651123+00 | | |
| public | r_group_auth | 436 | 13 | 0.00 | 2.00 | | 2024-02-10 12:06:10.640048+00 | | |
| public | r_location_zone | 31791 | 122 | 0.00 | 0.00 | | 2024-02-20 01:43:30.343249+00 | | 2024-02-16 10:26:41.730391+00 |
| public | r_pot_auth | 704 | 1 | 0.00 | 0.00 | | 2024-02-19 08:34:45.165072+00 | | 2024-02-08 06:51:37.599116+00 |
| public | r_pot_category | 5992 | 0 | 0.00 | 0.00 | | 2024-02-23 06:21:48.66496+00 | | 2024-02-23 06:01:48.296551+00 |
| public | r_pot_group | 95908 | 5249 | 0.00 | 5.00 | | 2024-02-23 06:01:48.153001+00 | | 2024-02-23 06:01:48.267869+00 |
| public | r_pot_tx | 45718 | 1 | 0.00 | 0.00 | | 2024-02-23 01:16:30.930137+00 | | 2024-02-02 05:46:00.55509+00 |
| public | r_pot_user | 18662 | 2536 | 0.00 | 11.00 | | 2024-02-18 06:20:47.088313+00 | | 2024-02-21 08:40:30.997445+00 |
| public | r_provider_tenant | 2672 | 92 | 0.00 | 3.00 | | 2024-02-14 06:55:09.773332+00 | | 2024-02-22 03:16:49.344335+00 |
| public | r_role_feature | 5321 | 1 | 0.00 | 0.00 | | 2024-02-18 02:30:02.031091+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3283 | 0 | 0.00 | 0.00 | | 2024-02-15 17:51:14.411088+00 | | |
| public | r_tx_sensor | 455 | 0 | 0.00 | 0.00 | | 2024-02-19 17:55:27.447717+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19204 | 2576 | 0.00 | 11.00 | | 2024-02-18 06:20:46.955737+00 | | 2024-02-21 08:40:30.42447+00 |
| public | r_user_site | 5227 | 28 | 0.00 | 0.00 | | 2024-02-10 02:55:50.770318+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2828 | 1 | 0.00 | 0.00 | | 2024-02-20 17:34:25.026497+00 | | 2024-01-23 05:12:39.85601+00 |
| public | t_attendance | 729229 | 44274 | 0.00 | 5.00 | | 2024-02-15 17:51:31.660381+00 | | 2024-02-20 03:35:28.166416+00 |
| public | t_general | 1384 | 1 | 0.00 | 0.00 | | 2024-02-10 04:41:09.854553+00 | | 2024-01-29 01:00:49.959426+00 |
| public | t_mobile_device_history | 390543 | 0 | 0.00 | 0.00 | | 2024-02-13 10:37:59.86692+00 | | 2024-02-09 04:49:46.654181+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.697028+00 | | |
| public | t_notify_history | 1893661 | 58083 | 0.00 | 2.00 | | 2024-02-12 01:03:03.92206+00 | | 2024-02-19 00:20:06.667528+00 |
| public | t_operation_log | 7392809 | 39077 | 0.00 | 0.00 | | 2024-02-21 00:37:13.680176+00 | | 2024-02-15 19:06:28.324191+00 |
| public | t_plan | 8977667 | 1309364 | 0.00 | 12.00 | | 2024-02-13 00:36:42.000271+00 | | 2024-02-20 22:05:41.095252+00 |
| public | t_plan_detail | 14062191 | 1035589 | 0.00 | 6.00 | | 2024-02-16 07:36:26.792864+00 | | 2024-02-21 08:22:06.25427+00 |
| public | t_plan_sync | 25059 | 4402 | 0.00 | 14.00 | | 2024-02-23 03:35:33.368417+00 | | 2024-02-23 03:35:33.555039+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.895987+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.485957+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.76382+00 | | |
| public | t_recv_position_history | 88577 | 25377 | 0.00 | 22.00 | | 2024-02-23 08:21:51.883913+00 | 2024-02-22 12:30:02.129386+00 | 2024-02-23 08:21:52.40206+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.497786+00 | | |
| public | t_terminal | 23974 | 3645 | 0.00 | 13.00 | | 2024-02-22 23:58:36.59607+00 | | 2024-02-23 06:21:49.959817+00 |
| public | t_terminal_log | 4879584 | 0 | 0.00 | 0.00 | | 2024-02-20 09:05:52.58847+00 | | 2024-02-10 06:01:59.826383+00 |
| public | w_arrival_notify | 61 | 24 | 0.00 | 28.00 | | 2024-02-12 18:14:45.694847+00 | | 2024-02-21 00:34:37.660717+00 |
| public | w_latest_position | 43130 | 5888 | 0.00 | 12.00 | | 2024-02-23 08:20:45.126329+00 | | 2024-02-23 08:21:44.821597+00 |
| public | w_latest_presence | 184075 | 57788 | 0.00 | 23.00 | 2024-01-18 12:30:06.016796+00 | 2024-02-23 08:21:46.448281+00 | 2024-01-18 12:30:06.178604+00 | 2024-02-23 08:21:46.848864+00 |
| public | w_latest_sensor | 443 | 118 | 0.00 | 21.00 | | 2024-02-23 08:21:47.061487+00 | | 2024-02-23 08:21:47.243932+00 |
| public | w_lock | 11546 | 0 | 0.00 | 0.00 | | 2024-02-17 10:15:45.414956+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 96 | 40 | 0.00 | 29.00 | | 2024-02-23 01:07:30.448209+00 | | 2024-02-23 04:07:37.01502+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.953492+00 | | |
| public | w_plan_with_detail | 8983639 | 1562244 | 0.00 | 14.00 | | 2024-02-08 04:57:16.082299+00 | | 2024-02-20 22:45:21.829989+00 |