| 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 | 581741787 | 49235 | 0.00 | 0.00 | | 2025-10-11 18:01:45.403348+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 | 29564016 | 681 | 0.00 | 0.00 | | 2025-10-11 02:58:47.213742+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 | 18270509 | 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 | 23332158 | 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 | 347184630 | 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 | 31751184 | 4204722 | 0.00 | 11.00 | | 2025-10-18 00:18:49.780088+00 | | 2025-10-18 00:48:18.169207+00 |
| e202510 | t_sensor_history | 6726949 | 0 | 0.00 | 0.00 | | 2025-10-16 13:35:49.033747+00 | | 2025-10-16 20:49:46.516557+00 |
| public | __digdag_status | 36 | 3 | 0.00 | 7.00 | | 2025-10-16 12:54:07.643075+00 | | 2025-10-16 12:31:00.121853+00 |
| public | a_attendance_sum | 166604 | 26675 | 0.00 | 13.00 | | 2025-10-16 11:18:09.752546+00 | | 2025-10-17 10:18:01.940333+00 |
| public | a_plan_actual | 1292406 | 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-11 22:41:53.626447+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-10-11 00:52:40.173272+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-10-11 05:52:45.43558+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.759269+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-10-11 05:52:45.458767+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-10-11 05:52:45.478503+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.780089+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.727907+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-10-11 05:52:43.796938+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.802849+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.825368+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 | 125712 | 8948 | 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 | 461003 | 6399 | 0.00 | 1.00 | | 2025-10-16 01:04:52.794752+00 | | 2025-10-08 08:16:47.032966+00 |
| public | l_pot_category | 14898 | 150 | 0.00 | 0.00 | | 2025-10-16 01:04:42.454122+00 | | 2025-10-09 00:24:05.35073+00 |
| public | l_pot_group | 232142 | 180 | 0.00 | 0.00 | | 2025-10-16 01:04:44.882841+00 | | 2025-10-08 06:51:13.475539+00 |
| public | l_pot_tx | 101238 | 334 | 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 | 14737 | 0.00 | 9.00 | | 2025-10-17 14:08:05.263636+00 | | 2025-10-17 14:08:05.522849+00 |
| public | l_user | 66648 | 318 | 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 | 232619 | 83 | 0.00 | 0.00 | | 2025-10-17 06:10:49.93841+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 116066 | 346 | 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 | 2181 | 0.00 | 7.00 | | 2025-10-15 14:40:11.347592+00 | | 2025-10-16 14:40:55.467088+00 |
| public | m_holiday | 42267 | 786 | 0.00 | 1.00 | | 2025-10-15 04:06:12.304085+00 | | |
| public | m_lob | 21714 | 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 | 44835 | 235 | 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 | 130132 | 18362 | 0.00 | 12.00 | | 2025-10-16 02:52:26.764228+00 | | 2025-10-17 14:27:45.181124+00 |
| public | m_pot | 204213 | 10791 | 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 | 15805 | 3154 | 0.00 | 16.00 | | 2025-10-16 09:37:00.315997+00 | | 2025-10-17 22:31:29.835647+00 |
| public | m_setting_log | 36630 | 1844 | 0.00 | 4.00 | | 2025-10-13 14:52:34.458006+00 | | 2025-10-17 05:51:49.066291+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 | 12881 | 0.00 | 9.00 | | 2025-10-17 14:10:49.911254+00 | | 2025-10-17 14:10:50.09092+00 |
| public | m_user | 36812 | 255 | 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-11 23:07:42.901083+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 | 233 | 0.00 | 1.00 | | 2025-10-14 20:47:28.754226+00 | | 2025-10-16 14:40:55.512+00 |
| public | r_pot_group | 202971 | 802 | 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 | 68799 | 631 | 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 | 125 | 0.00 | 11.00 | | 2025-10-11 19:37:43.914034+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 | 95 | 0.00 | 2.00 | | 2025-10-11 00:50:10.301846+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 | 3480880 | 57863 | 0.00 | 1.00 | | 2025-10-11 00:51:27.652186+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4379 | 2 | 0.00 | 0.00 | | 2025-10-11 22:41:53.303348+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 | 1505527 | 0 | 0.00 | 0.00 | | 2025-10-17 00:27:53.768977+00 | | |
| public | t_mobile_status_history | 2284229 | 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 | 6883787 | 4659 | 0.00 | 0.00 | | 2025-10-17 01:04:12.218442+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 25339845 | 40178 | 0.00 | 0.00 | | 2025-10-15 00:11:28.016076+00 | | 2025-10-10 06:07:51.303391+00 |
| public | t_plan | 22581797 | 597243 | 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 | 737433 | 56391 | 0.00 | 7.00 | | 2025-10-15 14:21:18.305049+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 41739826 | 3529830 | 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 | 68817 | 6334 | 0.00 | 8.00 | | 2025-10-18 00:19:16.710699+00 | | 2025-10-18 00:35:09.78037+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 | 150037 | 7908 | 0.00 | 5.00 | | 2025-10-18 00:52:16.612968+00 | 2025-10-17 13:30:03.808262+00 | 2025-10-18 00:52:16.867458+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:10.091095+00 | | |
| public | t_terminal | 19914 | 1597 | 0.00 | 7.00 | | 2025-10-17 21:49:31.815715+00 | | 2025-10-18 00:47:11.812423+00 |
| public | t_terminal_log | 31562829 | 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 | 98 | 58 | 0.00 | 37.00 | | 2025-10-14 11:22:40.961184+00 | | 2025-10-16 15:01:12.122723+00 |
| public | w_latest_mobile_device | 55435 | 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 | 54429 | 8143 | 0.00 | 13.00 | | 2025-10-17 06:49:52.586031+00 | | 2025-10-17 13:51:55.272955+00 |
| public | w_latest_position | 79224 | 14253 | 0.00 | 15.00 | | 2025-10-18 00:49:10.274746+00 | | 2025-10-18 00:52:17.178012+00 |
| public | w_latest_presence | 102546 | 48533 | 0.00 | 32.00 | | 2025-10-18 00:52:30.109892+00 | | 2025-10-18 00:52:31.314278+00 |
| public | w_latest_sensor | 386 | 15 | 0.00 | 3.00 | | 2025-10-18 00:52:17.191058+00 | | 2025-10-18 00:52:17.305702+00 |
| public | w_lock | 19431 | 0 | 0.00 | 0.00 | | 2025-10-13 17:49:56.418036+00 | | |
| public | w_master_update | 193 | 12 | 0.00 | 5.00 | | 2025-10-18 00:05:22.263859+00 | | 2025-10-17 23:17:26.993389+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-10-16 13:32:17.085474+00 | | |
| public | w_plan_sync_retry | 0 | 28 | 0 | 100.00 | | 2025-10-17 11:22:32.493727+00 | | 2025-10-17 23:07:22.983728+00 |
| public | w_plan_with_detail | 22520424 | 421945 | 0.00 | 1.00 | | 2025-10-16 23:24:35.028941+00 | | 2025-10-15 07:11:39.648945+00 |