| 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 | 19401694 | 0 | 0.00 | 0.00 | | 2025-10-17 15:57:46.874821+00 | | 2025-10-19 16:32:55.152702+00 |
| e202510 | a_stay_time | 23635788 | 0 | 0.00 | 0.00 | | 2025-10-19 15:36:41.073303+00 | | 2025-10-17 15:10:52.241806+00 |
| e202510 | t_position_history | 370882065 | 0 | 0.00 | 0.00 | | 2025-10-16 07:38:11.363489+00 | | 2025-10-19 08:38:48.349423+00 |
| e202510 | t_presence_history | 33664439 | 4549302 | 0.00 | 11.00 | | 2025-10-20 00:19:33.637714+00 | | 2025-10-20 00:46:05.439037+00 |
| e202510 | t_sensor_history | 7496785 | 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 | 12 | 0.00 | 25.00 | | 2025-10-16 12:54:07.643075+00 | | 2025-10-16 12:31:00.121853+00 |
| public | a_attendance_sum | 167170 | 29386 | 0.00 | 14.00 | | 2025-10-16 11:18:09.752546+00 | | 2025-10-20 00:30:03.946647+00 |
| public | a_plan_actual | 1292452 | 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 | 461116 | 6439 | 0.00 | 1.00 | | 2025-10-16 01:04:52.794752+00 | | 2025-10-08 08:16:47.032966+00 |
| public | l_pot_category | 14987 | 165 | 0.00 | 1.00 | | 2025-10-16 01:04:42.454122+00 | | 2025-10-09 00:24:05.35073+00 |
| public | l_pot_group | 232146 | 186 | 0.00 | 0.00 | | 2025-10-16 01:04:44.882841+00 | | 2025-10-08 06:51:13.475539+00 |
| public | l_pot_tx | 103481 | 376 | 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 | 147201 | 14763 | 0.00 | 9.00 | | 2025-10-17 14:08:05.263636+00 | | 2025-10-17 14:08:05.522849+00 |
| public | l_user | 66696 | 396 | 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-19 06:14:50.687163+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 | 232780 | 208 | 0.00 | 0.00 | | 2025-10-17 06:10:49.93841+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 116411 | 354 | 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 | 3330 | 0.00 | 10.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 | 21720 | 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 | 130254 | 17907 | 0.00 | 12.00 | | 2025-10-16 02:52:26.764228+00 | | 2025-10-20 00:43:58.123028+00 |
| public | m_pot | 204306 | 16047 | 0.00 | 7.00 | | 2025-10-16 04:30:31.77145+00 | | 2025-10-17 09:59:09.942781+00 |
| public | m_pot_profile | 53450 | 25 | 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 | 25268 | 228 | 0.00 | 0.00 | | 2025-10-20 00:19:58.403218+00 | | 2025-10-19 21:24:04.110113+00 |
| public | m_setting_log | 36481 | 1402 | 0.00 | 3.00 | | 2025-10-18 02:24:37.28304+00 | | 2025-10-19 07:23:45.497073+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 | 126742 | 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 | 294 | 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 | 12088 | 248 | 0.00 | 2.00 | | 2025-10-14 20:47:28.754226+00 | | 2025-10-16 14:40:55.512+00 |
| public | r_pot_group | 259555 | 4 | 0.00 | 0.00 | | 2025-10-19 06:14:50.307663+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 | 71000 | 673 | 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-19 16:10:43.981681+00 | | |
| public | t_attendance | 3533873 | 404 | 0.00 | 0.00 | | 2025-10-18 02:29:56.211609+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4389 | 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 | 1505981 | 0 | 0.00 | 0.00 | | 2025-10-17 00:27:53.768977+00 | | |
| public | t_mobile_status_history | 2286355 | 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 | 6892392 | 8005 | 0.00 | 0.00 | | 2025-10-17 01:04:12.218442+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 25367781 | 40205 | 0.00 | 0.00 | | 2025-10-15 00:11:28.016076+00 | | 2025-10-10 06:07:51.303391+00 |
| public | t_plan | 22701290 | 769405 | 0.00 | 3.00 | | 2025-10-16 04:01:56.983322+00 | | 2025-10-16 04:01:58.798046+00 |
| public | t_plan_cancel_history | 738476 | 57429 | 0.00 | 7.00 | | 2025-10-15 14:21:18.305049+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 42133005 | 3969054 | 0.00 | 8.00 | | 2025-10-15 02:10:16.711982+00 | | 2025-10-19 23:57:44.132997+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 | 109915 | 5458 | 0.00 | 4.00 | | 2025-10-20 00:28:57.794562+00 | | 2025-10-20 00:19:58.752903+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 | 155695 | 11297 | 0.00 | 6.00 | | 2025-10-20 00:49:03.165306+00 | 2025-10-19 13:30:03.00627+00 | 2025-10-20 00:49:03.441134+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:10.091095+00 | | |
| public | t_terminal | 19922 | 2752 | 0.00 | 12.00 | | 2025-10-19 20:29:38.954656+00 | | 2025-10-20 00:35:59.064181+00 |
| public | t_terminal_log | 31775626 | 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 | 103 | 65 | 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 | 55475 | 64 | 0.00 | 0.00 | | 2025-10-19 22:55:56.700456+00 | | 2025-10-20 00:35:03.672755+00 |
| public | w_latest_mobile_status | 54470 | 5388 | 0.00 | 9.00 | | 2025-10-20 00:01:50.417548+00 | | 2025-10-20 00:31:04.064739+00 |
| public | w_latest_position | 79227 | 20743 | 0.00 | 20.00 | | 2025-10-20 00:49:03.616518+00 | | 2025-10-20 00:49:03.851448+00 |
| public | w_latest_presence | 101575 | 101224 | 0.00 | 49.00 | | 2025-10-20 00:49:19.851245+00 | | 2025-10-20 00:49:21.359531+00 |
| public | w_latest_sensor | 386 | 285 | 0.00 | 42.00 | | 2025-10-20 00:49:04.543687+00 | | 2025-10-20 00:49:04.659032+00 |
| public | w_lock | 19437 | 3 | 0.00 | 0.00 | | 2025-10-13 17:49:56.418036+00 | | |
| public | w_master_update | 111 | 69 | 0.00 | 38.00 | | 2025-10-19 22:02:03.63017+00 | | 2025-10-20 00:05:48.263469+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-10-16 13:32:17.085474+00 | | |
| public | w_plan_sync_retry | 0 | 19 | 0 | 100.00 | | 2025-10-19 02:13:05.313604+00 | | 2025-10-19 05:40:49.885225+00 |
| public | w_plan_with_detail | 22639917 | 626160 | 0.00 | 2.00 | | 2025-10-16 23:24:35.028941+00 | | 2025-10-15 07:11:39.648945+00 |