| 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 |
|---|
| e202508 | a_proximity_sum | 32424165 | 0 | 0.00 | 0.00 | | 2025-09-26 01:46:10.382598+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36269753 | 0 | 0.00 | 0.00 | | 2025-09-26 08:31:15.018665+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582013160 | 0 | 0.00 | 0.00 | | 2025-09-30 01:14:54.329299+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 54679041 | 0 | 0.00 | 0.00 | | 2025-09-26 02:50:13.277811+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764783 | 0 | 0.00 | 0.00 | | 2025-09-29 07:57:32.843752+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 29568114 | 0 | 0.00 | 0.00 | | 2025-09-29 17:32:29.741943+00 | | 2025-09-30 15:54:26.616538+00 |
| e202509 | a_stay_time | 38733918 | 0 | 0.00 | 0.00 | | 2025-09-30 13:45:23.224814+00 | | 2025-09-30 17:25:54.238102+00 |
| e202509 | t_position_history | 598736726 | 267 | 0.00 | 0.00 | | 2025-09-29 01:48:58.159382+00 | | 2025-09-29 20:40:54.897196+00 |
| e202509 | t_presence_history | 56847880 | 4947215 | 0.00 | 8.00 | | 2025-09-30 13:59:20.140036+00 | | 2025-09-30 14:47:50.312729+00 |
| e202509 | t_sensor_history | 11647042 | 0 | 0.00 | 0.00 | | 2025-09-28 21:23:01.795283+00 | | 2025-09-29 19:30:39.022501+00 |
| e202510 | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-09-27 00:30:49.663322+00 | | |
| e202510 | a_stay_time | 0 | 0 | 0 | 0 | | 2025-09-27 00:30:49.651907+00 | | |
| e202510 | t_position_history | 5973446 | 0 | 0.00 | 0.00 | | 2025-10-01 00:51:47.043976+00 | | 2025-10-01 00:34:44.131233+00 |
| e202510 | t_presence_history | 677604 | 263593 | 0.00 | 28.00 | | 2025-10-01 00:51:50.614963+00 | | 2025-10-01 00:51:51.103217+00 |
| e202510 | t_sensor_history | 156251 | 0 | 0.00 | 0.00 | | 2025-10-01 00:29:40.802675+00 | | 2025-10-01 00:03:39.325399+00 |
| public | __digdag_status | 32 | 21 | 0.00 | 39.00 | | 2025-09-25 23:22:08.912724+00 | | 2025-09-24 12:30:52.444456+00 |
| public | a_attendance_sum | 159956 | 16504 | 0.00 | 9.00 | | 2025-09-30 00:17:12.62908+00 | | 2025-10-01 00:32:40.469135+00 |
| public | a_plan_actual | 1173558 | 0 | 0.00 | 0.00 | | 2025-09-29 06:40:51.038075+00 | | 2025-09-19 16:41:52.537694+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:09.260565+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:09.249504+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:08.198039+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-09-30 02:16:43.326733+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-09-29 15:04:14.591899+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-09-29 20:59:48.518944+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.508183+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-09-29 20:59:48.542343+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-09-29 20:59:48.562157+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.5286+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.484714+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-09-29 20:52:32.085624+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.552228+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-09-29 15:03:17.578587+00 | | |
| public | l_area | 1576 | 9 | 0.00 | 0.00 | | 2025-09-27 00:31:07.508429+00 | | |
| public | l_auth | 196 | 6 | 0.00 | 2.00 | | 2025-09-27 00:31:07.411657+00 | | |
| public | l_category | 2712 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:08.877212+00 | | |
| public | l_group | 36478 | 1540 | 0.00 | 4.00 | | 2025-09-27 00:31:11.413414+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2030 | 4 | 0.00 | 0.00 | | 2025-09-25 18:01:07.224287+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 121045 | 1987 | 0.00 | 1.00 | | 2025-09-27 00:31:08.713558+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 108693 | 1795 | 0.00 | 1.00 | | 2025-09-27 00:31:07.982628+00 | | 2025-09-12 06:37:57.741842+00 |
| public | l_outside | 454 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:07.435231+00 | | |
| public | l_pot | 449624 | 4032 | 0.00 | 0.00 | | 2025-09-27 00:31:17.429297+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 14088 | 56 | 0.00 | 0.00 | | 2025-09-27 00:31:08.84655+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 233948 | 2734 | 0.00 | 1.00 | | 2025-09-27 00:31:11.164723+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 103537 | 404 | 0.00 | 0.00 | | 2025-09-27 00:31:09.694461+00 | | |
| public | l_role | 778 | 0 | 0.00 | 0.00 | | 2025-09-27 00:30:49.406991+00 | | |
| public | l_role_feature | 6795 | 0 | 0.00 | 0.00 | | 2025-09-27 00:30:49.368171+00 | | |
| public | l_site | 258 | 0 | 0.00 | 0.00 | | 2025-09-27 00:31:07.531251+00 | | |
| public | l_tx | 144112 | 7630 | 0.00 | 5.00 | | 2025-09-30 15:30:12.917624+00 | | 2025-09-30 14:54:10.922312+00 |
| public | l_user | 65737 | 717 | 0.00 | 1.00 | | 2025-09-27 00:30:49.281338+00 | | 2025-09-30 09:16:26.739287+00 |
| public | l_zone | 9904 | 51 | 0.00 | 0.00 | | 2025-09-27 00:31:08.005735+00 | | |
| public | l_zone_category | 4908 | 2 | 0.00 | 0.00 | | 2025-09-27 00:30:47.298473+00 | | |
| public | m_area | 792 | 8 | 0.00 | 1.00 | | 2025-09-29 09:46:56.388562+00 | | |
| public | m_auth | 151 | 17 | 0.00 | 10.00 | | 2025-09-28 08:26:24.228097+00 | | |
| public | m_category | 2449 | 0 | 0.00 | 0.00 | | 2025-09-29 09:46:56.352543+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-09-30 04:08:10.510591+00 | | |
| public | m_exb | 27511 | 0 | 0.00 | 0.00 | | 2025-09-27 23:13:41.371815+00 | | |
| public | m_favorite | 240619 | 1229 | 0.00 | 0.00 | | 2025-09-29 04:36:20.461205+00 | | |
| public | m_favorite_group | 117395 | 132 | 0.00 | 0.00 | | 2025-09-30 20:29:56.419371+00 | | |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-09-28 19:17:20.699203+00 | | |
| public | m_group | 29017 | 1064 | 0.00 | 3.00 | | 2025-09-30 12:58:57.925093+00 | | 2025-09-30 14:40:49.664464+00 |
| public | m_holiday | 43759 | 0 | 0.00 | 0.00 | | 2025-09-26 03:40:58.963395+00 | | |
| public | m_lob | 24766 | 67 | 0.00 | 0.00 | | 2025-09-26 07:10:51.143152+00 | | |
| public | m_lob_log | 2325 | 0 | 0.00 | 0.00 | | 2025-09-25 21:44:10.253938+00 | | 2025-09-29 04:32:21.117028+00 |
| public | m_location | 45451 | 2645 | 0.00 | 5.00 | | 2025-09-29 07:57:31.141608+00 | | 2025-09-19 06:15:04.836821+00 |
| public | m_notify_template | 1242 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.393836+00 | | |
| public | m_outside | 377 | 3 | 0.00 | 0.00 | | 2025-09-25 07:43:52.287136+00 | | |
| public | m_personal_setting | 135343 | 17547 | 0.00 | 11.00 | | 2025-09-25 02:13:15.489112+00 | | 2025-10-01 00:34:42.713125+00 |
| public | m_pot | 208321 | 21854 | 0.00 | 9.00 | | 2025-09-29 00:25:21.777348+00 | | 2025-10-01 00:21:43.436562+00 |
| public | m_pot_profile | 51958 | 25 | 0.00 | 0.00 | | 2025-09-26 15:58:50.426619+00 | | |
| public | m_provider_user | 85 | 0 | 0.00 | 0.00 | | 2025-09-28 22:01:50.627287+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.491149+00 | | |
| public | m_role | 781 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.466766+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.356467+00 | | |
| public | m_setting | 22367 | 1218 | 0.00 | 5.00 | | 2025-09-30 06:51:05.040174+00 | | 2025-09-30 01:23:48.191365+00 |
| public | m_setting_log | 37066 | 1626 | 0.00 | 4.00 | | 2025-09-28 01:51:05.799914+00 | | 2025-09-30 04:51:04.53757+00 |
| public | m_site | 189 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.030169+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.535602+00 | | |
| public | m_tx | 130664 | 21092 | 0.00 | 13.00 | | 2025-09-30 23:40:38.025205+00 | | 2025-09-30 23:50:37.424166+00 |
| public | m_user | 38061 | 388 | 0.00 | 1.00 | | 2025-09-25 03:18:58.262558+00 | | 2025-09-24 00:24:08.965179+00 |
| public | m_zone | 7934 | 67 | 0.00 | 0.00 | | 2025-09-29 01:49:31.277728+00 | | 2025-09-25 00:44:34.586772+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.170572+00 | | |
| public | r_auth_zone | 231 | 6 | 0.00 | 2.00 | | 2025-09-29 05:17:12.389541+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.418839+00 | | |
| public | r_group_auth | 573 | 1 | 0.00 | 0.00 | | 2025-09-30 02:21:37.244358+00 | | |
| public | r_location_zone | 55536 | 1787 | 0.00 | 3.00 | | 2025-09-29 09:46:56.225108+00 | | 2025-09-30 07:42:30.306467+00 |
| public | r_pot_auth | 9679 | 294 | 0.00 | 2.00 | | 2025-09-25 23:51:31.814069+00 | | 2025-09-22 00:49:20.732285+00 |
| public | r_pot_category | 14076 | 65 | 0.00 | 0.00 | | 2025-09-25 18:07:07.385886+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 446372 | 2650 | 0.00 | 0.00 | | 2025-09-30 04:08:10.203754+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-09-29 01:49:27.870676+00 | | |
| public | r_pot_tx | 70718 | 451 | 0.00 | 0.00 | | 2025-09-26 02:46:12.901782+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 21385 | 36 | 0.00 | 0.00 | | 2025-09-26 08:20:53.683302+00 | | |
| public | r_provider_tenant | 1173 | 0 | 0.00 | 0.00 | | 2025-09-26 08:25:48.01334+00 | | 2025-09-11 06:34:01.277345+00 |
| public | r_role_feature | 6212 | 0 | 0.00 | 0.00 | | 2025-09-30 21:53:35.884736+00 | | |
| public | r_tenant_feature | 4583 | 0 | 0.00 | 0.00 | | 2025-09-29 15:03:17.239868+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-30 12:58:57.936255+00 | | |
| public | r_user_region | 22226 | 35 | 0.00 | 0.00 | | 2025-09-26 08:20:47.334422+00 | | |
| public | r_user_site | 6372 | 2 | 0.00 | 0.00 | | 2025-09-28 08:26:24.33156+00 | | |
| public | r_zone_category | 5039 | 2 | 0.00 | 0.00 | | 2025-09-25 21:44:09.793467+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-30 06:44:08.908945+00 | | |
| public | t_attendance | 3314414 | 12191 | 0.00 | 0.00 | | 2025-09-29 15:04:14.567247+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4294 | 2 | 0.00 | 0.00 | | 2025-09-30 02:16:42.908797+00 | | |
| public | t_general_20250618 | 3155 | 0 | 0.00 | 0.00 | | 2025-09-25 07:40:53.178749+00 | | |
| public | t_job | 46 | 7 | 0.00 | 13.00 | | 2025-09-25 18:01:07.239135+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 894958 | 0 | 0.00 | 0.00 | | 2025-09-28 23:30:19.361438+00 | | |
| public | t_mobile_status_history | 2210813 | 0 | 0.00 | 0.00 | | 2025-09-26 06:43:52.847749+00 | | 2025-09-29 04:23:22.984019+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.440471+00 | | |
| public | t_notify_history | 6837004 | 9168 | 0.00 | 0.00 | | 2025-09-29 00:01:54.230029+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 22704336 | 37 | 0.00 | 0.00 | | 2025-09-25 23:22:08.498288+00 | | |
| public | t_plan | 28761952 | 197504 | 0.00 | 0.00 | | 2025-09-30 10:24:37.391323+00 | | 2025-09-29 05:17:15.079789+00 |
| public | t_plan_cancel_history | 717273 | 60854 | 0.00 | 7.00 | | 2025-09-26 11:53:59.678765+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 49768504 | 1654293 | 0.00 | 3.00 | | 2025-09-26 06:42:29.231983+00 | | 2025-09-30 00:46:48.443022+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-09-29 01:49:27.852841+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-09-29 01:49:27.831503+00 | | |
| public | t_plan_sync | 67921 | 4952 | 0.00 | 6.00 | | 2025-10-01 00:34:41.131524+00 | | 2025-10-01 00:34:41.464596+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-09-28 08:26:24.564337+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.243556+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:24.51431+00 | | |
| public | t_recv_position_history | 153322 | 26065 | 0.00 | 14.00 | | 2025-10-01 00:50:45.529634+00 | 2025-09-30 13:30:03.986224+00 | 2025-10-01 00:51:39.947255+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-28 08:26:08.303302+00 | | |
| public | t_terminal | 21765 | 3157 | 0.00 | 12.00 | | 2025-09-30 21:47:57.421429+00 | | 2025-10-01 00:44:48.339119+00 |
| public | t_terminal_log | 31516800 | 0 | 0.00 | 0.00 | | 2025-09-25 14:01:30.339582+00 | | 2025-09-21 13:00:59.492055+00 |
| public | temp_pivot_table | 239829 | 0 | 0.00 | 0.00 | | 2025-09-26 15:58:50.989452+00 | | |
| public | w_arrival_notify | 97 | 29 | 0.00 | 23.00 | | 2025-09-26 07:20:51.645836+00 | | 2025-09-26 15:06:49.18336+00 |
| public | w_latest_mobile_device | 57894 | 154 | 0.00 | 0.00 | | 2025-09-30 07:54:33.692494+00 | | 2025-09-29 10:02:56.584683+00 |
| public | w_latest_mobile_status | 56859 | 4502 | 0.00 | 7.00 | | 2025-10-01 00:05:40.657433+00 | | 2025-10-01 00:45:40.999098+00 |
| public | w_latest_position | 80180 | 46328 | 0.00 | 36.00 | | 2025-10-01 00:51:40.12159+00 | | 2025-10-01 00:51:40.322229+00 |
| public | w_latest_presence | 252938 | 263069 | 1.00 | 50.00 | | 2025-10-01 00:52:04.157483+00 | | 2025-10-01 00:52:06.008128+00 |
| public | w_latest_sensor | 386 | 358 | 0.00 | 48.00 | | 2025-10-01 00:51:51.119239+00 | | 2025-10-01 00:51:51.232761+00 |
| public | w_lock | 19034 | 0 | 0.00 | 0.00 | | 2025-09-30 16:35:51.991832+00 | | |
| public | w_master_update | 113 | 71 | 0.00 | 38.00 | | 2025-09-30 23:45:38.373694+00 | | 2025-10-01 00:30:39.392489+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-28 12:37:53.287481+00 | | |
| public | w_plan_sync_retry | 18 | 36 | 2.00 | 66.00 | | 2025-09-30 13:02:59.429253+00 | | 2025-09-30 23:44:37.627508+00 |
| public | w_plan_with_detail | 29126430 | 1010968 | 0.00 | 3.00 | | 2025-09-28 21:06:56.358731+00 | | 2025-09-29 05:17:10.778128+00 |