| 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 | 57060921 | 0 | 0.00 | 0.00 | | 2025-09-19 04:29:34.655223+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-09-14 12:00:28.030645+00 | | |
| e202507 | t_position_history | 611252368 | 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 | 32424209 | 0 | 0.00 | 0.00 | | 2025-09-19 06:22:48.155661+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36269781 | 0 | 0.00 | 0.00 | | 2025-09-19 21:37:27.688888+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582013224 | 0 | 0.00 | 0.00 | | 2025-09-17 05:29:12.691343+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 54679077 | 0 | 0.00 | 0.00 | | 2025-09-19 07:26:52.267797+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 | 20560899 | 0 | 0.00 | 0.00 | | 2025-09-18 15:14:45.548841+00 | | 2025-09-18 18:02:43.5865+00 |
| e202509 | a_stay_time | 27269938 | 0 | 0.00 | 0.00 | | 2025-09-18 15:49:57.624016+00 | | 2025-09-19 15:11:21.832082+00 |
| e202509 | t_position_history | 403665726 | 12 | 0.00 | 0.00 | | 2025-09-18 04:53:40.862704+00 | | 2025-09-19 04:32:39.400873+00 |
| e202509 | t_presence_history | 38582594 | 2039871 | 0.00 | 5.00 | | 2025-09-20 00:29:13.973283+00 | | 2025-09-20 00:45:38.946559+00 |
| e202509 | t_sensor_history | 7460971 | 0 | 0.00 | 0.00 | | 2025-09-19 06:21:29.741811+00 | | 2025-09-18 12:28:05.913659+00 |
| public | __digdag_status | 32 | 5 | 0.00 | 13.00 | | 2025-09-19 04:09:07.601873+00 | | 2025-09-15 12:30:25.294298+00 |
| public | a_attendance_sum | 155984 | 16434 | 0.00 | 9.00 | | 2025-09-17 09:22:08.782112+00 | | 2025-09-19 10:25:06.836533+00 |
| public | a_plan_actual | 1132634 | 6 | 0.00 | 0.00 | | 2025-09-16 12:00:00.062999+00 | | 2025-09-19 16:41:52.537694+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-17 06:32:56.811408+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-09-17 01:55:15.252589+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-09-17 02:34:18.040026+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.929502+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-09-17 02:34:18.063243+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-09-17 02:34:18.086221+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.950797+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.907163+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-09-17 02:34:16.014379+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.973518+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-09-17 01:48:34.994521+00 | | |
| public | l_area | 1563 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:03.184243+00 | | |
| public | l_auth | 188 | 4 | 0.00 | 2.00 | | 2025-09-14 18:01:03.053305+00 | | |
| public | l_category | 2706 | 0 | 0.00 | 0.00 | | 2025-09-14 18:01:04.805505+00 | | |
| public | l_group | 37075 | 348 | 0.00 | 0.00 | | 2025-09-14 18:01:08.154725+00 | | |
| public | l_lob | 1991 | 2 | 0.00 | 0.00 | | 2025-09-19 02:27:53.252742+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 118200 | 3641 | 0.00 | 2.00 | | 2025-09-14 18:01:04.545057+00 | | 2025-09-15 08:51:20.047628+00 |
| public | l_location_zone | 106128 | 1063 | 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 | 450071 | 3534 | 0.00 | 0.00 | | 2025-09-14 18:01:12.994029+00 | | 2025-09-18 01:24:08.798879+00 |
| public | l_pot_category | 13820 | 72 | 0.00 | 0.00 | | 2025-09-14 18:01:04.736916+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 234940 | 6268 | 0.00 | 2.00 | | 2025-09-14 18:01:07.872824+00 | | 2025-09-18 10:25:36.303314+00 |
| public | l_pot_tx | 102598 | 388 | 0.00 | 0.00 | | 2025-09-14 18:01:06.152168+00 | | |
| public | l_role | 775 | 2 | 0.00 | 0.00 | | 2025-09-14 18:01:00.747667+00 | | |
| public | l_role_feature | 6868 | 12 | 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 | 148847 | 20340 | 0.00 | 12.00 | | 2025-09-17 07:48:45.72305+00 | | 2025-09-17 14:46:48.549495+00 |
| public | l_user | 63813 | 604 | 0.00 | 0.00 | | 2025-09-14 18:01:00.554166+00 | | 2025-09-05 09:09:18.220322+00 |
| public | l_zone | 9845 | 18 | 0.00 | 0.00 | | 2025-09-14 18:01:03.85163+00 | | |
| public | l_zone_category | 4893 | 1 | 0.00 | 0.00 | | 2025-09-14 18:00:58.289129+00 | | |
| public | m_area | 788 | 2 | 0.00 | 0.00 | | 2025-09-16 22:56:19.695053+00 | | |
| public | m_auth | 149 | 18 | 0.00 | 10.00 | | 2025-09-15 23:29:55.581477+00 | | |
| public | m_category | 2443 | 0 | 0.00 | 0.00 | | 2025-09-16 22:56:19.665124+00 | | |
| public | m_env | 2 | 0 | 0.00 | 0.00 | | 2025-09-17 08:29:53.291589+00 | | |
| public | m_exb | 27372 | 398 | 0.00 | 1.00 | | 2025-09-15 14:35:48.652878+00 | | |
| public | m_favorite | 229291 | 648 | 0.00 | 0.00 | | 2025-09-16 08:35:56.155808+00 | | |
| public | m_favorite_group | 116379 | 86 | 0.00 | 0.00 | | 2025-09-18 03:21:32.345781+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-09-16 02:08:26.838674+00 | | |
| public | m_group | 28130 | 1167 | 0.00 | 3.00 | | 2025-09-18 01:27:52.316022+00 | | 2025-09-18 14:41:04.696606+00 |
| public | m_holiday | 43842 | 0 | 0.00 | 0.00 | | 2025-09-19 08:19:25.61968+00 | | |
| public | m_lob | 24643 | 3 | 0.00 | 0.00 | | 2025-09-19 16:32:52.646057+00 | | |
| public | m_lob_log | 2058 | 0 | 0.00 | 0.00 | | 2025-09-19 03:25:03.9077+00 | | |
| public | m_location | 45312 | 1572 | 0.00 | 3.00 | | 2025-09-16 16:02:10.698532+00 | | 2025-09-19 06:15:04.836821+00 |
| public | m_notify_template | 1242 | 0 | 0.00 | 0.00 | | 2025-09-15 23:29:55.691096+00 | | |
| public | m_outside | 377 | 0 | 0.00 | 0.00 | | 2025-09-18 17:03:31.255435+00 | | |
| public | m_personal_setting | 134520 | 15674 | 0.00 | 10.00 | | 2025-09-18 06:22:00.834309+00 | | 2025-09-19 11:42:59.918975+00 |
| public | m_pot | 206915 | 18494 | 0.00 | 8.00 | | 2025-09-16 04:23:05.942626+00 | | 2025-09-18 00:28:51.468456+00 |
| public | m_pot_profile | 52454 | 122 | 0.00 | 0.00 | | 2025-09-14 08:52:51.508104+00 | | |
| public | m_provider_user | 85 | 2 | 0.00 | 2.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 | 778 | 2 | 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 | 16176 | 3208 | 0.00 | 16.00 | | 2025-09-18 02:39:01.636917+00 | | 2025-09-19 15:11:21.242071+00 |
| public | m_setting_log | 36840 | 1696 | 0.00 | 4.00 | | 2025-09-17 21:30:56.084132+00 | | 2025-09-19 01:55:53.787773+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 | 185587 | 4733 | 0.00 | 2.00 | | 2025-09-19 15:04:21.878056+00 | | 2025-09-19 14:36:19.539665+00 |
| public | m_user | 36696 | 84 | 0.00 | 0.00 | | 2025-09-18 07:26:13.415748+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 9108 | 31 | 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 | 229 | 4 | 0.00 | 1.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 | 0 | 0.00 | 0.00 | | 2025-09-17 06:39:51.266188+00 | | |
| public | r_location_zone | 54974 | 971 | 0.00 | 1.00 | | 2025-09-16 22:56:19.520024+00 | | 2025-09-16 22:57:19.988245+00 |
| public | r_pot_auth | 8226 | 0 | 0.00 | 0.00 | | 2025-09-19 04:29:33.991678+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 13569 | 13 | 0.00 | 0.00 | | 2025-09-19 02:29:12.842783+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 445463 | 5902 | 0.00 | 1.00 | | 2025-09-17 08:29:53.266288+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 | 70431 | 19 | 0.00 | 0.00 | | 2025-09-19 07:23:32.429621+00 | | 2025-09-12 06:09:23.531816+00 |
| public | r_pot_user | 20697 | 0 | 0.00 | 0.00 | | 2025-09-19 20:48:06.95799+00 | | |
| public | r_provider_tenant | 1203 | 0 | 0.00 | 0.00 | | 2025-09-19 21:22:08.118145+00 | | 2025-09-11 06:34:01.277345+00 |
| public | r_role_feature | 6226 | 0 | 0.00 | 0.00 | | 2025-09-18 03:43:32.136685+00 | | |
| public | r_tenant_feature | 4582 | 0 | 0.00 | 0.00 | | 2025-09-17 01:48:34.090111+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-18 01:27:52.347279+00 | | |
| public | r_user_region | 21539 | 0 | 0.00 | 0.00 | | 2025-09-19 20:48:06.404386+00 | | |
| public | r_user_site | 6324 | 3 | 0.00 | 0.00 | | 2025-09-15 23:29:55.614724+00 | | |
| public | r_zone_category | 5001 | 0 | 0.00 | 0.00 | | 2025-09-19 03:25:03.876342+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-17 13:57:30.152607+00 | | |
| public | t_attendance | 3348157 | 32515 | 0.00 | 0.00 | | 2025-09-17 01:49:26.607103+00 | | 2025-09-10 06:00:54.775572+00 |
| public | t_general | 4249 | 0 | 0.00 | 0.00 | | 2025-09-17 06:32:56.738256+00 | | |
| public | t_general_20250618 | 3204 | 0 | 0.00 | 0.00 | | 2025-09-18 16:02:19.298468+00 | | |
| public | t_job | 32 | 0 | 0.00 | 0.00 | | 2025-09-19 02:27:53.282884+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 882133 | 0 | 0.00 | 0.00 | | 2025-09-16 03:31:03.362396+00 | | |
| public | t_mobile_status_history | 2065015 | 0 | 0.00 | 0.00 | | 2025-09-19 14:12:28.391646+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 | 6610441 | 12542 | 0.00 | 0.00 | | 2025-09-16 03:59:29.559742+00 | | |
| public | t_operation_log | 22340049 | 6 | 0.00 | 0.00 | | 2025-09-19 04:09:07.507687+00 | | |
| public | t_plan | 28561768 | 724183 | 0.00 | 2.00 | | 2025-09-18 00:28:13.340536+00 | | 2025-09-19 01:40:22.926577+00 |
| public | t_plan_cancel_history | 692742 | 99796 | 0.00 | 12.00 | | 2025-09-14 04:25:31.094644+00 | | |
| public | t_plan_detail | 48770093 | 44828 | 0.00 | 0.00 | | 2025-09-19 13:47:02.988837+00 | | 2025-09-19 06:38:48.96778+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 | 67763 | 10316 | 0.00 | 13.00 | | 2025-09-19 23:17:21.892827+00 | | 2025-09-20 00:29:37.645901+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 | 145498 | 17083 | 0.00 | 10.00 | | 2025-09-20 00:48:37.440483+00 | 2025-09-19 13:30:01.956922+00 | 2025-09-20 00:49:37.101312+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-09-15 23:29:52.017065+00 | | |
| public | t_terminal | 21702 | 3325 | 0.00 | 13.00 | | 2025-09-19 19:31:43.14259+00 | | 2025-09-20 00:44:38.824349+00 |
| public | t_terminal_log | 29660484 | 0 | 0.00 | 0.00 | | 2025-09-19 01:27:55.71492+00 | | |
| public | temp_pivot_table | 239971 | 0 | 0.00 | 0.00 | | 2025-09-14 08:52:51.681509+00 | | |
| public | w_arrival_notify | 99 | 55 | 0.00 | 35.00 | | 2025-09-14 12:00:27.851502+00 | | 2025-09-18 04:54:37.49216+00 |
| public | w_latest_mobile_device | 57482 | 522 | 0.00 | 0.00 | | 2025-09-17 19:25:11.784497+00 | | 2025-09-17 08:24:58.407674+00 |
| public | w_latest_mobile_status | 56453 | 5715 | 0.00 | 9.00 | | 2025-09-19 07:53:26.427681+00 | | 2025-09-19 12:14:01.059759+00 |
| public | w_latest_position | 79893 | 13463 | 0.00 | 14.00 | | 2025-09-20 00:40:36.845625+00 | | 2025-09-20 00:49:37.271517+00 |
| public | w_latest_presence | 221676 | 48233 | 0.00 | 17.00 | | 2025-09-20 00:49:52.765561+00 | | 2025-09-20 00:49:55.000684+00 |
| public | w_latest_sensor | 386 | 386 | 1.00 | 50.00 | | 2025-09-20 00:48:37.66461+00 | | 2025-09-20 00:49:37.398577+00 |
| public | w_lock | 18800 | 0 | 0.00 | 0.00 | | 2025-09-18 02:30:09.912499+00 | | |
| public | w_master_update | 197 | 22 | 0.00 | 10.00 | | 2025-09-19 23:18:21.290007+00 | | 2025-09-19 21:02:07.426378+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-09-16 00:38:04.851343+00 | | |
| public | w_plan_sync_retry | 0 | 25 | 0 | 100.00 | | 2025-09-19 09:07:01.389477+00 | | 2025-09-19 09:03:01.223682+00 |
| public | w_plan_with_detail | 28547204 | 1280684 | 0.00 | 4.00 | | 2025-09-16 02:46:04.634025+00 | | 2025-09-19 02:14:54.24258+00 |