| 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 | 37799892 | 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 | 91764 | 0 | 0.00 | 0.00 | | 2024-11-05 17:01:13.545221+00 | | 2024-11-05 17:01:13.641563+00 |
| e202411 | a_stay_time | 271510 | 0 | 0.00 | 0.00 | | 2024-11-05 17:00:13.005816+00 | | 2024-11-05 17:00:13.189191+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 | 4391862 | 0 | 0.00 | 0.00 | | 2024-11-06 01:23:27.210092+00 | | 2024-11-05 14:26:44.141224+00 |
| e202411 | t_presence_history | 737551 | 24273 | 0.00 | 3.00 | | 2024-11-06 01:44:59.073319+00 | | 2024-11-06 01:44:59.540651+00 |
| e202411 | t_sensor_history | 223703 | 0 | 0.00 | 0.00 | | 2024-11-05 02:27:46.494537+00 | | 2024-11-05 22:44:11.156797+00 |
| public | __digdag_status | 11 | 3 | 0.00 | 21.00 | | 2024-11-05 21:50:02.350891+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 | 497481 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.372943+00 | | |
| public | b_attendance_hour | 7468977 | 0 | 0.00 | 0.00 | | 2024-10-28 11:23:46.743681+00 | | |
| public | b_attendance_pot | 290525 | 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 | 4502876 | 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 | 4004901 | 0 | 0.00 | 0.00 | | 2024-10-28 12:25:31.544344+00 | | |
| public | b_check_in_hour | 60109471 | 0 | 0.00 | 0.00 | | 2024-10-28 11:24:04.27664+00 | | |
| public | b_check_in_pot | 153476 | 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 | 2963346 | 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 | 33443724 | 0 | 0.00 | 0.00 | | 2024-10-28 12:11:21.020351+00 | | |
| public | b_proximity_info | 29695687 | 0 | 0.00 | 0.00 | | 2024-11-04 04:38:48.670207+00 | | |
| public | b_seat_reserve | 905591 | 0 | 0.00 | 0.00 | | 2024-10-28 11:42:26.31841+00 | | |
| public | b_seat_reserve_hour | 17001188 | 0 | 0.00 | 0.00 | | 2024-10-28 08:14:35.244134+00 | | |
| public | b_usage | 1017938 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:36.850154+00 | | |
| public | b_usage_hour | 18628359 | 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 | 35353 | 412 | 0.00 | 1.00 | | 2024-10-27 09:43:20.750605+00 | | 2024-10-08 09:37:31.834203+00 |
| public | m_favorite_group | 7593 | 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 | 1168 | 13 | 0.00 | 1.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 | 26126 | 1446 | 0.00 | 5.00 | | 2024-11-06 00:10:24.143312+00 | | 2024-11-06 00:10:24.853064+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 | 2292 | 492 | 0.00 | 17.00 | | 2024-11-03 18:39:53.37716+00 | | 2024-11-05 02:36:45.347464+00 |
| public | m_setting_log | 4799 | 216 | 0.00 | 4.00 | | 2024-11-04 12:30:59.308727+00 | | 2024-11-05 22:32:09.663876+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 | 27354 | 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 | 990 | 9 | 0.00 | 0.00 | | 2024-10-28 11:27:05.306361+00 | | |
| public | r_pot_group | 13017 | 950 | 0.00 | 6.00 | | 2024-11-05 23:13:17.893618+00 | | 2024-11-05 23:32:20.80901+00 |
| public | r_pot_tx | 10160 | 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 | 378228 | 7835 | 0.00 | 2.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 | 98451 | 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 | 542248 | 7459 | 0.00 | 1.00 | | 2024-10-28 12:32:19.904995+00 | | 2024-10-24 15:03:15.635118+00 |
| public | t_operation_log | 2466945 | 0 | 0.00 | 0.00 | | 2024-10-28 08:31:04.238095+00 | | |
| public | t_plan | 4131115 | 343140 | 0.00 | 7.00 | | 2024-10-28 01:39:53.550293+00 | | 2024-11-04 23:15:53.973291+00 |
| public | t_plan_detail | 5086797 | 213472 | 0.00 | 4.00 | | 2024-10-30 17:43:19.08068+00 | | 2024-11-05 06:05:24.60041+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | 2024-10-30 02:04:11.585106+00 | | |
| public | t_plan_sync | 233324 | 20906 | 0.00 | 8.00 | | 2024-11-03 07:46:14.898937+00 | | 2024-11-05 23:11:17.542565+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 | 6883 | 3854 | 0.00 | 35.00 | | 2024-11-06 01:44:59.607348+00 | 2024-11-05 12:42:00.592106+00 | 2024-11-06 01:44:59.637521+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-10-28 11:16:33.309088+00 | | |
| public | t_terminal | 22908 | 1152 | 0.00 | 4.00 | | 2024-11-01 00:15:46.15212+00 | | 2024-11-05 23:46:19.952004+00 |
| public | t_terminal_log | 4971148 | 0 | 0.00 | 0.00 | | 2024-10-28 08:18:00.652956+00 | | |
| public | w_arrival_notify | 1 | 6 | 6.00 | 85.00 | | 2024-10-28 08:21:01.038349+00 | | |
| public | w_latest_position | 10699 | 1724 | 0.00 | 13.00 | | 2024-11-06 01:44:54.480423+00 | | 2024-11-06 01:44:54.505108+00 |
| public | w_latest_presence | 17232 | 20078 | 1.00 | 53.00 | | 2024-11-06 01:44:59.765984+00 | | 2024-11-06 01:44:59.867972+00 |
| public | w_latest_sensor | 113 | 25 | 0.00 | 18.00 | | 2024-11-06 01:44:54.215987+00 | | 2024-11-06 01:44:54.455962+00 |
| public | w_lock | 1052 | 0 | 0.00 | 0.00 | | 2024-10-28 08:17:54.791118+00 | | |
| public | w_master_update | 17 | 24 | 1.00 | 58.00 | | 2024-11-05 06:11:53.906763+00 | | 2024-11-05 23:11:17.557241+00 |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-11-04 09:52:08.040081+00 | | |
| public | w_plan_with_detail | 4138903 | 374848 | 0.00 | 8.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 | | |