| 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 | 432238116 | 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 | 416333375 | 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 | 4518690 | 0 | 0.00 | 0.00 | | 2025-03-05 17:46:47.545124+00 | | 2025-03-05 18:01:45.392282+00 |
| e202503 | a_stay_time | 5570368 | 0 | 0.00 | 0.00 | | 2025-03-05 17:42:33.774836+00 | | 2025-03-05 17:56:49.176207+00 |
| e202503 | t_position_history | 75738496 | 0 | 0.00 | 0.00 | | 2025-03-05 06:24:28.720189+00 | | 2025-03-06 00:32:07.274783+00 |
| e202503 | t_presence_history | 8401782 | 898043 | 0.00 | 9.00 | | 2025-03-06 00:45:51.870964+00 | | 2025-03-06 00:48:18.910646+00 |
| e202503 | t_sensor_history | 2335783 | 0 | 0.00 | 0.00 | | 2025-03-05 03:13:42.318122+00 | | 2025-03-05 15:46:03.503135+00 |
| public | __digdag_status | 34 | 51 | 1.00 | 60.00 | | 2025-03-01 12:30:15.476662+00 | | 2025-03-03 12:30:20.516746+00 |
| public | a_attendance_sum | 83970 | 14723 | 0.00 | 14.00 | | 2025-03-06 00:41:12.402698+00 | | 2025-03-06 00:48:17.400864+00 |
| public | a_plan_actual | 121972 | 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 | 924 | 0.00 | 4.00 | | 2025-03-01 18:30:18.771165+00 | | 2025-03-01 15:41:28.407782+00 |
| public | m_favorite | 203452 | 615 | 0.00 | 0.00 | | 2025-03-03 11:09:04.099778+00 | | 2025-02-28 07:08:33.880379+00 |
| public | m_favorite_group | 87925 | 409 | 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 | 18789 | 287 | 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 | 22503 | 78 | 0.00 | 0.00 | | 2025-02-28 00:45:07.639545+00 | | 2024-12-25 16:12:18.619994+00 |
| public | m_lob_log | 744 | 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 | 4104 | 0.00 | 9.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 | 164974 | 11169 | 0.00 | 6.00 | | 2025-03-05 22:39:59.553069+00 | | 2025-03-06 00:21:40.880062+00 |
| public | m_pot_profile | 50278 | 34 | 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 | 4 | 0.00 | 5.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 | 23343 | 246 | 0.00 | 1.00 | | 2025-03-05 20:45:05.269694+00 | | 2025-03-05 19:18:49.67434+00 |
| public | m_setting_log | 30035 | 1372 | 0.00 | 4.00 | | 2025-03-05 02:57:31.25815+00 | | 2025-03-05 12:30:10.622447+00 |
| public | m_site | 163 | 3 | 0.00 | 1.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 | 98839 | 12474 | 0.00 | 11.00 | | 2025-03-05 12:44:09.041382+00 | | 2025-03-05 12:45:08.776094+00 |
| public | m_user | 27818 | 2207 | 0.00 | 7.00 | | 2025-02-25 23:43:27.397133+00 | | 2025-03-03 02:12:36.529809+00 |
| public | m_zone | 5845 | 11 | 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 | 46882 | 5279 | 0.00 | 10.00 | | 2025-03-04 04:50:20.999299+00 | | 2025-03-05 12:41:14.745208+00 |
| public | r_pot_auth | 2881 | 480 | 0.00 | 14.00 | | 2025-03-05 03:42:22.269978+00 | | 2025-03-05 12:21:10.403238+00 |
| public | r_pot_category | 7920 | 0 | 0.00 | 0.00 | | 2025-03-05 20:11:29.439112+00 | | 2025-03-05 20:01:23.46538+00 |
| public | r_pot_group | 155691 | 3603 | 0.00 | 2.00 | | 2025-03-06 00:37:06.333694+00 | | 2025-03-06 00:29:05.166766+00 |
| public | r_pot_tx | 57770 | 94 | 0.00 | 0.00 | | 2025-03-05 12:21:17.975053+00 | | 2025-03-05 12:21:18.062798+00 |
| public | r_pot_user | 17442 | 43 | 0.00 | 0.00 | | 2025-02-28 02:20:26.494866+00 | | 2025-02-27 04:05:45.842808+00 |
| public | r_provider_tenant | 1245 | 186 | 0.00 | 12.00 | | 2025-03-05 00:39:44.719229+00 | | 2025-03-05 00:39:44.723576+00 |
| public | r_role_feature | 5420 | 20 | 0.00 | 0.00 | | 2025-02-25 08:47:31.948317+00 | | 2025-01-27 06:09:56.260074+00 |
| public | r_tenant_feature | 3907 | 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 | 18249 | 46 | 0.00 | 0.00 | | 2025-02-28 03:19:07.134634+00 | | 2025-02-27 04:05:39.396392+00 |
| public | r_user_site | 5990 | 3 | 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-03-05 11:14:41.829082+00 | | |
| public | t_attendance | 2153868 | 12850 | 0.00 | 0.00 | | 2025-03-04 07:35:48.692819+00 | | 2025-02-19 10:00:31.938254+00 |
| public | t_general | 3333 | 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 | 807836 | 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 | 4509098 | 8095 | 0.00 | 0.00 | | 2025-03-03 03:12:22.492562+00 | | 2025-02-13 07:49:43.35861+00 |
| public | t_operation_log | 15961696 | 30 | 0.00 | 0.00 | | 2025-02-27 02:20:50.277518+00 | | 2025-02-06 23:24:38.554102+00 |
| public | t_plan | 18690860 | 34254 | 0.00 | 0.00 | | 2025-03-06 00:11:40.515127+00 | | 2025-03-05 23:48:15.528835+00 |
| public | t_plan_cancel_history | 314785 | 56010 | 0.00 | 15.00 | | 2025-03-04 02:11:17.50128+00 | | 2025-02-12 09:55:14.84214+00 |
| public | t_plan_detail | 31892930 | 2023517 | 0.00 | 5.00 | | 2025-02-27 19:16:23.844386+00 | | 2025-03-04 07:03:13.144759+00 |
| public | t_plan_sync | 77712 | 4263 | 0.00 | 5.00 | | 2025-03-06 00:37:06.660534+00 | | 2025-03-06 00:36:06.213983+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 | 118454 | 58221 | 0.00 | 32.00 | | 2025-03-06 00:51:17.552489+00 | 2025-03-05 13:30:06.59844+00 | 2025-03-06 00:51:18.144108+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-03-02 04:11:04.332362+00 | | |
| public | t_terminal | 139750 | 3452 | 0.00 | 2.00 | | 2025-02-28 04:45:30.783449+00 | | 2025-03-05 23:48:18.228846+00 |
| public | t_terminal_log | 16517938 | 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 | 86 | 46 | 0.00 | 34.00 | | 2025-03-03 00:18:30.255233+00 | | 2025-03-04 04:21:51.491387+00 |
| public | w_latest_position | 62424 | 15089 | 0.00 | 19.00 | | 2025-03-06 00:51:18.290654+00 | | 2025-03-06 00:51:18.437977+00 |
| public | w_latest_presence | 204025 | 131596 | 0.00 | 39.00 | | 2025-03-06 00:51:26.006106+00 | | 2025-03-06 00:51:27.160037+00 |
| public | w_latest_sensor | 386 | 262 | 0.00 | 40.00 | | 2025-03-06 00:51:18.454423+00 | | 2025-03-06 00:51:18.567491+00 |
| public | w_lock | 15726 | 0 | 0.00 | 0.00 | | 2025-02-25 06:41:58.890169+00 | | |
| public | w_master_update | 103 | 69 | 0.00 | 40.00 | | 2025-03-06 00:12:13.999318+00 | | 2025-03-06 00:12:14.004223+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 | 18723100 | 913488 | 0.00 | 4.00 | | 2025-03-03 01:15:48.874557+00 | | 2025-03-05 18:27:10.053516+00 |