| 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 | 38715301 | 0 | 0.00 | 0.00 | | 2025-10-20 02:47:57.994207+00 | | 2025-09-30 17:25:54.238102+00 |
| e202509 | t_position_history | 598197284 | 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 | 21543150 | 0 | 0.00 | 0.00 | | 2025-10-20 17:57:17.685552+00 | | 2025-10-20 17:57:20.743667+00 |
| e202510 | a_stay_time | 25690850 | 0 | 0.00 | 0.00 | | 2025-10-19 15:36:41.073303+00 | | 2025-10-20 15:35:52.341976+00 |
| e202510 | t_position_history | 396695158 | 0 | 0.00 | 0.00 | | 2025-10-20 07:36:05.874415+00 | | 2025-10-19 08:38:48.349423+00 |
| e202510 | t_presence_history | 45349756 | 2276142 | 0.00 | 4.00 | | 2025-10-21 00:33:21.970624+00 | | 2025-10-21 00:24:23.648512+00 |
| e202510 | t_sensor_history | 7887160 | 0 | 0.00 | 0.00 | | 2025-10-20 02:58:38.802857+00 | | 2025-10-20 09:58:50.014214+00 |
| public | __digdag_status | 36 | 15 | 0.00 | 29.00 | | 2025-10-16 12:54:07.643075+00 | | 2025-10-16 12:31:00.121853+00 |
| public | a_attendance_sum | 167751 | 8890 | 0.00 | 5.00 | | 2025-10-20 23:25:29.625368+00 | | 2025-10-21 00:34:45.48278+00 |
| public | a_plan_actual | 1301820 | 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 | 1562 | 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 | 35697 | 51 | 0.00 | 0.00 | | 2025-10-16 01:04:45.171989+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2052 | 37 | 0.00 | 1.00 | | 2025-10-14 20:47:30.44883+00 | | 2025-10-07 02:10:08.82178+00 |
| public | l_location | 125824 | 9068 | 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 | 567 | 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 | 461507 | 6650 | 0.00 | 1.00 | | 2025-10-16 01:04:52.794752+00 | | 2025-10-08 08:16:47.032966+00 |
| public | l_pot_category | 15093 | 253 | 0.00 | 1.00 | | 2025-10-16 01:04:42.454122+00 | | 2025-10-09 00:24:05.35073+00 |
| public | l_pot_group | 232352 | 214 | 0.00 | 0.00 | | 2025-10-16 01:04:44.882841+00 | | 2025-10-08 06:51:13.475539+00 |
| public | l_pot_tx | 103693 | 530 | 0.00 | 0.00 | | 2025-10-16 01:04:43.553381+00 | | 2025-10-16 14:41:09.972047+00 |
| public | l_role | 772 | 4 | 0.00 | 0.00 | | 2025-10-15 23:42:52.72862+00 | | |
| public | l_role_feature | 7377 | 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 | 147270 | 25488 | 0.00 | 14.00 | | 2025-10-17 14:08:05.263636+00 | | 2025-10-20 09:19:39.926768+00 |
| public | l_user | 66804 | 516 | 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 | 779 | 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 | 27421 | 35 | 0.00 | 0.00 | | 2025-10-16 06:19:02.098597+00 | | 2025-10-08 06:39:33.915423+00 |
| public | m_favorite | 233153 | 372 | 0.00 | 0.00 | | 2025-10-17 06:10:49.93841+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 117201 | 27 | 0.00 | 0.00 | | 2025-10-20 04:24:25.384252+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 | 28225 | 3752 | 0.00 | 11.00 | | 2025-10-15 14:40:11.347592+00 | | 2025-10-20 14:40:56.685806+00 |
| public | m_holiday | 42267 | 786 | 0.00 | 1.00 | | 2025-10-15 04:06:12.304085+00 | | |
| public | m_lob | 21755 | 95 | 0.00 | 0.00 | | 2025-10-15 07:20:47.269519+00 | | 2025-10-08 07:12:18.311027+00 |
| public | m_lob_log | 5486 | 21 | 0.00 | 0.00 | | 2025-10-15 06:21:25.418426+00 | | 2025-10-08 07:12:19.071766+00 |
| public | m_location | 44841 | 412 | 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 | 0 | 0.00 | 0.00 | | 2025-10-20 22:31:48.936907+00 | | |
| public | m_personal_setting | 130623 | 18443 | 0.00 | 12.00 | | 2025-10-16 02:52:26.764228+00 | | 2025-10-21 00:33:45.622891+00 |
| public | m_pot | 204618 | 19403 | 0.00 | 8.00 | | 2025-10-16 04:30:31.77145+00 | | 2025-10-21 00:05:30.564612+00 |
| public | m_pot_profile | 53490 | 55 | 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 | 775 | 1 | 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 | 27285 | 438 | 0.00 | 1.00 | | 2025-10-20 23:25:19.820152+00 | | 2025-10-20 07:44:32.331343+00 |
| public | m_setting_log | 38509 | 0 | 0.00 | 0.00 | | 2025-10-18 02:24:37.28304+00 | | 2025-10-20 21:56:44.656632+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 | 126811 | 13760 | 0.00 | 9.00 | | 2025-10-21 00:12:21.822952+00 | | 2025-10-21 00:12:22.004855+00 |
| public | m_user | 38212 | 29 | 0.00 | 0.00 | | 2025-10-20 08:38:24.741209+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 | 55618 | 26 | 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 | 234 | 0.00 | 2.00 | | 2025-10-15 00:33:47.344451+00 | | 2025-10-02 06:32:17.177394+00 |
| public | r_pot_category | 12106 | 336 | 0.00 | 2.00 | | 2025-10-14 20:47:28.754226+00 | | 2025-10-16 14:40:55.512+00 |
| public | r_pot_group | 259733 | 32 | 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 | 71058 | 827 | 0.00 | 1.00 | | 2025-10-15 03:33:28.955169+00 | | 2025-10-09 00:14:51.631362+00 |
| public | r_pot_user | 21438 | 81 | 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 | 6631 | 0 | 0.00 | 0.00 | | 2025-10-20 04:59:29.180782+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-20 02:21:45.620831+00 | | |
| public | r_user_region | 21974 | 81 | 0.00 | 0.00 | | 2025-10-15 07:20:40.488275+00 | | 2025-10-20 06:30:18.607127+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 | 3545203 | 11624 | 0.00 | 0.00 | | 2025-10-18 02:29:56.211609+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4394 | 0 | 0.00 | 0.00 | | 2025-10-18 23:32:16.999893+00 | | |
| public | t_general_20250618 | 2967 | 0 | 0.00 | 0.00 | | 2025-10-20 22:05:17.569479+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 | 1506791 | 0 | 0.00 | 0.00 | | 2025-10-17 00:27:53.768977+00 | | |
| public | t_mobile_status_history | 2296605 | 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 | 6909536 | 9154 | 0.00 | 0.00 | | 2025-10-17 01:04:12.218442+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 25433055 | 40219 | 0.00 | 0.00 | | 2025-10-15 00:11:28.016076+00 | | 2025-10-10 06:07:51.303391+00 |
| public | t_plan | 22882108 | 566660 | 0.00 | 2.00 | | 2025-10-20 01:32:17.721826+00 | | 2025-10-20 14:13:51.657236+00 |
| public | t_plan_cancel_history | 740841 | 83790 | 0.00 | 10.00 | | 2025-10-15 14:21:18.305049+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 42607970 | 4911346 | 0.00 | 10.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 | 110026 | 739 | 0.00 | 0.00 | | 2025-10-21 00:35:44.802257+00 | | 2025-10-21 00:34:44.482273+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 | 163168 | 71524 | 0.00 | 30.00 | | 2025-10-21 00:49:49.325484+00 | 2025-10-20 13:30:02.714675+00 | 2025-10-21 00:49:49.604443+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:10.091095+00 | | |
| public | t_terminal | 19934 | 3566 | 0.00 | 15.00 | | 2025-10-20 19:43:33.210916+00 | | 2025-10-21 00:45:51.846153+00 |
| public | t_terminal_log | 31885672 | 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 | 101 | 15 | 0.00 | 12.00 | | 2025-10-20 02:35:46.507327+00 | | 2025-10-20 05:31:29.677846+00 |
| public | w_latest_mobile_device | 55600 | 157 | 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 | 54596 | 6100 | 0.00 | 10.00 | | 2025-10-20 23:52:21.551746+00 | | 2025-10-21 00:11:21.791329+00 |
| public | w_latest_position | 79275 | 105465 | 1.00 | 57.00 | | 2025-10-21 00:49:49.716742+00 | | 2025-10-21 00:49:49.89548+00 |
| public | w_latest_presence | 111362 | 500500 | 4.00 | 81.00 | | 2025-10-21 00:49:50.274315+00 | | 2025-10-21 00:49:52.599222+00 |
| public | w_latest_sensor | 386 | 825 | 2.00 | 68.00 | | 2025-10-21 00:49:49.914421+00 | | 2025-10-21 00:49:50.026864+00 |
| public | w_lock | 19442 | 0 | 0.00 | 0.00 | | 2025-10-20 03:20:24.420019+00 | | |
| public | w_master_update | 194 | 14 | 0.00 | 6.00 | | 2025-10-21 00:37:49.280736+00 | | 2025-10-21 00:01:26.347287+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-10-16 13:32:17.085474+00 | | |
| public | w_plan_sync_retry | 1 | 48 | 48.00 | 97.00 | | 2025-10-20 08:38:24.853559+00 | | 2025-10-21 00:18:28.481633+00 |
| public | w_plan_with_detail | 22764654 | 1082812 | 0.00 | 4.00 | | 2025-10-16 23:24:35.028941+00 | | 2025-10-20 02:27:41.473246+00 |