| 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 | 32412573 | 0 | 0.00 | 0.00 | | 2025-10-27 12:24:49.346057+00 | | |
| e202508 | a_stay_time | 0 | 0 | 0 | 0 | | | | |
| e202508 | t_position_history | 581729393 | 0 | 0.00 | 0.00 | | 2025-10-24 07:26:44.979691+00 | | |
| e202508 | t_presence_history | 77266206 | 0 | 0.00 | 0.00 | | 2025-10-27 12:42:26.602254+00 | | |
| e202508 | t_sensor_history | 11764739 | 0 | 0.00 | 0.00 | | 2025-10-23 22:20:03.004408+00 | | |
| e202509 | a_proximity_sum | 29563960 | 0 | 0.00 | 0.00 | | 2025-10-24 03:26:56.325418+00 | | |
| e202509 | a_stay_time | 38715257 | 0 | 0.00 | 0.00 | | 2025-10-25 16:18:53.466173+00 | | |
| e202509 | t_position_history | 598197530 | 0 | 0.00 | 0.00 | | 2025-10-23 06:45:41.711107+00 | | |
| e202509 | t_presence_history | 0 | 0 | 0 | 0 | | | | |
| e202509 | t_sensor_history | 11637600 | 0 | 0.00 | 0.00 | | 2025-10-23 03:39:37.282378+00 | | |
| e202510 | a_proximity_sum | 33090789 | 0 | 0.00 | 0.00 | | 2025-10-24 00:20:10.661505+00 | | 2025-10-25 17:56:42.512627+00 |
| e202510 | a_stay_time | 36269034 | 0 | 0.00 | 0.00 | | 2025-10-24 20:29:27.405553+00 | | 2025-10-27 17:36:07.03623+00 |
| e202510 | t_position_history | 545153325 | 689 | 0.00 | 0.00 | | | | 2025-10-27 13:50:27.593355+00 |
| e202510 | t_presence_history | 65597556 | 2269074 | 0.00 | 3.00 | | 2025-10-28 00:36:28.372077+00 | | 2025-10-28 00:14:35.554501+00 |
| e202510 | t_sensor_history | 10592073 | 0 | 0.00 | 0.00 | | 2025-10-25 16:57:50.856305+00 | | 2025-10-27 08:55:36.215895+00 |
| public | __digdag_status | 35 | 21 | 0.00 | 37.00 | | 2025-10-23 00:54:45.255163+00 | | |
| public | a_attendance_sum | 170614 | 28269 | 0.00 | 14.00 | | 2025-10-23 09:30:54.735454+00 | | 2025-10-28 00:43:04.519312+00 |
| public | a_plan_actual | 1334149 | 0 | 0.00 | 0.00 | | 2025-10-23 09:51:51.113343+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-10-22 23:31:39.744556+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-10-22 23:31:39.257062+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:37.910421+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-10-24 08:19:47.489597+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-10-24 02:44:22.494098+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-10-24 04:20:57.520608+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-10-24 02:42:35.238352+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-10-24 04:20:57.542403+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-10-24 04:20:57.564115+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-10-24 02:42:35.259194+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-10-24 02:42:35.215866+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-10-24 04:20:55.743994+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-10-24 02:42:35.282771+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-10-24 02:42:35.304834+00 | | |
| public | l_area | 2 | 1 | 0.00 | 33.00 | | | | |
| public | l_auth | 0 | 0 | 0 | 0 | | | | |
| public | l_category | 1 | 0 | 0.00 | 0.00 | | | | |
| public | l_group | 69 | 71 | 1.00 | 50.00 | | | | |
| public | l_lob | 2067 | 0 | 0.00 | 0.00 | | 2025-10-27 07:51:40.393181+00 | | |
| public | l_location | 152654 | 885 | 0.00 | 0.00 | | 2025-10-22 23:32:46.969741+00 | | |
| public | l_location_zone | 713 | 453 | 0.00 | 38.00 | | | | |
| public | l_outside | 0 | 0 | 0 | 0 | | | | |
| public | l_pot | 1353 | 939 | 0.00 | 40.00 | | | | |
| public | l_pot_category | 387 | 296 | 0.00 | 43.00 | | | | |
| public | l_pot_group | 470 | 185 | 0.00 | 28.00 | | | | |
| public | l_pot_tx | 809 | 558 | 0.00 | 40.00 | | | | |
| public | l_role | 0 | 0 | 0 | 0 | | | | |
| public | l_role_feature | 4 | 0 | 0.00 | 0.00 | | | | |
| public | l_site | 1 | 0 | 0.00 | 0.00 | | | | |
| public | l_tx | 147872 | 23934 | 0.00 | 13.00 | | 2025-10-27 09:49:13.402896+00 | | 2025-10-27 10:02:45.385235+00 |
| public | l_user | 513 | 664 | 1.00 | 56.00 | | | | |
| public | l_zone | 7 | 0 | 0.00 | 0.00 | | | | |
| public | l_zone_category | 6 | 0 | 0.00 | 0.00 | | | | |
| public | m_area | 781 | 1 | 0.00 | 0.00 | | 2025-10-24 00:26:33.902796+00 | | |
| public | m_auth | 145 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:39.79084+00 | | |
| public | m_category | 2389 | 2 | 0.00 | 0.00 | | 2025-10-24 00:26:33.860567+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-10-24 11:11:15.497482+00 | | |
| public | m_exb | 71 | 55 | 0.00 | 43.00 | | | | |
| public | m_favorite | 222413 | 572 | 0.00 | 0.00 | | 2025-10-23 09:52:03.090065+00 | | |
| public | m_favorite_group | 118791 | 42 | 0.00 | 0.00 | | 2025-10-25 22:52:26.143507+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-10-23 01:58:41.256615+00 | | |
| public | m_group | 28259 | 1824 | 0.00 | 6.00 | | | | 2025-10-26 14:40:57.04979+00 |
| public | m_holiday | 42385 | 0 | 0.00 | 0.00 | | 2025-10-27 12:42:26.459535+00 | | |
| public | m_lob | 22550 | 0 | 0.00 | 0.00 | | 2025-10-28 00:45:03.901057+00 | | |
| public | m_lob_log | 5218 | 0 | 0.00 | 0.00 | | 2025-10-27 23:19:30.934246+00 | | |
| public | m_location | 45239 | 679 | 0.00 | 1.00 | | 2025-10-23 21:39:19.200307+00 | | |
| public | m_notify_template | 1209 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:40.113539+00 | | |
| public | m_outside | 367 | 0 | 0.00 | 0.00 | | 2025-10-27 01:57:18.235968+00 | | |
| public | m_personal_setting | 131447 | 24728 | 0.00 | 15.00 | | 2025-10-27 06:56:48.310929+00 | | 2025-10-28 00:16:34.454679+00 |
| public | m_pot | 205691 | 16361 | 0.00 | 7.00 | | | | 2025-10-26 14:40:55.706893+00 |
| public | m_pot_profile | 117 | 18 | 0.00 | 13.00 | | | | |
| public | m_provider_user | 85 | 1 | 0.00 | 1.00 | | 2025-10-23 03:39:37.314711+00 | | |
| public | m_region | 112 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:40.218547+00 | | |
| public | m_role | 775 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:40.194381+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:39.879845+00 | | |
| public | m_setting | 15814 | 2493 | 0.00 | 13.00 | | 2025-10-27 00:41:02.980275+00 | | 2025-10-27 11:17:26.007338+00 |
| public | m_setting_log | 37362 | 0 | 0.00 | 0.00 | | 2025-10-26 05:39:50.962432+00 | | 2025-10-27 21:15:04.351429+00 |
| public | m_site | 183 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:39.765244+00 | | |
| public | m_tenant | 111 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:40.25665+00 | | |
| public | m_tx | 172620 | 1 | 0.00 | 0.00 | | 2025-10-27 10:25:14.59917+00 | | 2025-10-27 10:20:56.631226+00 |
| public | m_user | 38581 | 250 | 0.00 | 0.00 | | 2025-10-26 14:25:24.348506+00 | | |
| public | m_zone | 7772 | 1 | 0.00 | 0.00 | | 2025-10-23 07:17:16.676418+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-10-22 23:31:37.885532+00 | | |
| public | r_auth_zone | 170 | 0 | 0.00 | 0.00 | | 2025-10-23 09:52:03.111779+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:40.137814+00 | | |
| public | r_group_auth | 580 | 0 | 0.00 | 0.00 | | 2025-10-24 08:24:19.63678+00 | | |
| public | r_location_zone | 56660 | 453 | 0.00 | 0.00 | | 2025-10-24 00:26:33.831264+00 | | |
| public | r_pot_auth | 8405 | 6 | 0.00 | 0.00 | | 2025-10-27 10:16:20.131801+00 | | |
| public | r_pot_category | 12110 | 90 | 0.00 | 0.00 | | 2025-10-27 07:51:39.980922+00 | | |
| public | r_pot_group | 303455 | 48 | 0.00 | 0.00 | | 2025-10-24 11:10:56.857602+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-10-23 07:06:27.29278+00 | | |
| public | r_pot_tx | 71231 | 131 | 0.00 | 0.00 | | 2025-10-27 12:42:26.062326+00 | | |
| public | r_pot_user | 21189 | 1 | 0.00 | 0.00 | | 2025-10-28 00:45:03.629318+00 | | |
| public | r_provider_tenant | 1092 | 0 | 0.00 | 0.00 | | 2025-10-24 07:27:40.485938+00 | | |
| public | r_role_feature | 6635 | 0 | 0.00 | 0.00 | | 2025-10-26 01:04:31.732596+00 | | |
| public | r_tenant_feature | 4426 | 0 | 0.00 | 0.00 | | 2025-10-24 02:42:34.897709+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-10-25 14:11:18.384814+00 | | |
| public | r_user_region | 22034 | 1 | 0.00 | 0.00 | | 2025-10-28 00:44:57.07352+00 | | |
| public | r_user_site | 6188 | 6 | 0.00 | 0.00 | | 2025-10-22 23:31:39.853468+00 | | |
| public | r_zone_category | 5104 | 0 | 0.00 | 0.00 | | 2025-10-27 07:51:39.823501+00 | | |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-10-24 20:46:48.431009+00 | | |
| public | t_attendance | 3600324 | 20580 | 0.00 | 0.00 | | 2025-10-24 02:43:52.134431+00 | | |
| public | t_general | 4429 | 0 | 0.00 | 0.00 | | 2025-10-24 08:19:47.181014+00 | | |
| public | t_general_20250618 | 2922 | 0 | 0.00 | 0.00 | | 2025-10-27 01:46:47.419801+00 | | |
| public | t_job | 56 | 0 | 0.00 | 0.00 | | 2025-10-27 07:51:40.455372+00 | | |
| public | t_mobile_device_history | 1519311 | 0 | 0.00 | 0.00 | | 2025-10-23 04:22:38.423764+00 | | |
| public | t_mobile_status_history | 2308692 | 0 | 0.00 | 0.00 | | 2025-10-28 00:45:06.835829+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:40.159627+00 | | |
| public | t_notify_history | 6939003 | 11371 | 0.00 | 0.00 | | 2025-10-23 04:52:52.20106+00 | | |
| public | t_operation_log | 25793410 | 3 | 0.00 | 0.00 | | 2025-10-27 10:20:30.255586+00 | | |
| public | t_plan | 23271352 | 874413 | 0.00 | 3.00 | | 2025-10-25 10:25:41.791169+00 | | 2025-10-27 01:13:29.050121+00 |
| public | t_plan_cancel_history | 8587 | 100665 | 11.00 | 92.00 | | | | |
| public | t_plan_detail | 43797429 | 661198 | 0.00 | 1.00 | | 2025-10-27 11:56:19.177269+00 | | 2025-10-27 06:59:43.101985+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-10-23 07:06:27.266306+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-10-23 07:06:27.243839+00 | | |
| public | t_plan_sync | 69378 | 7516 | 0.00 | 9.00 | | 2025-10-28 00:18:34.353316+00 | | 2025-10-28 00:36:59.697247+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-10-22 23:31:40.31061+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-10-22 23:31:37.965134+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-10-22 23:31:40.239148+00 | | |
| public | t_recv_position_history | 160630 | 9087 | 0.00 | 5.00 | | 2025-10-28 00:52:37.966209+00 | 2025-10-27 13:30:02.001536+00 | 2025-10-28 00:52:38.234229+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-22 23:31:38.023314+00 | | |
| public | t_terminal | 19971 | 1518 | 0.00 | 7.00 | | 2025-10-27 23:37:31.987975+00 | | 2025-10-28 00:52:40.490231+00 |
| public | t_terminal_log | 33427438 | 0 | 0.00 | 0.00 | | 2025-10-27 05:48:42.04843+00 | | |
| public | temp_pivot_table | 0 | 0 | 0 | 0 | | | | |
| public | w_arrival_notify | 102 | 22 | 0.00 | 17.00 | | 2025-10-24 04:43:53.557145+00 | | 2025-10-24 04:43:00.019424+00 |
| public | w_latest_mobile_device | 55959 | 372 | 0.00 | 0.00 | | 2025-10-25 03:04:32.561712+00 | | 2025-10-27 00:16:02.662622+00 |
| public | w_latest_mobile_status | 54957 | 8875 | 0.00 | 13.00 | | 2025-10-27 12:06:56.775222+00 | | 2025-10-28 00:37:01.364725+00 |
| public | w_latest_position | 79400 | 15773 | 0.00 | 16.00 | | 2025-10-28 00:52:38.411981+00 | | 2025-10-28 00:52:38.631197+00 |
| public | w_latest_presence | 125440 | 211967 | 1.00 | 62.00 | | 2025-10-28 00:51:55.070267+00 | | 2025-10-28 00:51:57.074837+00 |
| public | w_latest_sensor | 386 | 375 | 0.00 | 49.00 | | 2025-10-28 00:51:32.45418+00 | | 2025-10-28 00:51:32.999198+00 |
| public | w_lock | 19466 | 0 | 0.00 | 0.00 | | 2025-10-25 18:28:42.404508+00 | | |
| public | w_master_update | 111 | 48 | 0.00 | 30.00 | | 2025-10-27 23:57:32.948034+00 | | 2025-10-28 00:49:03.5327+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-10-23 01:08:05.339311+00 | | |
| public | w_plan_sync_retry | 1 | 43 | 43.00 | 97.00 | | 2025-10-27 07:47:19.669778+00 | | 2025-10-27 09:13:02.344009+00 |
| public | w_plan_with_detail | 23258752 | 1706677 | 0.00 | 6.00 | | 2025-10-23 03:38:23.651976+00 | | 2025-10-27 01:08:27.199296+00 |