| 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 |
|---|
| e202502 | a_proximity_sum | 26761417 | 0 | 0.00 | 0.00 | | 2025-04-22 10:02:33.75932+00 | | |
| e202502 | a_stay_time | 32954414 | 0 | 0.00 | 0.00 | | 2025-04-22 10:05:12.315711+00 | | |
| e202502 | t_position_history | 410577599 | 0 | 0.00 | 0.00 | | 2025-04-22 08:08:04.318472+00 | | |
| e202502 | t_presence_history | 43102119 | 0 | 0.00 | 0.00 | | 2025-04-22 11:30:30.239643+00 | | |
| e202502 | t_sensor_history | 9718051 | 0 | 0.00 | 0.00 | | 2025-04-18 06:41:39.347645+00 | | |
| e202503 | a_proximity_sum | 30294941 | 0 | 0.00 | 0.00 | | 2025-04-22 02:44:50.638785+00 | | 2025-03-31 18:03:10.657748+00 |
| e202503 | a_stay_time | 37339455 | 0 | 0.00 | 0.00 | | 2025-04-20 06:14:45.256497+00 | | 2025-03-31 16:10:17.452785+00 |
| e202503 | t_position_history | 458463862 | 145281 | 0.00 | 0.00 | | 2025-04-20 01:50:35.883744+00 | | 2025-03-31 02:22:42.238716+00 |
| e202503 | t_presence_history | 47512495 | 0 | 0.00 | 0.00 | | 2025-04-21 11:35:58.222577+00 | | 2025-03-31 14:30:05.025309+00 |
| e202503 | t_sensor_history | 13280702 | 0 | 0.00 | 0.00 | | 2025-04-21 03:50:00.415335+00 | | 2025-03-30 05:19:12.818843+00 |
| e202504 | a_proximity_sum | 26309394 | 0 | 0.00 | 0.00 | | 2025-04-22 16:04:45.88068+00 | | 2025-04-22 17:45:05.176894+00 |
| e202504 | a_stay_time | 32724364 | 0 | 0.00 | 0.00 | | 2025-04-23 16:55:23.442549+00 | | 2025-04-23 17:31:36.782077+00 |
| e202504 | t_position_history | 381312420 | 0 | 0.00 | 0.00 | | 2025-04-23 06:23:32.142429+00 | | 2025-04-24 00:28:18.30021+00 |
| e202504 | t_presence_history | 43602299 | 8637815 | 0.00 | 16.00 | | 2025-04-24 00:12:51.540091+00 | | 2025-04-24 00:32:15.42399+00 |
| e202504 | t_sensor_history | 10091605 | 0 | 0.00 | 0.00 | | 2025-04-23 07:01:51.740615+00 | | 2025-04-23 20:41:44.314888+00 |
| public | __digdag_status | 33 | 11 | 0.00 | 25.00 | | 2025-04-22 08:49:24.979608+00 | | 2025-04-22 08:30:30.373927+00 |
| public | a_attendance_sum | 154381 | 2117 | 0.00 | 1.00 | | 2025-04-24 01:00:48.26704+00 | | 2025-04-24 00:57:30.342781+00 |
| public | a_plan_actual | 360998 | 0 | 0.00 | 0.00 | | 2025-04-23 03:34:49.063815+00 | | 2025-04-21 19:56:09.242262+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-04-16 09:10:59.947023+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-04-16 09:10:27.61003+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-04-16 08:11:24.131816+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-04-18 11:23:47.576298+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-04-18 06:15:47.674999+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-04-18 06:15:48.80397+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-04-18 06:09:42.6822+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-04-18 06:15:48.828974+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-04-18 06:15:48.853962+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-04-18 06:09:42.705808+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-04-18 06:09:42.659395+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-04-18 06:15:47.698392+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-04-18 06:09:42.728269+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-04-18 06:09:42.752282+00 | | |
| public | m_area | 682 | 26 | 0.00 | 3.00 | | 2025-04-18 03:41:07.771952+00 | | |
| public | m_auth | 126 | 19 | 0.00 | 13.00 | | 2025-04-16 09:15:44.480864+00 | | |
| public | m_category | 2055 | 64 | 0.00 | 3.00 | | 2025-04-18 03:41:07.62419+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-04-19 09:45:24.940352+00 | | |
| public | m_exb | 22446 | 1853 | 0.00 | 7.00 | | 2025-04-18 05:33:05.212782+00 | | 2025-04-18 05:25:13.194696+00 |
| public | m_favorite | 206686 | 1723 | 0.00 | 0.00 | | 2025-04-17 09:57:07.36418+00 | | 2025-04-17 07:23:56.648773+00 |
| public | m_favorite_group | 94029 | 453 | 0.00 | 0.00 | | 2025-04-21 01:02:00.995417+00 | | 2025-04-23 01:13:01.586631+00 |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-04-17 00:13:05.625619+00 | | |
| public | m_group | 21536 | 160 | 0.00 | 0.00 | | 2025-04-21 02:13:04.623366+00 | | 2025-04-17 05:11:27.091502+00 |
| public | m_holiday | 34499 | 573 | 0.00 | 1.00 | | 2025-04-23 02:29:10.389634+00 | | |
| public | m_lob | 22887 | 16 | 0.00 | 0.00 | | 2025-04-23 06:33:29.143669+00 | | |
| public | m_lob_log | 1208 | 0 | 0.00 | 0.00 | | 2025-04-22 08:19:24.128424+00 | | 2025-04-08 13:07:59.355699+00 |
| public | m_location | 37787 | 1141 | 0.00 | 2.00 | | 2025-04-21 12:24:12.196559+00 | | 2025-04-18 05:33:05.989617+00 |
| public | m_notify_template | 796 | 26 | 0.00 | 3.00 | | 2025-04-16 09:15:45.70316+00 | | |
| public | m_outside | 336 | 9 | 0.00 | 2.00 | | 2025-04-22 01:54:22.744188+00 | | |
| public | m_personal_setting | 117552 | 19260 | 0.00 | 14.00 | | 2025-04-23 00:20:35.923841+00 | | 2025-04-24 00:59:51.502519+00 |
| public | m_pot | 172898 | 16093 | 0.00 | 8.00 | | 2025-04-20 23:52:06.821616+00 | | 2025-04-24 00:13:13.891562+00 |
| public | m_pot_profile | 55651 | 0 | 0.00 | 0.00 | | 2025-04-23 21:06:42.647069+00 | | |
| public | m_provider_user | 76 | 7 | 0.00 | 8.00 | | 2025-04-17 00:41:54.888865+00 | | |
| public | m_region | 104 | 4 | 0.00 | 3.00 | | 2025-04-16 09:15:45.778636+00 | | |
| public | m_role | 627 | 18 | 0.00 | 2.00 | | 2025-04-16 09:15:45.762189+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-04-16 09:15:45.200466+00 | | |
| public | m_setting | 24916 | 512 | 0.00 | 2.00 | | 2025-04-23 18:04:53.10631+00 | | 2025-04-23 11:20:57.951234+00 |
| public | m_setting_log | 31218 | 0 | 0.00 | 0.00 | | 2025-04-20 05:03:58.706451+00 | | 2025-04-23 15:07:48.064873+00 |
| public | m_site | 168 | 6 | 0.00 | 3.00 | | 2025-04-16 09:15:45.665051+00 | | |
| public | m_tenant | 103 | 4 | 0.00 | 3.00 | | 2025-04-16 09:15:45.942834+00 | | |
| public | m_tx | 103828 | 7175 | 0.00 | 6.00 | | 2025-04-23 00:51:12.69858+00 | | 2025-04-23 00:51:12.960008+00 |
| public | m_user | 30621 | 865 | 0.00 | 2.00 | | 2025-04-21 07:31:27.208932+00 | | 2025-04-10 00:37:55.807882+00 |
| public | m_zone | 5957 | 147 | 0.00 | 2.00 | | 2025-04-17 05:37:31.383188+00 | | 2025-04-22 05:10:35.803034+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-04-16 09:10:26.25672+00 | | |
| public | r_auth_zone | 199 | 17 | 0.00 | 7.00 | | 2025-04-17 12:15:43.011781+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-04-16 09:15:45.725537+00 | | |
| public | r_group_auth | 525 | 1 | 0.00 | 0.00 | | 2025-04-19 04:12:55.271672+00 | | 2025-03-26 03:04:45.736116+00 |
| public | r_location_zone | 48369 | 6002 | 0.00 | 11.00 | | 2025-04-18 05:25:13.470897+00 | | 2025-04-18 05:33:05.351013+00 |
| public | r_pot_auth | 3100 | 519 | 0.00 | 14.00 | | 2025-04-21 09:16:48.043092+00 | | 2025-04-21 09:16:48.055394+00 |
| public | r_pot_category | 8651 | 275 | 0.00 | 3.00 | | 2025-04-22 06:20:05.507789+00 | | 2025-04-22 06:05:03.33299+00 |
| public | r_pot_group | 157810 | 25312 | 0.00 | 13.00 | | 2025-04-22 09:12:43.90272+00 | | 2025-04-22 09:11:40.774965+00 |
| public | r_pot_tx | 59518 | 245 | 0.00 | 0.00 | | 2025-04-22 23:01:13.89301+00 | | 2025-04-16 01:46:23.478317+00 |
| public | r_pot_user | 17679 | 0 | 0.00 | 0.00 | | 2025-04-23 07:38:24.333483+00 | | 2025-04-11 04:25:14.304027+00 |
| public | r_provider_tenant | 1238 | 282 | 0.00 | 18.00 | | 2025-04-17 06:15:38.434373+00 | | 2025-04-17 06:15:38.439218+00 |
| public | r_role_feature | 5507 | 112 | 0.00 | 1.00 | | 2025-04-21 02:13:04.338255+00 | | |
| public | r_tenant_feature | 3919 | 109 | 0.00 | 2.00 | | 2025-04-18 06:09:36.18059+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-04-20 18:25:24.25478+00 | | |
| public | r_user_region | 18483 | 0 | 0.00 | 0.00 | | 2025-04-23 08:38:42.879194+00 | | 2025-04-11 08:15:31.065002+00 |
| public | r_user_site | 5500 | 120 | 0.00 | 2.00 | | 2025-04-16 09:15:44.587425+00 | | 2025-04-01 08:22:56.974638+00 |
| public | r_zone_category | 4073 | 0 | 0.00 | 0.00 | | 2025-04-22 08:19:24.101578+00 | | 2025-04-21 08:24:56.428231+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-04-20 01:17:09.36399+00 | | |
| public | t_attendance | 2398314 | 35020 | 0.00 | 1.00 | | 2025-04-18 06:10:10.669451+00 | | 2025-04-09 22:28:06.904166+00 |
| public | t_general | 3585 | 10 | 0.00 | 0.00 | | 2025-04-16 09:15:45.925642+00 | | |
| public | t_mobile_device_history | 1292402 | 6037 | 0.00 | 0.00 | | 2025-04-17 01:55:49.917865+00 | | 2025-04-08 09:59:18.385985+00 |
| public | t_mobile_status_history | 273353 | 0 | 0.00 | 0.00 | | 2025-04-23 03:45:10.095471+00 | | 2025-04-23 04:57:56.898093+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-04-16 09:15:45.74667+00 | | |
| public | t_notify_history | 5077709 | 18198 | 0.00 | 0.00 | | 2025-04-17 02:33:17.08325+00 | | 2025-04-16 01:46:24.219943+00 |
| public | t_operation_log | 18404765 | 2039 | 0.00 | 0.00 | | 2025-04-22 08:52:10.715778+00 | | |
| public | t_plan | 21318070 | 1098625 | 0.00 | 4.00 | | 2025-04-20 09:44:12.097181+00 | | 2025-04-22 00:34:06.978868+00 |
| public | t_plan_cancel_history | 559979 | 63402 | 0.00 | 10.00 | | 2025-04-22 03:49:40.838267+00 | | 2025-04-21 00:15:34.806232+00 |
| public | t_plan_detail | 36449207 | 842298 | 0.00 | 2.00 | | 2025-04-23 04:35:35.75541+00 | | 2025-04-22 22:42:35.032085+00 |
| public | t_plan_sync | 48328 | 7299 | 0.00 | 13.00 | | 2025-04-24 00:34:15.426435+00 | | 2025-04-24 00:38:15.331719+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-04-16 09:15:45.97142+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-04-16 09:10:26.31432+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-04-16 09:15:45.797993+00 | | |
| public | t_recv_position_history | 131166 | 179173 | 1.00 | 57.00 | | 2025-04-24 01:01:55.617313+00 | 2025-04-23 13:30:12.011459+00 | 2025-04-24 01:01:56.058138+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-04-16 09:10:26.377154+00 | | |
| public | t_terminal | 7827 | 1211 | 0.00 | 13.00 | | 2025-04-24 00:20:18.091909+00 | | 2025-04-24 01:01:57.047805+00 |
| public | t_terminal_log | 19415867 | 0 | 0.00 | 0.00 | | 2025-04-22 05:23:47.984289+00 | | 2025-04-20 18:17:12.184127+00 |
| public | temp_pivot_table | 241320 | 0 | 0.00 | 0.00 | | 2025-04-23 21:06:48.530345+00 | | |
| public | w_arrival_notify | 88 | 11 | 0.00 | 11.00 | | 2025-04-23 06:33:17.317387+00 | | 2025-04-24 00:24:19.738231+00 |
| public | w_latest_mobile_device | 49950 | 2500 | 0.00 | 4.00 | | 2025-04-20 02:54:46.449667+00 | | 2025-04-24 00:58:51.628649+00 |
| public | w_latest_mobile_status | 48890 | 3122 | 0.00 | 6.00 | | 2025-04-24 00:43:16.283552+00 | | 2025-04-24 00:31:20.445908+00 |
| public | w_latest_position | 66138 | 60675 | 0.00 | 47.00 | | 2025-04-24 01:01:56.298504+00 | | 2025-04-24 01:01:56.594131+00 |
| public | w_latest_presence | 186116 | 319680 | 1.00 | 63.00 | | 2025-04-24 01:02:05.059179+00 | | 2025-04-24 01:02:05.793552+00 |
| public | w_latest_sensor | 386 | 612 | 1.00 | 61.00 | | 2025-04-24 01:01:57.729794+00 | | 2025-04-24 01:01:57.842776+00 |
| public | w_lock | 16219 | 0 | 0.00 | 0.00 | | 2025-04-21 00:17:41.785502+00 | | |
| public | w_master_update | 182 | 67 | 0.00 | 26.00 | | 2025-04-23 22:05:04.545688+00 | | 2025-04-23 22:04:04.349229+00 |
| public | w_migration | 679 | 58 | 0.00 | 7.00 | | 2025-04-16 11:03:20.145572+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-04-16 05:39:36.255688+00 | | |
| public | w_plan_with_detail | 21281952 | 1593057 | 0.00 | 6.00 | | 2025-04-17 01:21:32.38087+00 | | 2025-04-22 00:29:48.034387+00 |