| 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 | 57061101 | 0 | 0.00 | 0.00 | | 2025-09-02 09:38:20.22516+00 | | |
| e202507 | a_stay_time | 47407726 | 0 | 0.00 | 0.00 | | 2025-08-29 01:19:12.377192+00 | | |
| e202507 | t_position_history | 610147581 | 0 | 0.00 | 0.00 | | 2025-08-29 05:11:18.352514+00 | | |
| e202507 | t_presence_history | 55790761 | 0 | 0.00 | 0.00 | | 2025-08-29 03:31:56.746341+00 | | |
| e202507 | t_sensor_history | 11690426 | 0 | 0.00 | 0.00 | | 2025-08-29 09:20:05.086305+00 | | |
| e202508 | a_proximity_sum | 32424357 | 0 | 0.00 | 0.00 | | 2025-09-02 12:43:57.582627+00 | | 2025-08-29 17:48:54.693087+00 |
| e202508 | a_stay_time | 36284973 | 64272 | 0.00 | 0.00 | | 2025-08-28 15:21:13.177374+00 | | 2025-08-28 18:55:34.466148+00 |
| e202508 | t_position_history | 582784448 | 143020 | 0.00 | 0.00 | | 2025-09-01 01:12:49.313432+00 | | 2025-08-29 08:15:47.453374+00 |
| e202508 | t_presence_history | 54679185 | 0 | 0.00 | 0.00 | | 2025-09-02 15:54:34.785902+00 | | 2025-08-31 15:00:01.280907+00 |
| e202508 | t_sensor_history | 11924182 | 0 | 0.00 | 0.00 | | 2025-08-31 02:11:59.210078+00 | | 2025-08-28 22:46:31.047543+00 |
| e202509 | a_proximity_sum | 3152941 | 0 | 0.00 | 0.00 | | 2025-09-02 19:01:22.376185+00 | | 2025-09-02 19:01:22.954423+00 |
| e202509 | a_stay_time | 4182191 | 0 | 0.00 | 0.00 | | 2025-09-02 17:23:26.638154+00 | | 2025-09-02 18:55:28.984871+00 |
| e202509 | t_position_history | 58429977 | 0 | 0.00 | 0.00 | | 2025-09-03 00:00:35.589473+00 | | 2025-09-02 19:34:23.889075+00 |
| e202509 | t_presence_history | 5700567 | 1278720 | 0.00 | 18.00 | | 2025-09-03 00:48:48.722986+00 | | 2025-09-03 00:53:07.780857+00 |
| e202509 | t_sensor_history | 922630 | 0 | 0.00 | 0.00 | | 2025-09-02 23:04:24.147262+00 | | 2025-09-02 21:58:20.188405+00 |
| public | __digdag_status | 32 | 5 | 0.00 | 13.00 | | 2025-09-02 09:17:33.265173+00 | | 2025-08-28 12:30:18.362409+00 |
| public | a_attendance_sum | 149667 | 28956 | 0.00 | 16.00 | | 2025-09-01 23:58:04.655266+00 | | 2025-09-03 00:31:09.358445+00 |
| public | a_plan_actual | 1022487 | 0 | 0.00 | 0.00 | | 2025-08-30 23:36:05.630777+00 | | 2025-09-02 17:17:15.571058+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:45.556903+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:44.85802+00 | | |
| public | aaa | 1 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:43.56926+00 | | |
| public | area_history | 1005 | 0 | 0.00 | 0.00 | | 2025-09-01 01:16:13.818492+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2025-08-31 13:33:02.783709+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.289939+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.386749+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.300939+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:09.311824+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.397995+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.374961+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2025-08-31 17:02:05.9155+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.409231+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2025-08-31 13:32:10.420554+00 | | |
| public | l_area | 1548 | 16 | 0.00 | 1.00 | | 2025-08-29 02:39:03.624866+00 | | |
| public | l_auth | 173 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:03.531273+00 | | |
| public | l_category | 2684 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:05.006558+00 | | |
| public | l_group | 35523 | 69 | 0.00 | 0.00 | | 2025-08-29 02:39:07.069636+00 | | |
| public | l_lob | 1943 | 0 | 0.00 | 0.00 | | 2025-09-02 07:47:38.571929+00 | | 2025-08-26 10:11:39.850837+00 |
| public | l_location | 103559 | 774 | 0.00 | 0.00 | | 2025-08-29 02:39:04.798722+00 | | |
| public | l_location_zone | 100522 | 1886 | 0.00 | 1.00 | | 2025-08-29 02:39:04.037808+00 | | |
| public | l_outside | 441 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:03.559857+00 | | |
| public | l_pot | 435837 | 3538 | 0.00 | 0.00 | | 2025-08-29 02:39:13.107243+00 | | |
| public | l_pot_category | 13495 | 296 | 0.00 | 2.00 | | 2025-08-29 02:39:04.916179+00 | | 2025-08-29 14:41:29.666383+00 |
| public | l_pot_group | 230108 | 1195 | 0.00 | 0.00 | | 2025-08-29 02:39:06.870491+00 | | |
| public | l_pot_tx | 99184 | 688 | 0.00 | 0.00 | | 2025-08-29 02:39:05.678988+00 | | |
| public | l_role | 770 | 1 | 0.00 | 0.00 | | 2025-08-29 02:39:01.364422+00 | | |
| public | l_role_feature | 6223 | 8 | 0.00 | 0.00 | | 2025-08-29 02:39:01.28785+00 | | |
| public | l_site | 255 | 1 | 0.00 | 0.00 | | 2025-08-29 02:39:03.652806+00 | | |
| public | l_tx | 141197 | 19000 | 0.00 | 11.00 | | 2025-08-30 04:31:36.816025+00 | | 2025-09-02 07:07:08.381498+00 |
| public | l_user | 62504 | 789 | 0.00 | 1.00 | | 2025-08-29 02:39:01.147802+00 | | |
| public | l_zone | 9977 | 6 | 0.00 | 0.00 | | 2025-08-29 02:39:04.132076+00 | | |
| public | l_zone_category | 5212 | 0 | 0.00 | 0.00 | | 2025-08-29 02:39:00.228516+00 | | |
| public | m_area | 784 | 9 | 0.00 | 1.00 | | 2025-08-31 07:12:17.78997+00 | | |
| public | m_auth | 141 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.588843+00 | | |
| public | m_category | 2421 | 0 | 0.00 | 0.00 | | 2025-08-31 07:12:17.760777+00 | | |
| public | m_env | 1 | 0 | 0.00 | 0.00 | | 2025-09-01 02:50:56.702024+00 | | |
| public | m_exb | 26434 | 133 | 0.00 | 0.00 | | 2025-08-29 08:31:43.277481+00 | | |
| public | m_favorite | 235628 | 1360 | 0.00 | 0.00 | | 2025-08-30 15:17:27.111905+00 | | |
| public | m_favorite_group | 114045 | 215 | 0.00 | 0.00 | | 2025-09-01 11:47:17.582229+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-08-29 20:56:34.194737+00 | | |
| public | m_group | 28016 | 1339 | 0.00 | 4.00 | | 2025-09-01 09:12:19.246068+00 | | 2025-09-02 14:40:24.378939+00 |
| public | m_holiday | 43859 | 0 | 0.00 | 0.00 | | 2025-09-02 19:18:17.411059+00 | | |
| public | m_lob | 24493 | 96 | 0.00 | 0.00 | | 2025-08-28 12:37:15.856479+00 | | |
| public | m_lob_log | 1999 | 0 | 0.00 | 0.00 | | 2025-09-02 08:36:18.552889+00 | | |
| public | m_location | 44672 | 355 | 0.00 | 0.00 | | 2025-08-31 02:41:50.263825+00 | | 2025-08-29 11:38:48.027813+00 |
| public | m_notify_template | 1224 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.923329+00 | | |
| public | m_outside | 372 | 0 | 0.00 | 0.00 | | 2025-09-02 03:59:15.518457+00 | | |
| public | m_personal_setting | 132735 | 16440 | 0.00 | 11.00 | | 2025-09-01 22:34:35.261922+00 | | 2025-09-03 00:19:58.379459+00 |
| public | m_pot | 203038 | 25010 | 0.00 | 10.00 | | 2025-08-30 04:00:41.329102+00 | | 2025-09-01 08:20:15.970697+00 |
| public | m_pot_profile | 52430 | 26 | 0.00 | 0.00 | | 2025-08-29 00:24:59.621977+00 | | |
| public | m_provider_user | 84 | 0 | 0.00 | 0.00 | | 2025-08-30 00:11:13.188894+00 | | |
| public | m_region | 113 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.065754+00 | | |
| public | m_role | 773 | 1 | 0.00 | 0.00 | | 2025-08-29 12:01:46.022102+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.717675+00 | | |
| public | m_setting | 30117 | 1333 | 0.00 | 4.00 | | 2025-09-02 06:09:52.880787+00 | | 2025-09-01 13:28:20.032678+00 |
| public | m_setting_log | 36563 | 1632 | 0.00 | 4.00 | | 2025-08-29 02:36:01.163381+00 | | 2025-09-02 11:35:22.903933+00 |
| public | m_site | 187 | 1 | 0.00 | 0.00 | | 2025-08-29 12:01:45.577023+00 | | |
| public | m_tenant | 112 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.099196+00 | | |
| public | m_tx | 121194 | 17661 | 0.00 | 12.00 | | 2025-09-02 12:23:17.941845+00 | | 2025-09-02 12:27:17.228299+00 |
| public | m_user | 33159 | 407 | 0.00 | 1.00 | | 2025-09-01 23:58:32.019978+00 | | 2025-09-02 05:12:48.761193+00 |
| public | m_zone | 7847 | 13 | 0.00 | 0.00 | | 2025-08-30 06:30:41.401825+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.541931+00 | | |
| public | r_auth_zone | 214 | 0 | 0.00 | 0.00 | | 2025-08-30 18:03:57.632279+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.950491+00 | | |
| public | r_group_auth | 557 | 0 | 0.00 | 0.00 | | 2025-09-01 01:19:58.239654+00 | | |
| public | r_location_zone | 54172 | 184 | 0.00 | 0.00 | | 2025-08-31 07:12:17.601543+00 | | 2025-08-29 08:17:47.919486+00 |
| public | r_pot_auth | 8469 | 0 | 0.00 | 0.00 | | 2025-09-02 09:38:19.28621+00 | | 2025-09-01 08:20:11.265346+00 |
| public | r_pot_category | 11635 | 24 | 0.00 | 0.00 | | 2025-09-02 07:51:32.134264+00 | | 2025-08-29 14:41:12.5478+00 |
| public | r_pot_group | 439637 | 593 | 0.00 | 0.00 | | 2025-09-01 02:50:56.675397+00 | | |
| public | r_pot_plan_permission_group | 31 | 0 | 0.00 | 0.00 | | 2025-08-30 07:02:06.507248+00 | | |
| public | r_pot_tx | 69884 | 59 | 0.00 | 0.00 | | 2025-09-02 15:03:22.660988+00 | | |
| public | r_pot_user | 20136 | 67 | 0.00 | 0.00 | | 2025-08-28 14:02:52.624522+00 | | |
| public | r_provider_tenant | 1241 | 0 | 0.00 | 0.00 | | 2025-08-29 05:33:21.593808+00 | | |
| public | r_role_feature | 5844 | 5 | 0.00 | 0.00 | | 2025-09-01 12:38:18.794239+00 | | |
| public | r_tenant_feature | 4517 | 0 | 0.00 | 0.00 | | 2025-08-31 13:32:10.069592+00 | | |
| public | r_tx_sensor | 357 | 0 | 0.00 | 0.00 | | 2025-09-01 09:12:19.271531+00 | | |
| public | r_user_region | 21498 | 63 | 0.00 | 0.00 | | 2025-08-28 14:02:51.893863+00 | | |
| public | r_user_site | 6254 | 2 | 0.00 | 0.00 | | 2025-08-29 12:01:45.686288+00 | | |
| public | r_zone_category | 4970 | 0 | 0.00 | 0.00 | | 2025-09-02 08:36:18.528915+00 | | |
| public | t_ai_history | 24 | 0 | 0.00 | 0.00 | | 2025-09-01 05:19:49.762173+00 | | |
| public | t_attendance | 3181411 | 22014 | 0.00 | 0.00 | | 2025-08-31 13:33:02.7707+00 | | |
| public | t_general | 4179 | 1 | 0.00 | 0.00 | | 2025-09-01 01:16:12.459577+00 | | |
| public | t_general_20250618 | 3357 | 0 | 0.00 | 0.00 | | 2025-09-02 03:48:42.61602+00 | | |
| public | t_job | 31 | 0 | 0.00 | 0.00 | | 2025-09-02 07:49:15.377944+00 | | 2025-08-26 11:42:21.414678+00 |
| public | t_mobile_device_history | 922199 | 0 | 0.00 | 0.00 | | 2025-08-30 01:44:15.681829+00 | | |
| public | t_mobile_status_history | 1854959 | 0 | 0.00 | 0.00 | | 2025-09-03 00:37:09.413143+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:45.972227+00 | | |
| public | t_notify_history | 6503202 | 10108 | 0.00 | 0.00 | | 2025-08-30 02:30:31.165877+00 | | |
| public | t_operation_log | 21988996 | 9 | 0.00 | 0.00 | | 2025-09-02 09:17:33.174535+00 | | |
| public | t_plan | 27351034 | 709715 | 0.00 | 2.00 | | 2025-09-01 08:10:47.659333+00 | | 2025-08-31 22:35:31.099886+00 |
| public | t_plan_cancel_history | 596579 | 79222 | 0.00 | 11.00 | | 2025-08-28 23:05:37.563117+00 | | |
| public | t_plan_detail | 47212581 | 62396 | 0.00 | 0.00 | | 2025-09-03 00:29:42.943932+00 | | 2025-09-01 08:52:14.103923+00 |
| public | t_plan_permission | 105 | 0 | 0.00 | 0.00 | | 2025-08-30 07:02:06.48947+00 | | |
| public | t_plan_permission_group | 2 | 0 | 0.00 | 0.00 | | 2025-08-30 07:02:06.463177+00 | | |
| public | t_plan_sync | 66130 | 6156 | 0.00 | 8.00 | | 2025-09-03 00:20:59.372562+00 | | 2025-09-03 00:38:13.165813+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2025-08-29 12:01:46.13182+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.603149+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:46.077048+00 | | |
| public | t_recv_position_history | 154224 | 23901 | 0.00 | 13.00 | | 2025-09-03 00:55:20.876553+00 | 2025-09-02 13:30:02.425339+00 | 2025-09-03 00:55:21.211088+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-08-29 12:01:43.839998+00 | | |
| public | t_terminal | 20957 | 1095 | 0.00 | 4.00 | | 2025-09-02 22:37:22.021693+00 | | 2025-09-03 00:31:11.233123+00 |
| public | t_terminal_log | 28218168 | 0 | 0.00 | 0.00 | | 2025-09-02 07:12:16.990009+00 | | |
| public | temp_pivot_table | 240184 | 0 | 0.00 | 0.00 | | 2025-08-29 00:25:06.94772+00 | | |
| public | w_arrival_notify | 101 | 58 | 0.00 | 36.00 | | 2025-08-29 01:19:12.397653+00 | | 2025-09-02 23:09:22.881724+00 |
| public | w_latest_mobile_device | 56673 | 606 | 0.00 | 1.00 | | 2025-09-01 06:20:02.943264+00 | | 2025-08-31 11:26:59.109828+00 |
| public | w_latest_mobile_status | 55645 | 2649 | 0.00 | 4.00 | | 2025-09-03 00:31:08.767911+00 | | 2025-09-03 00:11:58.208471+00 |
| public | w_latest_position | 79082 | 25754 | 0.00 | 24.00 | | 2025-09-03 00:55:21.410758+00 | | 2025-09-03 00:55:21.591518+00 |
| public | w_latest_presence | 308959 | 169824 | 0.00 | 35.00 | | 2025-09-03 00:55:35.901335+00 | | 2025-09-03 00:55:37.198802+00 |
| public | w_latest_sensor | 386 | 291 | 0.00 | 42.00 | | 2025-09-03 00:55:21.609393+00 | | 2025-09-03 00:55:21.719881+00 |
| public | w_lock | 18454 | 0 | 0.00 | 0.00 | | 2025-09-01 10:22:51.233301+00 | | |
| public | w_master_update | 195 | 16 | 0.00 | 7.00 | | 2025-09-03 00:34:12.619344+00 | | 2025-09-02 23:52:30.981479+00 |
| public | w_migration | 679 | 0 | 0.00 | 0.00 | | 2025-08-29 14:40:13.993678+00 | | |
| public | w_plan_sync_retry | 0 | 32 | 0 | 100.00 | | 2025-09-02 23:15:23.910097+00 | | 2025-09-03 00:31:09.372403+00 |
| public | w_plan_with_detail | 27653240 | 1087049 | 0.00 | 3.00 | | 2025-08-29 23:38:14.910805+00 | | 2025-08-31 22:13:29.722609+00 |