| 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 | 582013268 | 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 | 11764805 | 0 | 0.00 | 0.00 | | 2025-09-16 15:09:07.788408+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 16421721 | 4895 | 0.00 | 0.00 | | 2025-09-12 20:16:15.592851+00 | | 2025-09-16 16:55:58.828877+00 |
| e202509 | a_stay_time | 21592956 | 116528 | 0.00 | 0.00 | | 2025-09-14 15:57:42.757021+00 | | 2025-09-16 17:19:06.604203+00 |
| e202509 | t_position_history | 331193332 | 107253 | 0.00 | 0.00 | | 2025-09-15 22:16:00.959212+00 | | 2025-09-16 08:26:36.759505+00 |
| e202509 | t_presence_history | 31450684 | 5455688 | 0.00 | 14.00 | | 2025-09-17 00:23:29.134902+00 | | 2025-09-17 00:49:58.667493+00 |
| e202509 | t_sensor_history | 6359786 | 0 | 0.00 | 0.00 | | 2025-09-15 16:07:08.028629+00 | | 2025-09-16 21:18:12.318305+00 |
| public | __digdag_status | 33 | 20 | 0.00 | 37.00 | | 2025-09-12 11:29:06.051712+00 | | 2025-09-15 12:30:25.294298+00 |
| public | a_attendance_sum | 154796 | 25872 | 0.00 | 14.00 | | 2025-09-11 00:29:10.495545+00 | | 2025-09-17 00:28:56.259105+00 |
| public | a_plan_actual | 1091293 | 0 | 0.00 | 0.00 | | 2025-09-16 12:00:00.062999+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 | 36818 | 11 | 0.00 | 0.00 | | 2025-09-14 18:01:08.154725+00 | | |
| public | l_lob | 1982 | 7 | 0.00 | 0.00 | | 2025-09-12 08:48:03.04958+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 116251 | 1774 | 0.00 | 1.00 | | 2025-09-14 18:01:04.545057+00 | | 2025-09-15 08:51:20.047628+00 |
| public | l_location_zone | 104713 | 97 | 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 | 441319 | 1775 | 0.00 | 0.00 | | 2025-09-14 18:01:12.994029+00 | | |
| public | l_pot_category | 13775 | 31 | 0.00 | 0.00 | | 2025-09-14 18:01:04.736916+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 233574 | 203 | 0.00 | 0.00 | | 2025-09-14 18:01:07.872824+00 | | |
| public | l_pot_tx | 102198 | 176 | 0.00 | 0.00 | | 2025-09-14 18:01:06.152168+00 | | |
| public | l_role | 774 | 1 | 0.00 | 0.00 | | 2025-09-14 18:01:00.747667+00 | | |
| public | l_role_feature | 6849 | 11 | 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 | 142728 | 27767 | 0.00 | 16.00 | | 2025-09-15 12:01:39.355259+00 | | 2025-09-16 11:45:17.949454+00 |
| public | l_user | 63531 | 287 | 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 | 1 | 0.00 | 0.00 | | 2025-09-16 22:56:19.695053+00 | | |
| public | m_auth | 147 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.581477+00 | | |
| public | m_category | 2439 | 0 | 0.00 | 0.00 | | 2025-09-16 22:56:19.665124+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-09-10 23:41:44.944613+00 | | |
| public | m_exb | 27372 | 395 | 0.00 | 1.00 | | 2025-09-15 14:35:48.652878+00 | | |
| public | m_favorite | 228641 | 77 | 0.00 | 0.00 | | 2025-09-16 08:35:56.155808+00 | | |
| public | m_favorite_group | 116030 | 104 | 0.00 | 0.00 | | 2025-09-11 08:56:28.520287+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-09-16 02:08:26.838674+00 | | |
| public | m_group | 28116 | 1895 | 0.00 | 6.00 | | 2025-09-11 07:02:06.028712+00 | | 2025-09-16 14:41:08.163611+00 |
| public | m_holiday | 43925 | 0 | 0.00 | 0.00 | | 2025-09-13 02:59:51.511446+00 | | |
| public | m_lob | 24591 | 20 | 0.00 | 0.00 | | 2025-09-13 16:18:47.350201+00 | | |
| public | m_lob_log | 2040 | 0 | 0.00 | 0.00 | | 2025-09-12 10:10:17.537653+00 | | |
| public | m_location | 45227 | 2 | 0.00 | 0.00 | | 2025-09-16 16:02:10.698532+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 | 134313 | 16495 | 0.00 | 10.00 | | 2025-09-11 16:54:41.218537+00 | | 2025-09-17 00:37:56.305178+00 |
| public | m_pot | 206653 | 6417 | 0.00 | 3.00 | | 2025-09-16 04:23:05.942626+00 | | 2025-09-16 03:04:43.532521+00 |
| public | m_pot_profile | 52328 | 34 | 0.00 | 0.00 | | 2025-09-14 08:52:51.508104+00 | | |
| public | m_provider_user | 85 | 1 | 0.00 | 1.00 | | 2025-09-16 02:46:07.438171+00 | | |
| public | m_region | 114 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.796115+00 | | |
| public | m_role | 777 | 1 | 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 | 26668 | 1409 | 0.00 | 5.00 | | 2025-09-16 04:52:54.438236+00 | | 2025-09-15 13:25:28.436633+00 |
| public | m_setting_log | 36906 | 0 | 0.00 | 0.00 | | 2025-09-12 17:50:39.618081+00 | | 2025-09-16 19:07:05.909455+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 | 122378 | 11479 | 0.00 | 8.00 | | 2025-09-16 09:50:20.385374+00 | | 2025-09-16 11:44:59.493938+00 |
| public | m_user | 36028 | 180 | 0.00 | 0.00 | | 2025-09-11 21:22:33.973185+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 9071 | 0 | 0.00 | 0.00 | | 2025-09-16 05:31:15.783434+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:51.859919+00 | | |
| public | r_auth_zone | 219 | 0 | 0.00 | 0.00 | | 2025-09-16 09:13:07.958403+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 | 54525 | 5 | 0.00 | 0.00 | | 2025-09-16 22:56:19.520024+00 | | 2025-09-16 22:57:19.988245+00 |
| public | r_pot_auth | 8459 | 1 | 0.00 | 0.00 | | 2025-09-12 12:33:27.588642+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 11750 | 40 | 0.00 | 0.00 | | 2025-09-12 08:50:22.917125+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 446195 | 3733 | 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-16 05:42:13.022442+00 | | |
| public | r_pot_tx | 70259 | 183 | 0.00 | 0.00 | | 2025-09-12 23:48:09.00391+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 20347 | 11 | 0.00 | 0.00 | | 2025-09-13 20:17:47.366153+00 | | |
| public | r_provider_tenant | 945 | 1 | 0.00 | 0.00 | | 2025-09-13 21:02:39.998046+00 | | 2025-09-11 06:34:01.277345+00 |
| public | r_role_feature | 6208 | 11 | 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 | 21365 | 10 | 0.00 | 0.00 | | 2025-09-13 20:17:38.700189+00 | | |
| public | r_user_site | 6321 | 3 | 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 | 3325942 | 39278 | 0.00 | 1.00 | | 2025-09-10 07:13:01.458336+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4236 | 3 | 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 | 878437 | 0 | 0.00 | 0.00 | | 2025-09-16 03:31:03.362396+00 | | |
| public | t_mobile_status_history | 2053316 | 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 | 6566521 | 3580 | 0.00 | 0.00 | | 2025-09-16 03:59:29.559742+00 | | |
| public | t_operation_log | 22325967 | 2240 | 0.00 | 0.00 | | 2025-09-12 11:29:05.960592+00 | | |
| public | t_plan | 28352747 | 1066347 | 0.00 | 3.00 | | 2025-09-11 06:00:24.240629+00 | | 2025-09-16 02:49:42.597842+00 |
| public | t_plan_cancel_history | 685982 | 27969 | 0.00 | 3.00 | | 2025-09-14 04:25:31.094644+00 | | |
| public | t_plan_detail | 48585489 | 985015 | 0.00 | 1.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-16 05:42:13.003572+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-09-16 05:42:12.979224+00 | | |
| public | t_plan_sync | 67712 | 6573 | 0.00 | 8.00 | | 2025-09-17 00:23:57.855138+00 | | 2025-09-17 00:34:56.792811+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 | 153067 | 25993 | 0.00 | 14.00 | | 2025-09-17 00:51:59.575587+00 | 2025-09-16 13:30:06.142063+00 | 2025-09-17 00:52:55.988938+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:52.017065+00 | | |
| public | t_terminal | 21685 | 3408 | 0.00 | 13.00 | | 2025-09-16 19:00:21.384391+00 | | 2025-09-17 00:24:00.186273+00 |
| public | t_terminal_log | 29408558 | 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 | 102 | 16 | 0.00 | 13.00 | | 2025-09-14 12:00:27.851502+00 | | 2025-09-16 04:53:53.634996+00 |
| public | w_latest_mobile_device | 57385 | 751 | 0.00 | 1.00 | | 2025-09-11 03:56:06.602002+00 | | 2025-09-11 15:00:47.019752+00 |
| public | w_latest_mobile_status | 56354 | 10859 | 0.00 | 16.00 | | 2025-09-16 07:01:53.977629+00 | | 2025-09-17 00:41:56.879927+00 |
| public | w_latest_position | 79496 | 17929 | 0.00 | 18.00 | | 2025-09-17 00:52:56.1625+00 | | 2025-09-17 00:52:56.330508+00 |
| public | w_latest_presence | 233385 | 76719 | 0.00 | 24.00 | | 2025-09-17 00:53:15.065387+00 | | 2025-09-17 00:53:17.545888+00 |
| public | w_latest_sensor | 386 | 74 | 0.00 | 16.00 | | 2025-09-17 00:52:56.348438+00 | | 2025-09-17 00:52:57.388521+00 |
| public | w_lock | 18749 | 0 | 0.00 | 0.00 | | 2025-09-11 08:03:53.338144+00 | | |
| public | w_master_update | 198 | 28 | 0.00 | 12.00 | | 2025-09-17 00:32:55.674524+00 | | 2025-09-16 23:51:06.8938+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-16 00:38:04.851343+00 | | |
| public | w_plan_sync_retry | 0 | 46 | 0 | 100.00 | | 2025-09-16 22:47:19.26686+00 | | 2025-09-16 22:47:19.267174+00 |
| public | w_plan_with_detail | 28337614 | 445304 | 0.00 | 1.00 | | 2025-09-16 02:46:04.634025+00 | | 2025-09-16 02:52:40.968298+00 |