| 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 |
|---|
| e202507 | a_proximity_sum | 57060981 | 0 | 0.00 | 0.00 | | 2025-09-12 12:33:28.060053+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-09-14 12:00:28.030645+00 | | |
| e202507 | t_position_history | 611252345 | 0 | 0.00 | 0.00 | | 2025-09-15 03:01:41.107406+00 | | |
| e202507 | t_presence_history | 55790617 | 0 | 0.00 | 0.00 | | 2025-09-14 21:41:49.470296+00 | | |
| e202507 | t_sensor_history | 11690414 | 0 | 0.00 | 0.00 | | 2025-09-15 18:33:13.354606+00 | | |
| e202508 | a_proximity_sum | 32424252 | 0 | 0.00 | 0.00 | | 2025-09-12 19:53:27.618241+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36269806 | 0 | 0.00 | 0.00 | | 2025-09-13 21:22:57.060813+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582013266 | 0 | 0.00 | 0.00 | | 2025-09-10 13:06:19.428649+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 54679113 | 0 | 0.00 | 0.00 | | 2025-09-13 00:02:28.222778+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11764816 | 0 | 0.00 | 0.00 | | 2025-09-10 02:30:39.823558+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 14893260 | 0 | 0.00 | 0.00 | | 2025-09-12 20:16:15.592851+00 | | 2025-09-12 17:32:15.149704+00 |
| e202509 | a_stay_time | 19746848 | 0 | 0.00 | 0.00 | | 2025-09-14 15:57:42.757021+00 | | 2025-09-12 17:30:14.393951+00 |
| e202509 | t_position_history | 304521279 | 0 | 0.00 | 0.00 | | 2025-09-15 22:16:00.959212+00 | | 2025-09-14 16:40:14.303343+00 |
| e202509 | t_presence_history | 29112784 | 6002210 | 0.00 | 17.00 | | 2025-09-16 00:11:43.28169+00 | | 2025-09-16 00:41:12.190698+00 |
| e202509 | t_sensor_history | 5910149 | 0 | 0.00 | 0.00 | | 2025-09-15 16:07:08.028629+00 | | 2025-09-15 09:33:34.873959+00 |
| public | __digdag_status | 32 | 17 | 0.00 | 34.00 | | 2025-09-12 11:29:06.051712+00 | | 2025-09-15 12:30:25.294298+00 |
| public | a_attendance_sum | 154223 | 18081 | 0.00 | 10.00 | | 2025-09-11 00:29:10.495545+00 | | 2025-09-16 00:29:05.400805+00 |
| public | a_plan_actual | 1087125 | 0 | 0.00 | 0.00 | | 2025-09-10 01:32:05.009404+00 | | 2025-09-02 17:17:15.571058+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:55.307725+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:53.140842+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:51.884505+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-09-10 17:01:25.990262+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-09-10 07:13:21.041857+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-09-10 07:57:48.16125+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.541941+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-09-10 07:57:48.182503+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-09-10 07:57:48.203228+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.563296+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.518058+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-09-10 07:57:45.411599+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.586916+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-09-10 07:12:12.607437+00 | | |
| public | l_area | 1563 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:03.184243+00 | | |
| public | l_auth | 182 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:03.053305+00 | | |
| public | l_category | 2702 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:04.805505+00 | | |
| public | l_group | 36815 | 2 | 0.00 | 0.00 | | 2025-09-14 18:01:08.154725+00 | | |
| public | l_lob | 1978 | 5 | 0.00 | 0.00 | | 2025-09-12 08:48:03.04958+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 116176 | 1710 | 0.00 | 1.00 | | 2025-09-14 18:01:04.545057+00 | | 2025-09-15 08:51:20.047628+00 |
| public | l_location_zone | 104691 | 81 | 0.00 | 0.00 | | 2025-09-14 18:01:03.739247+00 | | 2025-09-12 06:37:57.741842+00 |
| public | l_outside | 454 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:03.085137+00 | | |
| public | l_pot | 439675 | 105 | 0.00 | 0.00 | | 2025-09-14 18:01:12.994029+00 | | |
| public | l_pot_category | 13752 | 2 | 0.00 | 0.00 | | 2025-09-14 18:01:04.736916+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 233510 | 77 | 0.00 | 0.00 | | 2025-09-14 18:01:07.872824+00 | | |
| public | l_pot_tx | 101992 | 6 | 0.00 | 0.00 | | 2025-09-14 18:01:06.152168+00 | | |
| public | l_role | 774 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:00.747667+00 | | |
| public | l_role_feature | 6846 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:00.714019+00 | | |
| public | l_site | 258 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:03.226841+00 | | |
| public | l_tx | 142496 | 20339 | 0.00 | 12.00 | | 2025-09-15 12:01:39.355259+00 | | 2025-09-15 15:29:02.339975+00 |
| public | l_user | 63420 | 107 | 0.00 | 0.00 | | 2025-09-14 18:01:00.554166+00 | | 2025-09-05 09:09:18.220322+00 |
| public | l_zone | 9792 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:03.85163+00 | | |
| public | l_zone_category | 4857 | 0 | 0.00 | 0.00 | | 2025-09-14 18:00:58.289129+00 | | |
| public | m_area | 788 | 8 | 0.00 | 1.00 | | 2025-09-10 04:39:39.05262+00 | | |
| public | m_auth | 147 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.581477+00 | | |
| public | m_category | 2439 | 2 | 0.00 | 0.00 | | 2025-09-10 04:39:38.769675+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-09-10 23:41:44.944613+00 | | |
| public | m_exb | 27372 | 110 | 0.00 | 0.00 | | 2025-09-15 14:35:48.652878+00 | | |
| public | m_favorite | 217849 | 1106 | 0.00 | 0.00 | | 2025-09-09 23:11:44.683475+00 | | |
| public | m_favorite_group | 115821 | 65 | 0.00 | 0.00 | | 2025-09-11 08:56:28.520287+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-09-09 07:28:27.512178+00 | | |
| public | m_group | 28113 | 1626 | 0.00 | 5.00 | | 2025-09-11 07:02:06.028712+00 | | 2025-09-14 14:40:42.092708+00 |
| public | m_holiday | 43925 | 0 | 0.00 | 0.00 | | 2025-09-13 02:59:51.511446+00 | | |
| public | m_lob | 24585 | 3 | 0.00 | 0.00 | | 2025-09-13 16:18:47.350201+00 | | |
| public | m_lob_log | 2033 | 0 | 0.00 | 0.00 | | 2025-09-12 10:10:17.537653+00 | | |
| public | m_location | 45211 | 3171 | 0.00 | 6.00 | | 2025-09-10 02:43:18.821835+00 | | 2025-09-12 06:37:54.912894+00 |
| public | m_notify_template | 1234 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.691096+00 | | |
| public | m_outside | 377 | 0 | 0.00 | 0.00 | | 2025-09-12 03:54:01.271457+00 | | |
| public | m_personal_setting | 134123 | 16014 | 0.00 | 10.00 | | 2025-09-11 16:54:41.218537+00 | | 2025-09-16 00:30:06.070554+00 |
| public | m_pot | 206570 | 17618 | 0.00 | 7.00 | | 2025-09-09 09:41:04.228012+00 | | 2025-09-16 00:44:10.504856+00 |
| public | m_pot_profile | 52287 | 17 | 0.00 | 0.00 | | 2025-09-14 08:52:51.508104+00 | | |
| public | m_provider_user | 85 | 2 | 0.00 | 2.00 | | 2025-09-09 08:13:19.655811+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.796115+00 | | |
| public | m_role | 777 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.770199+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.638045+00 | | |
| public | m_setting | 16163 | 2943 | 0.00 | 15.00 | | 2025-09-14 02:34:54.22905+00 | | 2025-09-15 13:25:28.436633+00 |
| public | m_setting_log | 36664 | 3010 | 0.00 | 7.00 | | 2025-09-12 17:50:39.618081+00 | | 2025-09-15 12:30:25.551123+00 |
| public | m_site | 189 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.332495+00 | | |
| public | m_tenant | 113 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.833856+00 | | |
| public | m_tx | 180207 | 21418 | 0.00 | 10.00 | | 2025-09-15 16:48:59.674987+00 | | 2025-09-15 16:40:58.879882+00 |
| public | m_user | 36010 | 102 | 0.00 | 0.00 | | 2025-09-11 21:22:33.973185+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 8653 | 18 | 0.00 | 0.00 | | 2025-09-09 11:46:07.611479+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:51.859919+00 | | |
| public | r_auth_zone | 219 | 1 | 0.00 | 0.00 | | 2025-09-09 23:57:02.714158+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.721872+00 | | |
| public | r_group_auth | 575 | 23 | 0.00 | 3.00 | | 2025-09-10 18:34:14.789049+00 | | |
| public | r_location_zone | 55837 | 1644 | 0.00 | 2.00 | | 2025-09-10 04:39:38.747801+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8442 | 0 | 0.00 | 0.00 | | 2025-09-12 12:33:27.588642+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 11756 | 11 | 0.00 | 0.00 | | 2025-09-12 08:50:22.917125+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 446257 | 3607 | 0.00 | 0.00 | | 2025-09-10 23:41:44.920669+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-09-09 12:18:07.687294+00 | | |
| public | r_pot_tx | 70223 | 13 | 0.00 | 0.00 | | 2025-09-12 23:48:09.00391+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 20340 | 0 | 0.00 | 0.00 | | 2025-09-13 20:17:47.366153+00 | | |
| public | r_provider_tenant | 944 | 0 | 0.00 | 0.00 | | 2025-09-13 21:02:39.998046+00 | | 2025-09-11 06:34:01.277345+00 |
| public | r_role_feature | 6216 | 0 | 0.00 | 0.00 | | 2025-09-11 09:23:39.314364+00 | | |
| public | r_tenant_feature | 4581 | 0 | 0.00 | 0.00 | | 2025-09-10 07:12:11.364705+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-11 07:02:06.057022+00 | | |
| public | r_user_region | 21357 | 0 | 0.00 | 0.00 | | 2025-09-13 20:17:38.700189+00 | | |
| public | r_user_site | 6321 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.614724+00 | | |
| public | r_zone_category | 4953 | 0 | 0.00 | 0.00 | | 2025-09-12 10:10:17.518261+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-11 02:30:55.921065+00 | | |
| public | t_attendance | 3314363 | 27358 | 0.00 | 0.00 | | 2025-09-10 07:13:01.458336+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4232 | 2 | 0.00 | 0.00 | | 2025-09-10 17:01:25.873137+00 | | |
| public | t_general_20250618 | 3254 | 0 | 0.00 | 0.00 | | 2025-09-12 03:36:03.482828+00 | | |
| public | t_job | 32 | 0 | 0.00 | 0.00 | | 2025-09-12 08:48:03.070891+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 897607 | 0 | 0.00 | 0.00 | | 2025-09-09 08:47:30.700406+00 | | |
| public | t_mobile_status_history | 2039149 | 0 | 0.00 | 0.00 | | 2025-09-13 13:29:30.597174+00 | | 2025-09-04 10:03:21.422779+00 |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.746081+00 | | |
| public | t_notify_history | 6575436 | 15572 | 0.00 | 0.00 | | 2025-09-09 09:04:46.711356+00 | | |
| public | t_operation_log | 22267070 | 20 | 0.00 | 0.00 | | 2025-09-12 11:29:05.960592+00 | | |
| public | t_plan | 27824629 | 775135 | 0.00 | 2.00 | | 2025-09-11 06:00:24.240629+00 | | 2025-09-10 18:51:26.090908+00 |
| public | t_plan_cancel_history | 683372 | 2611 | 0.00 | 0.00 | | 2025-09-14 04:25:31.094644+00 | | |
| public | t_plan_detail | 48459200 | 387890 | 0.00 | 0.00 | | 2025-09-13 13:07:16.251535+00 | | 2025-09-14 20:29:48.981187+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-09-09 12:18:07.668991+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-09-09 12:18:07.644138+00 | | |
| public | t_plan_sync | 67694 | 9213 | 0.00 | 11.00 | | 2025-09-16 00:19:05.623283+00 | | 2025-09-16 00:35:05.89972+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.863358+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:51.950819+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:55.817661+00 | | |
| public | t_recv_position_history | 154098 | 39830 | 0.00 | 20.00 | | 2025-09-16 00:49:05.275632+00 | 2025-09-15 13:30:05.702845+00 | 2025-09-16 00:50:04.861817+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:52.017065+00 | | |
| public | t_terminal | 21679 | 2669 | 0.00 | 10.00 | | 2025-09-15 19:38:37.947485+00 | | 2025-09-16 00:24:12.131394+00 |
| public | t_terminal_log | 29305520 | 0 | 0.00 | 0.00 | | 2025-09-12 07:41:38.917148+00 | | |
| public | temp_pivot_table | 239971 | 0 | 0.00 | 0.00 | | 2025-09-14 08:52:51.681509+00 | | |
| public | w_arrival_notify | 101 | 0 | 0.00 | 0.00 | | 2025-09-14 12:00:27.851502+00 | | 2025-09-10 04:43:38.989167+00 |
| public | w_latest_mobile_device | 57315 | 473 | 0.00 | 0.00 | | 2025-09-11 03:56:06.602002+00 | | 2025-09-11 15:00:47.019752+00 |
| public | w_latest_mobile_status | 56282 | 5578 | 0.00 | 9.00 | | 2025-09-15 23:50:30.338135+00 | | 2025-09-16 00:39:10.15477+00 |
| public | w_latest_position | 79496 | 28773 | 0.00 | 26.00 | | 2025-09-16 00:50:05.020456+00 | | 2025-09-16 00:50:05.181605+00 |
| public | w_latest_presence | 216627 | 377765 | 1.00 | 63.00 | | 2025-09-16 00:49:21.769509+00 | | 2025-09-16 00:49:23.839324+00 |
| public | w_latest_sensor | 386 | 454 | 1.00 | 54.00 | | 2025-09-16 00:49:06.351307+00 | | 2025-09-16 00:49:06.464638+00 |
| public | w_lock | 18730 | 0 | 0.00 | 0.00 | | 2025-09-11 08:03:53.338144+00 | | |
| public | w_master_update | 113 | 73 | 0.00 | 39.00 | | 2025-09-16 00:05:29.888126+00 | | 2025-09-16 00:23:04.491928+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-16 00:38:04.851343+00 | | |
| public | w_plan_sync_retry | 1 | 40 | 40.00 | 97.00 | | 2025-09-15 05:51:00.316854+00 | | 2025-09-15 07:18:04.701794+00 |
| public | w_plan_with_detail | 28280060 | 1397293 | 0.00 | 4.00 | | 2025-09-09 08:12:54.593391+00 | | 2025-09-10 15:01:28.601384+00 |