| 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 | 31254317 | 0 | 0.00 | 0.00 | | 2025-03-04 05:19:55.90436+00 | | 2025-01-30 15:59:29.6377+00 |
| e202501 | a_stay_time | 32819007 | 0 | 0.00 | 0.00 | | 2025-03-06 04:38:25.555276+00 | | 2025-01-31 16:00:32.961716+00 |
| e202501 | t_position_history | 432237690 | 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 | 45584126 | 0 | 0.00 | 0.00 | | 2025-03-06 09:33:45.295181+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 | 26956986 | 0 | 0.00 | 0.00 | | 2025-03-08 06:12:36.615477+00 | | 2025-02-28 17:03:15.64101+00 |
| e202502 | a_stay_time | 33161184 | 0 | 0.00 | 0.00 | | 2025-03-08 06:13:23.178599+00 | | 2025-02-28 15:12:20.297538+00 |
| e202502 | t_position_history | 416045719 | 0 | 0.00 | 0.00 | | 2025-03-08 00:18:24.498359+00 | | 2025-02-28 02:57:45.931863+00 |
| e202502 | t_presence_history | 43102358 | 0 | 0.00 | 0.00 | | 2025-03-08 09:56:58.151628+00 | | 2025-02-28 14:57:50.054933+00 |
| e202502 | t_sensor_history | 9718286 | 0 | 0.00 | 0.00 | | 2025-03-04 07:50:23.525403+00 | | 2025-02-27 14:25:30.080657+00 |
| e202503 | a_proximity_sum | 13531575 | 0 | 0.00 | 0.00 | | 2025-03-12 16:08:41.448527+00 | | 2025-03-12 16:29:41.012191+00 |
| e202503 | a_stay_time | 15102473 | 0 | 0.00 | 0.00 | | 2025-03-12 17:46:29.251846+00 | | 2025-03-12 17:46:29.850688+00 |
| e202503 | t_position_history | 189482315 | 0 | 0.00 | 0.00 | | 2025-03-12 08:27:56.849667+00 | | 2025-03-12 11:35:54.884829+00 |
| e202503 | t_presence_history | 20432025 | 2807342 | 0.00 | 12.00 | | 2025-03-13 00:35:50.463202+00 | | 2025-03-13 00:36:04.018994+00 |
| e202503 | t_sensor_history | 5355745 | 0 | 0.00 | 0.00 | | 2025-03-11 00:52:29.169985+00 | | 2025-03-12 18:08:12.223229+00 |
| public | __digdag_status | 34 | 23 | 0.00 | 40.00 | | 2025-03-11 03:30:44.296428+00 | | 2025-03-09 12:30:22.700208+00 |
| public | a_attendance_sum | 121917 | 13899 | 0.00 | 10.00 | | 2025-03-13 00:44:24.284345+00 | | 2025-03-13 00:38:22.522991+00 |
| public | a_plan_actual | 159697 | 0 | 0.00 | 0.00 | | 2025-03-09 09:55:55.803896+00 | | 2025-03-11 19:55:59.519881+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-04 07:35:48.716574+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-03-04 07:40:59.870878+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-03-04 07:35:15.22957+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-03-04 07:40:59.892014+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-03-04 07:40:59.913454+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-03-04 07:35:15.252297+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-03-04 07:35:15.20568+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-03-04 07:35:48.738858+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-03-04 07:35:15.276483+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-03-04 07:35:15.299188+00 | | |
| public | m_area | 674 | 7 | 0.00 | 1.00 | | 2025-03-04 04:43:20.359982+00 | | 2025-03-04 03:12:43.39453+00 |
| public | m_auth | 138 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.305344+00 | | 2025-02-26 00:50:02.399236+00 |
| public | m_category | 2025 | 1 | 0.00 | 0.00 | | 2025-03-04 04:43:20.331219+00 | | 2025-02-27 07:11:00.813027+00 |
| public | m_env | 1 | 1 | 1.00 | 50.00 | | | | |
| public | m_exb | 21637 | 3 | 0.00 | 0.00 | | 2025-03-11 03:32:36.947885+00 | | 2025-03-10 02:56:04.897698+00 |
| public | m_favorite | 215520 | 96 | 0.00 | 0.00 | | 2025-03-12 09:21:26.718276+00 | | 2025-02-28 07:08:33.880379+00 |
| public | m_favorite_group | 88948 | 176 | 0.00 | 0.00 | | 2025-03-06 05:45:34.881802+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 | 18861 | 74 | 0.00 | 0.00 | | 2025-03-06 07:12:18.619642+00 | | 2025-01-27 03:08:39.876498+00 |
| public | m_holiday | 34557 | 0 | 0.00 | 0.00 | | 2025-03-09 06:34:51.602393+00 | | 2025-03-01 06:20:15.994998+00 |
| public | m_lob | 22593 | 18 | 0.00 | 0.00 | | 2025-03-09 19:41:26.671846+00 | | 2024-12-25 16:12:18.619994+00 |
| public | m_lob_log | 761 | 0 | 0.00 | 0.00 | | 2025-03-08 02:20:29.951862+00 | | 2025-02-20 20:12:15.627632+00 |
| public | m_location | 37601 | 1429 | 0.00 | 3.00 | | 2025-03-07 02:34:02.174335+00 | | 2025-03-10 02:56:05.581782+00 |
| public | m_notify_template | 787 | 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-07 08:22:51.762655+00 | | |
| public | m_pot | 185060 | 8463 | 0.00 | 4.00 | | 2025-03-13 00:09:00.94734+00 | | 2025-03-12 23:32:07.248101+00 |
| public | m_pot_profile | 50843 | 14 | 0.00 | 0.00 | | 2025-03-10 06:03:55.121522+00 | | 2025-02-05 06:15:42.374839+00 |
| public | m_provider_user | 74 | 3 | 0.00 | 3.00 | | 2025-03-11 23:01:19.166583+00 | | 2025-02-28 06:14:30.117878+00 |
| public | m_region | 105 | 0 | 0.00 | 0.00 | | 2025-03-11 06:34:08.534961+00 | | |
| public | m_role | 616 | 0 | 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 | 12917 | 1931 | 0.00 | 13.00 | | 2025-03-11 15:50:01.081014+00 | | 2025-03-12 09:55:50.381403+00 |
| public | m_setting_log | 30380 | 0 | 0.00 | 0.00 | | 2025-03-10 04:45:29.785517+00 | | 2025-03-12 20:42:40.386591+00 |
| public | m_site | 164 | 1 | 0.00 | 0.00 | | 2025-03-11 06:34:08.428175+00 | | |
| public | m_tenant | 104 | 1 | 0.00 | 0.00 | | 2025-03-11 06:34:08.57378+00 | | |
| public | m_tx | 99250 | 14139 | 0.00 | 12.00 | | 2025-03-10 10:48:00.793646+00 | | 2025-03-10 10:50:00.95557+00 |
| public | m_user | 29419 | 294 | 0.00 | 0.00 | | 2025-03-06 18:31:34.388383+00 | | 2025-03-03 02:12:36.529809+00 |
| public | m_zone | 5851 | 20 | 0.00 | 0.00 | | 2025-03-12 04:37:26.21768+00 | | 2025-02-28 05:10:47.335579+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-03-11 06:34:01.145018+00 | | |
| public | r_auth_zone | 212 | 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-05 03:22:27.930825+00 | | 2024-10-08 09:38:50.736835+00 |
| public | r_location_zone | 47199 | 163 | 0.00 | 0.00 | | 2025-03-12 23:46:27.969391+00 | | 2025-03-10 02:56:04.99748+00 |
| public | r_pot_auth | 3028 | 619 | 0.00 | 16.00 | | 2025-03-07 00:10:05.191025+00 | | 2025-03-10 03:03:11.400555+00 |
| public | r_pot_category | 7949 | 0 | 0.00 | 0.00 | | 2025-03-12 20:13:21.534994+00 | | 2025-03-12 20:01:19.022318+00 |
| public | r_pot_group | 156822 | 3245 | 0.00 | 2.00 | | 2025-03-13 00:36:02.623125+00 | | 2025-03-13 00:06:39.238524+00 |
| public | r_pot_tx | 58154 | 4953 | 0.00 | 7.00 | | 2025-03-10 02:11:21.467676+00 | | 2025-03-10 03:03:24.404938+00 |
| public | r_pot_user | 17557 | 115 | 0.00 | 0.00 | | 2025-03-10 00:14:02.638556+00 | | 2025-02-27 04:05:45.842808+00 |
| public | r_provider_tenant | 1255 | 268 | 0.00 | 17.00 | | 2025-03-11 01:11:18.922947+00 | | 2025-03-12 06:08:17.259621+00 |
| public | r_role_feature | 5475 | 10 | 0.00 | 0.00 | | 2025-03-06 07:12:18.392332+00 | | 2025-01-27 06:09:56.260074+00 |
| public | r_tenant_feature | 3972 | 0 | 0.00 | 0.00 | | 2025-03-04 07:35:08.999739+00 | | 2025-03-07 01:05:10.986634+00 |
| public | r_tx_sensor | 359 | 0 | 0.00 | 0.00 | | 2025-03-06 03:09:34.92293+00 | | |
| public | r_user_region | 18366 | 121 | 0.00 | 0.00 | | 2025-03-10 01:04:36.285273+00 | | 2025-02-27 04:05:39.396392+00 |
| public | r_user_site | 5259 | 3 | 0.00 | 0.00 | | 2025-03-11 06:34:08.387329+00 | | 2025-01-21 09:36:53.062817+00 |
| public | r_zone_category | 4017 | 30 | 0.00 | 0.00 | | 2025-03-08 02:20:29.937322+00 | | 2025-03-12 23:46:27.68387+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-03-05 11:14:41.829082+00 | | |
| public | t_attendance | 2239138 | 53624 | 0.00 | 2.00 | | 2025-03-04 07:35:48.692819+00 | | 2025-03-12 08:52:04.132053+00 |
| public | t_general | 3325 | 1 | 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 | 822212 | 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 | 4668565 | 4768 | 0.00 | 0.00 | | 2025-03-12 01:36:05.561658+00 | | 2025-03-12 09:04:09.869156+00 |
| public | t_operation_log | 16152565 | 17 | 0.00 | 0.00 | | 2025-03-08 04:35:25.96932+00 | | 2025-02-06 23:24:38.554102+00 |
| public | t_plan | 18982022 | 1232259 | 0.00 | 6.00 | | 2025-03-06 00:11:40.515127+00 | | 2025-03-12 23:37:12.770602+00 |
| public | t_plan_cancel_history | 351745 | 2591 | 0.00 | 0.00 | | 2025-03-12 12:38:23.233801+00 | | 2025-03-07 06:49:34.619565+00 |
| public | t_plan_detail | 32388315 | 1759240 | 0.00 | 5.00 | | 2025-03-09 11:38:03.327739+00 | | 2025-03-11 05:44:17.987776+00 |
| public | t_plan_sync | 45607 | 3995 | 0.00 | 8.00 | | 2025-03-13 00:36:02.993274+00 | | 2025-03-13 00:36:03.305006+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 | 117787 | 55542 | 0.00 | 32.00 | | 2025-03-13 00:50:22.363711+00 | 2025-03-12 13:30:07.751844+00 | 2025-03-13 00:50:22.896153+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-03-11 06:34:01.196822+00 | | |
| public | t_terminal | 142093 | 2601 | 0.00 | 1.00 | | 2025-03-10 02:11:23.048813+00 | | 2025-03-12 18:22:31.729457+00 |
| public | t_terminal_log | 17106658 | 0 | 0.00 | 0.00 | | 2025-03-07 15:03:08.623825+00 | | 2025-03-09 13:02:24.299912+00 |
| public | temp_pivot_table | 241678 | 0 | 0.00 | 0.00 | | 2025-03-10 06:04:01.944984+00 | | 2025-01-25 01:13:17.349449+00 |
| public | w_arrival_notify | 92 | 24 | 0.00 | 20.00 | | 2025-03-12 00:51:33.220219+00 | | 2025-03-12 15:01:02.839282+00 |
| public | w_latest_position | 62895 | 15904 | 0.00 | 20.00 | | 2025-03-13 00:50:23.026688+00 | | 2025-03-13 00:50:23.16168+00 |
| public | w_latest_presence | 206874 | 112689 | 0.00 | 35.00 | | 2025-03-13 00:50:31.228763+00 | | 2025-03-13 00:50:33.671164+00 |
| public | w_latest_sensor | 386 | 258 | 0.00 | 40.00 | | 2025-03-13 00:50:23.848421+00 | | 2025-03-13 00:50:23.960447+00 |
| public | w_lock | 15799 | 1 | 0.00 | 0.00 | | 2025-03-06 05:14:26.226916+00 | | |
| public | w_master_update | 181 | 19 | 0.00 | 9.00 | | 2025-03-13 00:36:02.639393+00 | | 2025-03-12 23:46:27.660769+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 | 18969928 | 500581 | 0.00 | 2.00 | | 2025-03-11 23:34:44.298961+00 | | 2025-03-12 16:26:41.074904+00 |