| 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 | 26956974 | 0 | 0.00 | 0.00 | | 2025-04-04 21:40:38.811198+00 | | |
| e202502 | a_stay_time | 33161106 | 0 | 0.00 | 0.00 | | 2025-04-04 21:40:38.856537+00 | | |
| e202502 | t_position_history | 416040085 | 0 | 0.00 | 0.00 | | 2025-04-04 11:24:09.377243+00 | | |
| e202502 | t_presence_history | 43102215 | 0 | 0.00 | 0.00 | | 2025-04-04 23:30:30.94475+00 | | |
| e202502 | t_sensor_history | 9718098 | 0 | 0.00 | 0.00 | | 2025-04-10 00:58:34.129103+00 | | |
| e202503 | a_proximity_sum | 32344710 | 0 | 0.00 | 0.00 | | 2025-04-04 05:45:38.104748+00 | | 2025-03-31 18:03:10.657748+00 |
| e202503 | a_stay_time | 37646760 | 0 | 0.00 | 0.00 | | 2025-04-02 12:13:56.57976+00 | | 2025-03-31 16:10:17.452785+00 |
| e202503 | t_position_history | 463592262 | 0 | 0.00 | 0.00 | | 2025-04-02 09:10:50.372355+00 | | 2025-03-31 02:22:42.238716+00 |
| e202503 | t_presence_history | 47512593 | 0 | 0.00 | 0.00 | | 2025-04-03 22:15:20.404582+00 | | 2025-03-31 14:30:05.025309+00 |
| e202503 | t_sensor_history | 13280802 | 0 | 0.00 | 0.00 | | 2025-04-03 06:23:50.586428+00 | | 2025-03-30 05:19:12.818843+00 |
| e202504 | a_proximity_sum | 12867617 | 0 | 0.00 | 0.00 | | 2025-04-10 18:00:47.493345+00 | | 2025-04-10 16:03:08.269273+00 |
| e202504 | a_stay_time | 15543458 | 0 | 0.00 | 0.00 | | 2025-04-10 15:14:19.216021+00 | | 2025-04-10 17:00:54.967447+00 |
| e202504 | t_position_history | 178856911 | 0 | 0.00 | 0.00 | | 2025-04-10 00:11:02.727804+00 | | 2025-04-10 21:28:29.56256+00 |
| e202504 | t_presence_history | 20407514 | 2357215 | 0.00 | 10.00 | | 2025-04-11 00:40:49.00425+00 | | 2025-04-11 00:43:20.340456+00 |
| e202504 | t_sensor_history | 4439204 | 0 | 0.00 | 0.00 | | 2025-04-10 10:54:15.405622+00 | | 2025-04-10 06:24:40.545147+00 |
| public | __digdag_status | 33 | 44 | 1.00 | 57.00 | | 2025-04-07 08:30:21.698057+00 | | 2025-04-08 08:30:34.249855+00 |
| public | a_attendance_sum | 97869 | 17853 | 0.00 | 15.00 | | 2025-04-11 00:30:51.789084+00 | | 2025-04-11 00:55:38.677131+00 |
| public | a_plan_actual | 300490 | 0 | 0.00 | 0.00 | | 2025-04-05 23:41:01.451485+00 | | 2025-04-09 16:20:28.281943+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-04-08 01:38:54.539555+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-04-08 01:38:48.218339+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-04-08 01:02:48.569002+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-04-10 05:05:40.297278+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-04-10 00:26:18.828927+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-04-10 00:26:20.904131+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-04-10 00:25:49.376499+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-04-10 00:26:20.925794+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-04-10 00:26:20.950915+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-04-10 00:25:49.399646+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-04-10 00:25:49.35432+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-04-10 00:26:19.269186+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-04-10 00:25:49.421964+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-04-10 00:25:49.445823+00 | | |
| public | m_area | 696 | 0 | 0.00 | 0.00 | | 2025-04-09 17:33:04.555775+00 | | |
| public | m_auth | 139 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.560006+00 | | |
| public | m_category | 2077 | 0 | 0.00 | 0.00 | | 2025-04-09 17:33:04.526289+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-04-10 21:17:26.117198+00 | | |
| public | m_exb | 22700 | 912 | 0.00 | 3.00 | | 2025-04-07 22:03:14.182811+00 | | 2025-04-08 04:44:38.347843+00 |
| public | m_favorite | 193728 | 508 | 0.00 | 0.00 | | 2025-04-09 03:41:51.956487+00 | | |
| public | m_favorite_group | 92520 | 390 | 0.00 | 0.00 | | 2025-04-03 03:33:32.385304+00 | | |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-04-08 08:01:16.587471+00 | | |
| public | m_group | 20683 | 530 | 0.00 | 2.00 | | 2025-04-03 04:47:12.749951+00 | | 2025-04-10 08:53:46.985551+00 |
| public | m_holiday | 34916 | 0 | 0.00 | 0.00 | | 2025-04-05 18:08:49.818807+00 | | |
| public | m_lob | 22856 | 53 | 0.00 | 0.00 | | 2025-04-06 06:31:58.501239+00 | | |
| public | m_lob_log | 1107 | 2 | 0.00 | 0.00 | | 2025-04-04 13:21:10.774033+00 | | 2025-04-08 13:07:59.355699+00 |
| public | m_location | 38579 | 4458 | 0.00 | 10.00 | | 2025-04-03 23:00:42.183363+00 | | 2025-04-10 11:54:58.526332+00 |
| public | m_notify_template | 801 | 1 | 0.00 | 0.00 | | 2025-04-08 01:38:54.755669+00 | | |
| public | m_outside | 338 | 3 | 0.00 | 0.00 | | 2025-04-04 04:55:42.814948+00 | | |
| public | m_personal_setting | 116470 | 20817 | 0.00 | 15.00 | | 2025-04-09 03:01:09.252642+00 | | 2025-04-11 00:31:49.699756+00 |
| public | m_pot | 172831 | 27642 | 0.00 | 13.00 | | 2025-04-08 10:06:16.177768+00 | | 2025-04-10 00:12:03.174784+00 |
| public | m_pot_profile | 51744 | 86 | 0.00 | 0.00 | | 2025-04-07 01:33:24.074968+00 | | |
| public | m_provider_user | 76 | 3 | 0.00 | 3.00 | | 2025-04-08 08:32:33.23552+00 | | |
| public | m_region | 106 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.847892+00 | | |
| public | m_role | 632 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.825871+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.6977+00 | | |
| public | m_setting | 22345 | 1136 | 0.00 | 4.00 | | 2025-04-10 05:16:06.188692+00 | | 2025-04-10 00:23:49.691934+00 |
| public | m_setting_log | 31259 | 1422 | 0.00 | 4.00 | | 2025-04-10 01:46:42.819838+00 | | 2025-04-10 02:54:59.220075+00 |
| public | m_site | 167 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.728679+00 | | |
| public | m_tenant | 105 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.891213+00 | | |
| public | m_tx | 104122 | 12769 | 0.00 | 10.00 | | 2025-04-10 11:54:51.062824+00 | | 2025-04-10 11:56:49.639688+00 |
| public | m_user | 28820 | 349 | 0.00 | 1.00 | | 2025-04-03 10:37:20.485654+00 | | 2025-04-10 00:37:55.807882+00 |
| public | m_zone | 6781 | 37 | 0.00 | 0.00 | | 2025-04-08 22:40:19.029035+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-04-08 01:38:47.203311+00 | | |
| public | r_auth_zone | 213 | 0 | 0.00 | 0.00 | | 2025-04-09 05:12:08.1613+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.777901+00 | | |
| public | r_group_auth | 526 | 0 | 0.00 | 0.00 | | 2025-04-10 11:23:13.84504+00 | | 2025-03-26 03:04:45.736116+00 |
| public | r_location_zone | 47890 | 3732 | 0.00 | 7.00 | | 2025-04-07 09:36:15.592266+00 | | 2025-04-10 11:54:57.942558+00 |
| public | r_pot_auth | 3227 | 500 | 0.00 | 13.00 | | 2025-04-10 12:14:41.599887+00 | | 2025-04-10 12:14:41.612538+00 |
| public | r_pot_category | 8654 | 59 | 0.00 | 0.00 | | 2025-04-10 20:13:18.332443+00 | | 2025-04-10 20:02:00.904555+00 |
| public | r_pot_group | 156938 | 3327 | 0.00 | 2.00 | | 2025-04-11 00:36:49.402555+00 | | 2025-04-11 00:02:05.782063+00 |
| public | r_pot_tx | 59601 | 10257 | 0.00 | 14.00 | | 2025-04-09 00:12:21.656874+00 | | 2025-04-10 12:14:51.624163+00 |
| public | r_pot_user | 17993 | 75 | 0.00 | 0.00 | | 2025-04-06 10:03:44.247087+00 | | |
| public | r_provider_tenant | 1289 | 108 | 0.00 | 7.00 | | 2025-04-04 10:13:11.934083+00 | | 2025-04-09 03:44:53.984075+00 |
| public | r_role_feature | 5489 | 9 | 0.00 | 0.00 | | 2025-04-03 04:47:12.501199+00 | | |
| public | r_tenant_feature | 3926 | 0 | 0.00 | 0.00 | | 2025-04-10 00:25:42.293118+00 | | |
| public | r_tx_sensor | 359 | 0 | 0.00 | 0.00 | | 2025-04-03 00:47:29.699291+00 | | |
| public | r_user_region | 18810 | 74 | 0.00 | 0.00 | | 2025-04-06 12:29:24.382781+00 | | |
| public | r_user_site | 5563 | 10 | 0.00 | 0.00 | | 2025-04-08 01:38:54.67213+00 | | 2025-04-01 08:22:56.974638+00 |
| public | r_zone_category | 4103 | 90 | 0.00 | 2.00 | | 2025-04-04 13:21:10.742742+00 | | |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-04-02 08:56:37.436121+00 | | |
| public | t_attendance | 2366089 | 7821 | 0.00 | 0.00 | | 2025-04-10 00:26:18.803942+00 | | 2025-04-09 22:28:06.904166+00 |
| public | t_general | 3471 | 2 | 0.00 | 0.00 | | 2025-04-08 01:38:54.876756+00 | | |
| public | t_mobile_device_history | 882615 | 0 | 0.00 | 0.00 | | 2025-04-08 09:59:17.813828+00 | | 2025-04-08 09:59:18.385985+00 |
| public | t_mobile_status_history | 53590 | 0 | 0.00 | 0.00 | | 2025-04-10 07:11:17.720765+00 | | 2025-04-10 10:40:54.852727+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.798695+00 | | |
| public | t_notify_history | 4817854 | 8046 | 0.00 | 0.00 | | 2025-04-08 11:12:23.511698+00 | | |
| public | t_operation_log | 16721150 | 710 | 0.00 | 0.00 | | 2025-04-04 17:46:21.183203+00 | | |
| public | t_plan | 20570052 | 1866579 | 0.00 | 8.00 | | 2025-04-02 17:50:39.147964+00 | | 2025-04-08 22:18:12.083632+00 |
| public | t_plan_cancel_history | 380566 | 59753 | 0.00 | 13.00 | | 2025-04-09 03:17:39.529023+00 | | |
| public | t_plan_detail | 35349494 | 2806615 | 0.00 | 7.00 | | 2025-04-06 01:47:24.508025+00 | | 2025-04-10 04:19:00.413058+00 |
| public | t_plan_sync | 48014 | 5322 | 0.00 | 9.00 | | 2025-04-11 00:35:49.521798+00 | | 2025-04-11 00:41:19.862134+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-04-08 01:38:54.915085+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-04-08 01:38:47.226402+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-04-08 01:38:54.85902+00 | | |
| public | t_recv_position_history | 130872 | 115848 | 0.00 | 46.00 | | 2025-04-11 00:56:37.425279+00 | 2025-04-10 13:30:08.432486+00 | 2025-04-11 00:56:37.995733+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-04-08 01:38:47.255251+00 | | |
| public | t_terminal | 7524 | 994 | 0.00 | 11.00 | | 2025-04-11 00:34:49.052431+00 | | 2025-04-11 00:55:39.072201+00 |
| public | t_terminal_log | 18521912 | 0 | 0.00 | 0.00 | | 2025-04-04 08:35:50.45422+00 | | |
| public | temp_pivot_table | 241462 | 0 | 0.00 | 0.00 | | 2025-04-07 01:33:30.298199+00 | | |
| public | w_arrival_notify | 88 | 12 | 0.00 | 12.00 | | 2025-04-10 11:08:47.938742+00 | | 2025-04-10 15:01:22.080546+00 |
| public | w_latest_mobile_device | 49691 | 776 | 0.00 | 1.00 | | 2025-04-08 10:05:15.075883+00 | | 2025-04-08 10:05:15.263702+00 |
| public | w_latest_mobile_status | 48632 | 9357 | 0.00 | 16.00 | | 2025-04-09 03:05:08.081927+00 | | 2025-04-11 00:31:50.298346+00 |
| public | w_latest_position | 65378 | 19889 | 0.00 | 23.00 | | 2025-04-11 00:56:38.140369+00 | | 2025-04-11 00:56:38.272675+00 |
| public | w_latest_presence | 226458 | 113668 | 0.00 | 33.00 | | 2025-04-11 00:56:45.83631+00 | | 2025-04-11 00:56:48.724384+00 |
| public | w_latest_sensor | 386 | 294 | 0.00 | 43.00 | | 2025-04-11 00:56:38.28605+00 | | 2025-04-11 00:56:38.402585+00 |
| public | w_lock | 16134 | 0 | 0.00 | 0.00 | | 2025-04-03 03:03:32.667252+00 | | |
| public | w_master_update | 183 | 60 | 0.00 | 24.00 | | 2025-04-11 00:13:49.188332+00 | | 2025-04-10 23:51:50.267321+00 |
| public | w_migration | 737 | 0 | 0.00 | 0.00 | | 2025-04-08 03:19:25.053176+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-04-07 19:19:02.402139+00 | | |
| public | w_plan_with_detail | 20528166 | 947364 | 0.00 | 4.00 | | 2025-04-08 09:18:32.333633+00 | | 2025-04-08 22:27:05.205124+00 |