| 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 |
|---|
| e202403 | a_proximity_sum | 676307 | 0 | 0.00 | 0.00 | | 2024-05-20 01:05:16.065171+00 | | |
| e202403 | a_stay_time | 2220173 | 0 | 0.00 | 0.00 | | 2024-05-20 03:45:51.625943+00 | | |
| e202403 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.476721+00 | | |
| e202403 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.712258+00 | | |
| e202403 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-14 13:00:53.87342+00 | | |
| e202403 | t_position_history | 31270592 | 0 | 0.00 | 0.00 | | 2024-05-10 02:50:37.680742+00 | | |
| e202403 | t_presence_history | 9346747 | 0 | 0.00 | 0.00 | | 2024-05-27 10:25:16.557616+00 | | |
| e202403 | t_sensor_history | 1264956 | 0 | 0.00 | 0.00 | | 2024-05-22 04:03:03.484984+00 | | |
| e202404 | a_proximity_sum | 3117508 | 0 | 0.00 | 0.00 | | 2024-05-25 03:42:41.125741+00 | | |
| e202404 | a_stay_time | 2915987 | 0 | 0.00 | 0.00 | | 2024-05-22 06:11:33.971169+00 | | |
| e202404 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-26 21:13:21.975465+00 | | |
| e202404 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-28 01:50:20.216005+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-28 01:50:20.205161+00 | | |
| e202404 | t_position_history | 47382534 | 0 | 0.00 | 0.00 | | 2024-05-23 09:50:14.234647+00 | | |
| e202404 | t_presence_history | 6867099 | 0 | 0.00 | 0.00 | | 2024-05-28 11:23:46.911052+00 | | 2024-04-30 14:47:32.149293+00 |
| e202404 | t_sensor_history | 1154976 | 0 | 0.00 | 0.00 | | 2024-05-25 16:06:03.305219+00 | | 2024-04-28 22:43:41.720491+00 |
| e202405 | a_proximity_sum | 1865137 | 0 | 0.00 | 0.00 | | 2024-05-28 15:31:43.116358+00 | | 2024-05-28 15:31:45.965856+00 |
| e202405 | a_stay_time | 2465946 | 0 | 0.00 | 0.00 | | 2024-05-26 15:31:02.125482+00 | | 2024-05-27 15:30:52.2474+00 |
| e202405 | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-26 21:13:21.986166+00 | | |
| e202405 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-28 01:50:20.534855+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-28 01:50:20.524006+00 | | |
| e202405 | t_position_history | 42173791 | 0 | 0.00 | 0.00 | | 2024-05-26 20:56:20.623747+00 | | 2024-05-27 14:05:31.287503+00 |
| e202405 | t_presence_history | 5650519 | 1009600 | 0.00 | 15.00 | | 2024-05-29 01:17:07.235106+00 | | 2024-05-29 01:34:19.105141+00 |
| e202405 | t_sensor_history | 1172630 | 0 | 0.00 | 0.00 | | 2024-05-24 07:51:35.014502+00 | | 2024-05-28 18:57:43.773123+00 |
| public | __digdag_status | 7 | 27 | 3.00 | 79.00 | | 2024-05-26 12:30:48.002196+00 | | 2024-05-28 12:30:45.106975+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-26 20:43:53.387414+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-05-26 20:43:53.353729+00 | | |
| public | b_attendance_group | 400391 | 1890 | 0.00 | 0.00 | | 2024-05-26 20:43:52.238653+00 | | 2024-05-13 17:45:28.28103+00 |
| public | b_attendance_hour | 6015475 | 28073 | 0.00 | 0.00 | | 2024-05-27 01:53:32.506463+00 | | 2024-05-12 18:30:45.192135+00 |
| public | b_attendance_pot | 10094 | 560 | 0.00 | 5.00 | | 2024-05-24 12:47:55.004082+00 | | 2024-05-24 16:50:31.475606+00 |
| public | b_attendance_pot_hour | 153090 | 15090 | 0.00 | 8.00 | | 2024-05-20 18:01:06.115388+00 | | 2024-05-28 16:53:23.448232+00 |
| public | b_check_in | 3257934 | 16064 | 0.00 | 0.00 | | 2024-05-27 02:42:39.167386+00 | | 2024-05-13 13:02:16.932229+00 |
| public | b_check_in_hour | 48453205 | 234090 | 0.00 | 0.00 | | 2024-05-27 01:55:06.863707+00 | | 2024-05-13 11:33:31.827589+00 |
| public | b_check_in_pot | 9504 | 0 | 0.00 | 0.00 | | 2024-05-28 01:27:35.49262+00 | | 2024-05-25 16:50:41.32943+00 |
| public | b_check_in_pot_hour | 143082 | 0 | 0.00 | 0.00 | | 2024-05-16 16:51:19.883671+00 | | 2024-05-22 16:51:13.392525+00 |
| public | b_proximity_group | 38728579 | 230878 | 0.00 | 0.00 | | 2024-05-27 02:23:28.202388+00 | | 2024-05-16 18:35:09.969807+00 |
| public | b_proximity_info | 35066048 | 17550 | 0.00 | 0.00 | | 2024-05-27 01:53:17.712093+00 | | 2024-05-22 16:06:13.743869+00 |
| public | b_seat_reserve | 689659 | 3400 | 0.00 | 0.00 | | 2024-05-27 02:12:10.117048+00 | | 2024-05-12 18:34:43.576137+00 |
| public | b_seat_reserve_hour | 13187252 | 59850 | 0.00 | 0.00 | | 2024-05-26 20:41:50.391953+00 | | 2024-05-13 17:38:01.276617+00 |
| public | b_usage | 780437 | 3400 | 0.00 | 0.00 | | 2024-05-26 20:43:55.523193+00 | | 2024-05-13 17:34:00.932987+00 |
| public | b_usage_hour | 14223644 | 59850 | 0.00 | 0.00 | | 2024-05-27 01:51:06.132274+00 | | 2024-05-13 17:46:28.118293+00 |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-05-26 21:03:44.015528+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-05-26 21:03:44.004758+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-26 21:03:43.993951+00 | | |
| public | m_area | 98 | 0 | 0.00 | 0.00 | | 2024-05-27 02:50:05.51117+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-05-27 01:53:32.524864+00 | | |
| public | m_category | 456 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.700874+00 | | |
| public | m_exb | 4835 | 35 | 0.00 | 0.00 | | 2024-05-27 02:50:05.629079+00 | | |
| public | m_favorite | 36137 | 70 | 0.00 | 0.00 | | 2024-05-27 01:55:07.948582+00 | | |
| public | m_feature | 162 | 0 | 0.00 | 0.00 | | 2024-05-27 02:50:15.561486+00 | | |
| public | m_group | 2613 | 0 | 0.00 | 0.00 | | 2024-05-21 11:10:31.38581+00 | | |
| public | m_holiday | 5801 | 0 | 0.00 | 0.00 | | 2024-05-26 21:03:44.035079+00 | | |
| public | m_lob | 2271 | 0 | 0.00 | 0.00 | | 2024-05-27 01:56:07.607556+00 | | |
| public | m_location | 5393 | 108 | 0.00 | 1.00 | | 2024-05-26 20:43:53.564469+00 | | |
| public | m_notify_template | 119 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.55891+00 | | |
| public | m_outside | 57 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:53.581101+00 | | |
| public | m_pot | 23846 | 1287 | 0.00 | 5.00 | | 2024-05-29 00:10:55.131772+00 | | 2024-05-29 00:10:55.762174+00 |
| public | m_pot_profile | 671 | 0 | 0.00 | 0.00 | | 2024-05-27 01:53:18.318294+00 | | 2024-05-24 01:20:33.798494+00 |
| public | m_provider_user | 58 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:53.342894+00 | | |
| public | m_region | 15 | 0 | 0.00 | 0.00 | | 2024-05-27 02:50:11.805974+00 | | |
| public | m_role | 76 | 1 | 0.00 | 1.00 | | 2024-05-27 02:50:11.767384+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-05-27 02:42:32.161115+00 | | |
| public | m_setting | 2957 | 146 | 0.00 | 4.00 | | 2024-05-28 11:47:26.115668+00 | | 2024-05-27 21:55:04.764356+00 |
| public | m_setting_log | 4258 | 494 | 0.00 | 10.00 | | 2024-05-26 12:30:47.792018+00 | | 2024-05-28 12:30:44.817592+00 |
| public | m_site | 22 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.538736+00 | | |
| public | m_tenant | 15 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:53.299917+00 | | |
| public | m_tx | 14988 | 2 | 0.00 | 0.00 | | 2024-05-28 01:47:15.23991+00 | | 2024-05-28 01:47:15.343258+00 |
| public | m_user | 977 | 0 | 0.00 | 0.00 | | 2024-05-28 10:10:41.646512+00 | | |
| public | m_zone | 750 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.756803+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-05-27 02:12:10.128179+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-05-27 02:42:32.133523+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.581943+00 | | |
| public | r_group_auth | 320 | 0 | 0.00 | 0.00 | | 2024-05-27 02:12:08.357201+00 | | |
| public | r_location_zone | 3352 | 108 | 0.00 | 3.00 | | 2024-05-26 17:34:03.006031+00 | | 2024-05-27 07:45:23.854768+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-05-27 01:53:32.547685+00 | | |
| public | r_pot_category | 974 | 0 | 0.00 | 0.00 | | 2024-05-27 01:56:07.667051+00 | | |
| public | r_pot_group | 11004 | 1039 | 0.00 | 8.00 | | 2024-05-28 23:12:46.085211+00 | | 2024-05-28 23:33:51.530048+00 |
| public | r_pot_tx | 8233 | 10 | 0.00 | 0.00 | | 2024-05-26 20:43:55.663389+00 | | |
| public | r_pot_user | 694 | 0 | 0.00 | 0.00 | | 2024-05-28 10:10:41.511178+00 | | |
| public | r_provider_tenant | 189 | 0 | 0.00 | 0.00 | | 2024-05-24 01:51:16.810748+00 | | |
| public | r_role_feature | 688 | 1 | 0.00 | 0.00 | | 2024-05-27 02:50:11.751039+00 | | |
| public | r_tenant_feature | 541 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:53.323229+00 | | |
| public | r_tx_sensor | 109 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.68095+00 | | |
| public | r_user_region | 843 | 0 | 0.00 | 0.00 | | 2024-05-28 10:10:41.559015+00 | | |
| public | r_user_site | 736 | 0 | 0.00 | 0.00 | | 2024-05-28 10:10:41.536588+00 | | |
| public | r_zone_category | 670 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:53.376381+00 | | 2024-05-15 11:06:59.505804+00 |
| public | t_ai_history | 0 | 0 | 0 | 0 | | 2024-05-28 08:33:39.114921+00 | | |
| public | t_attendance | 388182 | 3509 | 0.00 | 0.00 | | 2024-05-27 02:50:11.727443+00 | | 2024-05-17 18:32:24.911297+00 |
| public | t_general | 30 | 0 | 0.00 | 0.00 | | 2024-05-27 02:50:11.790043+00 | | |
| public | t_mobile_device_history | 78935 | 0 | 0.00 | 0.00 | | 2024-05-26 23:02:09.794125+00 | | |
| public | t_news | 0 | 0 | 0 | 0 | | 2024-05-26 20:43:55.592605+00 | | |
| public | t_notify_history | 443490 | 3600 | 0.00 | 0.00 | | 2024-05-27 02:50:15.541056+00 | | 2024-05-25 18:33:03.129927+00 |
| public | t_operation_log | 1923811 | 5492 | 0.00 | 0.00 | | 2024-05-26 22:12:16.045671+00 | | 2024-05-22 05:27:44.476293+00 |
| public | t_plan | 3222419 | 312865 | 0.00 | 8.00 | | 2024-05-13 11:35:30.301556+00 | | 2024-05-29 00:23:56.990518+00 |
| public | t_plan_detail | 3654182 | 208954 | 0.00 | 5.00 | | 2024-05-13 13:10:07.054646+00 | | 2024-05-28 03:28:42.047309+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | | | |
| public | t_plan_sync | 16550 | 2235 | 0.00 | 11.00 | | 2024-05-28 23:32:48.583638+00 | | 2024-05-29 00:52:14.59505+00 |
| public | t_position_history | 0 | 0 | 0 | 0 | | 2024-05-26 20:43:53.275414+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-05-27 01:50:34.147919+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-05-27 01:56:07.626525+00 | | |
| public | t_recv_position_history | 7567 | 771 | 0.00 | 9.00 | | 2024-05-29 01:45:20.446543+00 | 2024-05-28 12:42:00.922553+00 | 2024-05-29 01:45:20.476757+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-05-27 01:52:07.207854+00 | | |
| public | t_terminal | 15285 | 2676 | 0.00 | 14.00 | | 2024-05-19 05:38:57.632115+00 | | 2024-05-28 23:24:48.471009+00 |
| public | t_terminal_log | 3843510 | 0 | 0.00 | 0.00 | | 2024-05-26 20:44:04.454232+00 | | |
| public | w_arrival_notify | 1 | 1 | 1.00 | 50.00 | | 2024-05-26 21:13:21.96418+00 | | |
| public | w_latest_position | 10846 | 2210 | 0.00 | 16.00 | | 2024-05-29 01:44:19.986694+00 | | 2024-05-29 01:45:20.357208+00 |
| public | w_latest_presence | 17327 | 6402 | 0.00 | 26.00 | | 2024-05-29 01:45:20.608639+00 | | 2024-05-29 01:45:20.792777+00 |
| public | w_latest_sensor | 113 | 66 | 0.00 | 36.00 | | 2024-05-29 01:43:19.8837+00 | | 2024-05-29 01:45:20.312434+00 |
| public | w_lock | 988 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:52.715739+00 | | |
| public | w_master_update | 15 | 48 | 3.00 | 76.00 | | 2024-05-27 23:11:41.410444+00 | | 2024-05-28 07:14:44.091785+00 |
| public | w_plan_with_detail | 3219936 | 320328 | 0.00 | 9.00 | | 2024-05-13 07:26:21.957432+00 | | 2024-05-28 00:47:24.510769+00 |
| public | w_plan_with_detail_new | 33 | 1 | 0.00 | 2.00 | | | | |