| 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 | 17019648 | 0 | 0.00 | 0.00 | | 2024-02-05 17:44:59.915336+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 | 322261979 | 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 | 11901056 | 0 | 0.00 | 0.00 | | 2024-02-04 13:37:25.772039+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 | 17146998 | 4457 | 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 | 338287698 | 177 | 0.00 | 0.00 | | 2024-02-12 05:00:24.254854+00 | | 2024-01-30 10:26:24.358574+00 |
| e202401 | t_presence_history | 36846721 | 0 | 0.00 | 0.00 | | 2024-02-07 05:10:35.781981+00 | | 2024-01-31 15:07:30.056064+00 |
| e202401 | t_sensor_history | 14218779 | 4803 | 0.00 | 0.00 | | 2024-02-08 17:46:32.326667+00 | | 2024-01-30 12:58:27.389928+00 |
| e202402 | a_proximity_sum | 14203794 | 0 | 0.00 | 0.00 | | 2024-02-15 16:16:33.046117+00 | | 2024-02-14 19:06:09.895564+00 |
| e202402 | a_stay_time | 8755615 | 5461 | 0.00 | 0.00 | | 2024-02-14 17:01:25.763461+00 | | 2024-02-15 19:06:28.923134+00 |
| e202402 | l_position_history | 0 | 0 | 0 | 0 | | 2024-02-04 17:45:51.675349+00 | | |
| e202402 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-02-04 17:45:51.697709+00 | | |
| e202402 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-02-04 17:45:51.686765+00 | | |
| e202402 | t_position_history | 191010068 | 0 | 0.00 | 0.00 | | 2024-02-15 10:03:35.91142+00 | | 2024-02-16 01:03:24.529732+00 |
| e202402 | t_presence_history | 22025826 | 1691387 | 0.00 | 7.00 | | 2024-02-16 08:27:18.427167+00 | | 2024-02-16 08:38:24.452274+00 |
| e202402 | t_sensor_history | 7827569 | 0 | 0.00 | 0.00 | | 2024-02-15 09:42:27.37734+00 | | 2024-02-15 13:36:51.959246+00 |
| public | __digdag_status | 58 | 36 | 0.00 | 38.00 | | 2024-02-16 02:35:53.267364+00 | | 2024-02-16 08:30:41.889827+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-02 00:33:54.614273+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:55.551944+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.527472+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:55.576229+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:55.597084+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.548568+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.505634+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.6382+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.569612+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-02-02 00:33:54.59112+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 | 624 | 0 | 0.00 | 0.00 | | 2024-02-14 01:24:18.309229+00 | | 2024-01-18 08:43:32.882494+00 |
| public | m_auth | 90 | 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 | 18565 | 61 | 0.00 | 0.00 | | 2024-02-08 05:37:37.34489+00 | | 2024-01-31 23:41:48.109481+00 |
| public | m_favorite | 148238 | 609 | 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 | 13462 | 28 | 0.00 | 0.00 | | 2024-02-02 08:29:26.691915+00 | | 2024-01-01 03:10:40.774873+00 |
| public | m_holiday | 15450 | 0 | 0.00 | 0.00 | | 2024-02-09 22:33:28.661294+00 | | 2024-02-01 01:01:41.977654+00 |
| public | m_lob | 17955 | 37 | 0.00 | 0.00 | | 2024-02-07 10:03:39.393564+00 | | 2024-01-26 12:24:11.753833+00 |
| public | m_location | 33034 | 48 | 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 | 268 | 1 | 0.00 | 0.00 | | 2024-02-05 02:43:42.016653+00 | | |
| public | m_pot | 234825 | 41987 | 0.00 | 15.00 | | 2024-02-12 22:37:26.973981+00 | | 2024-02-16 05:35:35.762875+00 |
| public | m_pot_profile | 30217 | 55 | 0.00 | 0.00 | | 2024-02-11 06:58:34.461014+00 | | 2024-01-17 00:25:12.254289+00 |
| public | m_provider_user | 65 | 60 | 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 | 18628 | 736 | 0.00 | 3.00 | | 2024-02-16 08:03:16.368651+00 | | 2024-02-16 07:57:16.128373+00 |
| public | m_setting_log | 61565 | 0 | 0.00 | 0.00 | 2024-02-16 03:34:50.060418+00 | 2024-02-16 01:42:40.361125+00 | | 2024-02-16 01:41:41.703069+00 |
| public | m_site | 167 | 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 | 81429 | 7789 | 0.00 | 8.00 | | 2024-02-16 01:52:16.94084+00 | | 2024-02-16 01:52:17.084821+00 |
| public | m_user | 28528 | 67 | 0.00 | 0.00 | | 2024-02-14 00:10:47.398573+00 | | 2024-01-21 00:05:10.573968+00 |
| public | m_zone | 5828 | 4 | 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 | 195 | 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 | 31784 | 1480 | 0.00 | 4.00 | | 2024-02-05 00:16:24.519249+00 | | 2024-02-05 00:16:24.621693+00 |
| public | r_pot_auth | 702 | 43 | 0.00 | 5.00 | | 2024-02-04 01:31:20.991639+00 | | 2024-02-08 06:51:37.599116+00 |
| public | r_pot_category | 5987 | 0 | 0.00 | 0.00 | | 2024-02-16 06:27:55.737176+00 | | 2024-02-16 06:02:35.189924+00 |
| public | r_pot_group | 95595 | 5496 | 0.00 | 5.00 | | 2024-02-16 06:02:35.036518+00 | | 2024-02-16 06:02:35.160004+00 |
| public | r_pot_tx | 45449 | 889 | 0.00 | 1.00 | | 2024-02-08 00:54:05.710327+00 | | 2024-02-02 05:46:00.55509+00 |
| public | r_pot_user | 18581 | 114 | 0.00 | 0.00 | | 2024-02-02 10:30:05.483017+00 | | 2024-01-11 06:16:34.031162+00 |
| public | r_provider_tenant | 2671 | 13 | 0.00 | 0.00 | | 2024-02-14 06:55:09.773332+00 | | 2024-02-14 06:29:54.651401+00 |
| public | r_role_feature | 5320 | 7 | 0.00 | 0.00 | | 2024-02-02 08:29:26.494402+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3282 | 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-04 13:36:24.314076+00 | | 2024-01-27 01:38:23.792244+00 |
| public | r_user_region | 19125 | 106 | 0.00 | 0.00 | | 2024-02-02 10:30:05.317859+00 | | 2024-01-11 06:16:33.903871+00 |
| public | r_user_site | 5221 | 2 | 0.00 | 0.00 | | 2024-02-10 02:55:50.770318+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2827 | 7 | 0.00 | 0.00 | | 2024-02-05 17:44:59.866477+00 | | 2024-01-23 05:12:39.85601+00 |
| public | t_attendance | 710027 | 3783 | 0.00 | 0.00 | | 2024-02-15 17:51:31.660381+00 | | 2024-02-09 19:46:38.999716+00 |
| public | t_general | 1349 | 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 | 386699 | 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 | 1884990 | 25697 | 0.00 | 1.00 | | 2024-02-12 01:03:03.92206+00 | | 2024-02-06 08:50:25.684869+00 |
| public | t_operation_log | 7532377 | 146341 | 0.00 | 1.00 | | 2024-02-06 00:39:28.041404+00 | | 2024-02-15 19:06:28.324191+00 |
| public | t_plan | 8926169 | 660319 | 0.00 | 6.00 | | 2024-02-13 00:36:42.000271+00 | | 2024-02-15 00:22:56.657939+00 |
| public | t_plan_detail | 13911092 | 35594 | 0.00 | 0.00 | | 2024-02-16 07:36:26.792864+00 | | 2024-02-16 04:34:44.824957+00 |
| public | t_plan_sync | 40933 | 7776 | 0.00 | 15.00 | | 2024-02-16 03:53:54.260943+00 | | 2024-02-16 03:35:22.280383+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 | 109035 | 657279 | 6.00 | 85.00 | | 2024-02-16 08:41:25.666119+00 | 2024-02-15 12:30:10.101065+00 | 2024-02-16 08:41:26.18904+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-02-10 04:41:09.497786+00 | | |
| public | t_terminal | 22204 | 4150 | 0.00 | 15.00 | | 2024-02-15 02:51:33.51099+00 | | 2024-02-16 07:28:15.939539+00 |
| public | t_terminal_log | 4723970 | 0 | 0.00 | 0.00 | | 2024-02-05 08:20:40.408287+00 | | 2024-02-10 06:01:59.826383+00 |
| public | w_arrival_notify | 63 | 9 | 0.00 | 12.00 | | 2024-02-12 18:14:45.694847+00 | | 2024-02-07 01:06:02.433681+00 |
| public | w_latest_position | 42924 | 202480 | 4.00 | 82.00 | | 2024-02-16 08:41:24.120524+00 | | 2024-02-16 08:41:24.342452+00 |
| public | w_latest_presence | 180301 | 1337138 | 7.00 | 88.00 | 2024-01-18 12:30:06.016796+00 | 2024-02-16 08:41:24.935933+00 | 2024-01-18 12:30:06.178604+00 | 2024-02-16 08:41:25.353697+00 |
| public | w_latest_sensor | 443 | 4545 | 10.00 | 91.00 | | 2024-02-16 08:41:24.358445+00 | | 2024-02-16 08:41:24.472355+00 |
| public | w_lock | 11459 | 10 | 0.00 | 0.00 | | 2024-02-02 02:31:46.868393+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 162 | 12 | 0.00 | 6.00 | | 2024-02-16 07:45:13.727138+00 | | 2024-02-16 06:14:40.064503+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-02-10 04:41:09.953492+00 | | |
| public | w_plan_with_detail | 8889575 | 1000806 | 0.00 | 10.00 | | 2024-02-08 04:57:16.082299+00 | | 2024-02-15 00:31:00.192609+00 |