| 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 |
|---|
| e202409 | a_proximity_sum | 881161 | 0 | 0.00 | 0.00 | | 2024-11-02 20:26:16.444993+00 | | |
| e202409 | a_stay_time | 2549792 | 0 | 0.00 | 0.00 | | 2024-11-01 05:09:51.913601+00 | | |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:26.8741+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:26.855516+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 06:44:44.855543+00 | | |
| e202409 | t_position_history | 30787930 | 0 | 0.00 | 0.00 | | 2024-10-29 01:17:53.199012+00 | | |
| e202409 | t_presence_history | 6027195 | 0 | 0.00 | 0.00 | | 2024-11-01 17:42:58.958968+00 | | |
| e202409 | t_sensor_history | 1163362 | 0 | 0.00 | 0.00 | | 2024-11-01 02:55:43.301618+00 | | |
| e202410 | a_proximity_sum | 1036281 | 0 | 0.00 | 0.00 | | 2024-10-31 17:01:33.766561+00 | | 2024-10-30 15:32:18.858546+00 |
| e202410 | a_stay_time | 3104064 | 0 | 0.00 | 0.00 | | 2024-10-28 09:36:46.005156+00 | | 2024-10-30 15:31:17.628148+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:33.260613+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:33.242983+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 12:18:21.465801+00 | | |
| e202410 | t_position_history | 37799888 | 0 | 0.00 | 0.00 | | 2024-10-31 05:27:45.93225+00 | | 2024-10-29 23:37:01.175338+00 |
| e202410 | t_presence_history | 6478696 | 534360 | 0.00 | 7.00 | | 2024-10-31 14:43:28.235734+00 | | 2024-10-31 14:52:46.384793+00 |
| e202410 | t_sensor_history | 1268926 | 0 | 0.00 | 0.00 | | 2024-10-30 07:40:04.115722+00 | | 2024-10-29 03:22:14.031407+00 |
| e202411 | a_proximity_sum | 40009 | 0 | 0.00 | 0.00 | | 2024-11-01 17:00:58.289055+00 | | 2024-11-01 17:25:59.6545+00 |
| e202411 | a_stay_time | 133088 | 0 | 0.00 | 0.00 | | 2024-11-01 17:00:58.133032+00 | | 2024-11-02 17:00:23.839063+00 |
| e202411 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-05 01:30:35.471428+00 | | |
| e202411 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 01:30:35.482778+00 | | |
| e202411 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 01:30:35.493794+00 | | |
| e202411 | t_position_history | 2563386 | 0 | 0.00 | 0.00 | | 2024-11-05 00:27:46.619136+00 | | 2024-11-05 00:58:56.307165+00 |
| e202411 | t_presence_history | 450229 | 62738 | 0.00 | 12.00 | | 2024-11-05 01:43:36.858259+00 | | 2024-11-05 01:43:37.188789+00 |
| e202411 | t_sensor_history | 183822 | 0 | 0.00 | 0.00 | | 2024-11-04 04:55:50.025169+00 | | 2024-11-04 23:54:53.97428+00 |
| public | __digdag_status | 6 | 44 | 7.00 | 88.00 | | 2024-10-31 21:20:08.959718+00 | | 2024-11-04 21:50:38.187043+00 |
| public | a_attendance_sum | 0 | 0 | 0 | 0 | | 2024-10-30 03:27:18.099277+00 | | |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:55.147438+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-10-28 08:14:35.379014+00 | | |
| public | b_attendance_group | 495977 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.372943+00 | | |
| public | b_attendance_hour | 7445443 | 0 | 0.00 | 0.00 | | 2024-10-28 11:23:46.743681+00 | | |
| public | b_attendance_pot | 287691 | 0 | 0.00 | 0.00 | | 2024-11-03 12:46:40.012239+00 | | 2024-11-03 18:40:54.764031+00 |
| public | b_attendance_pot_hour | 4458881 | 0 | 0.00 | 0.00 | | 2024-11-02 13:34:06.928641+00 | | 2024-11-03 18:38:54.558776+00 |
| public | b_check_in | 3994346 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:31.544344+00 | | |
| public | b_check_in_hour | 59947576 | 0 | 0.00 | 0.00 | | 2024-10-28 11:24:04.27664+00 | | |
| public | b_check_in_pot | 152537 | 0 | 0.00 | 0.00 | | 2024-11-04 04:42:49.927686+00 | | 2024-10-22 18:20:35.817639+00 |
| public | b_check_in_pot_hour | 2941836 | 0 | 0.00 | 0.00 | | 2024-11-02 22:52:23.712868+00 | | 2024-11-01 18:26:05.689469+00 |
| public | b_proximity_group | 33375808 | 0 | 0.00 | 0.00 | | 2024-10-28 12:11:21.020351+00 | | |
| public | b_proximity_info | 29592763 | 0 | 0.00 | 0.00 | | 2024-11-04 04:38:48.670207+00 | | |
| public | b_seat_reserve | 902927 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:26.31841+00 | | |
| public | b_seat_reserve_hour | 16950687 | 0 | 0.00 | 0.00 | | 2024-10-28 08:14:35.244134+00 | | |
| public | b_usage | 1014840 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.850154+00 | | |
| public | b_usage_hour | 18571276 | 0 | 0.00 | 0.00 | | 2024-10-28 11:14:40.66615+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-10-28 08:20:37.601081+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-10-28 08:20:37.583442+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-10-28 08:21:00.98664+00 | | |
| public | m_area | 93 | 0 | 0.00 | 0.00 | | 2024-10-28 12:33:18.585557+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-10-28 11:28:05.307697+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.941145+00 | | |
| public | m_exb | 4297 | 15 | 0.00 | 0.00 | | 2024-10-28 00:31:57.781913+00 | | |
| public | m_favorite | 35327 | 366 | 0.00 | 1.00 | | 2024-10-27 09:43:20.750605+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 7579 | 12 | 0.00 | 0.00 | | 2024-10-30 01:37:29.427463+00 | | 2024-10-25 08:55:40.648705+00 |
| public | m_feature | 165 | 0 | 0.00 | 0.00 | | 2024-10-28 12:42:32.844822+00 | | |
| public | m_group | 2320 | 1 | 0.00 | 0.00 | | 2024-10-27 18:33:14.838391+00 | | |
| public | m_holiday | 5588 | 0 | 0.00 | 0.00 | | 2024-10-28 08:20:37.621813+00 | | |
| public | m_lob | 1169 | 11 | 0.00 | 0.00 | | 2024-10-27 18:33:15.040979+00 | | |
| public | m_location | 5434 | 23 | 0.00 | 0.00 | | 2024-10-27 18:33:14.965317+00 | | |
| public | m_notify_template | 124 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.904151+00 | | |
| public | m_outside | 63 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.163872+00 | | |
| public | m_pot | 26123 | 1313 | 0.00 | 4.00 | | 2024-11-05 00:10:40.966522+00 | | 2024-11-05 00:10:41.761873+00 |
| public | m_pot_profile | 675 | 31 | 0.00 | 4.00 | | 2024-10-28 11:23:43.470573+00 | | 2024-10-31 01:38:07.653388+00 |
| public | m_provider_user | 59 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.118745+00 | | |
| public | m_region | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 12:32:17.633999+00 | | |
| public | m_role | 79 | 0 | 0.00 | 0.00 | | 2024-10-28 12:33:18.568388+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:30.439106+00 | | |
| public | m_setting | 3537 | 280 | 0.00 | 7.00 | | 2024-11-03 18:39:53.37716+00 | | 2024-11-03 05:48:38.040525+00 |
| public | m_setting_log | 4803 | 0 | 0.00 | 0.00 | | 2024-11-04 12:30:59.308727+00 | | 2024-11-04 12:30:59.4259+00 |
| public | m_site | 26 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.885637+00 | | |
| public | m_tenant | 17 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.082778+00 | | |
| public | m_tx | 27349 | 2131 | 0.00 | 7.00 | | 2024-11-01 08:53:27.27751+00 | | 2024-11-01 08:52:27.085739+00 |
| public | m_user | 3253 | 2 | 0.00 | 0.00 | | 2024-10-28 23:56:22.596594+00 | | |
| public | m_zone | 751 | 3 | 0.00 | 0.00 | | 2024-10-28 08:17:55.23092+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-10-28 11:43:25.973878+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:30.418866+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.187193+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:25.984069+00 | | |
| public | r_location_zone | 5983 | 28 | 0.00 | 0.00 | | 2024-11-01 00:12:39.448777+00 | | |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-10-28 11:28:05.330443+00 | | |
| public | r_pot_category | 989 | 9 | 0.00 | 0.00 | | 2024-10-28 11:27:05.306361+00 | | |
| public | r_pot_group | 12511 | 1054 | 0.00 | 7.00 | | 2024-11-04 23:12:45.45524+00 | | 2024-11-04 23:33:40.021239+00 |
| public | r_pot_tx | 10154 | 12 | 0.00 | 0.00 | | 2024-10-31 06:05:20.606701+00 | | |
| public | r_pot_user | 3024 | 1 | 0.00 | 0.00 | | 2024-10-28 23:56:22.497034+00 | | |
| public | r_provider_tenant | 161 | 0 | 0.00 | 0.00 | | 2024-11-03 11:16:09.184287+00 | | |
| public | r_role_feature | 598 | 0 | 0.00 | 0.00 | | 2024-10-27 13:31:54.74472+00 | | |
| public | r_tenant_feature | 645 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.101252+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.208593+00 | | |
| public | r_user_region | 3082 | 2 | 0.00 | 0.00 | | 2024-10-28 23:56:22.536161+00 | | |
| public | r_user_site | 356 | 0 | 0.00 | 0.00 | | 2024-11-04 03:53:35.325894+00 | | |
| public | r_zone_category | 684 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:55.135814+00 | | |
| public | t_ai_history | 33 | 0 | 0.00 | 0.00 | | 2024-10-29 11:21:06.475001+00 | | |
| public | t_attendance | 376686 | 6263 | 0.00 | 1.00 | | 2024-10-28 12:33:25.971598+00 | | 2024-10-31 08:47:16.370632+00 |
| public | t_general | 34 | 0 | 0.00 | 0.00 | | 2024-10-28 12:32:17.617736+00 | | |
| public | t_mobile_device_history | 96829 | 0 | 0.00 | 0.00 | | 2024-10-28 08:45:04.064105+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:36.915455+00 | | |
| public | t_notify_history | 539955 | 6921 | 0.00 | 1.00 | | 2024-10-28 12:32:19.904995+00 | | 2024-10-24 15:03:15.635118+00 |
| public | t_operation_log | 2459381 | 0 | 0.00 | 0.00 | | 2024-10-28 08:31:04.238095+00 | | |
| public | t_plan | 4113376 | 295500 | 0.00 | 6.00 | | 2024-10-28 01:39:53.550293+00 | | 2024-11-04 23:15:53.973291+00 |
| public | t_plan_detail | 5048680 | 173072 | 0.00 | 3.00 | | 2024-10-30 17:43:19.08068+00 | | 2024-10-31 12:21:34.234277+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-10-30 02:04:11.585106+00 | | |
| public | t_plan_sync | 233321 | 19661 | 0.00 | 7.00 | | 2024-11-03 07:46:14.898937+00 | | 2024-11-04 09:05:47.612926+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-10-28 08:17:55.066068+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:14:33.256327+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-10-28 11:27:05.267224+00 | | |
| public | t_recv_position_history | 7108 | 5194 | 0.00 | 42.00 | | 2024-11-05 01:44:35.791144+00 | 2024-11-04 12:42:01.436574+00 | 2024-11-05 01:44:35.821981+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:16:33.309088+00 | | |
| public | t_terminal | 22860 | 999 | 0.00 | 4.00 | | 2024-11-01 00:15:46.15212+00 | | 2024-11-04 22:09:44.631046+00 |
| public | t_terminal_log | 4962335 | 0 | 0.00 | 0.00 | | 2024-10-28 08:18:00.652956+00 | | |
| public | w_arrival_notify | 1 | 4 | 4.00 | 80.00 | | 2024-10-28 08:21:01.038349+00 | | |
| public | w_latest_position | 10695 | 2753 | 0.00 | 20.00 | | 2024-11-05 01:44:35.727346+00 | | 2024-11-05 01:44:35.753638+00 |
| public | w_latest_presence | 17229 | 34514 | 2.00 | 66.00 | | 2024-11-05 01:44:35.902421+00 | | 2024-11-05 01:44:36.003052+00 |
| public | w_latest_sensor | 163 | 25 | 0.00 | 13.00 | | 2024-11-05 01:44:35.709617+00 | | 2024-11-05 01:43:35.920364+00 |
| public | w_lock | 1052 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:54.791118+00 | | |
| public | w_master_update | 17 | 47 | 2.00 | 73.00 | | 2024-11-03 06:11:38.737543+00 | | 2024-11-04 03:21:37.735055+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-11-04 09:52:08.040081+00 | | |
| public | w_plan_with_detail | 4121164 | 326588 | 0.00 | 7.00 | | 2024-10-27 11:32:59.532396+00 | | 2024-11-04 23:02:46.38977+00 |
| public | w_plan_with_detail_new | 33 | 0 | 0.00 | 0.00 | | 2024-10-30 01:51:29.897995+00 | | |