| 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-10-23 07:24:43.752121+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-23 07:24:43.782509+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-23 07:24:43.763659+00 | | |
| e202409 | t_position_history | 452405438 | 0 | 0.00 | 0.00 | | 2024-10-30 03:26:31.339059+00 | | |
| e202409 | t_presence_history | 45407403 | 0 | 0.00 | 0.00 | | 2024-10-23 05:51:51.998448+00 | | |
| e202409 | t_sensor_history | 9170548 | 0 | 0.00 | 0.00 | | 2024-10-24 07:55:48.025439+00 | | |
| e202410 | a_proximity_sum | 37826318 | 0 | 0.00 | 0.00 | | 2024-10-31 15:35:22.14365+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-10-23 12:10:09.348733+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-23 12:10:09.371283+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-23 12:10:09.360144+00 | | |
| e202410 | t_position_history | 488775448 | 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 | 9502076 | 0 | 0.00 | 0.00 | | 2024-10-26 02:46:49.942251+00 | | 2024-10-29 03:17:40.973549+00 |
| e202411 | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-25 11:00:06.040918+00 | | |
| e202411 | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-25 11:00:06.138607+00 | | |
| e202411 | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-25 11:00:06.029491+00 | | |
| e202411 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-25 11:00:06.063207+00 | | |
| e202411 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-25 11:00:06.157994+00 | | |
| e202411 | t_position_history | 4440003 | 0 | 0.00 | 0.00 | | 2024-11-01 00:15:37.156908+00 | | 2024-11-01 00:36:15.355038+00 |
| e202411 | t_presence_history | 566228 | 100371 | 0.00 | 15.00 | | 2024-11-01 00:52:16.167495+00 | | 2024-11-01 00:52:16.662924+00 |
| e202411 | t_sensor_history | 126579 | 0 | 0.00 | 0.00 | | 2024-10-31 22:55:45.283569+00 | | 2024-11-01 00:44:16.919579+00 |
| public | __digdag_status | 32 | 40 | 1.00 | 55.00 | | 2024-10-28 12:30:25.566123+00 | | 2024-10-29 03:30:10.464244+00 |
| public | a_attendance_sum | 39849 | 4595 | 0.00 | 10.00 | | 2024-11-01 00:44:17.381531+00 | | 2024-11-01 00:48:18.179788+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-25 08:59:08.014147+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-25 08:59:04.895554+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-10-25 10:16:31.230695+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-25 10:16:31.21377+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-25 10:16:31.196934+00 | | |
| public | m_area | 663 | 2 | 0.00 | 0.00 | | 2024-10-28 04:34:38.226561+00 | | |
| public | m_auth | 121 | 0 | 0.00 | 0.00 | | 2024-10-25 08:59:08.031914+00 | | |
| public | m_category | 1746 | 0 | 0.00 | 0.00 | | 2024-10-28 04:34:38.165928+00 | | |
| public | m_exb | 21501 | 50 | 0.00 | 0.00 | | 2024-10-25 05:14:36.39086+00 | | |
| public | m_favorite | 198060 | 1250 | 0.00 | 0.00 | | 2024-10-27 10:28:35.833147+00 | | 2024-10-08 10:00:05.802028+00 |
| public | m_favorite_group | 67929 | 92 | 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-10-26 02:32:31.525006+00 | | |
| public | m_group | 17867 | 7 | 0.00 | 0.00 | | 2024-10-30 07:12:28.875241+00 | | |
| public | m_holiday | 26074 | 0 | 0.00 | 0.00 | | 2024-10-23 11:11:32.021448+00 | | |
| public | m_lob | 21836 | 80 | 0.00 | 0.00 | | 2024-10-24 00:29:53.534035+00 | | |
| public | m_location | 37646 | 21 | 0.00 | 0.00 | | 2024-10-31 02:20:29.749659+00 | | |
| public | m_notify_template | 739 | 5 | 0.00 | 0.00 | | 2024-10-25 08:59:08.214983+00 | | |
| public | m_outside | 318 | 0 | 0.00 | 0.00 | | 2024-10-31 08:56:16.889299+00 | | |
| public | m_pot | 160953 | 23802 | 0.00 | 12.00 | | 2024-10-31 00:01:54.062311+00 | | 2024-10-31 23:31:48.375177+00 |
| public | m_pot_profile | 48415 | 44 | 0.00 | 0.00 | | 2024-10-24 07:34:35.794371+00 | | |
| public | m_provider_user | 71 | 1 | 0.00 | 1.00 | | 2024-10-26 03:39:27.909527+00 | | |
| public | m_region | 99 | 0 | 0.00 | 0.00 | | 2024-10-25 08:59:08.29826+00 | | |
| public | m_role | 563 | 0 | 0.00 | 0.00 | | 2024-10-25 08:59:08.277107+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-25 08:59:08.132474+00 | | |
| public | m_setting | 11899 | 1806 | 0.00 | 13.00 | | 2024-10-30 14:13:00.742355+00 | | 2024-10-31 19:31:48.124857+00 |
| public | m_setting_log | 28496 | 1256 | 0.00 | 4.00 | | 2024-10-28 18:37:52.516744+00 | | 2024-10-31 07:38:56.107888+00 |
| public | m_site | 177 | 0 | 0.00 | 0.00 | | 2024-10-25 08:59:08.152717+00 | | |
| public | m_tenant | 98 | 0 | 0.00 | 0.00 | | 2024-10-25 08:59:08.458753+00 | | |
| public | m_tx | 99864 | 16770 | 0.00 | 14.00 | | 2024-10-31 11:27:02.79583+00 | | 2024-10-31 11:37:37.760584+00 |
| public | m_user | 30587 | 83 | 0.00 | 0.00 | | 2024-10-28 04:34:28.81365+00 | | |
| public | m_zone | 6949 | 4 | 0.00 | 0.00 | | 2024-10-26 22:13:23.150694+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-25 08:57:50.080807+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-10-25 08:59:08.236632+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 | 42227 | 0 | 0.00 | 0.00 | | 2024-10-31 23:45:26.008068+00 | | 2024-10-10 09:13:16.68237+00 |
| public | r_pot_auth | 8403 | 327 | 0.00 | 3.00 | | 2024-10-28 04:48:16.273919+00 | | |
| public | r_pot_category | 6989 | 4 | 0.00 | 0.00 | | 2024-10-31 20:07:28.144943+00 | | 2024-10-31 20:01:26.846284+00 |
| public | r_pot_group | 95802 | 15960 | 0.00 | 14.00 | | 2024-10-31 22:02:26.934809+00 | | 2024-11-01 00:05:25.220923+00 |
| public | r_pot_tx | 57216 | 4333 | 0.00 | 7.00 | | 2024-10-24 06:17:04.301856+00 | | 2024-10-29 10:18:54.209249+00 |
| public | r_pot_user | 18833 | 16 | 0.00 | 0.00 | | 2024-10-30 07:12:28.643799+00 | | |
| public | r_provider_tenant | 3021 | 6 | 0.00 | 0.00 | | 2024-10-31 03:30:33.946133+00 | | |
| public | r_role_feature | 5186 | 0 | 0.00 | 0.00 | | 2024-10-30 07:12:28.675646+00 | | |
| public | r_tenant_feature | 3593 | 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 | 19301 | 13 | 0.00 | 0.00 | | 2024-10-30 07:12:22.073489+00 | | |
| public | r_user_site | 5094 | 10 | 0.00 | 0.00 | | 2024-10-25 08:59:08.110821+00 | | |
| public | r_zone_category | 3376 | 0 | 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 | 1559758 | 30511 | 0.00 | 1.00 | | 2024-10-28 07:14:11.555458+00 | | 2024-10-21 08:30:34.484639+00 |
| public | t_general | 2693 | 20 | 0.00 | 0.00 | | 2024-10-25 08:59:08.438807+00 | | |
| public | t_mobile_device_history | 651360 | 0 | 0.00 | 0.00 | | 2024-10-27 23:34:41.754604+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-10-25 08:59:08.257742+00 | | |
| public | t_notify_history | 3339294 | 13962 | 0.00 | 0.00 | | 2024-10-26 11:42:21.809569+00 | | 2024-10-24 22:46:31.398488+00 |
| public | t_operation_log | 12438479 | 6 | 0.00 | 0.00 | | 2024-10-23 02:39:12.220069+00 | | |
| public | t_plan | 13928926 | 547590 | 0.00 | 3.00 | | 2024-10-29 23:27:26.161738+00 | | 2024-10-31 01:28:17.533824+00 |
| public | t_plan_detail | 23969006 | 1660188 | 0.00 | 6.00 | | 2024-10-23 17:56:43.003801+00 | | 2024-10-31 07:10:53.444351+00 |
| public | t_plan_sync | 41957 | 4423 | 0.00 | 9.00 | | 2024-11-01 00:31:14.414898+00 | | 2024-11-01 00:41:17.113628+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-10-25 08:59:08.48175+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-25 08:57:50.123891+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-25 08:59:08.319174+00 | | |
| public | t_recv_position_history | 116817 | 59012 | 0.00 | 33.00 | | 2024-11-01 00:52:14.153194+00 | 2024-10-31 13:30:07.694634+00 | 2024-11-01 00:52:14.708146+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-25 08:57:50.150535+00 | | |
| public | t_terminal | 103380 | 7099 | 0.00 | 6.00 | | 2024-10-24 06:17:05.395335+00 | | 2024-10-31 21:07:32.480431+00 |
| public | t_terminal_log | 11916190 | 0 | 0.00 | 0.00 | | 2024-10-31 12:58:45.492243+00 | | |
| public | w_arrival_notify | 79 | 9 | 0.00 | 10.00 | | 2024-10-31 07:02:26.023294+00 | | 2024-10-30 19:57:34.379205+00 |
| public | w_latest_position | 61658 | 13474 | 0.00 | 17.00 | | 2024-11-01 00:52:14.825382+00 | | 2024-11-01 00:52:14.940738+00 |
| public | w_latest_presence | 199945 | 86328 | 0.00 | 30.00 | | 2024-11-01 00:52:21.947448+00 | | 2024-11-01 00:52:22.38363+00 |
| public | w_latest_sensor | 344 | 213 | 0.00 | 38.00 | | 2024-11-01 00:52:16.762037+00 | | 2024-11-01 00:52:16.875059+00 |
| public | w_lock | 14740 | 0 | 0.00 | 0.00 | | 2024-10-30 04:41:31.350151+00 | | |
| public | w_master_update | 172 | 56 | 0.00 | 24.00 | | 2024-10-31 23:52:25.916486+00 | | 2024-10-31 23:45:25.840974+00 |
| public | w_migration | 824 | 0 | 0.00 | 0.00 | | 2024-10-25 10:16:31.251755+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | | | |
| public | w_plan_with_detail | 13932483 | 1075335 | 0.00 | 7.00 | | 2024-10-26 04:33:02.041393+00 | | 2024-10-31 01:22:08.767261+00 |