| 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 |
|---|
| e202508 | a_proximity_sum | 32412630 | 1118 | 0.00 | 0.00 | | 2025-10-15 02:17:11.551315+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36235392 | 5820 | 0.00 | 0.00 | | 2025-10-15 09:34:18.195148+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 581729523 | 0 | 0.00 | 0.00 | | 2025-10-18 19:25:56.636407+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 77266308 | 0 | 0.00 | 0.00 | | 2025-10-15 03:53:58.254543+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764750 | 0 | 0.00 | 0.00 | | 2025-10-17 11:21:30.41468+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 29563984 | 0 | 0.00 | 0.00 | | 2025-10-18 04:38:39.082311+00 | | 2025-09-30 15:54:26.616538+00 |
| e202509 | a_stay_time | 38715375 | 2363 | 0.00 | 0.00 | | 2025-10-13 14:58:31.047301+00 | | 2025-09-30 17:25:54.238102+00 |
| e202509 | t_position_history | 598197283 | 0 | 0.00 | 0.00 | | 2025-10-17 03:18:12.784883+00 | | 2025-09-29 20:40:54.897196+00 |
| e202509 | t_presence_history | 74242343 | 0 | 0.00 | 0.00 | | 2025-10-16 07:57:03.935953+00 | | 2025-09-30 14:47:50.312729+00 |
| e202509 | t_sensor_history | 11637656 | 0 | 0.00 | 0.00 | | 2025-10-16 23:25:13.940952+00 | | 2025-09-29 19:30:39.022501+00 |
| e202510 | a_proximity_sum | 18689761 | 0 | 0.00 | 0.00 | | 2025-10-17 15:57:46.874821+00 | | 2025-10-17 15:57:56.4325+00 |
| e202510 | a_stay_time | 23470974 | 0 | 0.00 | 0.00 | | 2025-10-15 17:26:20.081411+00 | | 2025-10-17 15:10:52.241806+00 |
| e202510 | t_position_history | 357982157 | 0 | 0.00 | 0.00 | | 2025-10-16 07:38:11.363489+00 | | 2025-10-17 03:19:26.613066+00 |
| e202510 | t_presence_history | 32366307 | 5848068 | 0.00 | 15.00 | | 2025-10-18 23:20:51.195886+00 | | 2025-10-19 00:37:28.256577+00 |
| e202510 | t_sensor_history | 7108496 | 0 | 0.00 | 0.00 | | 2025-10-16 13:35:49.033747+00 | | 2025-10-18 11:45:00.385458+00 |
| public | __digdag_status | 35 | 8 | 0.00 | 18.00 | | 2025-10-16 12:54:07.643075+00 | | 2025-10-16 12:31:00.121853+00 |
| public | a_attendance_sum | 166613 | 26853 | 0.00 | 13.00 | | 2025-10-16 11:18:09.752546+00 | | 2025-10-18 08:38:58.55109+00 |
| public | a_plan_actual | 1292435 | 0 | 0.00 | 0.00 | | 2025-10-17 06:14:45.038448+00 | | 2025-10-08 16:50:49.780136+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:11.962589+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:11.210474+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-10-16 10:41:10.017066+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-10-18 23:32:17.503506+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-10-18 02:30:13.15784+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-10-18 07:38:38.560617+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-10-18 02:28:36.336791+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-10-18 07:38:38.582538+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-10-18 07:38:38.602415+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-10-18 02:28:36.356149+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-10-18 02:28:36.31393+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-10-18 07:38:37.518795+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-10-18 02:28:36.378399+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-10-18 02:28:36.398704+00 | | |
| public | l_area | 1561 | 3 | 0.00 | 0.00 | | 2025-10-16 01:04:40.868272+00 | | |
| public | l_auth | 188 | 9 | 0.00 | 4.00 | | 2025-10-16 01:04:40.765633+00 | | |
| public | l_category | 2648 | 32 | 0.00 | 1.00 | | 2025-10-16 01:04:42.506556+00 | | |
| public | l_group | 35659 | 34 | 0.00 | 0.00 | | 2025-10-16 01:04:45.171989+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2049 | 36 | 0.00 | 1.00 | | 2025-10-14 20:47:30.44883+00 | | 2025-10-07 02:10:08.82178+00 |
| public | l_location | 125757 | 8992 | 0.00 | 6.00 | | 2025-10-16 10:00:17.400384+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 110534 | 541 | 0.00 | 0.00 | | 2025-10-16 01:04:41.503386+00 | | 2025-10-08 06:15:53.514279+00 |
| public | l_outside | 442 | 2 | 0.00 | 0.00 | | 2025-10-16 01:04:40.806484+00 | | |
| public | l_pot | 461015 | 6410 | 0.00 | 1.00 | | 2025-10-16 01:04:52.794752+00 | | 2025-10-08 08:16:47.032966+00 |
| public | l_pot_category | 14899 | 151 | 0.00 | 1.00 | | 2025-10-16 01:04:42.454122+00 | | 2025-10-09 00:24:05.35073+00 |
| public | l_pot_group | 232145 | 182 | 0.00 | 0.00 | | 2025-10-16 01:04:44.882841+00 | | 2025-10-08 06:51:13.475539+00 |
| public | l_pot_tx | 103371 | 336 | 0.00 | 0.00 | | 2025-10-16 01:04:43.553381+00 | | 2025-10-16 14:41:09.972047+00 |
| public | l_role | 770 | 3 | 0.00 | 0.00 | | 2025-10-15 23:42:52.72862+00 | | |
| public | l_role_feature | 7353 | 54 | 0.00 | 0.00 | | 2025-10-15 23:42:52.689972+00 | | 2025-10-15 07:33:48.119231+00 |
| public | l_site | 246 | 2 | 0.00 | 0.00 | | 2025-10-16 01:04:40.892779+00 | | |
| public | l_tx | 147189 | 14763 | 0.00 | 9.00 | | 2025-10-17 14:08:05.263636+00 | | 2025-10-17 14:08:05.522849+00 |
| public | l_user | 66650 | 322 | 0.00 | 0.00 | | 2025-10-15 23:42:52.591292+00 | | 2025-09-30 09:16:26.739287+00 |
| public | l_zone | 9921 | 96 | 0.00 | 0.00 | | 2025-10-16 01:04:41.593598+00 | | |
| public | l_zone_category | 5644 | 144 | 0.00 | 2.00 | | 2025-10-15 23:42:51.586576+00 | | |
| public | m_area | 778 | 0 | 0.00 | 0.00 | | 2025-10-17 16:38:48.602218+00 | | 2025-10-01 05:38:37.738397+00 |
| public | m_auth | 144 | 0 | 0.00 | 0.00 | | 2025-10-16 10:41:12.015023+00 | | 2025-10-16 07:39:06.554981+00 |
| public | m_category | 2388 | 0 | 0.00 | 0.00 | | 2025-10-17 16:38:48.534576+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-10-12 06:16:07.621763+00 | | |
| public | m_exb | 27415 | 31 | 0.00 | 0.00 | | 2025-10-16 06:19:02.098597+00 | | 2025-10-08 06:39:33.915423+00 |
| public | m_favorite | 232638 | 90 | 0.00 | 0.00 | | 2025-10-17 06:10:49.93841+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 116097 | 351 | 0.00 | 0.00 | | 2025-10-13 22:17:23.877275+00 | | 2025-10-08 06:28:55.123658+00 |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-10-16 21:34:04.954876+00 | | |
| public | m_group | 28187 | 2859 | 0.00 | 9.00 | | 2025-10-15 14:40:11.347592+00 | | 2025-10-18 14:40:39.157965+00 |
| public | m_holiday | 42267 | 786 | 0.00 | 1.00 | | 2025-10-15 04:06:12.304085+00 | | |
| public | m_lob | 21716 | 87 | 0.00 | 0.00 | | 2025-10-15 07:20:47.269519+00 | | 2025-10-08 07:12:18.311027+00 |
| public | m_lob_log | 5476 | 21 | 0.00 | 0.00 | | 2025-10-15 06:21:25.418426+00 | | 2025-10-08 07:12:19.071766+00 |
| public | m_location | 44836 | 262 | 0.00 | 0.00 | | 2025-10-17 10:56:06.119452+00 | | 2025-10-01 00:59:46.898895+00 |
| public | m_notify_template | 1209 | 0 | 0.00 | 0.00 | | 2025-10-16 10:44:58.361093+00 | | 2025-10-15 07:20:46.843185+00 |
| public | m_outside | 367 | 6 | 0.00 | 1.00 | | 2025-10-14 07:56:51.22316+00 | | |
| public | m_personal_setting | 130155 | 17894 | 0.00 | 12.00 | | 2025-10-16 02:52:26.764228+00 | | 2025-10-18 23:53:04.004951+00 |
| public | m_pot | 204216 | 12361 | 0.00 | 5.00 | | 2025-10-16 04:30:31.77145+00 | | 2025-10-17 09:59:09.942781+00 |
| public | m_pot_profile | 53449 | 22 | 0.00 | 0.00 | | 2025-10-15 20:27:39.77273+00 | | 2025-10-08 07:13:12.749032+00 |
| public | m_provider_user | 85 | 1 | 0.00 | 1.00 | | 2025-10-16 23:31:35.151863+00 | | |
| public | m_region | 112 | 0 | 0.00 | 0.00 | | 2025-10-16 10:44:58.449917+00 | | |
| public | m_role | 773 | 0 | 0.00 | 0.00 | | 2025-10-16 10:44:58.435175+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-10-16 10:41:12.184676+00 | | |
| public | m_setting | 27338 | 1388 | 0.00 | 4.00 | | 2025-10-18 01:40:34.970093+00 | | 2025-10-17 22:31:29.835647+00 |
| public | m_setting_log | 35833 | 2244 | 0.00 | 5.00 | | 2025-10-18 02:24:37.28304+00 | | 2025-10-18 09:09:59.721685+00 |
| public | m_site | 182 | 0 | 0.00 | 0.00 | | 2025-10-16 10:41:11.980197+00 | | |
| public | m_tenant | 111 | 0 | 0.00 | 0.00 | | 2025-10-16 10:44:58.475613+00 | | |
| public | m_tx | 126730 | 23390 | 0.00 | 15.00 | | 2025-10-17 14:10:49.911254+00 | | 2025-10-18 03:48:10.626733+00 |
| public | m_user | 36812 | 256 | 0.00 | 0.00 | | 2025-10-14 03:12:23.753574+00 | | 2025-10-09 05:29:57.240234+00 |
| public | m_zone | 7763 | 11 | 0.00 | 0.00 | | 2025-10-17 03:44:56.905054+00 | | 2025-09-25 00:44:34.586772+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:09.989192+00 | | |
| public | r_auth_zone | 169 | 0 | 0.00 | 0.00 | | 2025-10-17 06:14:52.145994+00 | | 2025-10-16 06:10:16.245861+00 |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-10-16 10:44:58.387914+00 | | |
| public | r_group_auth | 573 | 0 | 0.00 | 0.00 | | 2025-10-18 23:51:03.405534+00 | | |
| public | r_location_zone | 55644 | 0 | 0.00 | 0.00 | | 2025-10-17 16:38:48.407563+00 | | 2025-10-10 09:12:08.559148+00 |
| public | r_pot_auth | 8456 | 232 | 0.00 | 2.00 | | 2025-10-15 00:33:47.344451+00 | | 2025-10-02 06:32:17.177394+00 |
| public | r_pot_category | 12014 | 234 | 0.00 | 1.00 | | 2025-10-14 20:47:28.754226+00 | | 2025-10-16 14:40:55.512+00 |
| public | r_pot_group | 202972 | 804 | 0.00 | 0.00 | | 2025-10-12 06:16:07.13053+00 | | 2025-10-06 05:12:08.991893+00 |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-10-17 03:33:34.656217+00 | | |
| public | r_pot_tx | 70930 | 633 | 0.00 | 0.00 | | 2025-10-15 03:33:28.955169+00 | | 2025-10-09 00:14:51.631362+00 |
| public | r_pot_user | 21441 | 77 | 0.00 | 0.00 | | 2025-10-15 07:20:46.797942+00 | | 2025-10-15 06:52:43.009326+00 |
| public | r_provider_tenant | 919 | 0 | 0.00 | 0.00 | | 2025-10-18 19:35:37.886044+00 | | 2025-10-15 08:41:23.083636+00 |
| public | r_role_feature | 6607 | 146 | 0.00 | 2.00 | | 2025-10-13 23:21:15.799189+00 | | 2025-10-16 08:18:51.923966+00 |
| public | r_tenant_feature | 4465 | 0 | 0.00 | 0.00 | | 2025-10-18 02:28:34.398451+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-10-13 13:08:43.8596+00 | | |
| public | r_user_region | 21940 | 77 | 0.00 | 0.00 | | 2025-10-15 07:20:40.488275+00 | | |
| public | r_user_site | 5525 | 0 | 0.00 | 0.00 | | 2025-10-16 10:41:12.158072+00 | | |
| public | r_zone_category | 5111 | 72 | 0.00 | 1.00 | | 2025-10-14 22:42:42.606648+00 | | |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-10-12 19:11:42.167693+00 | | |
| public | t_attendance | 3529370 | 71 | 0.00 | 0.00 | | 2025-10-18 02:29:56.211609+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4384 | 0 | 0.00 | 0.00 | | 2025-10-18 23:32:16.999893+00 | | |
| public | t_general_20250618 | 3013 | 0 | 0.00 | 0.00 | | 2025-10-14 07:50:31.613174+00 | | |
| public | t_job | 56 | 0 | 0.00 | 0.00 | | 2025-10-14 20:47:30.501356+00 | | 2025-10-07 11:10:36.569592+00 |
| public | t_mobile_device_history | 1505581 | 0 | 0.00 | 0.00 | | 2025-10-17 00:27:53.768977+00 | | |
| public | t_mobile_status_history | 2284512 | 0 | 0.00 | 0.00 | | 2025-10-15 07:20:51.807708+00 | | 2025-09-29 04:23:22.984019+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-10-16 10:44:58.413621+00 | | |
| public | t_notify_history | 6884447 | 5212 | 0.00 | 0.00 | | 2025-10-17 01:04:12.218442+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 25345464 | 40191 | 0.00 | 0.00 | | 2025-10-15 00:11:28.016076+00 | | 2025-10-10 06:07:51.303391+00 |
| public | t_plan | 22599481 | 624901 | 0.00 | 2.00 | | 2025-10-16 04:01:56.983322+00 | | 2025-10-16 04:01:58.798046+00 |
| public | t_plan_cancel_history | 737673 | 56466 | 0.00 | 7.00 | | 2025-10-15 14:21:18.305049+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 41792621 | 3575206 | 0.00 | 7.00 | | 2025-10-15 02:10:16.711982+00 | | 2025-10-16 04:10:14.026992+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-10-17 03:33:34.634033+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-10-17 03:33:34.60921+00 | | |
| public | t_plan_sync | 68862 | 5080 | 0.00 | 6.00 | | 2025-10-19 00:18:27.142494+00 | | 2025-10-19 00:33:27.02114+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-10-16 10:44:58.508647+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:10.058447+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-10-16 10:44:58.46087+00 | | |
| public | t_recv_position_history | 149879 | 31888 | 0.00 | 17.00 | | 2025-10-19 00:49:26.926862+00 | 2025-10-18 13:30:02.416199+00 | 2025-10-19 00:50:26.195097+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:10.091095+00 | | |
| public | t_terminal | 19917 | 3252 | 0.00 | 14.00 | | 2025-10-18 19:36:16.368437+00 | | 2025-10-19 00:35:28.746749+00 |
| public | t_terminal_log | 31669434 | 260263 | 0.00 | 0.00 | | 2025-10-14 15:57:34.482462+00 | | 2025-10-10 03:51:41.313882+00 |
| public | temp_pivot_table | 239616 | 0 | 0.00 | 0.00 | | 2025-10-15 20:28:03.458407+00 | | |
| public | w_arrival_notify | 99 | 62 | 0.00 | 38.00 | | 2025-10-14 11:22:40.961184+00 | | 2025-10-16 15:01:12.122723+00 |
| public | w_latest_mobile_device | 55443 | 581 | 0.00 | 1.00 | | 2025-10-13 00:43:21.333282+00 | | 2025-10-10 10:34:42.678977+00 |
| public | w_latest_mobile_status | 54438 | 8160 | 0.00 | 13.00 | | 2025-10-17 06:49:52.586031+00 | | 2025-10-18 13:49:45.369477+00 |
| public | w_latest_position | 79224 | 15778 | 0.00 | 16.00 | | 2025-10-19 00:45:27.406817+00 | | 2025-10-19 00:50:26.417656+00 |
| public | w_latest_presence | 106061 | 80646 | 0.00 | 43.00 | | 2025-10-19 00:50:42.193285+00 | | 2025-10-19 00:50:44.209552+00 |
| public | w_latest_sensor | 386 | 272 | 0.00 | 41.00 | | 2025-10-19 00:50:26.435788+00 | | 2025-10-19 00:50:26.554875+00 |
| public | w_lock | 19433 | 1 | 0.00 | 0.00 | | 2025-10-13 17:49:56.418036+00 | | |
| public | w_master_update | 111 | 59 | 0.00 | 34.00 | | 2025-10-18 19:35:34.598706+00 | | 2025-10-18 23:46:04.401418+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-10-16 13:32:17.085474+00 | | |
| public | w_plan_sync_retry | 0 | 49 | 0 | 100.00 | | 2025-10-17 11:22:32.493727+00 | | 2025-10-17 23:07:22.983728+00 |
| public | w_plan_with_detail | 22538108 | 453948 | 0.00 | 1.00 | | 2025-10-16 23:24:35.028941+00 | | 2025-10-15 07:11:39.648945+00 |