| 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 | 41134018 | 0 | 0.00 | 0.00 | | 2025-12-22 08:59:26.707025+00 | | 2025-10-31 17:24:22.03982+00 |
| e202510 | a_stay_time | 44473557 | 0 | 0.00 | 0.00 | | 2025-12-25 15:46:12.844685+00 | | 2025-10-31 16:15:51.689039+00 |
| e202510 | t_position_history | 539166568 | 0 | 0.00 | 0.00 | | 2025-12-22 08:50:41.564472+00 | | 2025-12-19 10:01:30.111158+00 |
| e202510 | t_presence_history | 64428524 | 693154 | 0.00 | 1.00 | | 2025-12-23 03:15:44.079095+00 | | 2025-10-31 14:59:46.05603+00 |
| e202510 | t_sensor_history | 11673835 | 0 | 0.00 | 0.00 | | 2025-12-22 04:03:52.832332+00 | | 2025-10-30 01:18:33.550108+00 |
| e202511 | a_proximity_sum | 55941187 | 0 | 0.00 | 0.00 | | 2025-12-23 03:18:06.298676+00 | | 2025-11-29 16:49:11.217033+00 |
| e202511 | a_stay_time | 40981189 | 0 | 0.00 | 0.00 | | 2025-12-22 09:01:23.925137+00 | | 2025-11-28 20:10:59.778401+00 |
| e202511 | t_position_history | 490763627 | 0 | 0.00 | 0.00 | | 2025-12-22 10:43:08.657183+00 | | 2025-12-19 05:54:11.843972+00 |
| e202511 | t_presence_history | 52320637 | 596533 | 0.00 | 1.00 | | 2025-12-22 08:59:26.836969+00 | | 2025-11-30 14:33:44.67193+00 |
| e202511 | t_sensor_history | 11233450 | 0 | 0.00 | 0.00 | | 2025-12-23 03:15:44.198653+00 | | 2025-11-28 12:39:29.055744+00 |
| e202512 | a_proximity_sum | 57330271 | 0 | 0.00 | 0.00 | | 2025-12-24 18:04:54.767459+00 | | 2025-12-24 22:56:21.528497+00 |
| e202512 | a_stay_time | 42360867 | 0 | 0.00 | 0.00 | | 2025-12-23 17:57:08.571614+00 | | 2025-12-24 16:26:52.196695+00 |
| e202512 | t_position_history | 547746336 | 0 | 0.00 | 0.00 | | 2025-12-24 08:06:05.360705+00 | | 2025-12-25 08:01:43.386162+00 |
| e202512 | t_presence_history | 118136457 | 65337685 | 0.00 | 35.00 | | 2025-12-26 00:24:44.807415+00 | | 2025-12-25 23:39:06.977072+00 |
| e202512 | t_sensor_history | 9459785 | 0 | 0.00 | 0.00 | | 2025-12-25 20:10:42.330508+00 | | 2025-12-25 03:04:57.984012+00 |
| public | __digdag_status | 36 | 11 | 0.00 | 23.00 | | 2025-12-22 23:51:26.835069+00 | | 2025-12-18 12:30:37.076082+00 |
| public | a_attendance_sum | 267514 | 27780 | 0.00 | 9.00 | | 2025-12-26 00:10:14.799072+00 | | 2025-12-25 23:43:25.210133+00 |
| public | a_plan_actual | 1694676 | 16365 | 0.00 | 0.00 | | 2025-12-22 23:49:48.126807+00 | | 2025-12-15 20:40:51.498853+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-12-22 23:50:36.475823+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-12-22 23:49:53.627827+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-12-22 23:49:46.515365+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-12-25 09:34:03.524439+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-12-25 03:43:20.079719+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-12-25 07:00:38.897524+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-12-25 03:42:12.893564+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-12-25 07:00:38.921014+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-12-25 07:00:38.942727+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-12-25 03:42:12.913755+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-12-25 03:42:12.868273+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-12-25 07:00:34.890972+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-12-25 03:42:12.936766+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-12-25 03:42:12.958404+00 | | |
| public | l_area | 1776 | 18 | 0.00 | 1.00 | | 2025-12-22 11:11:15.979576+00 | | 2025-12-23 06:56:17.626366+00 |
| public | l_auth | 201 | 0 | 0.00 | 0.00 | | 2025-12-22 11:11:15.859106+00 | | |
| public | l_category | 2778 | 48 | 0.00 | 1.00 | | 2025-12-22 11:11:16.300716+00 | | 2025-12-18 00:09:22.386871+00 |
| public | l_group | 34851 | 1505 | 0.00 | 4.00 | | 2025-12-22 11:11:16.778477+00 | | 2025-12-25 07:58:37.376266+00 |
| public | l_lob | 2336 | 11 | 0.00 | 0.00 | | 2025-12-22 05:12:28.796224+00 | | 2025-12-23 06:44:16.69489+00 |
| public | l_location | 145708 | 1761 | 0.00 | 1.00 | | 2025-12-23 03:39:56.398126+00 | | 2025-12-19 07:02:11.209672+00 |
| public | l_location_zone | 125772 | 2158 | 0.00 | 1.00 | | 2025-12-23 03:39:55.033093+00 | | 2025-12-25 07:17:31.445664+00 |
| public | l_outside | 444 | 3 | 0.00 | 0.00 | | 2025-12-22 11:11:15.904836+00 | | |
| public | l_pot | 487958 | 6602 | 0.00 | 1.00 | | 2025-12-22 11:11:24.029249+00 | | 2025-12-01 03:18:19.255248+00 |
| public | l_pot_category | 26180 | 3809 | 0.00 | 12.00 | | 2025-12-23 03:39:56.64596+00 | | 2025-12-25 07:17:31.612196+00 |
| public | l_pot_group | 539836 | 4079 | 0.00 | 0.00 | | 2025-12-23 03:39:59.744449+00 | | 2025-10-29 08:46:37.528183+00 |
| public | l_pot_tx | 131229 | 4170 | 0.00 | 3.00 | | 2025-12-23 03:39:58.068315+00 | | 2025-12-25 03:21:17.511254+00 |
| public | l_role | 783 | 4 | 0.00 | 0.00 | | 2025-12-22 05:12:29.583792+00 | | |
| public | l_role_feature | 7665 | 86 | 0.00 | 1.00 | | 2025-12-22 23:51:26.967857+00 | | 2025-12-25 01:59:46.810264+00 |
| public | l_site | 258 | 1 | 0.00 | 0.00 | | 2025-12-22 11:11:16.016775+00 | | |
| public | l_tx | 151983 | 10836 | 0.00 | 6.00 | | 2025-12-24 08:33:43.736178+00 | | 2025-12-24 08:33:44.211716+00 |
| public | l_user | 71075 | 594 | 0.00 | 0.00 | | 2025-12-22 05:12:28.71764+00 | | 2025-12-16 03:28:45.703323+00 |
| public | l_zone | 10987 | 187 | 0.00 | 1.00 | | 2025-12-22 11:11:16.201429+00 | | 2025-12-23 15:28:06.456745+00 |
| public | l_zone_category | 7534 | 234 | 0.00 | 3.00 | | 2025-12-22 23:50:38.17788+00 | | 2025-12-07 11:39:14.825058+00 |
| public | m_area | 828 | 20 | 0.00 | 2.00 | | 2025-12-22 23:50:46.630163+00 | | 2025-12-23 06:56:20.406211+00 |
| public | m_auth | 151 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:45.806541+00 | | |
| public | m_category | 2473 | 47 | 0.00 | 1.00 | | 2025-12-22 23:50:46.555997+00 | | 2025-12-25 00:41:02.500661+00 |
| public | m_env | 6 | 0 | 0.00 | 0.00 | | 2025-12-25 09:34:03.544213+00 | | |
| public | m_exb | 28440 | 686 | 0.00 | 2.00 | | 2025-12-22 05:11:02.784015+00 | | 2025-12-20 04:19:34.600295+00 |
| public | m_favorite | 228448 | 861 | 0.00 | 0.00 | | 2025-12-22 23:50:45.751048+00 | | 2025-12-03 07:18:48.83535+00 |
| public | m_favorite_group | 120174 | 390 | 0.00 | 0.00 | | 2025-12-22 03:59:13.498089+00 | | 2025-12-03 07:18:48.571033+00 |
| public | m_feature | 171 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:46.05144+00 | | |
| public | m_group | 28148 | 2523 | 0.00 | 8.00 | | 2025-12-22 05:11:12.787054+00 | | 2025-12-25 08:01:56.303874+00 |
| public | m_holiday | 40288 | 333 | 0.00 | 0.00 | | 2025-12-22 05:12:29.734491+00 | | |
| public | m_lob | 21575 | 507 | 0.00 | 2.00 | | 2025-12-22 05:11:13.043485+00 | | 2025-12-25 08:39:25.559447+00 |
| public | m_lob_log | 6336 | 58 | 0.00 | 0.00 | | 2025-12-22 05:12:28.742162+00 | | 2025-12-02 20:01:23.488624+00 |
| public | m_location | 55585 | 487 | 0.00 | 0.00 | | 2025-12-22 23:50:47.749562+00 | | 2025-12-18 08:29:02.019161+00 |
| public | m_notify_template | 1201 | 7 | 0.00 | 0.00 | | 2025-12-22 23:50:46.034641+00 | | |
| public | m_outside | 366 | 3 | 0.00 | 0.00 | | 2025-12-22 05:11:02.319371+00 | | |
| public | m_personal_setting | 129131 | 17759 | 0.00 | 12.00 | | 2025-12-25 22:43:10.350227+00 | | 2025-12-25 23:53:08.481629+00 |
| public | m_pot | 219626 | 18619 | 0.00 | 7.00 | | 2025-12-22 05:11:12.364914+00 | | 2025-12-25 00:20:23.261706+00 |
| public | m_pot_profile | 59881 | 20 | 0.00 | 0.00 | | 2025-12-22 05:11:00.186463+00 | | |
| public | m_provider_user | 86 | 2 | 0.00 | 2.00 | | 2025-12-22 23:51:27.030427+00 | | 2025-12-18 00:08:24.475654+00 |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:46.446066+00 | | |
| public | m_role | 786 | 4 | 0.00 | 0.00 | | 2025-12-22 23:50:46.417554+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:45.98834+00 | | |
| public | m_setting | 26907 | 648 | 0.00 | 2.00 | | 2025-12-25 23:54:33.802352+00 | | 2025-12-25 08:22:12.421387+00 |
| public | m_setting_log | 38372 | 0 | 0.00 | 0.00 | | 2025-12-26 00:07:12.431764+00 | | 2025-12-25 12:32:14.279309+00 |
| public | m_site | 188 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:45.786507+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:47.885822+00 | | |
| public | m_tx | 206615 | 4123 | 0.00 | 1.00 | | 2025-12-25 23:43:18.991944+00 | | 2025-12-25 08:21:58.295194+00 |
| public | m_user | 36767 | 240 | 0.00 | 0.00 | | 2025-12-22 05:12:29.505023+00 | | 2025-12-19 02:15:45.454939+00 |
| public | m_zone | 8121 | 631 | 0.00 | 7.00 | | 2025-12-22 23:53:22.106791+00 | | 2025-12-23 15:35:36.400102+00 |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-12-22 23:49:46.49212+00 | | |
| public | r_auth_zone | 175 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:45.826116+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:46.077384+00 | | |
| public | r_group_auth | 235 | 0 | 0.00 | 0.00 | | 2025-12-22 11:12:33.113925+00 | | 2025-12-17 07:59:30.462475+00 |
| public | r_location_zone | 56245 | 928 | 0.00 | 1.00 | | 2025-12-22 23:50:46.37085+00 | | 2025-12-18 08:29:01.397946+00 |
| public | r_pot_auth | 8461 | 19 | 0.00 | 0.00 | | 2025-12-22 04:37:49.331791+00 | | 2025-11-28 05:28:47.020235+00 |
| public | r_pot_category | 11416 | 1246 | 0.00 | 9.00 | | 2025-12-25 14:40:44.243998+00 | | 2025-12-25 14:40:44.268544+00 |
| public | r_pot_group | 370486 | 48 | 0.00 | 0.00 | | 2025-12-25 09:34:02.715276+00 | | |
| public | r_pot_plan_permission_group | 32 | 0 | 0.00 | 0.00 | | 2025-12-22 23:51:27.089247+00 | | |
| public | r_pot_tx | 71895 | 4233 | 0.00 | 5.00 | | 2025-12-22 05:11:13.488213+00 | | 2025-12-25 14:40:44.105608+00 |
| public | r_pot_user | 20416 | 37 | 0.00 | 0.00 | | 2025-12-22 05:11:02.457607+00 | | 2025-12-03 02:39:54.914143+00 |
| public | r_provider_tenant | 904 | 11 | 0.00 | 1.00 | | 2025-12-25 03:15:06.24848+00 | | 2025-12-25 00:41:03.61234+00 |
| public | r_role_feature | 6780 | 47 | 0.00 | 0.00 | | 2025-12-22 05:11:13.522718+00 | | 2025-12-25 07:00:30.25688+00 |
| public | r_tenant_feature | 4468 | 55 | 0.00 | 1.00 | | 2025-12-25 03:42:09.008157+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-12-22 03:59:13.523165+00 | | |
| public | r_user_region | 21324 | 35 | 0.00 | 0.00 | | 2025-12-22 05:11:00.330998+00 | | 2025-12-03 08:08:50.88222+00 |
| public | r_user_site | 4470 | 2 | 0.00 | 0.00 | | 2025-12-22 23:50:45.963774+00 | | 2025-11-17 06:49:36.429664+00 |
| public | r_zone_category | 5702 | 104 | 0.00 | 1.00 | | 2025-12-22 05:11:12.839746+00 | | 2025-12-07 11:39:14.852119+00 |
| public | t_ai_history | 36 | 0 | 0.00 | 0.00 | | 2025-12-25 17:01:14.505888+00 | | |
| public | t_attendance | 3887394 | 17292 | 0.00 | 0.00 | | 2025-12-25 03:43:20.052193+00 | | 2025-12-22 01:20:35.668265+00 |
| public | t_general | 3924 | 0 | 0.00 | 0.00 | | 2025-12-25 09:34:02.901533+00 | | 2025-12-16 06:44:51.949697+00 |
| public | t_general_20250618 | 2477 | 0 | 0.00 | 0.00 | | 2025-12-22 05:12:29.759022+00 | | |
| public | t_job | 64 | 5 | 0.00 | 7.00 | | 2025-12-22 05:12:28.827992+00 | | |
| public | t_mobile_device_history | 1432404 | 65 | 0.00 | 0.00 | | 2025-12-22 23:50:44.388139+00 | | |
| public | t_mobile_status_history | 2653876 | 0 | 0.00 | 0.00 | | 2025-12-22 05:12:31.028401+00 | | 2025-12-08 03:15:06.269743+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-12-22 23:50:46.104968+00 | | |
| public | t_notify_history | 7450424 | 24162 | 0.00 | 0.00 | | 2025-12-22 23:51:26.657931+00 | | 2025-12-19 00:13:39.432828+00 |
| public | t_operation_log | 27501641 | 6724 | 0.00 | 0.00 | | 2025-12-22 05:12:06.305818+00 | | 2025-12-10 01:39:15.085282+00 |
| public | t_plan | 27938548 | 923124 | 0.00 | 3.00 | | 2025-12-25 06:56:45.847848+00 | | 2025-12-25 06:56:48.353291+00 |
| public | t_plan_cancel_history | 830425 | 78352 | 0.00 | 8.00 | | 2025-12-22 05:12:27.361679+00 | | 2025-11-17 06:40:32.133611+00 |
| public | t_plan_detail | 52413586 | 8241119 | 0.00 | 13.00 | | 2025-12-25 01:58:29.588769+00 | | 2025-12-25 05:59:34.131709+00 |
| public | t_plan_permission | 117 | 0 | 0.00 | 0.00 | | 2025-12-22 23:51:27.068651+00 | | |
| public | t_plan_permission_group | 5 | 0 | 0.00 | 0.00 | | 2025-12-22 23:51:27.049823+00 | | |
| public | t_plan_sync | 131454 | 44577 | 0.00 | 25.00 | | 2025-12-26 00:24:49.950987+00 | | 2025-12-25 23:53:07.639232+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-12-22 23:51:26.681661+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-12-22 23:49:48.199949+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-12-22 23:50:46.575387+00 | | |
| public | t_recv_position_history | 151399 | 6136213 | 40.00 | 97.00 | | 2025-12-26 00:24:47.607086+00 | 2025-12-25 13:30:08.36813+00 | 2025-12-26 00:24:48.170065+00 |
| public | t_safr_event_history | 0 | 0 | 0 | 0 | | 2025-12-25 09:42:32.181623+00 | | |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-12-22 23:49:48.261041+00 | | |
| public | t_terminal | 65697 | 24210 | 0.00 | 26.00 | | 2025-12-26 00:24:50.111491+00 | | 2025-12-25 23:13:47.284508+00 |
| public | t_terminal_log | 36195185 | 0 | 0.00 | 0.00 | | 2025-12-22 05:31:13.262507+00 | | 2025-12-17 07:47:52.832407+00 |
| public | temp_pivot_table | 238693 | 0 | 0.00 | 0.00 | | 2025-12-22 05:40:29.352746+00 | | |
| public | w_arrival_notify | 103 | 37 | 0.00 | 26.00 | | 2025-12-22 23:51:26.982811+00 | | 2025-12-23 22:57:22.60391+00 |
| public | w_latest_mobile_device | 58142 | 977 | 0.00 | 1.00 | | 2025-12-22 01:17:40.409947+00 | | 2025-12-25 01:59:49.022979+00 |
| public | w_latest_mobile_status | 57149 | 8898 | 0.00 | 13.00 | | 2025-12-25 22:50:41.86489+00 | | 2025-12-25 23:46:12.234234+00 |
| public | w_latest_position | 87842 | 3409658 | 38.00 | 97.00 | | 2025-12-26 00:24:49.347099+00 | | 2025-12-26 00:24:49.831133+00 |
| public | w_latest_presence | 132931 | 48466947 | 364.00 | 99.00 | | 2025-12-26 00:27:49.109014+00 | | 2025-12-26 00:27:51.910369+00 |
| public | w_latest_sensor | 386 | 73815 | 191.00 | 99.00 | | 2025-12-26 00:24:50.168678+00 | | 2025-12-26 00:24:50.287982+00 |
| public | w_lock | 20339 | 4 | 0.00 | 0.00 | | 2025-12-22 03:57:58.900119+00 | | |
| public | w_master_update | 195 | 86 | 0.00 | 30.00 | | 2025-12-26 00:07:17.155013+00 | | 2025-12-26 00:05:50.297665+00 |
| public | w_migration | 650 | 0 | 0.00 | 0.00 | | 2025-12-22 23:51:27.013189+00 | | |
| public | w_plan_sync_retry | 1 | 18 | 18.00 | 94.00 | | 2025-12-26 00:24:49.962325+00 | | 2025-12-25 23:08:33.946936+00 |
| public | w_plan_with_detail | 27941672 | 794711 | 0.00 | 2.00 | | 2025-12-25 07:52:27.806639+00 | | 2025-12-25 07:52:30.752924+00 |