| 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 | 11764761 | 0 | 0.00 | 0.00 | | 2025-10-10 11:23:44.463657+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 | 598156032 | 39824 | 0.00 | 0.00 | | 2025-10-10 03:43:30.581428+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 | 16868512 | 0 | 0.00 | 0.00 | | 2025-10-15 15:11:37.39059+00 | | 2025-10-16 15:13:54.763497+00 |
| e202510 | a_stay_time | 21498181 | 0 | 0.00 | 0.00 | | 2025-10-15 17:26:20.081411+00 | | 2025-10-15 18:54:39.798176+00 |
| e202510 | t_position_history | 322308466 | 0 | 0.00 | 0.00 | | 2025-10-16 07:38:11.363489+00 | | 2025-10-16 00:30:26.386715+00 |
| e202510 | t_presence_history | 29749066 | 5733787 | 0.00 | 16.00 | | 2025-10-17 00:18:26.187096+00 | | 2025-10-17 00:42:52.751345+00 |
| e202510 | t_sensor_history | 6340525 | 0 | 0.00 | 0.00 | | 2025-10-16 13:35:49.033747+00 | | 2025-10-16 20:49:46.516557+00 |
| public | __digdag_status | 35 | 0 | 0.00 | 0.00 | | 2025-10-16 12:54:07.643075+00 | | 2025-10-16 12:31:00.121853+00 |
| public | a_attendance_sum | 166499 | 22166 | 0.00 | 11.00 | | 2025-10-16 11:18:09.752546+00 | | 2025-10-17 00:18:48.730552+00 |
| public | a_plan_actual | 1279243 | 9835 | 0.00 | 0.00 | | 2025-10-10 08:40:47.915063+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 | 35652 | 29 | 0.00 | 0.00 | | 2025-10-16 01:04:45.171989+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2042 | 33 | 0.00 | 1.00 | | 2025-10-14 20:47:30.44883+00 | | 2025-10-07 02:10:08.82178+00 |
| public | l_location | 125415 | 8654 | 0.00 | 6.00 | | 2025-10-16 10:00:17.400384+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 110319 | 350 | 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 | 454965 | 302 | 0.00 | 0.00 | | 2025-10-16 01:04:52.794752+00 | | 2025-10-08 08:16:47.032966+00 |
| public | l_pot_category | 14890 | 72 | 0.00 | 0.00 | | 2025-10-16 01:04:42.454122+00 | | 2025-10-09 00:24:05.35073+00 |
| public | l_pot_group | 232089 | 125 | 0.00 | 0.00 | | 2025-10-16 01:04:44.882841+00 | | 2025-10-08 06:51:13.475539+00 |
| public | l_pot_tx | 101175 | 238 | 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 | 7302 | 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 | 147143 | 28065 | 0.00 | 16.00 | | 2025-10-15 01:19:53.101041+00 | | 2025-10-16 05:31:48.988708+00 |
| public | l_user | 66610 | 235 | 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 | 7 | 0.00 | 0.00 | | 2025-10-10 16:09:10.662207+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 | 45 | 0.00 | 1.00 | | 2025-10-10 16:09:10.627537+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-10-12 06:16:07.621763+00 | | |
| public | m_exb | 27415 | 21 | 0.00 | 0.00 | | 2025-10-16 06:19:02.098597+00 | | 2025-10-08 06:39:33.915423+00 |
| public | m_favorite | 216960 | 578 | 0.00 | 0.00 | | 2025-10-10 06:16:54.25121+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 115657 | 278 | 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 | 28180 | 1719 | 0.00 | 5.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 | 21671 | 68 | 0.00 | 0.00 | | 2025-10-15 07:20:47.269519+00 | | 2025-10-08 07:12:18.311027+00 |
| public | m_lob_log | 5470 | 21 | 0.00 | 0.00 | | 2025-10-15 06:21:25.418426+00 | | 2025-10-08 07:12:19.071766+00 |
| public | m_location | 44849 | 662 | 0.00 | 1.00 | | 2025-10-10 11:00:32.073051+00 | | 2025-10-01 00:59:46.898895+00 |
| public | m_notify_template | 1208 | 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 | 130035 | 18267 | 0.00 | 12.00 | | 2025-10-16 02:52:26.764228+00 | | 2025-10-17 00:18:48.033748+00 |
| public | m_pot | 204153 | 7044 | 0.00 | 3.00 | | 2025-10-16 04:30:31.77145+00 | | 2025-10-16 00:18:53.62003+00 |
| public | m_pot_profile | 53421 | 20 | 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 | 0 | 0.00 | 0.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 | 27574 | 990 | 0.00 | 3.00 | | 2025-10-16 09:37:00.315997+00 | | 2025-10-15 20:19:44.431201+00 |
| public | m_setting_log | 36301 | 1864 | 0.00 | 4.00 | | 2025-10-13 14:52:34.458006+00 | | 2025-10-16 08:04:01.264856+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 | 126705 | 22246 | 0.00 | 14.00 | | 2025-10-16 08:58:18.830266+00 | | 2025-10-16 23:56:32.420639+00 |
| public | m_user | 36800 | 212 | 0.00 | 0.00 | | 2025-10-14 03:12:23.753574+00 | | 2025-10-09 05:29:57.240234+00 |
| public | m_zone | 7763 | 173 | 0.00 | 2.00 | | 2025-10-10 03:51:43.362212+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 | 63 | 0.00 | 27.00 | | 2025-10-10 07:01:50.730353+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 | 55617 | 243 | 0.00 | 0.00 | | 2025-10-10 16:09:10.503155+00 | | 2025-10-10 09:12:08.559148+00 |
| public | r_pot_auth | 8481 | 189 | 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 | 151 | 0.00 | 1.00 | | 2025-10-14 20:47:28.754226+00 | | 2025-10-16 14:40:55.512+00 |
| public | r_pot_group | 202973 | 747 | 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-10 03:45:19.355841+00 | | |
| public | r_pot_tx | 68832 | 535 | 0.00 | 0.00 | | 2025-10-15 03:33:28.955169+00 | | 2025-10-09 00:14:51.631362+00 |
| public | r_pot_user | 21448 | 56 | 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 | 123 | 0.00 | 11.00 | | 2025-10-11 19:37:43.914034+00 | | 2025-10-15 08:41:23.083636+00 |
| public | r_role_feature | 6556 | 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 | 21949 | 56 | 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 | 3475042 | 47511 | 0.00 | 1.00 | | 2025-10-11 00:51:27.652186+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4374 | 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 | 1505015 | 0 | 0.00 | 0.00 | | 2025-10-17 00:27:53.768977+00 | | |
| public | t_mobile_status_history | 2276467 | 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 | 6932544 | 24946 | 0.00 | 0.00 | | 2025-10-10 01:11:05.366937+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 25292820 | 40153 | 0.00 | 0.00 | | 2025-10-15 00:11:28.016076+00 | | 2025-10-10 06:07:51.303391+00 |
| public | t_plan | 22464543 | 340050 | 0.00 | 1.00 | | 2025-10-16 04:01:56.983322+00 | | 2025-10-16 04:01:58.798046+00 |
| public | t_plan_cancel_history | 735702 | 34902 | 0.00 | 4.00 | | 2025-10-15 14:21:18.305049+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 41392578 | 3121227 | 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-10 03:45:19.330343+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-10-10 03:45:19.310877+00 | | |
| public | t_plan_sync | 62955 | 12318 | 0.00 | 16.00 | | 2025-10-16 23:41:34.773124+00 | | 2025-10-17 00:34:51.860768+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 | 160078 | 26388 | 0.00 | 14.00 | | 2025-10-17 00:51:51.523154+00 | 2025-10-16 13:30:04.957788+00 | 2025-10-17 00:51:51.786507+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-16 10:41:10.091095+00 | | |
| public | t_terminal | 19905 | 1474 | 0.00 | 6.00 | | 2025-10-16 22:41:19.774282+00 | | 2025-10-17 00:48:54.147783+00 |
| public | t_terminal_log | 31454576 | 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 | 49 | 0.00 | 32.00 | | 2025-10-14 11:22:40.961184+00 | | 2025-10-16 15:01:12.122723+00 |
| public | w_latest_mobile_device | 55380 | 575 | 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 | 54376 | 10743 | 0.00 | 16.00 | | 2025-10-16 11:09:06.158857+00 | | 2025-10-17 00:39:46.295575+00 |
| public | w_latest_position | 79202 | 34863 | 0.00 | 30.00 | | 2025-10-17 00:51:52.064328+00 | | 2025-10-17 00:51:52.41316+00 |
| public | w_latest_presence | 96876 | 196895 | 2.00 | 67.00 | | 2025-10-17 00:52:04.422602+00 | | 2025-10-17 00:52:05.078816+00 |
| public | w_latest_sensor | 386 | 413 | 1.00 | 51.00 | | 2025-10-17 00:51:52.428855+00 | | 2025-10-17 00:51:52.543227+00 |
| public | w_lock | 19401 | 0 | 0.00 | 0.00 | | 2025-10-13 17:49:56.418036+00 | | |
| public | w_master_update | 192 | 1 | 0.00 | 0.00 | | 2025-10-17 00:51:51.801424+00 | | 2025-10-17 00:49:51.77839+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-10-16 13:32:17.085474+00 | | |
| public | w_plan_sync_retry | 0 | 43 | 0 | 100.00 | | 2025-10-16 23:59:35.140597+00 | | 2025-10-17 00:18:48.746493+00 |
| public | w_plan_with_detail | 22403170 | 89030 | 0.00 | 0.00 | | 2025-10-16 23:24:35.028941+00 | | 2025-10-15 07:11:39.648945+00 |