| 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 | 32413403 | 10674 | 0.00 | 0.00 | | 2025-10-08 03:29:41.045736+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36242152 | 27545 | 0.00 | 0.00 | | 2025-10-08 10:55:56.862292+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 581791020 | 0 | 0.00 | 0.00 | | 2025-10-11 18:01:45.403348+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 69665849 | 0 | 0.00 | 0.00 | | 2025-10-08 04:59:58.040019+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764761 | 0 | 0.00 | 0.00 | | 2025-10-10 11:23:44.463657+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 29564697 | 0 | 0.00 | 0.00 | | 2025-10-11 02:58:47.213742+00 | | 2025-09-30 15:54:26.616538+00 |
| e202509 | a_stay_time | 38717738 | 0 | 0.00 | 0.00 | | 2025-10-13 14:58:31.047301+00 | | 2025-09-30 17:25:54.238102+00 |
| e202509 | t_position_history | 598189598 | 3065 | 0.00 | 0.00 | | 2025-10-10 03:43:30.581428+00 | | 2025-09-29 20:40:54.897196+00 |
| e202509 | t_presence_history | 70578444 | 0 | 0.00 | 0.00 | | 2025-10-09 08:33:51.09414+00 | | 2025-09-30 14:47:50.312729+00 |
| e202509 | t_sensor_history | 11637712 | 0 | 0.00 | 0.00 | | 2025-10-09 23:33:56.932711+00 | | 2025-09-29 19:30:39.022501+00 |
| e202510 | a_proximity_sum | 12305858 | 0 | 0.00 | 0.00 | | 2025-10-10 16:24:26.192689+00 | | 2025-10-10 16:24:52.867988+00 |
| e202510 | a_stay_time | 15680714 | 0 | 0.00 | 0.00 | | 2025-10-13 11:21:43.400697+00 | | 2025-10-10 16:00:11.050506+00 |
| e202510 | t_position_history | 248706742 | 0 | 0.00 | 0.00 | | 2025-10-10 01:10:13.379428+00 | | 2025-10-13 19:54:46.314246+00 |
| e202510 | t_presence_history | 22996964 | 2880286 | 0.00 | 11.00 | | 2025-10-14 00:34:05.669012+00 | | 2025-10-14 00:47:33.367446+00 |
| e202510 | t_sensor_history | 5192149 | 0 | 0.00 | 0.00 | | 2025-10-11 19:17:56.418568+00 | | 2025-10-13 21:19:27.330039+00 |
| public | __digdag_status | 35 | 0 | 0.00 | 0.00 | | 2025-10-13 12:45:03.334951+00 | | 2025-10-13 12:31:00.845249+00 |
| public | a_attendance_sum | 164686 | 6025 | 0.00 | 3.00 | | 2025-10-10 10:22:17.431178+00 | | 2025-10-14 00:27:54.735519+00 |
| public | a_plan_actual | 1259164 | 1 | 0.00 | 0.00 | | 2025-10-10 08:40:47.915063+00 | | 2025-10-08 16:50:49.780136+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-10-09 11:25:30.198315+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-10-09 11:25:28.807975+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-10-09 11:25:27.543413+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-10-11 22:41:53.626447+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-10-11 00:52:40.173272+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-10-11 05:52:45.43558+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.759269+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-10-11 05:52:45.458767+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-10-11 05:52:45.478503+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.780089+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.727907+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-10-11 05:52:43.796938+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.802849+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-10-11 00:50:11.825368+00 | | |
| public | l_area | 1570 | 4 | 0.00 | 0.00 | | 2025-10-09 02:04:59.349649+00 | | |
| public | l_auth | 197 | 0 | 0.00 | 0.00 | | 2025-10-09 02:04:59.275325+00 | | |
| public | l_category | 2684 | 0 | 0.00 | 0.00 | | 2025-10-09 02:05:01.127954+00 | | |
| public | l_group | 35035 | 45 | 0.00 | 0.00 | | 2025-10-09 02:05:05.114832+00 | | 2025-09-30 23:33:59.40754+00 |
| public | l_lob | 2065 | 18 | 0.00 | 0.00 | | 2025-10-07 23:27:46.167409+00 | | 2025-10-07 02:10:08.82178+00 |
| public | l_location | 118423 | 337 | 0.00 | 0.00 | | 2025-10-09 02:05:00.892893+00 | | 2025-09-30 14:54:10.611121+00 |
| public | l_location_zone | 111620 | 1603 | 0.00 | 1.00 | | 2025-10-09 02:04:59.904353+00 | | 2025-10-08 06:15:53.514279+00 |
| public | l_outside | 448 | 0 | 0.00 | 0.00 | | 2025-10-09 02:04:59.315627+00 | | |
| public | l_pot | 451694 | 6345 | 0.00 | 1.00 | | 2025-10-09 02:05:12.676285+00 | | 2025-10-08 08:16:47.032966+00 |
| public | l_pot_category | 14471 | 141 | 0.00 | 0.00 | | 2025-10-09 02:05:01.050552+00 | | 2025-10-09 00:24:05.35073+00 |
| public | l_pot_group | 233331 | 202 | 0.00 | 0.00 | | 2025-10-09 02:05:04.757317+00 | | 2025-10-08 06:51:13.475539+00 |
| public | l_pot_tx | 100885 | 252 | 0.00 | 0.00 | | 2025-10-09 02:05:02.368376+00 | | 2025-10-02 00:02:22.235052+00 |
| public | l_role | 776 | 0 | 0.00 | 0.00 | | 2025-10-09 01:30:31.495391+00 | | |
| public | l_role_feature | 6986 | 0 | 0.00 | 0.00 | | 2025-10-09 01:30:31.415545+00 | | |
| public | l_site | 248 | 0 | 0.00 | 0.00 | | 2025-10-09 02:04:59.372356+00 | | |
| public | l_tx | 147647 | 25310 | 0.00 | 14.00 | | 2025-10-10 05:44:47.299338+00 | | 2025-10-10 09:27:42.888162+00 |
| public | l_user | 66614 | 315 | 0.00 | 0.00 | | 2025-10-09 01:30:31.298868+00 | | 2025-09-30 09:16:26.739287+00 |
| public | l_zone | 10007 | 1 | 0.00 | 0.00 | | 2025-10-09 02:04:59.988492+00 | | |
| public | l_zone_category | 5760 | 0 | 0.00 | 0.00 | | 2025-10-09 01:30:29.143078+00 | | |
| public | m_area | 783 | 0 | 0.00 | 0.00 | | 2025-10-10 16:09:10.662207+00 | | 2025-10-01 05:38:37.738397+00 |
| public | m_auth | 152 | 0 | 0.00 | 0.00 | | 2025-10-09 11:25:30.254093+00 | | |
| public | m_category | 2422 | 0 | 0.00 | 0.00 | | 2025-10-10 16:09:10.627537+00 | | |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-10-12 06:16:07.621763+00 | | |
| public | m_exb | 27486 | 3 | 0.00 | 0.00 | | 2025-10-09 07:43:30.354095+00 | | 2025-10-08 06:39:33.915423+00 |
| public | m_favorite | 216651 | 49 | 0.00 | 0.00 | | 2025-10-10 06:16:54.25121+00 | | 2025-10-04 11:44:23.054199+00 |
| public | m_favorite_group | 115175 | 0 | 0.00 | 0.00 | | 2025-10-13 22:17:23.877275+00 | | 2025-10-08 06:28:55.123658+00 |
| public | m_feature | 169 | 0 | 0.00 | 0.00 | | 2025-10-09 22:10:52.391748+00 | | |
| public | m_group | 28306 | 3658 | 0.00 | 11.00 | | 2025-10-09 14:41:00.447365+00 | | 2025-10-12 14:40:58.400174+00 |
| public | m_holiday | 42898 | 695 | 0.00 | 1.00 | | 2025-10-08 05:22:25.101436+00 | | |
| public | m_lob | 21736 | 17 | 0.00 | 0.00 | | 2025-10-08 08:47:25.718252+00 | | 2025-10-08 07:12:18.311027+00 |
| public | m_lob_log | 5314 | 0 | 0.00 | 0.00 | | 2025-10-08 07:12:19.05236+00 | | 2025-10-08 07:12:19.071766+00 |
| public | m_location | 45358 | 2 | 0.00 | 0.00 | | 2025-10-10 11:00:32.073051+00 | | 2025-10-01 00:59:46.898895+00 |
| public | m_notify_template | 1228 | 0 | 0.00 | 0.00 | | 2025-10-09 11:28:31.981404+00 | | |
| public | m_outside | 373 | 4 | 0.00 | 1.00 | | 2025-10-07 09:14:24.121028+00 | | |
| public | m_personal_setting | 130034 | 11519 | 0.00 | 8.00 | | 2025-10-13 23:09:12.95438+00 | | 2025-10-14 00:48:26.319098+00 |
| public | m_pot | 204891 | 18837 | 0.00 | 8.00 | | 2025-10-10 01:10:51.91979+00 | | 2025-10-14 00:19:56.028547+00 |
| public | m_pot_profile | 53046 | 11 | 0.00 | 0.00 | | 2025-10-08 22:49:33.959437+00 | | 2025-10-08 07:13:12.749032+00 |
| public | m_provider_user | 85 | 2 | 0.00 | 2.00 | | 2025-10-09 23:37:36.603107+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-10-09 11:28:32.105099+00 | | |
| public | m_role | 779 | 0 | 0.00 | 0.00 | | 2025-10-09 11:28:32.078649+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-10-09 11:25:30.405374+00 | | |
| public | m_setting | 15845 | 2215 | 0.00 | 12.00 | | 2025-10-12 11:36:57.994648+00 | | 2025-10-13 08:47:49.18723+00 |
| public | m_setting_log | 35899 | 0 | 0.00 | 0.00 | | 2025-10-13 14:52:34.458006+00 | | 2025-10-12 12:30:18.375199+00 |
| public | m_site | 183 | 6 | 0.00 | 3.00 | | 2025-10-09 11:25:30.229242+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-10-09 11:28:32.144519+00 | | |
| public | m_tx | 153907 | 4201 | 0.00 | 2.00 | | 2025-10-10 10:31:52.875039+00 | | 2025-10-10 10:12:13.174267+00 |
| public | m_user | 34127 | 244 | 0.00 | 0.00 | | 2025-10-07 04:32:09.173374+00 | | 2025-10-09 05:29:57.240234+00 |
| public | m_zone | 7884 | 46 | 0.00 | 0.00 | | 2025-10-10 03:51:43.362212+00 | | 2025-09-25 00:44:34.586772+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-10-09 11:25:27.518438+00 | | |
| public | r_auth_zone | 232 | 0 | 0.00 | 0.00 | | 2025-10-10 07:01:50.730353+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-10-09 11:28:32.010644+00 | | |
| public | r_group_auth | 573 | 0 | 0.00 | 0.00 | | 2025-10-11 23:07:42.901083+00 | | |
| public | r_location_zone | 55833 | 0 | 0.00 | 0.00 | | 2025-10-10 16:09:10.503155+00 | | 2025-10-10 09:12:08.559148+00 |
| public | r_pot_auth | 8464 | 5 | 0.00 | 0.00 | | 2025-10-08 01:36:12.727357+00 | | 2025-10-02 06:32:17.177394+00 |
| public | r_pot_category | 11968 | 172 | 0.00 | 1.00 | | 2025-10-07 23:27:45.92528+00 | | 2025-10-02 06:27:17.344153+00 |
| public | r_pot_group | 203331 | 72 | 0.00 | 0.00 | | 2025-10-12 06:16:07.13053+00 | | 2025-10-06 05:12:08.991893+00 |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-10-10 03:45:19.355841+00 | | |
| public | r_pot_tx | 69011 | 2401 | 0.00 | 3.00 | | 2025-10-08 04:31:50.095983+00 | | 2025-10-09 00:14:51.631362+00 |
| public | r_pot_user | 21208 | 7 | 0.00 | 0.00 | | 2025-10-08 10:30:29.869504+00 | | |
| public | r_provider_tenant | 937 | 0 | 0.00 | 0.00 | | 2025-10-11 19:37:43.914034+00 | | 2025-10-06 02:33:51.799078+00 |
| public | r_role_feature | 6236 | 0 | 0.00 | 0.00 | | 2025-10-13 23:21:15.799189+00 | | |
| public | r_tenant_feature | 4546 | 0 | 0.00 | 0.00 | | 2025-10-11 00:50:10.301846+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-10-13 13:08:43.8596+00 | | |
| public | r_user_region | 22056 | 4 | 0.00 | 0.00 | | 2025-10-08 10:30:28.381015+00 | | |
| public | r_user_site | 5562 | 0 | 0.00 | 0.00 | | 2025-10-09 11:25:30.377667+00 | | |
| public | r_zone_category | 5023 | 37 | 0.00 | 0.00 | | 2025-10-08 00:21:10.831109+00 | | |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-10-12 19:11:42.167693+00 | | |
| public | t_attendance | 3451755 | 533 | 0.00 | 0.00 | | 2025-10-11 00:51:27.652186+00 | | 2025-10-03 08:31:08.110581+00 |
| public | t_general | 4359 | 0 | 0.00 | 0.00 | | 2025-10-11 22:41:53.303348+00 | | |
| public | t_general_20250618 | 3060 | 0 | 0.00 | 0.00 | | 2025-10-07 09:10:53.430364+00 | | |
| public | t_job | 56 | 1 | 0.00 | 1.00 | | 2025-10-07 23:27:46.182276+00 | | 2025-10-07 11:10:36.569592+00 |
| public | t_mobile_device_history | 1374382 | 0 | 0.00 | 0.00 | | 2025-10-10 00:34:48.70393+00 | | |
| public | t_mobile_status_history | 2266076 | 0 | 0.00 | 0.00 | | 2025-10-08 08:19:50.088037+00 | | 2025-09-29 04:23:22.984019+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-10-09 11:28:32.0331+00 | | |
| public | t_notify_history | 6889720 | 7352 | 0.00 | 0.00 | | 2025-10-10 01:11:05.366937+00 | | 2025-09-21 22:24:10.089655+00 |
| public | t_operation_log | 25129311 | 260107 | 0.00 | 1.00 | | 2025-10-08 01:18:18.596097+00 | | 2025-10-10 06:07:51.303391+00 |
| public | t_plan | 29350713 | 186133 | 0.00 | 0.00 | | 2025-10-13 08:47:11.121307+00 | | 2025-10-07 23:16:11.564103+00 |
| public | t_plan_cancel_history | 725695 | 62437 | 0.00 | 7.00 | | 2025-10-08 19:02:52.79431+00 | | 2025-10-01 00:18:42.780986+00 |
| public | t_plan_detail | 42815061 | 2528032 | 0.00 | 5.00 | | 2025-10-08 03:11:55.561254+00 | | 2025-10-10 01:38:03.354338+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-10-10 03:45:19.330343+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-10-10 03:45:19.310877+00 | | |
| public | t_plan_sync | 63757 | 11510 | 0.00 | 15.00 | | 2025-10-13 23:35:11.576175+00 | | 2025-10-14 00:34:28.12786+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-10-09 11:28:32.17808+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-10-09 11:25:27.582543+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-10-09 11:28:32.120088+00 | | |
| public | t_recv_position_history | 152656 | 23639 | 0.00 | 13.00 | | 2025-10-14 00:50:30.897486+00 | 2025-10-13 13:30:02.16812+00 | 2025-10-14 00:51:25.504086+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-10-09 11:25:27.65469+00 | | |
| public | t_terminal | 19927 | 1755 | 0.00 | 8.00 | | 2025-10-13 19:53:44.233906+00 | | 2025-10-14 00:34:30.378189+00 |
| public | t_terminal_log | 31343450 | 1648132 | 0.00 | 4.00 | | 2025-10-07 21:01:08.198212+00 | | 2025-10-10 03:51:41.313882+00 |
| public | temp_pivot_table | 239687 | 0 | 0.00 | 0.00 | | 2025-10-08 22:49:35.712668+00 | | |
| public | w_arrival_notify | 98 | 49 | 0.00 | 33.00 | | 2025-10-07 15:01:01.561004+00 | | 2025-10-09 15:00:43.165239+00 |
| public | w_latest_mobile_device | 55544 | 166 | 0.00 | 0.00 | | 2025-10-13 00:43:21.333282+00 | | 2025-10-10 10:34:42.678977+00 |
| public | w_latest_mobile_status | 54521 | 10380 | 0.00 | 15.00 | | 2025-10-10 10:22:13.023956+00 | | 2025-10-14 00:51:26.622681+00 |
| public | w_latest_position | 77451 | 16522 | 0.00 | 17.00 | | 2025-10-14 00:51:25.641359+00 | | 2025-10-14 00:51:25.810616+00 |
| public | w_latest_presence | 244336 | 173761 | 0.00 | 41.00 | | 2025-10-14 00:50:47.827212+00 | | 2025-10-14 00:50:49.492829+00 |
| public | w_latest_sensor | 386 | 204 | 0.00 | 34.00 | | 2025-10-14 00:51:26.639731+00 | | 2025-10-14 00:51:26.75191+00 |
| public | w_lock | 19345 | 0 | 0.00 | 0.00 | | 2025-10-13 17:49:56.418036+00 | | |
| public | w_master_update | 112 | 60 | 0.00 | 34.00 | | 2025-10-13 22:14:23.54294+00 | | 2025-10-14 00:44:31.028011+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-10-09 14:46:23.271884+00 | | |
| public | w_plan_sync_retry | 1 | 31 | 31.00 | 96.00 | | 2025-10-13 00:47:15.500852+00 | | 2025-10-13 23:01:24.368459+00 |
| public | w_plan_with_detail | 23512062 | 639417 | 0.00 | 2.00 | | 2025-10-09 23:33:27.752486+00 | | 2025-10-14 00:34:26.570151+00 |