| 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 | 32819063 | 0 | 0.00 | 0.00 | | 2025-02-25 05:53:35.879235+00 | | 2025-01-31 16:00:32.961716+00 |
| e202501 | t_position_history | 432238112 | 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 | 45584178 | 0 | 0.00 | 0.00 | | 2025-02-25 11:30:40.071402+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 | 26957797 | 0 | 0.00 | 0.00 | | 2025-02-27 03:12:05.742953+00 | | 2025-02-28 17:03:15.64101+00 |
| e202502 | a_stay_time | 33176539 | 0 | 0.00 | 0.00 | | 2025-02-27 03:03:21.965567+00 | | 2025-02-28 15:12:20.297538+00 |
| e202502 | t_position_history | 416333043 | 0 | 0.00 | 0.00 | | 2025-02-27 01:22:14.124825+00 | | 2025-02-28 02:57:45.931863+00 |
| e202502 | t_presence_history | 45357993 | 3778605 | 0.00 | 7.00 | | 2025-02-28 14:48:26.862768+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 | 3170995 | 0 | 0.00 | 0.00 | | 2025-03-04 17:38:41.570038+00 | | 2025-03-04 18:06:35.218361+00 |
| e202503 | a_stay_time | 3839811 | 0 | 0.00 | 0.00 | | 2025-03-04 17:34:44.758673+00 | | 2025-03-04 17:45:43.399825+00 |
| e202503 | t_position_history | 56491729 | 0 | 0.00 | 0.00 | | 2025-03-04 14:03:14.611199+00 | | 2025-03-05 00:41:46.395476+00 |
| e202503 | t_presence_history | 6359602 | 784960 | 0.00 | 10.00 | | 2025-03-05 00:45:49.620451+00 | | 2025-03-05 00:50:18.510944+00 |
| e202503 | t_sensor_history | 1906909 | 0 | 0.00 | 0.00 | | 2025-03-04 07:22:53.589494+00 | | 2025-03-04 17:54:38.698398+00 |
| public | __digdag_status | 33 | 40 | 1.00 | 54.00 | | 2025-03-01 12:30:15.476662+00 | | 2025-03-03 12:30:20.516746+00 |
| public | a_attendance_sum | 119194 | 4019 | 0.00 | 3.00 | | 2025-03-05 00:45:24.613249+00 | | 2025-03-05 00:34:41.002677+00 |
| public | a_plan_actual | 115192 | 0 | 0.00 | 0.00 | | 2025-03-04 20:00:58.682589+00 | | 2025-03-04 16:41:49.542803+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 | 669 | 1 | 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 | 2012 | 0 | 0.00 | 0.00 | | 2025-03-04 04:43:20.331219+00 | | 2025-02-27 07:11:00.813027+00 |
| public | m_exb | 21637 | 118 | 0.00 | 0.00 | | 2025-03-01 18:30:18.771165+00 | | 2025-03-01 15:41:28.407782+00 |
| public | m_favorite | 203201 | 356 | 0.00 | 0.00 | | 2025-03-03 11:09:04.099778+00 | | 2025-02-28 07:08:33.880379+00 |
| public | m_favorite_group | 87666 | 375 | 0.00 | 0.00 | | 2025-02-25 07:11:48.160719+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 | 18774 | 286 | 0.00 | 1.00 | | 2025-02-25 08:47:32.203236+00 | | 2025-01-27 03:08:39.876498+00 |
| public | m_holiday | 34722 | 0 | 0.00 | 0.00 | | 2025-03-01 05:00:57.382314+00 | | 2025-03-01 06:20:15.994998+00 |
| public | m_lob | 22499 | 73 | 0.00 | 0.00 | | 2025-02-28 00:45:07.639545+00 | | 2024-12-25 16:12:18.619994+00 |
| public | m_lob_log | 739 | 1 | 0.00 | 0.00 | | 2025-02-27 01:23:28.720961+00 | | 2025-02-20 20:12:15.627632+00 |
| public | m_location | 37312 | 2572 | 0.00 | 6.00 | | 2025-02-26 03:50:49.81412+00 | | 2025-03-01 18:00:19.776934+00 |
| public | m_notify_template | 783 | 1 | 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-02-26 09:30:17.954501+00 | | |
| public | m_pot | 164924 | 17173 | 0.00 | 9.00 | | 2025-03-04 05:07:07.209494+00 | | 2025-03-05 00:22:44.946506+00 |
| public | m_pot_profile | 50259 | 24 | 0.00 | 0.00 | | 2025-02-28 08:22:57.360837+00 | | 2025-02-05 06:15:42.374839+00 |
| public | m_provider_user | 72 | 2 | 0.00 | 2.00 | | 2025-03-03 00:50:52.514432+00 | | 2025-02-28 06:14:30.117878+00 |
| public | m_region | 104 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:11.868258+00 | | |
| public | m_role | 607 | 0 | 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 | 12697 | 1471 | 0.00 | 10.00 | | 2025-03-03 23:41:45.639746+00 | | 2025-03-04 21:40:19.546236+00 |
| public | m_setting_log | 29961 | 1571 | 0.00 | 4.00 | | 2025-02-27 23:06:53.402307+00 | | 2025-03-04 09:32:54.692215+00 |
| public | m_site | 161 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:11.757633+00 | | |
| public | m_tenant | 103 | 0 | 0.00 | 0.00 | | 2025-03-02 04:11:12.003614+00 | | |
| public | m_tx | 136842 | 53 | 0.00 | 0.00 | | 2025-03-04 10:11:51.38171+00 | | 2025-03-04 10:03:50.077704+00 |
| public | m_user | 27816 | 2191 | 0.00 | 7.00 | | 2025-02-25 23:43:27.397133+00 | | 2025-03-03 02:12:36.529809+00 |
| public | m_zone | 5845 | 1 | 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-02-23 18:40:35.239494+00 | | 2024-10-08 09:38:50.736835+00 |
| public | r_location_zone | 46840 | 55 | 0.00 | 0.00 | | 2025-03-04 04:50:20.999299+00 | | 2025-03-01 15:45:28.450486+00 |
| public | r_pot_auth | 2826 | 559 | 0.00 | 16.00 | | 2025-02-27 03:18:16.038983+00 | | 2025-03-01 15:35:22.340855+00 |
| public | r_pot_category | 7922 | 0 | 0.00 | 0.00 | | 2025-03-04 20:11:06.358805+00 | | 2025-03-04 20:01:05.268586+00 |
| public | r_pot_group | 151855 | 3224 | 0.00 | 2.00 | | 2025-03-05 00:36:41.604431+00 | | 2025-03-05 00:22:40.857983+00 |
| public | r_pot_tx | 57674 | 5161 | 0.00 | 8.00 | | 2025-02-28 04:45:29.561022+00 | | 2025-03-01 15:35:28.085832+00 |
| public | r_pot_user | 17443 | 39 | 0.00 | 0.00 | | 2025-02-28 02:20:26.494866+00 | | 2025-02-27 04:05:45.842808+00 |
| public | r_provider_tenant | 1234 | 178 | 0.00 | 12.00 | | 2025-03-05 00:39:44.719229+00 | | 2025-03-05 00:39:44.723576+00 |
| public | r_role_feature | 5415 | 1 | 0.00 | 0.00 | | 2025-02-25 08:47:31.948317+00 | | 2025-01-27 06:09:56.260074+00 |
| public | r_tenant_feature | 3839 | 0 | 0.00 | 0.00 | | 2025-03-04 07:35:08.999739+00 | | 2024-12-26 08:05:11.164323+00 |
| public | r_tx_sensor | 359 | 0 | 0.00 | 0.00 | | 2025-02-25 04:39:36.438384+00 | | |
| public | r_user_region | 18250 | 42 | 0.00 | 0.00 | | 2025-02-28 03:19:07.134634+00 | | 2025-02-27 04:05:39.396392+00 |
| public | r_user_site | 5991 | 1 | 0.00 | 0.00 | | 2025-03-02 04:11:11.698304+00 | | 2025-01-21 09:36:53.062817+00 |
| public | r_zone_category | 4016 | 172 | 0.00 | 4.00 | | 2025-02-27 01:23:28.597231+00 | | 2025-02-26 16:39:56.2929+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2025-02-24 14:16:00.550485+00 | | |
| public | t_attendance | 2145980 | 5111 | 0.00 | 0.00 | | 2025-03-04 07:35:48.692819+00 | | 2025-02-19 10:00:31.938254+00 |
| public | t_general | 3327 | 1 | 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 | 803868 | 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 | 4494254 | 7279 | 0.00 | 0.00 | | 2025-03-03 03:12:22.492562+00 | | 2025-02-13 07:49:43.35861+00 |
| public | t_operation_log | 15914228 | 25 | 0.00 | 0.00 | | 2025-02-27 02:20:50.277518+00 | | 2025-02-06 23:24:38.554102+00 |
| public | t_plan | 18626044 | 1489192 | 0.00 | 7.00 | | 2025-02-25 01:33:55.029998+00 | | 2025-03-03 04:53:46.857595+00 |
| public | t_plan_cancel_history | 312956 | 29952 | 0.00 | 8.00 | | 2025-03-04 02:11:17.50128+00 | | 2025-02-12 09:55:14.84214+00 |
| public | t_plan_detail | 31805960 | 1808026 | 0.00 | 5.00 | | 2025-02-27 19:16:23.844386+00 | | 2025-03-04 07:03:13.144759+00 |
| public | t_plan_sync | 45357 | 5126 | 0.00 | 10.00 | | 2025-03-05 00:25:41.555812+00 | | 2025-03-05 00:36:41.907498+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 | 116602 | 69389 | 0.00 | 37.00 | | 2025-03-05 00:50:16.933979+00 | 2025-03-04 13:30:07.381561+00 | 2025-03-05 00:50:17.449389+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-03-02 04:11:04.332362+00 | | |
| public | t_terminal | 139224 | 3064 | 0.00 | 2.00 | | 2025-02-28 04:45:30.783449+00 | | 2025-03-04 21:05:17.428409+00 |
| public | t_terminal_log | 16467494 | 8 | 0.00 | 0.00 | | 2025-02-26 18:47:02.668439+00 | | 2025-01-30 06:33:02.210081+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 | 84 | 32 | 0.00 | 27.00 | | 2025-03-03 00:18:30.255233+00 | | 2025-03-04 04:21:51.491387+00 |
| public | w_latest_position | 62337 | 15808 | 0.00 | 20.00 | | 2025-03-05 00:50:17.581181+00 | | 2025-03-05 00:50:17.710969+00 |
| public | w_latest_presence | 227115 | 116273 | 0.00 | 33.00 | | 2025-03-05 00:50:25.768118+00 | | 2025-03-05 00:50:27.218477+00 |
| public | w_latest_sensor | 386 | 266 | 0.00 | 40.00 | | 2025-03-05 00:50:19.206796+00 | | 2025-03-05 00:50:19.320425+00 |
| public | w_lock | 15722 | 0 | 0.00 | 0.00 | | 2025-02-25 06:41:58.890169+00 | | |
| public | w_master_update | 179 | 24 | 0.00 | 11.00 | | 2025-03-05 00:31:41.434591+00 | | 2025-03-05 00:30:41.576873+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 | 18696844 | 716560 | 0.00 | 3.00 | | 2025-03-03 01:15:48.874557+00 | | 2025-03-03 03:30:38.859189+00 |