| 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 |
|---|
| e202504 | a_proximity_sum | 3724637 | 0 | 0.00 | 0.00 | | 2025-06-15 10:00:34.573983+00 | | |
| e202504 | a_stay_time | 6814229 | 0 | 0.00 | 0.00 | | 2025-06-22 12:56:31.247233+00 | | |
| e202504 | t_position_history | 45793453 | 0 | 0.00 | 0.00 | | 2025-06-16 03:27:57.770983+00 | | |
| e202504 | t_presence_history | 4102407 | 0 | 0.00 | 0.00 | | 2025-06-21 08:29:14.970753+00 | | |
| e202504 | t_sensor_history | 1180496 | 0 | 0.00 | 0.00 | | 2025-06-20 08:59:44.296067+00 | | |
| e202505 | a_proximity_sum | 2887498 | 0 | 0.00 | 0.00 | | 2025-06-14 21:56:40.533703+00 | | 2025-05-30 15:37:38.689728+00 |
| e202505 | a_stay_time | 6541484 | 0 | 0.00 | 0.00 | | 2025-06-17 10:39:44.943529+00 | | 2025-05-29 15:31:32.693656+00 |
| e202505 | t_position_history | 43287028 | 0 | 0.00 | 0.00 | | 2025-06-17 07:57:01.351054+00 | | 2025-05-29 00:56:19.646506+00 |
| e202505 | t_presence_history | 5511047 | 0 | 0.00 | 0.00 | | 2025-06-16 16:34:30.843327+00 | | 2025-05-31 14:51:24.959193+00 |
| e202505 | t_sensor_history | 1268461 | 0 | 0.00 | 0.00 | | 2025-06-16 09:52:09.49328+00 | | 2025-05-31 13:57:48.979362+00 |
| e202506 | a_proximity_sum | 2935727 | 0 | 0.00 | 0.00 | | 2025-06-21 15:43:12.384379+00 | | 2025-06-22 15:49:26.154691+00 |
| e202506 | a_stay_time | 4930670 | 0 | 0.00 | 0.00 | | 2025-06-18 15:31:42.812914+00 | | 2025-06-20 15:30:55.627308+00 |
| e202506 | t_position_history | 33476643 | 0 | 0.00 | 0.00 | | 2025-06-21 04:24:40.966785+00 | | 2025-06-22 02:19:56.726804+00 |
| e202506 | t_presence_history | 3183729 | 592867 | 0.00 | 15.00 | | 2025-06-23 01:20:53.443515+00 | | 2025-06-23 01:37:38.461099+00 |
| e202506 | t_sensor_history | 913916 | 0 | 0.00 | 0.00 | | 2025-06-21 06:25:50.611701+00 | | 2025-06-21 14:30:09.413533+00 |
| public | __digdag_status | 7 | 51 | 7.00 | 87.00 | | 2025-06-17 21:50:31.688295+00 | | 2025-06-20 00:10:40.925415+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2025-06-21 02:10:44.071582+00 | | |
| public | a_plan_actual | 79805 | 0 | 0.00 | 0.00 | | 2025-06-14 08:30:15.696596+00 | | 2025-06-11 16:02:33.817698+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2025-06-19 06:05:28.641177+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2025-06-19 06:04:23.941069+00 | | |
| public | area_history | 181 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:50.280893+00 | | |
| public | b_attendance_group | 752809 | 0 | 0.00 | 0.00 | | 2025-06-19 06:04:22.857161+00 | | |
| public | b_attendance_hour | 12007210 | 0 | 0.00 | 0.00 | | 2025-06-19 13:59:36.003555+00 | | |
| public | b_attendance_pot | 861092 | 0 | 0.00 | 0.00 | | 2025-06-16 09:51:09.659595+00 | | 2025-06-20 18:35:37.836021+00 |
| public | b_attendance_pot_hour | 13407072 | 0 | 0.00 | 0.00 | | 2025-06-15 12:17:39.769291+00 | | 2025-06-20 18:36:38.97666+00 |
| public | b_check_in | 5378111 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:16.195618+00 | | |
| public | b_check_in_hour | 83810837 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:28.683566+00 | | |
| public | b_check_in_pot | 338287 | 0 | 0.00 | 0.00 | | 2025-06-17 07:59:55.931188+00 | | 2025-06-22 17:03:11.361067+00 |
| public | b_check_in_pot_hour | 7459639 | 0 | 0.00 | 0.00 | | 2025-06-16 04:14:17.501347+00 | | 2025-06-21 18:32:35.58719+00 |
| public | b_proximity_group | 52125371 | 0 | 0.00 | 0.00 | | 2025-06-19 13:59:30.297564+00 | | |
| public | b_proximity_info | 82532428 | 0 | 0.00 | 0.00 | | 2025-06-16 22:22:38.639529+00 | | |
| public | b_seat_reserve | 1455637 | 0 | 0.00 | 0.00 | | 2025-06-19 13:58:29.69161+00 | | |
| public | b_seat_reserve_hour | 28053130 | 0 | 0.00 | 0.00 | | 2025-06-19 06:04:22.527585+00 | | |
| public | b_usage | 1667866 | 0 | 0.00 | 0.00 | | 2025-06-19 06:05:28.534116+00 | | |
| public | b_usage_hour | 31166925 | 0 | 0.00 | 0.00 | | 2025-06-19 13:58:36.010041+00 | | |
| public | l_area | 191 | 0 | 0.00 | 0.00 | | 2025-06-16 09:56:35.751687+00 | | 2025-05-27 10:20:10.564892+00 |
| public | l_auth | 12 | 0 | 0.00 | 0.00 | | 2025-06-16 09:56:35.702597+00 | | |
| public | l_category | 484 | 0 | 0.00 | 0.00 | | 2025-06-16 09:57:35.705369+00 | | 2025-05-27 10:20:10.789895+00 |
| public | l_group | 3176 | 37 | 0.00 | 1.00 | | 2025-06-16 09:58:35.649074+00 | | 2025-05-27 10:20:11.032762+00 |
| public | l_location | 7560 | 159 | 0.00 | 2.00 | | 2025-06-16 09:57:35.631412+00 | | 2025-05-27 10:23:10.473563+00 |
| public | l_location_zone | 5026 | 170 | 0.00 | 3.00 | | 2025-06-16 09:57:35.591769+00 | | 2025-05-27 10:21:10.104411+00 |
| public | l_outside | 92 | 0 | 0.00 | 0.00 | | 2025-06-16 09:56:35.731615+00 | | 2025-05-27 10:24:10.187977+00 |
| public | l_pot | 72716 | 229 | 0.00 | 0.00 | | 2025-06-16 09:58:36.220867+00 | | 2025-05-27 10:20:11.875509+00 |
| public | l_pot_category | 1111 | 4 | 0.00 | 0.00 | | 2025-06-16 09:57:35.693915+00 | | 2025-05-27 10:21:10.122155+00 |
| public | l_pot_group | 27392 | 163 | 0.00 | 0.00 | | 2025-06-16 09:58:35.611364+00 | | 2025-05-27 10:21:10.212154+00 |
| public | l_pot_tx | 12368 | 129 | 0.00 | 1.00 | | 2025-06-16 09:57:35.793114+00 | | 2025-05-27 10:20:10.837915+00 |
| public | l_role | 80 | 0 | 0.00 | 0.00 | | 2025-06-16 09:56:35.675708+00 | | 2025-05-27 10:20:10.547091+00 |
| public | l_role_feature | 673 | 12 | 0.00 | 1.00 | | 2025-06-16 09:56:35.648323+00 | | 2025-05-27 10:21:10.078282+00 |
| public | l_site | 35 | 0 | 0.00 | 0.00 | | 2025-06-16 09:57:35.562799+00 | | |
| public | l_tx | 18981 | 2580 | 0.00 | 11.00 | | 2025-06-22 04:06:45.08014+00 | | 2025-06-22 04:14:45.175697+00 |
| public | l_user | 3739 | 125 | 0.00 | 3.00 | | 2025-06-16 09:56:35.611712+00 | | 2025-05-27 10:20:10.53188+00 |
| public | l_zone | 1045 | 1 | 0.00 | 0.00 | | 2025-06-16 09:57:35.603922+00 | | 2025-05-27 10:20:10.594027+00 |
| public | l_zone_category | 754 | 0 | 0.00 | 0.00 | | 2025-06-16 09:56:35.553642+00 | | 2025-05-27 10:20:10.46805+00 |
| public | m_area | 90 | 2 | 0.00 | 2.00 | | 2025-06-19 14:01:42.15688+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:15.370922+00 | | |
| public | m_category | 428 | 0 | 0.00 | 0.00 | | 2025-06-19 06:05:32.933143+00 | | |
| public | m_env | 0 | 0 | 0 | 0 | | 2025-06-20 02:11:13.397624+00 | | |
| public | m_exb | 3479 | 61 | 0.00 | 1.00 | | 2025-06-15 10:13:10.866253+00 | | |
| public | m_favorite | 39835 | 125 | 0.00 | 0.00 | | 2025-06-18 08:12:58.27293+00 | | |
| public | m_favorite_group | 9057 | 0 | 0.00 | 0.00 | | 2025-06-20 22:30:22.660993+00 | | |
| public | m_feature | 168 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:42.138988+00 | | |
| public | m_group | 2018 | 0 | 0.00 | 0.00 | | 2025-06-22 05:36:14.559196+00 | | 2025-05-27 09:50:51.924555+00 |
| public | m_holiday | 6702 | 0 | 0.00 | 0.00 | | 2025-06-19 06:05:39.339836+00 | | |
| public | m_lob | 1939 | 8 | 0.00 | 0.00 | | 2025-06-18 07:10:48.480884+00 | | 2025-05-20 10:00:55.820078+00 |
| public | m_lob_log | 648 | 0 | 0.00 | 0.00 | | 2025-06-14 08:30:15.553782+00 | | |
| public | m_location | 5170 | 126 | 0.00 | 2.00 | | 2025-06-18 11:40:16.676008+00 | | |
| public | m_notify_template | 164 | 1 | 0.00 | 0.00 | | 2025-06-19 06:05:28.554848+00 | | |
| public | m_outside | 69 | 0 | 0.00 | 0.00 | | 2025-06-19 06:05:28.146922+00 | | |
| public | m_personal_setting | 13846 | 2284 | 0.00 | 14.00 | | 2025-06-20 03:01:14.908207+00 | | 2025-06-23 01:18:13.591782+00 |
| public | m_pot | 27607 | 3178 | 0.00 | 10.00 | | 2025-06-22 13:10:31.959303+00 | | 2025-06-23 00:11:01.928669+00 |
| public | m_pot_profile | 4163 | 4 | 0.00 | 0.00 | | 2025-06-18 20:45:20.606057+00 | | 2025-05-28 04:10:33.590762+00 |
| public | m_provider_user | 62 | 0 | 0.00 | 0.00 | | 2025-06-19 06:04:23.929552+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:39.930613+00 | | |
| public | m_role | 82 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:39.856254+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:15.445325+00 | | |
| public | m_setting | 2431 | 459 | 0.00 | 15.00 | | 2025-06-20 12:04:22.838881+00 | | 2025-06-22 03:28:49.394309+00 |
| public | m_setting_log | 5162 | 356 | 0.00 | 6.00 | | 2025-06-20 12:30:42.83148+00 | | 2025-06-22 12:32:51.841724+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2025-06-19 06:05:28.629593+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2025-06-19 06:04:23.889937+00 | | |
| public | m_tx | 29911 | 0 | 0.00 | 0.00 | | 2025-06-22 04:25:49.51621+00 | | 2025-06-22 04:21:47.231308+00 |
| public | m_user | 3550 | 0 | 0.00 | 0.00 | | 2025-06-22 03:21:44.028645+00 | | 2025-06-20 07:28:54.605204+00 |
| public | m_zone | 823 | 20 | 0.00 | 2.00 | | 2025-06-19 06:05:32.910703+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2025-06-19 13:58:29.702618+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:15.421568+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2025-06-19 06:05:28.580339+00 | | |
| public | r_group_auth | 378 | 0 | 0.00 | 0.00 | | 2025-06-19 13:58:29.324003+00 | | |
| public | r_location_zone | 7069 | 154 | 0.00 | 2.00 | | 2025-06-14 12:03:18.715878+00 | | |
| public | r_pot_auth | 66 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:15.399252+00 | | |
| public | r_pot_category | 918 | 4 | 0.00 | 0.00 | | 2025-06-16 00:35:40.71433+00 | | |
| public | r_pot_group | 50092 | 164 | 0.00 | 0.00 | | 2025-06-14 11:42:17.47813+00 | | |
| public | r_pot_tx | 12126 | 0 | 0.00 | 0.00 | | 2025-06-23 00:07:00.907862+00 | | |
| public | r_pot_user | 2854 | 0 | 0.00 | 0.00 | | 2025-06-19 13:58:36.031408+00 | | |
| public | r_provider_tenant | 147 | 0 | 0.00 | 0.00 | | 2025-06-18 08:47:16.136617+00 | | |
| public | r_role_feature | 611 | 12 | 0.00 | 1.00 | | 2025-06-18 09:54:46.794303+00 | | |
| public | r_tenant_feature | 667 | 0 | 0.00 | 0.00 | | 2025-06-19 06:04:23.910029+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2025-06-19 06:05:28.613288+00 | | |
| public | r_user_region | 2970 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:28.751408+00 | | |
| public | r_user_site | 361 | 0 | 0.00 | 0.00 | | 2025-06-14 17:51:37.572414+00 | | 2025-06-20 07:28:54.28563+00 |
| public | r_zone_category | 705 | 0 | 0.00 | 0.00 | | 2025-06-19 06:04:23.964707+00 | | |
| public | t_ai_history | 38 | 0 | 0.00 | 0.00 | | 2025-06-20 07:45:00.549122+00 | | |
| public | t_attendance | 785399 | 1188 | 0.00 | 0.00 | | 2025-06-19 14:01:39.841802+00 | | |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2025-06-19 14:01:39.914222+00 | | |
| public | t_mobile_device_history | 183247 | 0 | 0.00 | 0.00 | | 2025-06-17 22:42:51.978075+00 | | |
| public | t_mobile_status_history | 0 | 0 | 0 | 0 | | 2025-06-20 06:51:11.512454+00 | | |
| public | t_news | 1 | 11 | 11.00 | 91.00 | | 2025-06-19 06:05:28.591615+00 | | |
| public | t_notify_history | 778841 | 801 | 0.00 | 0.00 | | 2025-06-19 14:01:42.11796+00 | | |
| public | t_operation_log | 2895955 | 14 | 0.00 | 0.00 | | 2025-06-19 06:05:54.119049+00 | | |
| public | t_plan | 7003154 | 249119 | 0.00 | 3.00 | | 2025-06-18 23:05:33.616625+00 | | 2025-06-22 23:32:06.359166+00 |
| public | t_plan_cancel_history | 91302 | 4 | 0.00 | 0.00 | | 2025-06-18 11:38:44.328928+00 | | |
| public | t_plan_detail | 7727041 | 82118 | 0.00 | 1.00 | | 2025-06-22 02:44:10.493653+00 | | 2025-06-20 07:40:00.206441+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2025-06-20 22:55:02.889582+00 | | |
| public | t_plan_sync | 234775 | 29194 | 0.00 | 11.00 | | 2025-06-16 10:45:03.756237+00 | | 2025-06-23 00:46:56.322639+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2025-06-19 06:04:23.872915+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2025-06-19 13:58:29.735316+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2025-06-19 14:01:39.949941+00 | | |
| public | t_recv_position_history | 14493 | 17792 | 1.00 | 55.00 | | 2025-06-23 01:44:35.674701+00 | 2025-06-22 12:42:01.06635+00 | 2025-06-23 01:44:35.745948+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2025-06-19 13:58:36.075586+00 | | |
| public | t_terminal | 32695 | 5073 | 0.00 | 13.00 | | 2025-06-17 02:48:13.032698+00 | | 2025-06-22 23:41:24.219011+00 |
| public | t_terminal_log | 6639781 | 0 | 0.00 | 0.00 | | 2025-06-19 06:05:39.316577+00 | | |
| public | w_arrival_notify | 1 | 2 | 2.00 | 66.00 | | 2025-06-19 06:05:39.362252+00 | | 2025-06-05 00:42:46.05356+00 |
| public | w_latest_mobile_device | 5814 | 119 | 0.00 | 2.00 | | 2025-06-20 06:51:12.353672+00 | | 2025-06-22 23:38:21.693503+00 |
| public | w_latest_mobile_status | 5685 | 843 | 0.00 | 12.00 | | 2025-06-22 23:51:22.245507+00 | | 2025-06-23 01:32:35.335631+00 |
| public | w_latest_position | 13272 | 7748 | 0.00 | 36.00 | | 2025-06-23 01:44:35.601139+00 | | 2025-06-23 01:44:35.64573+00 |
| public | w_latest_presence | 18664 | 59913 | 3.00 | 76.00 | | 2025-06-23 01:44:35.786873+00 | | 2025-06-23 01:44:35.890515+00 |
| public | w_latest_sensor | 162 | 62 | 0.00 | 27.00 | | 2025-06-23 01:44:35.577527+00 | | 2025-06-23 01:42:35.753401+00 |
| public | w_lock | 1151 | 3 | 0.00 | 0.00 | | 2025-06-19 06:04:23.362965+00 | | |
| public | w_master_update | 17 | 41 | 2.00 | 70.00 | | 2025-06-21 23:40:10.248043+00 | | 2025-06-21 23:38:09.580547+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2025-06-17 07:54:55.253689+00 | | |
| public | w_plan_with_detail | 6999621 | 266163 | 0.00 | 3.00 | | 2025-06-18 08:54:41.211189+00 | | 2025-06-22 23:03:12.364337+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2025-06-20 22:55:28.782513+00 | | |