| 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 |
|---|
| e202409 | a_proximity_sum | 45457302 | 1218170 | 0.00 | 2.00 | | 2024-10-30 02:00:03.400153+00 | | |
| e202409 | a_stay_time | 23318040 | 0 | 0.00 | 0.00 | | 2024-10-31 04:06:30.751843+00 | | 2024-10-31 04:06:41.049298+00 |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 06:29:45.955332+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 06:29:45.977639+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 06:29:45.96671+00 | | |
| e202409 | t_position_history | 452405443 | 0 | 0.00 | 0.00 | | 2024-10-30 03:26:31.339059+00 | | |
| e202409 | t_presence_history | 45407355 | 0 | 0.00 | 0.00 | | 2024-11-01 04:46:06.159008+00 | | |
| e202409 | t_sensor_history | 9170515 | 0 | 0.00 | 0.00 | | 2024-11-03 01:23:30.782582+00 | | |
| e202410 | a_proximity_sum | 37808258 | 0 | 0.00 | 0.00 | | 2024-11-05 12:07:46.204076+00 | | 2024-10-31 07:52:03.293317+00 |
| e202410 | a_stay_time | 25180233 | 1164234 | 0.00 | 4.00 | | 2024-10-31 06:42:36.818888+00 | | 2024-10-31 08:16:54.216363+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 10:51:13.390761+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 10:51:13.414401+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 10:51:13.402495+00 | | |
| e202410 | t_position_history | 488787604 | 0 | 0.00 | 0.00 | | 2024-10-31 03:29:54.372941+00 | | 2024-10-30 02:43:29.948815+00 |
| e202410 | t_presence_history | 53388544 | 2534349 | 0.00 | 4.00 | | 2024-10-31 14:41:57.988275+00 | | 2024-10-31 14:26:50.9548+00 |
| e202410 | t_sensor_history | 9420693 | 0 | 0.00 | 0.00 | | 2024-11-05 06:10:50.413169+00 | | 2024-10-29 03:17:40.973549+00 |
| e202411 | a_proximity_sum | 3358219 | 0 | 0.00 | 0.00 | | 2024-11-05 18:02:33.172118+00 | | 2024-11-05 18:02:33.729264+00 |
| e202411 | a_stay_time | 2277762 | 0 | 0.00 | 0.00 | | 2024-11-05 17:17:35.099072+00 | | 2024-11-05 17:42:37.275948+00 |
| e202411 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.917399+00 | | |
| e202411 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.928394+00 | | |
| e202411 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.939698+00 | | |
| e202411 | t_position_history | 63902423 | 0 | 0.00 | 0.00 | | 2024-11-05 07:06:26.964057+00 | | 2024-11-05 13:53:58.678657+00 |
| e202411 | t_presence_history | 7011403 | 1440108 | 0.00 | 17.00 | | 2024-11-06 00:41:21.281649+00 | | 2024-11-06 00:47:26.923433+00 |
| e202411 | t_sensor_history | 1661474 | 0 | 0.00 | 0.00 | | 2024-11-05 19:16:53.101433+00 | | 2024-11-05 20:49:06.544827+00 |
| public | __digdag_status | 31 | 45 | 1.00 | 59.00 | | 2024-11-02 08:30:43.116591+00 | | 2024-11-04 08:30:19.18422+00 |
| public | a_attendance_sum | 40963 | 6430 | 0.00 | 13.00 | | 2024-11-06 00:41:45.646125+00 | | 2024-11-06 00:51:26.573958+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:23.476002+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:17.623703+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-10-28 07:14:23.445178+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-10-28 07:18:45.539707+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-10-28 07:13:46.318346+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-10-28 07:18:45.561142+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-10-28 07:18:45.583122+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-10-28 07:13:46.339257+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-10-28 07:13:46.297678+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-10-28 07:14:23.465978+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-10-28 07:13:46.360141+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-10-28 07:13:46.381384+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.898449+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.887252+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.875912+00 | | |
| public | m_area | 664 | 4 | 0.00 | 0.00 | | 2024-10-28 04:34:38.226561+00 | | |
| public | m_auth | 121 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.495393+00 | | |
| public | m_category | 1748 | 4 | 0.00 | 0.00 | | 2024-10-28 04:34:38.165928+00 | | |
| public | m_exb | 20967 | 388 | 0.00 | 1.00 | | 2024-11-04 11:54:27.707728+00 | | 2024-11-05 15:49:31.712072+00 |
| public | m_favorite | 198155 | 1940 | 0.00 | 0.00 | | 2024-10-27 10:28:35.833147+00 | | 2024-10-08 10:00:05.802028+00 |
| public | m_favorite_group | 69415 | 179 | 0.00 | 0.00 | | 2024-10-30 05:06:49.284654+00 | | 2024-10-31 02:08:28.243557+00 |
| public | m_feature | 164 | 0 | 0.00 | 0.00 | | 2024-11-05 06:02:20.826151+00 | | |
| public | m_group | 17884 | 43 | 0.00 | 0.00 | | 2024-10-30 07:12:28.875241+00 | | |
| public | m_holiday | 26000 | 2 | 0.00 | 0.00 | | 2024-11-01 10:09:51.321615+00 | | |
| public | m_lob | 21854 | 24 | 0.00 | 0.00 | | 2024-11-02 01:10:13.539251+00 | | |
| public | m_location | 37725 | 368 | 0.00 | 0.00 | | 2024-10-31 02:20:29.749659+00 | | |
| public | m_notify_template | 739 | 1 | 0.00 | 0.00 | | 2024-11-05 00:04:23.648702+00 | | |
| public | m_outside | 321 | 0 | 0.00 | 0.00 | | 2024-10-31 08:56:16.889299+00 | | |
| public | m_pot | 161122 | 28294 | 0.00 | 14.00 | | 2024-11-04 00:12:10.192429+00 | | 2024-11-06 00:20:44.307786+00 |
| public | m_pot_profile | 49494 | 16 | 0.00 | 0.00 | | 2024-11-03 00:12:22.963099+00 | | |
| public | m_provider_user | 71 | 2 | 0.00 | 2.00 | | 2024-11-05 06:26:01.906602+00 | | |
| public | m_region | 99 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.740702+00 | | |
| public | m_role | 563 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.718635+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.601048+00 | | |
| public | m_setting | 19443 | 594 | 0.00 | 2.00 | | 2024-11-05 12:59:06.16181+00 | | 2024-11-05 08:10:45.199619+00 |
| public | m_setting_log | 28600 | 1142 | 0.00 | 3.00 | | 2024-11-03 00:07:52.419744+00 | | 2024-11-05 12:31:04.399727+00 |
| public | m_site | 177 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.621472+00 | | |
| public | m_tenant | 98 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.889476+00 | | |
| public | m_tx | 100135 | 3905 | 0.00 | 3.00 | | 2024-11-05 16:51:26.667423+00 | | 2024-11-05 16:51:26.829185+00 |
| public | m_user | 30595 | 140 | 0.00 | 0.00 | | 2024-10-28 04:34:28.81365+00 | | |
| public | m_zone | 6618 | 0 | 0.00 | 0.00 | | 2024-11-05 15:33:52.249132+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.801691+00 | | |
| public | r_auth_zone | 222 | 0 | 0.00 | 0.00 | | 2024-10-27 14:59:37.335702+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.672867+00 | | |
| public | r_group_auth | 588 | 0 | 0.00 | 0.00 | | 2024-10-29 03:07:40.22607+00 | | 2024-10-08 09:38:50.736835+00 |
| public | r_location_zone | 42385 | 952 | 0.00 | 2.00 | | 2024-10-31 23:45:26.008068+00 | | 2024-10-10 09:13:16.68237+00 |
| public | r_pot_auth | 8382 | 348 | 0.00 | 3.00 | | 2024-10-28 04:48:16.273919+00 | | |
| public | r_pot_category | 6969 | 0 | 0.00 | 0.00 | | 2024-11-05 20:08:03.459944+00 | | 2024-11-05 20:02:02.431894+00 |
| public | r_pot_group | 158488 | 3300 | 0.00 | 2.00 | | 2024-11-06 00:38:44.466341+00 | | 2024-11-06 00:20:42.367869+00 |
| public | r_pot_tx | 57366 | 465 | 0.00 | 0.00 | | 2024-11-02 18:58:25.722067+00 | | 2024-10-29 10:18:54.209249+00 |
| public | r_pot_user | 18832 | 35 | 0.00 | 0.00 | | 2024-10-30 07:12:28.643799+00 | | |
| public | r_provider_tenant | 1404 | 190 | 0.00 | 11.00 | | 2024-10-31 03:30:33.946133+00 | | 2024-11-05 11:06:29.554717+00 |
| public | r_role_feature | 5187 | 0 | 0.00 | 0.00 | | 2024-10-30 07:12:28.675646+00 | | |
| public | r_tenant_feature | 3594 | 0 | 0.00 | 0.00 | | 2024-10-28 07:13:39.491605+00 | | |
| public | r_tx_sensor | 327 | 0 | 0.00 | 0.00 | | 2024-10-30 02:33:27.724859+00 | | |
| public | r_user_region | 19300 | 32 | 0.00 | 0.00 | | 2024-10-30 07:12:22.073489+00 | | |
| public | r_user_site | 5090 | 4 | 0.00 | 0.00 | | 2024-11-05 00:04:23.577201+00 | | |
| public | r_zone_category | 3378 | 4 | 0.00 | 0.00 | | 2024-10-31 23:45:25.867365+00 | | 2024-10-21 14:08:10.484709+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2024-10-29 10:02:43.976545+00 | | |
| public | t_attendance | 1594235 | 47704 | 0.00 | 2.00 | | 2024-10-28 07:14:11.555458+00 | | 2024-11-04 23:45:17.608246+00 |
| public | t_general | 2716 | 4 | 0.00 | 0.00 | | 2024-11-05 00:04:23.871727+00 | | |
| public | t_mobile_device_history | 658831 | 0 | 0.00 | 0.00 | | 2024-10-27 23:34:41.754604+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.697153+00 | | |
| public | t_notify_history | 3324934 | 2921 | 0.00 | 0.00 | | 2024-11-05 09:48:44.694461+00 | | 2024-10-24 22:46:31.398488+00 |
| public | t_operation_log | 12428654 | 3 | 0.00 | 0.00 | | 2024-11-01 01:01:53.828826+00 | | |
| public | t_plan | 14077450 | 1028192 | 0.00 | 6.00 | | 2024-10-29 23:27:26.161738+00 | | 2024-11-05 00:01:27.115261+00 |
| public | t_plan_detail | 24178244 | 630861 | 0.00 | 2.00 | | 2024-11-01 16:22:50.242868+00 | | 2024-11-04 23:13:15.756178+00 |
| public | t_plan_sync | 42003 | 4716 | 0.00 | 10.00 | | 2024-11-06 00:31:44.184171+00 | | 2024-11-06 00:38:44.747183+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.918041+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.824769+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:23.752067+00 | | |
| public | t_recv_position_history | 119055 | 54909 | 0.00 | 31.00 | | 2024-11-06 00:52:25.765274+00 | 2024-11-05 13:30:07.204358+00 | 2024-11-06 00:52:26.167889+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.855061+00 | | |
| public | t_terminal | 104114 | 2376 | 0.00 | 2.00 | | 2024-11-02 18:58:26.981845+00 | | 2024-11-05 19:11:44.033304+00 |
| public | t_terminal_log | 12084606 | 0 | 0.00 | 0.00 | | 2024-10-31 12:58:45.492243+00 | | |
| public | w_arrival_notify | 77 | 50 | 0.00 | 39.00 | | 2024-10-31 07:02:26.023294+00 | | 2024-11-05 23:01:25.328601+00 |
| public | w_latest_position | 61817 | 12774 | 0.00 | 17.00 | | 2024-11-06 00:52:26.281473+00 | | 2024-11-06 00:52:26.393379+00 |
| public | w_latest_presence | 208900 | 103943 | 0.00 | 33.00 | | 2024-11-06 00:52:31.162476+00 | | 2024-11-06 00:52:31.834888+00 |
| public | w_latest_sensor | 344 | 216 | 0.00 | 38.00 | | 2024-11-06 00:52:26.419133+00 | | 2024-11-06 00:52:26.533234+00 |
| public | w_lock | 14749 | 0 | 0.00 | 0.00 | | 2024-10-30 04:41:31.350151+00 | | |
| public | w_master_update | 169 | 3 | 0.00 | 1.00 | | 2024-11-06 00:50:26.746425+00 | | 2024-11-06 00:39:44.532113+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2024-11-05 00:57:21.916025+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-11-04 10:00:57.243378+00 | | |
| public | w_plan_with_detail | 14055522 | 172253 | 0.00 | 1.00 | | 2024-11-05 06:56:57.073794+00 | | 2024-11-04 23:58:43.863822+00 |