| 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 | 9346778 | 0 | 0.00 | 0.00 | | 2024-05-14 04:26:30.990537+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-14 14:56:19.498021+00 | | |
| e202404 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.487395+00 | | |
| e202404 | t_position_history | 47382534 | 0 | 0.00 | 0.00 | | 2024-05-23 09:50:14.234647+00 | | |
| e202404 | t_presence_history | 6867143 | 0 | 0.00 | 0.00 | | 2024-05-15 06:28:14.379432+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 | 1708291 | 0 | 0.00 | 0.00 | | 2024-05-22 15:32:12.500698+00 | | 2024-05-24 15:31:28.686588+00 |
| e202405 | a_stay_time | 2217207 | 0 | 0.00 | 0.00 | | 2024-05-26 15:31:02.125482+00 | | 2024-05-23 15:31:14.097963+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-14 14:56:19.519649+00 | | |
| e202405 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-05-14 14:56:19.50898+00 | | |
| e202405 | t_position_history | 38520449 | 0 | 0.00 | 0.00 | | 2024-05-26 20:56:20.623747+00 | | 2024-05-24 06:34:32.965458+00 |
| e202405 | t_presence_history | 5084296 | 825457 | 0.00 | 13.00 | | 2024-05-27 01:22:47.811419+00 | | 2024-05-27 01:43:38.999427+00 |
| e202405 | t_sensor_history | 1092071 | 0 | 0.00 | 0.00 | | 2024-05-24 07:51:35.014502+00 | | 2024-05-26 04:09:36.306498+00 |
| public | __digdag_status | 12 | 7 | 0.00 | 36.00 | | 2024-05-26 12:30:48.002196+00 | | 2024-05-24 21:20:45.415168+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 | 399561 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:52.238653+00 | | 2024-05-13 17:45:28.28103+00 |
| public | b_attendance_hour | 6167975 | 189476 | 0.00 | 2.00 | | 2024-05-13 11:31:42.923437+00 | | 2024-05-12 18:30:45.192135+00 |
| public | b_attendance_pot | 10090 | 336 | 0.00 | 3.00 | | 2024-05-24 12:47:55.004082+00 | | 2024-05-24 16:50:31.475606+00 |
| public | b_attendance_pot_hour | 153030 | 11730 | 0.00 | 7.00 | | 2024-05-20 18:01:06.115388+00 | | 2024-05-23 16:51:04.159671+00 |
| public | b_check_in | 3362974 | 111524 | 0.00 | 3.00 | | 2024-05-13 13:01:21.036564+00 | | 2024-05-13 13:02:16.932229+00 |
| public | b_check_in_hour | 49980912 | 1631700 | 0.00 | 3.00 | | 2024-05-13 11:33:27.844926+00 | | 2024-05-13 11:33:31.827589+00 |
| public | b_check_in_pot | 9306 | 0 | 0.00 | 0.00 | | 2024-05-14 13:37:51.404808+00 | | 2024-05-25 16:50:41.32943+00 |
| public | b_check_in_pot_hour | 139662 | 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 | 40112002 | 1623757 | 0.00 | 3.00 | | 2024-05-13 12:26:12.512154+00 | | 2024-05-16 18:35:09.969807+00 |
| public | b_proximity_info | 34678125 | 138826 | 0.00 | 0.00 | | 2024-05-13 11:31:26.817385+00 | | 2024-05-22 16:06:13.743869+00 |
| public | b_seat_reserve | 709402 | 22876 | 0.00 | 3.00 | | 2024-05-13 12:05:31.739397+00 | | 2024-05-12 18:34:43.576137+00 |
| public | b_seat_reserve_hour | 13157334 | 0 | 0.00 | 0.00 | | 2024-05-26 20:41:50.391953+00 | | 2024-05-13 17:38:01.276617+00 |
| public | b_usage | 778547 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.523193+00 | | 2024-05-13 17:34:00.932987+00 |
| public | b_usage_hour | 14567026 | 412020 | 0.00 | 2.00 | | 2024-05-13 11:26:23.300117+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 | 1 | 0.00 | 1.00 | | 2024-05-13 13:07:30.764016+00 | | |
| public | m_auth | 9 | 0 | 0.00 | 0.00 | | 2024-05-13 11:31:42.94183+00 | | |
| public | m_category | 455 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.700874+00 | | |
| public | m_exb | 3790 | 166 | 0.00 | 4.00 | | 2024-05-13 13:07:30.811731+00 | | |
| public | m_favorite | 36040 | 624 | 0.00 | 1.00 | | 2024-05-13 11:33:32.274346+00 | | |
| public | m_feature | 161 | 0 | 0.00 | 0.00 | | 2024-05-13 13:09:31.014217+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 | 13 | 0.00 | 0.00 | | 2024-05-13 11:36:31.511653+00 | | |
| public | m_location | 5357 | 0 | 0.00 | 0.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 | 23837 | 1089 | 0.00 | 4.00 | | 2024-05-27 00:10:13.42412+00 | | 2024-05-27 00:10:14.210086+00 |
| public | m_pot_profile | 669 | 41 | 0.00 | 5.00 | | 2024-05-13 11:31:27.704216+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-13 13:07:30.880976+00 | | |
| public | m_role | 76 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.842935+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-05-13 13:01:13.579029+00 | | |
| public | m_setting | 3163 | 122 | 0.00 | 3.00 | | 2024-05-26 13:38:13.055806+00 | | 2024-05-26 10:31:08.769216+00 |
| public | m_setting_log | 4250 | 0 | 0.00 | 0.00 | | 2024-05-26 12:30:47.792018+00 | | 2024-05-26 12:30:47.900199+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 | 14936 | 1998 | 0.00 | 11.00 | | 2024-05-17 09:49:36.301144+00 | | 2024-05-22 10:43:45.349889+00 |
| public | m_user | 977 | 5 | 0.00 | 0.00 | | 2024-05-15 05:24:17.845591+00 | | |
| public | m_zone | 742 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.756803+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-05-13 12:05:47.720658+00 | | |
| public | r_auth_zone | 16 | 0 | 0.00 | 0.00 | | 2024-05-13 13:01:13.556501+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-13 12:05:29.8704+00 | | |
| public | r_location_zone | 3857 | 0 | 0.00 | 0.00 | | 2024-05-26 17:34:03.006031+00 | | 2024-05-17 09:40:01.219765+00 |
| public | r_pot_auth | 21 | 0 | 0.00 | 0.00 | | 2024-05-13 11:31:42.965339+00 | | |
| public | r_pot_category | 973 | 3 | 0.00 | 0.00 | | 2024-05-13 11:36:31.590838+00 | | |
| public | r_pot_group | 10682 | 0 | 0.00 | 0.00 | | 2024-05-27 01:43:34.531713+00 | | 2024-05-27 01:43:37.791975+00 |
| public | r_pot_tx | 8229 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:55.663389+00 | | |
| public | r_pot_user | 699 | 8 | 0.00 | 1.00 | | 2024-05-15 05:24:17.650352+00 | | |
| public | r_provider_tenant | 189 | 0 | 0.00 | 0.00 | | 2024-05-24 01:51:16.810748+00 | | |
| public | r_role_feature | 688 | 5 | 0.00 | 0.00 | | 2024-05-13 13:07:30.826875+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 | 848 | 7 | 0.00 | 0.00 | | 2024-05-15 05:24:17.717816+00 | | |
| public | r_user_site | 741 | 4 | 0.00 | 0.00 | | 2024-05-15 05:24:17.691913+00 | | |
| public | r_zone_category | 662 | 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-15 03:52:59.366364+00 | | |
| public | t_attendance | 305507 | 22775 | 0.00 | 6.00 | | 2024-05-13 13:07:01.11428+00 | | 2024-05-17 18:32:24.911297+00 |
| public | t_general | 30 | 0 | 0.00 | 0.00 | | 2024-05-13 13:07:30.86548+00 | | |
| public | t_mobile_device_history | 77551 | 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 | 410677 | 19454 | 0.00 | 4.00 | | 2024-05-13 13:07:34.298953+00 | | 2024-05-25 18:33:03.129927+00 |
| public | t_operation_log | 1911693 | 0 | 0.00 | 0.00 | | 2024-05-26 22:12:16.045671+00 | | 2024-05-22 05:27:44.476293+00 |
| public | t_plan | 3197751 | 516974 | 0.00 | 13.00 | | 2024-05-13 11:35:30.301556+00 | | 2024-05-23 04:54:12.315119+00 |
| public | t_plan_detail | 3655075 | 464779 | 0.00 | 11.00 | | 2024-05-13 13:10:07.054646+00 | | 2024-05-24 04:01:06.162006+00 |
| public | t_plan_new | 0 | 0 | 0 | 0 | | | | |
| public | t_plan_sync | 16544 | 1274 | 0.00 | 7.00 | | 2024-05-26 23:32:54.692891+00 | | 2024-05-27 00:51:47.710355+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-13 11:25:50.228895+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-05-13 11:36:31.530663+00 | | |
| public | t_recv_position_history | 7284 | 3556 | 0.00 | 32.00 | | 2024-05-27 01:44:34.027147+00 | 2024-05-26 12:42:01.02628+00 | 2024-05-27 01:44:34.071688+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-05-13 11:30:24.044351+00 | | |
| public | t_terminal | 15189 | 2518 | 0.00 | 14.00 | | 2024-05-19 05:38:57.632115+00 | | 2024-05-27 00:21:14.95724+00 |
| public | t_terminal_log | 3824166 | 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 | 10839 | 2512 | 0.00 | 18.00 | | 2024-05-27 01:44:33.912993+00 | | 2024-05-27 01:44:33.946161+00 |
| public | w_latest_presence | 17318 | 41979 | 2.00 | 70.00 | | 2024-05-27 01:44:34.184524+00 | | 2024-05-27 01:44:34.372439+00 |
| public | w_latest_sensor | 113 | 47 | 0.00 | 29.00 | | 2024-05-27 01:43:37.807728+00 | | 2024-05-27 01:43:38.03881+00 |
| public | w_lock | 988 | 0 | 0.00 | 0.00 | | 2024-05-26 20:43:52.715739+00 | | |
| public | w_master_update | 15 | 4 | 0.00 | 21.00 | | 2024-05-27 00:41:46.948112+00 | | 2024-05-26 06:01:01.137821+00 |
| public | w_plan_with_detail | 3194591 | 536566 | 0.00 | 14.00 | | 2024-05-13 07:26:21.957432+00 | | 2024-05-24 09:10:02.992025+00 |
| public | w_plan_with_detail_new | 33 | 1 | 0.00 | 2.00 | | | | |