| 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 | 29521865 | 0 | 0.00 | 0.00 | | 2024-01-31 17:10:08.547786+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-01-27 22:32:29.513253+00 | | |
| e202312 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-27 22:32:29.502436+00 | | |
| e202312 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-27 22:32:29.491556+00 | | |
| e202312 | t_position_history | 322270488 | 0 | 0.00 | 0.00 | | 2024-01-30 02:06:19.225522+00 | | 2023-12-30 17:24:31.17066+00 |
| e202312 | t_presence_history | 54449810 | 0 | 0.00 | 0.00 | | 2024-01-29 00:44:49.31426+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 | 27175641 | 86838 | 0.00 | 0.00 | | 2024-01-31 16:20:59.837737+00 | | 2024-01-30 15:14:06.375164+00 |
| e202401 | a_stay_time | 17178510 | 160826 | 0.00 | 0.00 | | 2024-01-29 17:15:20.16429+00 | | 2024-01-30 15:11:06.159905+00 |
| e202401 | l_position_history | 0 | 0 | 0 | 0 | | 2024-01-31 17:45:32.534218+00 | | |
| e202401 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-31 17:45:32.556084+00 | | |
| e202401 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-31 17:45:32.54524+00 | | |
| e202401 | t_position_history | 338646034 | 1570818 | 0.00 | 0.00 | | 2024-01-27 22:24:30.122039+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 | 14223154 | 428 | 0.00 | 0.00 | | 2024-02-08 17:46:32.326667+00 | | 2024-01-30 12:58:27.389928+00 |
| e202402 | a_proximity_sum | 7695847 | 0 | 0.00 | 0.00 | | 2024-02-08 15:11:56.886659+00 | | 2024-02-08 16:20:33.574182+00 |
| e202402 | a_stay_time | 4958815 | 24664 | 0.00 | 0.00 | | 2024-02-07 18:30:45.026621+00 | | 2024-02-08 17:26:01.599442+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 | 110196074 | 0 | 0.00 | 0.00 | | 2024-02-08 07:29:00.92736+00 | | 2024-02-09 00:19:02.509699+00 |
| e202402 | t_presence_history | 13072234 | 2232726 | 0.00 | 14.00 | | 2024-02-09 07:50:46.781183+00 | | 2024-02-09 08:04:08.703931+00 |
| e202402 | t_sensor_history | 4350806 | 0 | 0.00 | 0.00 | | 2024-02-08 15:21:55.388502+00 | | 2024-02-08 19:28:46.447331+00 |
| public | __digdag_status | 25 | 10 | 0.00 | 28.00 | | 2024-02-09 04:46:46.220971+00 | | 2024-02-09 07:00:08.563484+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.831309+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.819354+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-01-26 04:46:19.469496+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:19.45835+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:19.447248+00 | | |
| public | m_area | 624 | 12 | 0.00 | 1.00 | | 2024-01-30 00:23:30.956475+00 | | 2024-01-18 08:43:32.882494+00 |
| public | m_auth | 90 | 18 | 0.00 | 16.00 | | 2024-01-26 04:46:18.849777+00 | | |
| public | m_category | 1578 | 0 | 0.00 | 0.00 | | 2024-01-30 00:23:31.030972+00 | | |
| public | m_exb | 18550 | 11 | 0.00 | 0.00 | | 2024-02-08 05:37:37.34489+00 | | 2024-01-31 23:41:48.109481+00 |
| public | m_favorite | 147193 | 1936 | 0.00 | 1.00 | | 2024-01-27 02:50:24.98761+00 | | 2024-01-18 07:33:40.519402+00 |
| public | m_feature | 150 | 0 | 0.00 | 0.00 | | 2024-01-26 23:33:07.371313+00 | | |
| public | m_group | 13445 | 17 | 0.00 | 0.00 | | 2024-02-02 08:29:26.691915+00 | | 2024-01-01 03:10:40.774873+00 |
| public | m_holiday | 15697 | 0 | 0.00 | 0.00 | | 2024-01-26 02:30:50.318248+00 | | 2024-02-01 01:01:41.977654+00 |
| public | m_lob | 17927 | 16 | 0.00 | 0.00 | | 2024-02-07 10:03:39.393564+00 | | 2024-01-26 12:24:11.753833+00 |
| public | m_location | 33017 | 1440 | 0.00 | 4.00 | | 2024-01-27 17:20:22.386337+00 | | 2024-02-02 10:56:18.136784+00 |
| public | m_notify_template | 716 | 7 | 0.00 | 0.00 | | 2024-01-26 04:46:18.963043+00 | | 2023-12-25 06:37:18.875076+00 |
| public | m_outside | 268 | 0 | 0.00 | 0.00 | | 2024-02-05 02:43:42.016653+00 | | |
| public | m_pot | 260706 | 33365 | 0.00 | 11.00 | | 2024-01-31 13:22:30.527119+00 | | 2024-02-09 00:22:05.346271+00 |
| public | m_pot_profile | 30873 | 217 | 0.00 | 0.00 | | 2024-01-26 23:50:08.210301+00 | | 2024-01-17 00:25:12.254289+00 |
| public | m_provider_user | 24 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.018706+00 | | |
| public | m_region | 97 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.077118+00 | | |
| public | m_role | 511 | 2 | 0.00 | 0.00 | | 2024-01-26 04:46:19.060964+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:18.888729+00 | | |
| public | m_setting | 18547 | 458 | 0.00 | 2.00 | | 2024-02-09 07:24:18.994463+00 | | 2024-02-09 06:08:21.937846+00 |
| public | m_setting_log | 76041 | 0 | 0.00 | 0.00 | | 2024-02-09 02:36:43.391033+00 | | 2024-02-09 02:35:44.447927+00 |
| public | m_site | 166 | 1 | 0.00 | 0.00 | | 2024-01-26 04:46:18.914137+00 | | |
| public | m_tenant | 96 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.200989+00 | | |
| public | m_tx | 81148 | 13948 | 0.00 | 14.00 | | 2024-02-08 06:31:42.392266+00 | | 2024-02-08 07:26:01.907742+00 |
| public | m_user | 28546 | 438 | 0.00 | 1.00 | | 2024-01-29 22:25:54.409086+00 | | 2024-01-21 00:05:10.573968+00 |
| public | m_zone | 4106 | 303 | 0.00 | 6.00 | | 2024-01-28 04:25:04.123964+00 | | 2024-02-08 08:37:07.646051+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.784599+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-01-26 04:46:18.995069+00 | | |
| public | r_group_auth | 436 | 4 | 0.00 | 0.00 | | 2024-01-26 08:30:47.979591+00 | | |
| public | r_location_zone | 31771 | 1301 | 0.00 | 3.00 | | 2024-02-05 00:16:24.519249+00 | | 2024-02-05 00:16:24.621693+00 |
| public | r_pot_auth | 693 | 7 | 0.00 | 1.00 | | 2024-02-04 01:31:20.991639+00 | | 2024-02-08 06:51:37.599116+00 |
| public | r_pot_category | 5889 | 0 | 0.00 | 0.00 | | 2024-02-09 06:17:08.904608+00 | | 2024-02-09 06:02:15.273911+00 |
| public | r_pot_group | 95470 | 4408 | 0.00 | 4.00 | | 2024-02-09 06:02:15.124757+00 | | 2024-02-09 06:02:15.245099+00 |
| public | r_pot_tx | 45179 | 131 | 0.00 | 0.00 | | 2024-02-08 00:54:05.710327+00 | | 2024-02-02 05:46:00.55509+00 |
| public | r_pot_user | 18586 | 76 | 0.00 | 0.00 | | 2024-02-02 10:30:05.483017+00 | | 2024-01-11 06:16:34.031162+00 |
| public | r_role_feature | 5318 | 5 | 0.00 | 0.00 | | 2024-02-02 08:29:26.494402+00 | | 2024-01-18 08:22:54.488926+00 |
| public | r_tenant_feature | 3280 | 2 | 0.00 | 0.00 | | 2024-01-31 13:22:22.062717+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 | 72 | 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 | 109 | 0.00 | 2.00 | | 2024-01-26 04:18:33.478269+00 | | 2024-01-11 06:16:33.979684+00 |
| public | r_zone_category | 2824 | 2 | 0.00 | 0.00 | | 2024-02-05 17:44:59.866477+00 | | 2024-01-23 05:12:39.85601+00 |
| public | t_attendance | 703091 | 43160 | 0.00 | 5.00 | | 2024-01-31 13:22:46.058086+00 | | 2024-02-01 18:38:38.896522+00 |
| public | t_general | 1314 | 5 | 0.00 | 0.00 | | 2024-01-26 04:46:19.184577+00 | | 2024-01-29 01:00:49.959426+00 |
| public | t_mobile_device_history | 380344 | 0 | 0.00 | 0.00 | | 2024-01-29 09:35:08.449742+00 | | 2024-02-09 04:49:46.654181+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.039732+00 | | |
| public | t_notify_history | 1848131 | 68196 | 0.00 | 3.00 | | 2024-01-27 17:50:51.673848+00 | | 2024-02-06 08:50:25.684869+00 |
| public | t_operation_log | 7355351 | 56730 | 0.00 | 0.00 | | 2024-02-06 00:39:28.041404+00 | | 2024-01-30 04:47:46.888304+00 |
| public | t_plan | 8785662 | 1506880 | 0.00 | 14.00 | | 2024-01-28 22:53:07.879863+00 | | 2024-02-08 09:15:51.014426+00 |
| public | t_plan_detail | 13819946 | 1173519 | 0.00 | 7.00 | | 2024-02-01 05:51:30.210964+00 | | 2024-02-08 23:13:00.628582+00 |
| public | t_plan_sync | 37065 | 2956 | 0.00 | 7.00 | | 2024-02-09 03:35:10.593751+00 | | 2024-02-09 03:33:07.446279+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.226001+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.796329+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:19.098026+00 | | |
| public | t_recv_position_history | 113359 | 1213677 | 10.00 | 91.00 | | 2024-02-09 08:05:10.069024+00 | 2024-02-08 12:30:03.091528+00 | 2024-02-09 08:05:10.559656+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-01-26 04:46:18.807623+00 | | |
| public | t_terminal | 20426 | 3143 | 0.00 | 13.00 | | 2024-01-30 03:34:15.818288+00 | | 2024-02-09 07:02:09.511804+00 |
| public | t_terminal_log | 4527442 | 0 | 0.00 | 0.00 | | 2024-02-05 08:20:40.408287+00 | | 2024-01-23 00:05:24.194059+00 |
| public | w_arrival_notify | 60 | 63 | 1.00 | 51.00 | | 2024-01-28 13:19:14.955948+00 | | 2024-02-07 01:06:02.433681+00 |
| public | w_latest_position | 42720 | 384803 | 9.00 | 90.00 | | 2024-02-09 08:05:08.070411+00 | | 2024-02-09 08:05:08.251831+00 |
| public | w_latest_presence | 184228 | 2311604 | 12.00 | 92.00 | 2024-01-18 12:30:06.016796+00 | 2024-02-09 08:05:08.956718+00 | 2024-01-18 12:30:06.178604+00 | 2024-02-09 08:05:09.396947+00 |
| public | w_latest_sensor | 443 | 8267 | 18.00 | 94.00 | | 2024-02-09 08:05:09.414898+00 | | 2024-02-09 08:05:09.529458+00 |
| public | w_lock | 11301 | 7 | 0.00 | 0.00 | | 2024-02-02 02:31:46.868393+00 | | 2024-01-31 02:02:19.791893+00 |
| public | w_master_update | 168 | 45 | 0.00 | 21.00 | | 2024-02-09 06:44:20.774478+00 | | 2024-02-09 05:33:51.552204+00 |
| public | w_migration | 853 | 0 | 0.00 | 0.00 | | 2024-01-26 04:46:19.487935+00 | | |
| public | w_plan_with_detail | 8813694 | 287843 | 0.00 | 3.00 | | 2024-02-08 04:57:16.082299+00 | | 2024-02-08 09:46:32.856207+00 |