| 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 | 432238239 | 0 | 0.00 | 0.00 | | 2025-03-02 13:05:47.140334+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 | 9298209 | 0 | 0.00 | 0.00 | | 2025-03-02 00:24:17.935364+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 | 416042792 | 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 | 8292034 | 0 | 0.00 | 0.00 | | 2025-03-09 16:24:41.508379+00 | | 2025-03-09 17:58:39.909429+00 |
| e202503 | a_stay_time | 9518029 | 0 | 0.00 | 0.00 | | 2025-03-07 16:00:41.595983+00 | | 2025-03-07 17:42:50.111938+00 |
| e202503 | t_position_history | 129120141 | 0 | 0.00 | 0.00 | | 2025-03-09 00:22:15.811714+00 | | 2025-03-09 11:06:44.565201+00 |
| e202503 | t_presence_history | 14162006 | 2865937 | 0.00 | 16.00 | | 2025-03-10 00:45:54.46248+00 | | 2025-03-10 00:51:21.146236+00 |
| e202503 | t_sensor_history | 4067170 | 0 | 0.00 | 0.00 | | 2025-03-09 00:49:36.67576+00 | | 2025-03-09 17:00:15.785276+00 |
| public | __digdag_status | 33 | 44 | 1.00 | 57.00 | | 2025-03-06 08:30:32.247323+00 | | 2025-03-09 12:30:22.700208+00 |
| public | a_attendance_sum | 85110 | 14457 | 0.00 | 14.00 | | 2025-03-10 00:33:08.679975+00 | | 2025-03-10 00:50:20.304789+00 |
| public | a_plan_actual | 136154 | 0 | 0.00 | 0.00 | | 2025-03-09 09:55:55.803896+00 | | 2025-03-07 20:06:38.862723+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-03-02 04:11:11.609427+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-03-02 04:11:05.299579+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-03-02 02:53:05.216627+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 | 673 | 5 | 0.00 | 0.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-02 04:11:11.625817+00 | | 2025-02-26 00:50:02.399236+00 |
| public | m_category | 2024 | 1 | 0.00 | 0.00 | | 2025-03-04 04:43:20.331219+00 | | 2025-02-27 07:11:00.813027+00 |
| public | m_exb | 21637 | 997 | 0.00 | 4.00 | | 2025-03-01 18:30:18.771165+00 | | 2025-03-01 15:41:28.407782+00 |
| public | m_favorite | 204010 | 1074 | 0.00 | 0.00 | | 2025-03-03 11:09:04.099778+00 | | 2025-02-28 07:08:33.880379+00 |
| public | m_favorite_group | 88499 | 31 | 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-03 00:15:20.390176+00 | | |
| public | m_group | 18801 | 10 | 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 | 22578 | 4 | 0.00 | 0.00 | | 2025-03-09 19:41:26.671846+00 | | 2024-12-25 16:12:18.619994+00 |
| public | m_lob_log | 753 | 0 | 0.00 | 0.00 | | 2025-03-08 02:20:29.951862+00 | | 2025-02-20 20:12:15.627632+00 |
| public | m_location | 37391 | 148 | 0.00 | 0.00 | | 2025-03-07 02:34:02.174335+00 | | 2025-03-01 18:00:19.776934+00 |
| public | m_notify_template | 787 | 2 | 0.00 | 0.00 | | 2025-03-02 04:11:11.79445+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 | 165176 | 28017 | 0.00 | 14.00 | | 2025-03-07 00:35:45.877097+00 | | 2025-03-10 00:20:06.552931+00 |
| public | m_pot_profile | 50344 | 46 | 0.00 | 0.00 | | 2025-02-28 08:22:57.360837+00 | | 2025-02-05 06:15:42.374839+00 |
| public | m_provider_user | 74 | 11 | 0.00 | 12.00 | | 2025-03-03 00:50:52.514432+00 | | 2025-02-28 06:14:30.117878+00 |
| public | m_region | 105 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:11.868258+00 | | |
| public | m_role | 613 | 3 | 0.00 | 0.00 | | 2025-03-02 04:11:11.856861+00 | | 2025-02-26 02:14:35.030611+00 |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:11.720951+00 | | |
| public | m_setting | 20308 | 296 | 0.00 | 1.00 | | 2025-03-09 19:46:26.560412+00 | | 2025-03-09 08:31:39.149613+00 |
| public | m_setting_log | 30092 | 1218 | 0.00 | 3.00 | | 2025-03-05 02:57:31.25815+00 | | 2025-03-09 01:46:15.421562+00 |
| public | m_site | 163 | 4 | 0.00 | 2.00 | | 2025-03-02 04:11:11.757633+00 | | |
| public | m_tenant | 104 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:12.003614+00 | | |
| public | m_tx | 99094 | 12973 | 0.00 | 11.00 | | 2025-03-09 05:31:08.814277+00 | | 2025-03-09 05:51:57.062135+00 |
| public | m_user | 29339 | 41 | 0.00 | 0.00 | | 2025-03-06 18:31:34.388383+00 | | 2025-03-03 02:12:36.529809+00 |
| public | m_zone | 5846 | 32 | 0.00 | 0.00 | | 2025-03-03 05:52:50.422663+00 | | 2025-02-28 05:10:47.335579+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-03-02 04:11:04.241336+00 | | |
| public | r_auth_zone | 212 | 0 | 0.00 | 0.00 | | 2025-03-03 14:17:30.575897+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:11.815694+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 | 46965 | 5841 | 0.00 | 11.00 | | 2025-03-04 04:50:20.999299+00 | | 2025-03-05 12:41:14.745208+00 |
| public | r_pot_auth | 2973 | 301 | 0.00 | 9.00 | | 2025-03-07 00:10:05.191025+00 | | 2025-03-07 00:10:05.203329+00 |
| public | r_pot_category | 7943 | 0 | 0.00 | 0.00 | | 2025-03-09 20:12:19.893683+00 | | 2025-03-09 20:01:06.567031+00 |
| public | r_pot_group | 97634 | 16683 | 0.00 | 14.00 | | 2025-03-09 22:02:07.323397+00 | | 2025-03-09 23:59:55.557535+00 |
| public | r_pot_tx | 57957 | 5007 | 0.00 | 7.00 | | 2025-03-05 12:21:17.975053+00 | | 2025-03-07 00:10:16.096625+00 |
| public | r_pot_user | 17505 | 0 | 0.00 | 0.00 | | 2025-03-10 00:14:02.638556+00 | | 2025-02-27 04:05:45.842808+00 |
| public | r_provider_tenant | 1253 | 241 | 0.00 | 16.00 | | 2025-03-07 02:14:17.102069+00 | | 2025-03-07 02:34:57.831002+00 |
| public | r_role_feature | 5464 | 5 | 0.00 | 0.00 | | 2025-03-06 07:12:18.392332+00 | | 2025-01-27 06:09:56.260074+00 |
| public | r_tenant_feature | 3969 | 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 | 18311 | 53 | 0.00 | 0.00 | | 2025-02-28 03:19:07.134634+00 | | 2025-02-27 04:05:39.396392+00 |
| public | r_user_site | 5988 | 5 | 0.00 | 0.00 | | 2025-03-02 04:11:11.698304+00 | | 2025-01-21 09:36:53.062817+00 |
| public | r_zone_category | 4017 | 0 | 0.00 | 0.00 | | 2025-03-08 02:20:29.937322+00 | | 2025-02-26 16:39:56.2929+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-03-05 11:14:41.829082+00 | | |
| public | t_attendance | 2169472 | 28448 | 0.00 | 1.00 | | 2025-03-04 07:35:48.692819+00 | | 2025-02-19 10:00:31.938254+00 |
| public | t_general | 3354 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:11.991824+00 | | 2025-02-13 15:01:47.682131+00 |
| public | t_mobile_device_history | 814628 | 0 | 0.00 | 0.00 | | 2025-03-03 22:53:39.83393+00 | | 2025-01-20 12:37:08.728659+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:11.83625+00 | | |
| public | t_notify_history | 4540682 | 15150 | 0.00 | 0.00 | | 2025-03-03 03:12:22.492562+00 | | 2025-02-13 07:49:43.35861+00 |
| public | t_operation_log | 16006879 | 3 | 0.00 | 0.00 | | 2025-03-08 04:35:25.96932+00 | | 2025-02-06 23:24:38.554102+00 |
| public | t_plan | 18814699 | 646748 | 0.00 | 3.00 | | 2025-03-06 00:11:40.515127+00 | | 2025-03-05 23:48:15.528835+00 |
| public | t_plan_cancel_history | 422683 | 63885 | 0.00 | 13.00 | | 2025-03-06 02:03:02.078606+00 | | 2025-03-07 06:49:34.619565+00 |
| public | t_plan_detail | 32088990 | 201668 | 0.00 | 0.00 | | 2025-03-09 11:38:03.327739+00 | | 2025-03-10 00:17:57.087723+00 |
| public | t_plan_sync | 45502 | 4663 | 0.00 | 9.00 | | 2025-03-10 00:18:04.579704+00 | | 2025-03-10 00:36:07.421531+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:12.026104+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-03-02 04:11:04.276031+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-03-02 04:11:11.887155+00 | | |
| public | t_recv_position_history | 118404 | 51535 | 0.00 | 30.00 | | 2025-03-10 00:51:19.477626+00 | 2025-03-09 13:30:07.220779+00 | 2025-03-10 00:51:20.07185+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-03-02 04:11:04.332362+00 | | |
| public | t_terminal | 140476 | 4487 | 0.00 | 3.00 | | 2025-02-28 04:45:30.783449+00 | | 2025-03-09 18:15:30.033725+00 |
| public | t_terminal_log | 16951278 | 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 | 241750 | 0 | 0.00 | 0.00 | | 2025-02-28 08:23:06.476896+00 | | 2025-01-25 01:13:17.349449+00 |
| public | w_arrival_notify | 87 | 26 | 0.00 | 23.00 | | 2025-03-06 15:01:02.188351+00 | | 2025-03-09 23:23:49.838536+00 |
| public | w_latest_position | 62678 | 12817 | 0.00 | 16.00 | | 2025-03-10 00:51:20.284829+00 | | 2025-03-10 00:51:20.421922+00 |
| public | w_latest_presence | 246311 | 84746 | 0.00 | 25.00 | | 2025-03-10 00:51:29.601444+00 | | 2025-03-10 00:51:31.737591+00 |
| public | w_latest_sensor | 386 | 240 | 0.00 | 38.00 | | 2025-03-10 00:51:21.829614+00 | | 2025-03-10 00:51:21.943669+00 |
| public | w_lock | 15786 | 1 | 0.00 | 0.00 | | 2025-03-06 05:14:26.226916+00 | | |
| public | w_master_update | 104 | 56 | 0.00 | 35.00 | | 2025-03-09 23:24:50.016755+00 | | 2025-03-10 00:18:04.071364+00 |
| public | w_migration | 737 | 0 | 0.00 | 0.00 | | 2025-03-02 08:40:47.475543+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-03-01 16:43:09.749834+00 | | |
| public | w_plan_with_detail | 18846928 | 1308997 | 0.00 | 6.00 | | 2025-03-03 01:15:48.874557+00 | | 2025-03-05 18:27:10.053516+00 |