| 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 |
|---|
| e202510 | a_proximity_sum | 41494129 | 0 | 0.00 | 0.00 | | 2025-12-12 00:08:28.888552+00 | | 2025-10-31 17:24:22.03982+00 |
| e202510 | a_stay_time | 44674737 | 0 | 0.00 | 0.00 | | 2025-12-16 10:03:30.723673+00 | | 2025-10-31 16:15:51.689039+00 |
| e202510 | t_position_history | 639583747 | 2345093 | 0.00 | 0.00 | | 2025-12-12 00:08:28.799349+00 | | 2025-10-29 19:35:21.809624+00 |
| e202510 | t_presence_history | 65121742 | 0 | 0.00 | 0.00 | | 2025-12-12 18:58:25.93356+00 | | 2025-10-31 14:59:46.05603+00 |
| e202510 | t_sensor_history | 11673859 | 0 | 0.00 | 0.00 | | 2025-12-11 13:26:54.670538+00 | | 2025-10-30 01:18:33.550108+00 |
| e202511 | a_proximity_sum | 56051234 | 0 | 0.00 | 0.00 | | 2025-12-12 19:01:20.651193+00 | | 2025-11-29 16:49:11.217033+00 |
| e202511 | a_stay_time | 40993256 | 0 | 0.00 | 0.00 | | 2025-12-11 20:15:03.850338+00 | | 2025-11-28 20:10:59.778401+00 |
| e202511 | t_position_history | 558677591 | 2965774 | 0.00 | 0.00 | | 2025-12-11 20:15:04.536145+00 | | 2025-11-29 02:17:09.975534+00 |
| e202511 | t_presence_history | 52917234 | 0 | 0.00 | 0.00 | | 2025-12-12 00:08:29.080799+00 | | 2025-11-30 14:33:44.67193+00 |
| e202511 | t_sensor_history | 11233538 | 0 | 0.00 | 0.00 | | 2025-12-12 18:58:26.011037+00 | | 2025-11-28 12:39:29.055744+00 |
| e202512 | a_proximity_sum | 32496956 | 0 | 0.00 | 0.00 | | 2025-12-11 20:08:18.297555+00 | | 2025-12-16 20:14:56.071996+00 |
| e202512 | a_stay_time | 27291034 | 0 | 0.00 | 0.00 | | 2025-12-16 02:38:33.339559+00 | | 2025-12-16 17:33:53.967302+00 |
| e202512 | t_position_history | 342690523 | 15931761 | 0.00 | 4.00 | | 2025-12-16 08:12:35.362921+00 | | 2025-12-16 08:49:57.586524+00 |
| e202512 | t_presence_history | 77837116 | 65810994 | 0.00 | 45.00 | | 2025-12-17 00:20:31.919405+00 | | 2025-12-16 23:59:43.180947+00 |
| e202512 | t_sensor_history | 6114729 | 0 | 0.00 | 0.00 | | 2025-12-15 08:43:32.893702+00 | | 2025-12-15 15:19:03.024245+00 |
| public | __digdag_status | 35 | 16 | 0.00 | 31.00 | | 2025-12-12 18:56:34.113422+00 | | 2025-12-08 12:30:49.860087+00 |
| public | a_attendance_sum | 264448 | 33579 | 0.00 | 11.00 | | 2025-12-16 23:58:45.381755+00 | | 2025-12-16 22:59:32.482244+00 |
| public | a_plan_actual | 1648836 | 44 | 0.00 | 0.00 | | 2025-12-12 18:54:25.95994+00 | | 2025-12-15 20:40:51.498853+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-12-12 18:54:29.209548+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-12-12 18:54:29.082151+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-12-12 18:54:22.219321+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-12-16 08:13:08.927574+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-12-16 02:42:04.397719+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-12-16 05:08:35.217343+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-12-16 02:40:52.03636+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-12-16 05:08:35.240242+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-12-16 05:08:35.261072+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-12-16 02:40:52.05645+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-12-16 02:40:52.013475+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-12-16 05:08:34.0559+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-12-16 02:40:52.079671+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-12-16 02:40:52.101322+00 | | |
| public | l_area | 1770 | 25 | 0.00 | 1.00 | | 2025-12-12 00:09:01.700895+00 | | 2025-11-20 04:34:00.972924+00 |
| public | l_auth | 199 | 1 | 0.00 | 0.00 | | 2025-12-12 00:09:01.564176+00 | | |
| public | l_category | 2819 | 28 | 0.00 | 0.00 | | 2025-12-12 00:09:02.098156+00 | | |
| public | l_group | 37274 | 51 | 0.00 | 0.00 | | 2025-12-12 00:09:02.550986+00 | | |
| public | l_lob | 2300 | 25 | 0.00 | 1.00 | | 2025-12-11 20:09:35.104708+00 | | 2025-11-25 02:07:03.012893+00 |
| public | l_location | 149709 | 6447 | 0.00 | 4.00 | | 2025-12-12 19:01:23.181738+00 | | 2025-12-14 11:15:48.475978+00 |
| public | l_location_zone | 143888 | 436 | 0.00 | 0.00 | | 2025-12-12 19:01:21.499798+00 | | 2025-11-29 07:06:54.490052+00 |
| public | l_outside | 451 | 1 | 0.00 | 0.00 | | 2025-12-12 00:09:01.617921+00 | | |
| public | l_pot | 505778 | 3491 | 0.00 | 0.00 | | 2025-12-12 00:09:10.786784+00 | | 2025-12-01 03:18:19.255248+00 |
| public | l_pot_category | 23876 | 1370 | 0.00 | 5.00 | | 2025-12-12 19:01:23.396576+00 | | 2025-12-14 11:53:06.212323+00 |
| public | l_pot_group | 521710 | 624 | 0.00 | 0.00 | | 2025-12-12 19:01:26.609759+00 | | 2025-10-29 08:46:37.528183+00 |
| public | l_pot_tx | 172563 | 1831 | 0.00 | 1.00 | | 2025-12-12 19:01:24.752461+00 | | 2025-12-03 07:20:12.846955+00 |
| public | l_role | 783 | 6 | 0.00 | 0.00 | | 2025-12-12 00:08:01.666749+00 | | |
| public | l_role_feature | 8005 | 64 | 0.00 | 0.00 | | 2025-12-12 18:56:34.256724+00 | | 2025-10-29 08:49:05.223461+00 |
| public | l_site | 258 | 1 | 0.00 | 0.00 | | 2025-12-12 00:09:01.739268+00 | | |
| public | l_tx | 153112 | 4308 | 0.00 | 2.00 | | 2025-12-16 04:54:46.618626+00 | | 2025-12-16 04:54:47.108175+00 |
| public | l_user | 71419 | 606 | 0.00 | 0.00 | | 2025-12-12 00:08:01.623693+00 | | 2025-12-16 03:28:45.703323+00 |
| public | l_zone | 11191 | 19 | 0.00 | 0.00 | | 2025-12-12 00:09:01.980531+00 | | |
| public | l_zone_category | 5946 | 3 | 0.00 | 0.00 | | 2025-12-12 18:54:29.639478+00 | | 2025-12-07 11:39:14.825058+00 |
| public | m_area | 829 | 24 | 0.00 | 2.00 | | 2025-12-12 18:54:34.293296+00 | | 2025-12-05 12:08:26.097943+00 |
| public | m_auth | 152 | 2 | 0.00 | 1.00 | | 2025-12-12 18:54:33.759611+00 | | |
| public | m_category | 2513 | 27 | 0.00 | 1.00 | | 2025-12-12 18:54:34.254041+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-12-16 08:35:23.344314+00 | | |
| public | m_exb | 28855 | 58 | 0.00 | 0.00 | | 2025-12-12 00:07:26.088427+00 | | 2025-11-18 03:16:32.600306+00 |
| public | m_favorite | 234264 | 226 | 0.00 | 0.00 | | 2025-12-12 18:54:33.704466+00 | | 2025-12-03 07:18:48.83535+00 |
| public | m_favorite_group | 118641 | 121 | 0.00 | 0.00 | | 2025-12-11 13:24:41.820486+00 | | 2025-12-03 07:18:48.571033+00 |
| public | m_feature | 171 | 0 | 0.00 | 0.00 | | 2025-12-12 18:54:33.867554+00 | | |
| public | m_group | 28841 | 2033 | 0.00 | 6.00 | | 2025-12-12 00:07:36.29357+00 | | 2025-12-15 14:46:38.914559+00 |
| public | m_holiday | 41547 | 0 | 0.00 | 0.00 | | 2025-12-11 20:09:35.909746+00 | | |
| public | m_lob | 22853 | 49 | 0.00 | 0.00 | | 2025-12-11 20:08:24.531714+00 | | |
| public | m_lob_log | 5944 | 3 | 0.00 | 0.00 | | 2025-12-11 20:09:35.012325+00 | | 2025-12-02 20:01:23.488624+00 |
| public | m_location | 49563 | 9626 | 0.00 | 16.00 | | 2025-12-12 18:54:35.455902+00 | | 2025-12-15 08:07:34.414607+00 |
| public | m_notify_template | 1211 | 7 | 0.00 | 0.00 | | 2025-12-12 18:54:33.851463+00 | | |
| public | m_outside | 372 | 1 | 0.00 | 0.00 | | 2025-12-11 20:08:24.128566+00 | | |
| public | m_personal_setting | 126969 | 29437 | 0.00 | 18.00 | | 2025-12-17 00:09:59.768016+00 | | 2025-12-17 00:01:50.17288+00 |
| public | m_pot | 215828 | 18963 | 0.00 | 8.00 | | 2025-12-12 00:07:35.838033+00 | | 2025-12-15 00:02:31.811373+00 |
| public | m_pot_profile | 58734 | 22 | 0.00 | 0.00 | | 2025-12-12 00:07:20.676784+00 | | |
| public | m_provider_user | 86 | 0 | 0.00 | 0.00 | | 2025-12-12 18:56:34.329882+00 | | |
| public | m_region | 113 | 1 | 0.00 | 0.00 | | 2025-12-12 18:54:34.12573+00 | | |
| public | m_role | 786 | 6 | 0.00 | 0.00 | | 2025-12-12 18:54:34.10504+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-12-12 18:54:33.816912+00 | | |
| public | m_setting | 27128 | 684 | 0.00 | 2.00 | | 2025-12-16 20:26:59.093357+00 | | 2025-12-16 19:16:23.273987+00 |
| public | m_setting_log | 38601 | 2647 | 0.00 | 6.00 | | 2025-12-15 19:09:46.014134+00 | | 2025-12-16 12:32:59.282855+00 |
| public | m_site | 187 | 1 | 0.00 | 0.00 | | 2025-12-12 18:54:33.736476+00 | | |
| public | m_tenant | 112 | 1 | 0.00 | 0.00 | | 2025-12-12 18:54:35.474836+00 | | |
| public | m_tx | 131213 | 8226 | 0.00 | 5.00 | | 2025-12-16 06:47:07.455098+00 | | 2025-12-16 06:47:07.663114+00 |
| public | m_user | 38750 | 238 | 0.00 | 0.00 | | 2025-12-11 20:09:35.891358+00 | | 2025-12-02 09:51:45.064708+00 |
| public | m_zone | 8168 | 41 | 0.00 | 0.00 | | 2025-12-12 18:58:15.308515+00 | | 2025-12-02 09:09:49.640452+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-12-12 18:54:22.193018+00 | | |
| public | r_auth_zone | 177 | 1 | 0.00 | 0.00 | | 2025-12-12 18:54:33.780801+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-12-12 18:54:33.891936+00 | | |
| public | r_group_auth | 461 | 0 | 0.00 | 0.00 | | 2025-12-16 08:13:08.673339+00 | | 2025-11-17 06:43:36.264507+00 |
| public | r_location_zone | 56872 | 322 | 0.00 | 0.00 | | 2025-12-12 18:54:34.082399+00 | | 2025-12-10 16:54:02.529391+00 |
| public | r_pot_auth | 9074 | 4 | 0.00 | 0.00 | | 2025-12-11 20:08:20.931077+00 | | 2025-11-28 05:28:47.020235+00 |
| public | r_pot_category | 12332 | 1537 | 0.00 | 11.00 | | 2025-12-11 20:08:59.646971+00 | | 2025-12-14 14:46:41.244538+00 |
| public | r_pot_group | 420976 | 43 | 0.00 | 0.00 | | 2025-12-16 08:35:23.258937+00 | | |
| public | r_pot_plan_permission_group | 32 | 0 | 0.00 | 0.00 | | 2025-12-12 18:56:34.383696+00 | | |
| public | r_pot_tx | 72322 | 1929 | 0.00 | 2.00 | | 2025-12-11 20:08:59.426146+00 | | 2025-12-11 23:55:12.08588+00 |
| public | r_pot_user | 21337 | 17 | 0.00 | 0.00 | | 2025-12-11 20:08:24.222803+00 | | 2025-12-03 02:39:54.914143+00 |
| public | r_provider_tenant | 921 | 10 | 0.00 | 1.00 | | 2025-12-16 02:12:22.335254+00 | | 2025-12-10 02:09:25.013357+00 |
| public | r_role_feature | 6549 | 52 | 0.00 | 0.00 | | 2025-12-11 20:08:59.48481+00 | | |
| public | r_tenant_feature | 4415 | 19 | 0.00 | 0.00 | | 2025-12-16 02:40:47.840154+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-12-11 13:24:41.84641+00 | | |
| public | r_user_region | 21502 | 9 | 0.00 | 0.00 | | 2025-12-11 20:08:21.095157+00 | | 2025-12-03 08:08:50.88222+00 |
| public | r_user_site | 5504 | 0 | 0.00 | 0.00 | | 2025-12-12 18:54:33.792974+00 | | 2025-11-17 06:49:36.429664+00 |
| public | r_zone_category | 5719 | 2 | 0.00 | 0.00 | | 2025-12-11 20:08:24.286385+00 | | 2025-12-07 11:39:14.852119+00 |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-12-16 10:29:43.585462+00 | | |
| public | t_attendance | 3822745 | 11335 | 0.00 | 0.00 | | 2025-12-16 02:42:04.372029+00 | | 2025-11-28 04:00:24.432875+00 |
| public | t_general | 3893 | 3 | 0.00 | 0.00 | | 2025-12-16 08:13:08.89051+00 | | 2025-12-16 06:44:51.949697+00 |
| public | t_general_20250618 | 2552 | 0 | 0.00 | 0.00 | | 2025-12-11 20:09:35.939703+00 | | |
| public | t_job | 59 | 1 | 0.00 | 1.00 | | 2025-12-11 20:09:35.131442+00 | | |
| public | t_mobile_device_history | 1381171 | 0 | 0.00 | 0.00 | | 2025-12-12 18:54:31.536027+00 | | |
| public | t_mobile_status_history | 2633301 | 0 | 0.00 | 0.00 | | 2025-12-11 20:09:37.505348+00 | | 2025-12-08 03:15:06.269743+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-12-12 18:54:33.917209+00 | | |
| public | t_notify_history | 7477303 | 25725 | 0.00 | 0.00 | | 2025-12-12 18:56:33.983141+00 | | 2025-11-17 06:24:32.780981+00 |
| public | t_operation_log | 27338420 | 2309 | 0.00 | 0.00 | | 2025-12-11 20:09:34.994096+00 | | 2025-12-10 01:39:15.085282+00 |
| public | t_plan | 29478869 | 5414625 | 0.00 | 15.00 | | 2025-12-11 10:56:30.251345+00 | | 2025-12-16 23:42:36.648095+00 |
| public | t_plan_cancel_history | 827109 | 68562 | 0.00 | 7.00 | | 2025-12-12 00:08:00.139848+00 | | 2025-11-17 06:40:32.133611+00 |
| public | t_plan_detail | 54331717 | 1786408 | 0.00 | 3.00 | | 2025-12-16 13:47:52.785052+00 | | 2025-12-17 00:18:25.939111+00 |
| public | t_plan_permission | 116 | 0 | 0.00 | 0.00 | | 2025-12-12 18:56:34.360946+00 | | |
| public | t_plan_permission_group | 4 | 0 | 0.00 | 0.00 | | 2025-12-12 18:56:34.346489+00 | | |
| public | t_plan_sync | 106735 | 45507 | 0.00 | 29.00 | | 2025-12-17 00:19:33.970256+00 | | 2025-12-17 00:18:31.523679+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-12-12 18:56:34.0109+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-12-12 18:54:26.017843+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-12-12 18:54:34.265224+00 | | |
| public | t_recv_position_history | 176958 | 7313094 | 41.00 | 97.00 | | 2025-12-17 00:20:34.868388+00 | 2025-12-16 13:30:02.783669+00 | 2025-12-17 00:20:35.449213+00 |
| public | t_safr_event_history | 0 | 0 | 0 | 0 | | 2025-12-16 08:29:17.756483+00 | | |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-12-12 18:54:26.044555+00 | | |
| public | t_terminal | 59061 | 25550 | 0.00 | 30.00 | | 2025-12-17 00:19:34.143375+00 | | 2025-12-17 00:11:04.450502+00 |
| public | t_terminal_log | 37910952 | 18366 | 0.00 | 0.00 | | 2025-12-11 20:11:03.876113+00 | | 2025-11-24 08:37:11.884041+00 |
| public | temp_pivot_table | 238835 | 0 | 0.00 | 0.00 | | 2025-12-12 00:08:03.138314+00 | | |
| public | w_arrival_notify | 102 | 39 | 0.00 | 27.00 | | 2025-12-12 18:56:34.275663+00 | | 2025-12-16 15:01:21.873905+00 |
| public | w_latest_mobile_device | 57329 | 2976 | 0.00 | 4.00 | | 2025-12-16 20:22:00.452771+00 | | 2025-12-16 23:42:37.138502+00 |
| public | w_latest_mobile_status | 55764 | 13915 | 0.00 | 19.00 | | 2025-12-17 00:08:57.928628+00 | | 2025-12-16 23:46:38.231976+00 |
| public | w_latest_position | 85532 | 4368829 | 51.00 | 98.00 | | 2025-12-17 00:20:36.691361+00 | | 2025-12-17 00:20:37.173463+00 |
| public | w_latest_presence | 131308 | 66993781 | 510.00 | 99.00 | | 2025-12-17 00:19:53.090559+00 | | 2025-12-17 00:19:55.81179+00 |
| public | w_latest_sensor | 386 | 80696 | 209.00 | 99.00 | | 2025-12-17 00:19:34.202198+00 | | 2025-12-17 00:19:34.32641+00 |
| public | w_lock | 20230 | 10 | 0.00 | 0.00 | | 2025-12-11 13:24:06.300363+00 | | |
| public | w_master_update | 261 | 115 | 0.00 | 30.00 | | 2025-12-17 00:09:59.011137+00 | | 2025-12-17 00:05:52.378144+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-12-12 18:56:34.308671+00 | | |
| public | w_plan_sync_retry | 1 | 24 | 24.00 | 96.00 | | 2025-12-17 00:19:33.982515+00 | | 2025-12-16 22:08:29.439195+00 |
| public | w_plan_with_detail | 29462107 | 5068551 | 0.00 | 14.00 | | 2025-12-11 23:09:36.08413+00 | | 2025-12-16 12:08:14.197377+00 |