| 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 |
|---|
| e202501 | a_proximity_sum | 31254301 | 0 | 0.00 | 0.00 | | 2025-03-13 04:15:42.93103+00 | | 2025-01-30 15:59:29.6377+00 |
| e202501 | a_stay_time | 32818951 | 0 | 0.00 | 0.00 | | 2025-03-15 10:52:14.359866+00 | | 2025-01-31 16:00:32.961716+00 |
| e202501 | t_position_history | 432237693 | 0 | 0.00 | 0.00 | | 2025-03-11 10:20:37.247684+00 | | 2025-01-30 02:48:35.191713+00 |
| e202501 | t_presence_history | 45584078 | 0 | 0.00 | 0.00 | | 2025-03-16 04:00:27.322617+00 | | 2025-01-31 14:43:59.70332+00 |
| e202501 | t_sensor_history | 9298170 | 0 | 0.00 | 0.00 | | 2025-03-11 05:03:35.090746+00 | | 2025-01-29 01:53:48.867109+00 |
| e202502 | a_proximity_sum | 26956982 | 0 | 0.00 | 0.00 | | 2025-03-18 00:20:52.693409+00 | | 2025-02-28 17:03:15.64101+00 |
| e202502 | a_stay_time | 33161158 | 0 | 0.00 | 0.00 | | 2025-03-18 00:21:09.674815+00 | | 2025-02-28 15:12:20.297538+00 |
| e202502 | t_position_history | 416041817 | 0 | 0.00 | 0.00 | | 2025-03-17 17:00:23.322179+00 | | 2025-02-28 02:57:45.931863+00 |
| e202502 | t_presence_history | 43102311 | 0 | 0.00 | 0.00 | | 2025-03-18 01:40:50.411162+00 | | 2025-02-28 14:57:50.054933+00 |
| e202502 | t_sensor_history | 9718239 | 0 | 0.00 | 0.00 | | 2025-03-13 06:50:30.377759+00 | | 2025-02-27 14:25:30.080657+00 |
| e202503 | a_proximity_sum | 21434428 | 0 | 0.00 | 0.00 | | 2025-03-19 18:07:37.042169+00 | | 2025-03-19 17:36:28.133171+00 |
| e202503 | a_stay_time | 24466190 | 0 | 0.00 | 0.00 | | 2025-03-19 15:31:58.372327+00 | | 2025-03-19 17:53:18.571393+00 |
| e202503 | t_position_history | 298898383 | 0 | 0.00 | 0.00 | | 2025-03-18 07:38:49.583632+00 | | 2025-03-18 09:33:10.296295+00 |
| e202503 | t_presence_history | 32538584 | 3862348 | 0.00 | 10.00 | | 2025-03-20 00:26:17.391357+00 | | 2025-03-20 00:50:38.596596+00 |
| e202503 | t_sensor_history | 8303166 | 0 | 0.00 | 0.00 | | 2025-03-19 23:34:34.11707+00 | | 2025-03-18 13:13:29.089911+00 |
| public | __digdag_status | 33 | 51 | 1.00 | 60.00 | | 2025-03-15 12:31:06.748481+00 | | 2025-03-19 03:30:43.180101+00 |
| public | a_attendance_sum | 89020 | 16306 | 0.00 | 15.00 | | 2025-03-20 00:26:41.855927+00 | | 2025-03-20 00:51:38.32783+00 |
| public | a_plan_actual | 195425 | 0 | 0.00 | 0.00 | | 2025-03-18 09:56:33.54031+00 | | 2025-03-18 17:27:15.737919+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-03-11 06:34:08.292372+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-03-11 06:34:02.153132+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-03-11 06:03:33.659762+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-03-11 01:01:21.522259+00 | | 2025-03-11 01:01:21.527867+00 |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:38.472964+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:39.402872+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:01.143294+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:39.424365+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:39.446508+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:01.163504+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:01.121348+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:38.498538+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:01.1846+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-03-13 06:31:01.205436+00 | | |
| public | m_area | 686 | 5 | 0.00 | 0.00 | | 2025-03-13 03:38:30.173073+00 | | 2025-03-04 03:12:43.39453+00 |
| public | m_auth | 139 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.305344+00 | | 2025-02-26 00:50:02.399236+00 |
| public | m_category | 2041 | 5 | 0.00 | 0.00 | | 2025-03-13 03:38:30.149276+00 | | 2025-02-27 07:11:00.813027+00 |
| public | m_env | 1 | 1 | 1.00 | 50.00 | | | | |
| public | m_exb | 21718 | 309 | 0.00 | 1.00 | | 2025-03-11 03:32:36.947885+00 | | 2025-03-10 02:56:04.897698+00 |
| public | m_favorite | 216588 | 1169 | 0.00 | 0.00 | | 2025-03-12 09:21:26.718276+00 | | 2025-02-28 07:08:33.880379+00 |
| public | m_favorite_group | 89748 | 72 | 0.00 | 0.00 | | 2025-03-15 14:23:58.571695+00 | | 2025-02-20 08:11:31.536402+00 |
| public | m_feature | 167 | 0 | 0.00 | 0.00 | | 2025-03-11 21:09:37.317058+00 | | |
| public | m_group | 18865 | 40 | 0.00 | 0.00 | | 2025-03-15 21:47:15.097554+00 | | 2025-03-19 21:27:46.593273+00 |
| public | m_holiday | 34525 | 0 | 0.00 | 0.00 | | 2025-03-18 08:20:17.347308+00 | | 2025-03-01 06:20:15.994998+00 |
| public | m_lob | 22606 | 5 | 0.00 | 0.00 | | 2025-03-18 16:44:03.736897+00 | | 2024-12-25 16:12:18.619994+00 |
| public | m_lob_log | 799 | 0 | 0.00 | 0.00 | | 2025-03-17 21:38:47.311748+00 | | 2025-02-20 20:12:15.627632+00 |
| public | m_location | 37676 | 27 | 0.00 | 0.00 | | 2025-03-17 01:00:43.384688+00 | | 2025-03-10 02:56:05.581782+00 |
| public | m_notify_template | 791 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.460262+00 | | 2025-02-25 04:59:43.609644+00 |
| public | m_outside | 331 | 0 | 0.00 | 0.00 | | 2025-03-17 06:44:56.304273+00 | | |
| public | m_pot | 167022 | 19105 | 0.00 | 10.00 | | 2025-03-19 01:15:18.525656+00 | | 2025-03-19 12:08:51.469216+00 |
| public | m_pot_profile | 50958 | 5 | 0.00 | 0.00 | | 2025-03-19 05:27:55.708203+00 | | 2025-02-05 06:15:42.374839+00 |
| public | m_provider_user | 74 | 5 | 0.00 | 6.00 | | 2025-03-11 23:01:19.166583+00 | | 2025-02-28 06:14:30.117878+00 |
| public | m_region | 106 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.534961+00 | | |
| public | m_role | 623 | 3 | 0.00 | 0.00 | | 2025-03-11 06:34:08.52316+00 | | 2025-02-26 02:14:35.030611+00 |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.411437+00 | | |
| public | m_setting | 18989 | 839 | 0.00 | 4.00 | | 2025-03-19 09:10:18.151934+00 | | 2025-03-19 08:03:46.11745+00 |
| public | m_setting_log | 31921 | 0 | 0.00 | 0.00 | | 2025-03-15 03:17:12.904473+00 | | 2025-03-18 17:35:25.298755+00 |
| public | m_site | 167 | 1 | 0.00 | 0.00 | | 2025-03-11 06:34:08.428175+00 | | |
| public | m_tenant | 105 | 1 | 0.00 | 0.00 | | 2025-03-11 06:34:08.57378+00 | | |
| public | m_tx | 168210 | 4129 | 0.00 | 2.00 | | 2025-03-17 05:24:10.496078+00 | | 2025-03-17 02:56:44.142737+00 |
| public | m_user | 30810 | 211 | 0.00 | 0.00 | | 2025-03-16 12:38:09.183349+00 | | 2025-03-03 02:12:36.529809+00 |
| public | m_zone | 5902 | 117 | 0.00 | 1.00 | | 2025-03-12 04:37:26.21768+00 | | 2025-03-17 13:16:37.200807+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-03-11 06:34:01.145018+00 | | |
| public | r_auth_zone | 213 | 0 | 0.00 | 0.00 | | 2025-03-12 11:43:53.424173+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.482859+00 | | |
| public | r_group_auth | 611 | 0 | 0.00 | 0.00 | | 2025-03-14 02:21:52.409348+00 | | 2024-10-08 09:38:50.736835+00 |
| public | r_location_zone | 47335 | 1573 | 0.00 | 3.00 | | 2025-03-12 23:46:27.969391+00 | | 2025-03-16 02:32:27.147832+00 |
| public | r_pot_auth | 3032 | 376 | 0.00 | 11.00 | | 2025-03-16 20:48:04.887225+00 | | 2025-03-18 01:28:06.778168+00 |
| public | r_pot_category | 7940 | 0 | 0.00 | 0.00 | | 2025-03-19 20:14:41.172298+00 | | 2025-03-19 20:02:06.945136+00 |
| public | r_pot_group | 98678 | 15967 | 0.00 | 13.00 | | 2025-03-19 21:06:46.811146+00 | | 2025-03-20 00:34:36.857361+00 |
| public | r_pot_tx | 58458 | 23 | 0.00 | 0.00 | | 2025-03-19 01:24:23.350461+00 | | 2025-03-10 03:03:24.404938+00 |
| public | r_pot_user | 17907 | 19 | 0.00 | 0.00 | | 2025-03-18 23:01:40.230465+00 | | 2025-03-18 07:08:27.015479+00 |
| public | r_provider_tenant | 1257 | 0 | 0.00 | 0.00 | | 2025-03-18 07:28:36.190038+00 | | 2025-03-18 07:28:36.196856+00 |
| public | r_role_feature | 5500 | 20 | 0.00 | 0.00 | | 2025-03-15 21:47:14.87647+00 | | 2025-01-27 06:09:56.260074+00 |
| public | r_tenant_feature | 4026 | 0 | 0.00 | 0.00 | | 2025-03-13 06:30:54.797836+00 | | 2025-03-07 01:05:10.986634+00 |
| public | r_tx_sensor | 359 | 0 | 0.00 | 0.00 | | 2025-03-15 07:21:05.876113+00 | | |
| public | r_user_region | 18713 | 15 | 0.00 | 0.00 | | 2025-03-19 00:23:10.821325+00 | | 2025-02-27 04:05:39.396392+00 |
| public | r_user_site | 5564 | 29 | 0.00 | 0.00 | | 2025-03-11 06:34:08.387329+00 | | 2025-03-15 13:43:45.289135+00 |
| public | r_zone_category | 4023 | 0 | 0.00 | 0.00 | | 2025-03-17 21:38:47.291105+00 | | 2025-03-12 23:46:27.68387+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-03-14 10:25:00.366374+00 | | |
| public | t_attendance | 2212307 | 37828 | 0.00 | 1.00 | | 2025-03-13 06:31:38.45035+00 | | 2025-03-12 08:52:04.132053+00 |
| public | t_general | 3360 | 4 | 0.00 | 0.00 | | 2025-03-11 06:34:08.561469+00 | | 2025-02-13 15:01:47.682131+00 |
| public | t_mobile_device_history | 832101 | 0 | 0.00 | 0.00 | | 2025-03-12 17:36:28.585219+00 | | 2025-01-20 12:37:08.728659+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.505022+00 | | |
| public | t_notify_history | 4742296 | 17874 | 0.00 | 0.00 | | 2025-03-12 01:36:05.561658+00 | | 2025-03-12 09:04:09.869156+00 |
| public | t_operation_log | 16279565 | 11 | 0.00 | 0.00 | | 2025-03-17 23:33:00.328884+00 | | 2025-02-06 23:24:38.554102+00 |
| public | t_plan | 19352044 | 966451 | 0.00 | 4.00 | | 2025-03-15 00:06:30.364605+00 | | 2025-03-19 08:50:52.990689+00 |
| public | t_plan_cancel_history | 326406 | 32181 | 0.00 | 8.00 | | 2025-03-18 14:19:55.478695+00 | | 2025-03-07 06:49:34.619565+00 |
| public | t_plan_detail | 32982736 | 1345326 | 0.00 | 3.00 | | 2025-03-18 10:58:07.417838+00 | | 2025-03-19 05:51:30.436371+00 |
| public | t_plan_sync | 45781 | 4646 | 0.00 | 9.00 | | 2025-03-20 00:34:37.336238+00 | | 2025-03-20 00:34:37.608227+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.597829+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-03-11 06:34:01.168343+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-03-11 06:34:08.54636+00 | | |
| public | t_recv_position_history | 88562 | 69107 | 0.00 | 43.00 | | 2025-03-20 00:51:37.437382+00 | 2025-03-19 13:30:07.304325+00 | 2025-03-20 00:51:37.980536+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-03-11 06:34:01.196822+00 | | |
| public | t_terminal | 144038 | 2831 | 0.00 | 1.00 | | 2025-03-19 01:24:24.96441+00 | | 2025-03-19 23:18:50.153528+00 |
| public | t_terminal_log | 17389544 | 0 | 0.00 | 0.00 | | 2025-03-17 10:51:06.211969+00 | | 2025-03-09 13:02:24.299912+00 |
| public | temp_pivot_table | 241606 | 0 | 0.00 | 0.00 | | 2025-03-19 05:28:02.968094+00 | | 2025-01-25 01:13:17.349449+00 |
| public | w_arrival_notify | 81 | 34 | 0.00 | 29.00 | | 2025-03-17 15:00:39.58185+00 | | 2025-03-17 15:00:39.585035+00 |
| public | w_latest_position | 63112 | 8886 | 0.00 | 12.00 | | 2025-03-20 00:45:40.132844+00 | | 2025-03-20 00:50:37.964624+00 |
| public | w_latest_presence | 199534 | 127639 | 0.00 | 39.00 | | 2025-03-20 00:51:45.938607+00 | | 2025-03-20 00:51:48.609999+00 |
| public | w_latest_sensor | 386 | 234 | 0.00 | 37.00 | | 2025-03-20 00:51:38.344671+00 | | 2025-03-20 00:51:38.45796+00 |
| public | w_lock | 15916 | 0 | 0.00 | 0.00 | | 2025-03-15 12:49:18.324654+00 | | |
| public | w_master_update | 185 | 12 | 0.00 | 6.00 | | 2025-03-20 00:03:08.782744+00 | | 2025-03-19 23:33:15.598426+00 |
| public | w_migration | 737 | 0 | 0.00 | 0.00 | | 2025-03-11 08:21:41.012693+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-03-11 03:03:01.971921+00 | | |
| public | w_plan_with_detail | 19292998 | 1734315 | 0.00 | 8.00 | | 2025-03-11 23:34:44.298961+00 | | 2025-03-19 07:01:15.152402+00 |