| 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 | 45457302 | 1218170 | 0.00 | 2.00 | | 2024-10-30 02:00:03.400153+00 | | |
| e202409 | a_stay_time | 23374018 | 140554 | 0.00 | 0.00 | | 2024-10-31 04:06:30.751843+00 | | 2024-10-31 04:06:41.049298+00 |
| e202409 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 06:29:45.955332+00 | | |
| e202409 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 06:29:45.977639+00 | | |
| e202409 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 06:29:45.96671+00 | | |
| e202409 | t_position_history | 452405443 | 0 | 0.00 | 0.00 | | 2024-10-30 03:26:31.339059+00 | | |
| e202409 | t_presence_history | 45407355 | 0 | 0.00 | 0.00 | | 2024-11-01 04:46:06.159008+00 | | |
| e202409 | t_sensor_history | 9170515 | 0 | 0.00 | 0.00 | | 2024-11-03 01:23:30.782582+00 | | |
| e202410 | a_proximity_sum | 37947414 | 497231 | 0.00 | 1.00 | | 2024-11-05 12:07:46.204076+00 | | 2024-10-31 07:52:03.293317+00 |
| e202410 | a_stay_time | 24669404 | 129060 | 0.00 | 0.00 | | 2024-11-06 01:44:46.868255+00 | | 2024-10-31 08:16:54.216363+00 |
| e202410 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-01 10:51:13.390761+00 | | |
| e202410 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-01 10:51:13.414401+00 | | |
| e202410 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-01 10:51:13.402495+00 | | |
| e202410 | t_position_history | 488788700 | 0 | 0.00 | 0.00 | | 2024-10-31 03:29:54.372941+00 | | 2024-10-30 02:43:29.948815+00 |
| e202410 | t_presence_history | 53388544 | 2534349 | 0.00 | 4.00 | | 2024-10-31 14:41:57.988275+00 | | 2024-10-31 14:26:50.9548+00 |
| e202410 | t_sensor_history | 9420693 | 0 | 0.00 | 0.00 | | 2024-11-05 06:10:50.413169+00 | | 2024-10-29 03:17:40.973549+00 |
| e202411 | a_proximity_sum | 6281052 | 8893 | 0.00 | 0.00 | | 2024-11-07 17:34:59.771801+00 | | 2024-11-07 17:58:14.171527+00 |
| e202411 | a_stay_time | 4472915 | 17560 | 0.00 | 0.00 | | 2024-11-07 17:48:27.27049+00 | | 2024-11-07 18:05:20.235675+00 |
| e202411 | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.917399+00 | | |
| e202411 | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.928394+00 | | |
| e202411 | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 01:20:55.939698+00 | | |
| e202411 | t_position_history | 103758066 | 0 | 0.00 | 0.00 | | 2024-11-07 17:48:19.390775+00 | | 2024-11-07 09:20:07.594965+00 |
| e202411 | t_presence_history | 11142840 | 545262 | 0.00 | 4.00 | | 2024-11-08 00:49:29.931329+00 | | 2024-11-08 00:52:42.84688+00 |
| e202411 | t_sensor_history | 2275461 | 0 | 0.00 | 0.00 | | 2024-11-06 23:03:28.462393+00 | | 2024-11-07 15:55:06.083161+00 |
| public | __digdag_status | 31 | 17 | 0.00 | 35.00 | | 2024-11-06 12:31:04.188787+00 | | 2024-11-07 08:30:57.614306+00 |
| public | a_attendance_sum | 42054 | 5373 | 0.00 | 11.00 | | 2024-11-08 00:44:13.109842+00 | | 2024-11-08 00:50:41.900321+00 |
| public | a_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:23.476002+00 | | |
| public | a_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:17.623703+00 | | |
| public | del_b_attendance_group | 0 | 0 | 0 | 0 | | 2024-11-06 22:02:36.609503+00 | | |
| public | del_b_attendance_hour | 0 | 0 | 0 | 0 | | 2024-11-06 22:11:37.99731+00 | | |
| public | del_b_check_in | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:02.988725+00 | | |
| public | del_b_check_in_hour | 0 | 0 | 0 | 0 | | 2024-11-06 22:11:38.008858+00 | | |
| public | del_b_proximity_group | 0 | 0 | 0 | 0 | | 2024-11-06 22:11:38.020417+00 | | |
| public | del_b_proximity_info | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:02.999769+00 | | |
| public | del_b_seat_reserve | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:02.977197+00 | | |
| public | del_b_seat_reserve_hour | 0 | 0 | 0 | 0 | | 2024-11-06 22:02:36.620623+00 | | |
| public | del_b_usage | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:03.010785+00 | | |
| public | del_b_usage_hour | 0 | 0 | 0 | 0 | | 2024-11-06 22:01:03.021779+00 | | |
| public | l_position_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.898449+00 | | |
| public | l_proximity_sum | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.887252+00 | | |
| public | l_stay_time | 0 | 0 | 0 | 0 | | 2024-11-05 00:57:21.875912+00 | | |
| public | m_area | 655 | 0 | 0.00 | 0.00 | | 2024-11-06 11:16:23.009611+00 | | |
| public | m_auth | 121 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.495393+00 | | |
| public | m_category | 1720 | 2 | 0.00 | 0.00 | | 2024-11-06 11:16:22.983095+00 | | |
| public | m_exb | 20899 | 456 | 0.00 | 2.00 | | 2024-11-04 11:54:27.707728+00 | | 2024-11-05 15:49:31.712072+00 |
| public | m_favorite | 212968 | 283 | 0.00 | 0.00 | | 2024-11-06 02:17:45.689012+00 | | 2024-10-08 10:00:05.802028+00 |
| public | m_favorite_group | 70338 | 187 | 0.00 | 0.00 | | 2024-10-30 05:06:49.284654+00 | | 2024-10-31 02:08:28.243557+00 |
| public | m_feature | 164 | 0 | 0.00 | 0.00 | | 2024-11-05 06:02:20.826151+00 | | |
| public | m_group | 17878 | 65 | 0.00 | 0.00 | | 2024-10-30 07:12:28.875241+00 | | |
| public | m_holiday | 25250 | 752 | 0.00 | 2.00 | | 2024-11-01 10:09:51.321615+00 | | |
| public | m_lob | 21868 | 60 | 0.00 | 0.00 | | 2024-11-02 01:10:13.539251+00 | | |
| public | m_location | 37661 | 440 | 0.00 | 1.00 | | 2024-10-31 02:20:29.749659+00 | | |
| public | m_notify_template | 731 | 15 | 0.00 | 2.00 | | 2024-11-05 00:04:23.648702+00 | | |
| public | m_outside | 319 | 2 | 0.00 | 0.00 | | 2024-10-31 08:56:16.889299+00 | | |
| public | m_pot | 161159 | 27749 | 0.00 | 14.00 | | 2024-11-06 06:07:46.221531+00 | | 2024-11-07 23:59:49.332282+00 |
| public | m_pot_profile | 49611 | 69 | 0.00 | 0.00 | | 2024-11-03 00:12:22.963099+00 | | |
| public | m_provider_user | 71 | 4 | 0.00 | 5.00 | | 2024-11-05 06:26:01.906602+00 | | |
| public | m_region | 97 | 3 | 0.00 | 3.00 | | 2024-11-05 00:04:23.740702+00 | | |
| public | m_role | 557 | 10 | 0.00 | 1.00 | | 2024-11-05 00:04:23.718635+00 | | |
| public | m_sensor | 17 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.601048+00 | | |
| public | m_setting | 21415 | 879 | 0.00 | 3.00 | | 2024-11-07 08:07:08.640607+00 | | 2024-11-06 18:15:08.646659+00 |
| public | m_setting_log | 28492 | 0 | 0.00 | 0.00 | | 2024-11-03 00:07:52.419744+00 | | 2024-11-07 18:25:30.353121+00 |
| public | m_site | 175 | 3 | 0.00 | 1.00 | | 2024-11-05 00:04:23.621472+00 | | |
| public | m_tenant | 96 | 3 | 0.00 | 3.00 | | 2024-11-05 00:04:23.889476+00 | | |
| public | m_tx | 100108 | 5690 | 0.00 | 5.00 | | 2024-11-06 02:53:12.782998+00 | | 2024-11-06 02:53:12.939486+00 |
| public | m_user | 30596 | 26 | 0.00 | 0.00 | | 2024-11-06 11:16:16.619931+00 | | |
| public | m_zone | 6593 | 25 | 0.00 | 0.00 | | 2024-11-05 15:33:52.249132+00 | | |
| public | r_auth_group | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.801691+00 | | |
| public | r_auth_zone | 222 | 0 | 0.00 | 0.00 | | 2024-11-06 03:52:28.108281+00 | | |
| public | r_exb_sensor | 4 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.672867+00 | | |
| public | r_group_auth | 588 | 0 | 0.00 | 0.00 | | 2024-11-07 08:03:08.2434+00 | | 2024-10-08 09:38:50.736835+00 |
| public | r_location_zone | 42341 | 1026 | 0.00 | 2.00 | | 2024-10-31 23:45:26.008068+00 | | 2024-10-10 09:13:16.68237+00 |
| public | r_pot_auth | 8380 | 4 | 0.00 | 0.00 | | 2024-11-06 11:53:37.67393+00 | | 2024-11-06 01:49:00.707869+00 |
| public | r_pot_category | 6965 | 0 | 0.00 | 0.00 | | 2024-11-07 20:08:33.250923+00 | | 2024-11-07 20:01:08.026975+00 |
| public | r_pot_group | 145455 | 3298 | 0.00 | 2.00 | | 2024-11-08 00:38:10.61659+00 | | 2024-11-08 00:22:33.473636+00 |
| public | r_pot_tx | 57400 | 761 | 0.00 | 1.00 | | 2024-11-02 18:58:25.722067+00 | | 2024-10-29 10:18:54.209249+00 |
| public | r_pot_user | 18841 | 40 | 0.00 | 0.00 | | 2024-10-30 07:12:28.643799+00 | | |
| public | r_provider_tenant | 1359 | 170 | 0.00 | 11.00 | | 2024-11-06 07:34:09.948857+00 | | 2024-11-06 07:34:09.9535+00 |
| public | r_role_feature | 5143 | 67 | 0.00 | 1.00 | | 2024-10-30 07:12:28.675646+00 | | |
| public | r_tenant_feature | 3569 | 0 | 0.00 | 0.00 | | 2024-11-06 22:00:57.414772+00 | | |
| public | r_tx_sensor | 313 | 14 | 0.00 | 4.00 | | 2024-10-30 02:33:27.724859+00 | | |
| public | r_user_region | 19300 | 52 | 0.00 | 0.00 | | 2024-10-30 07:12:22.073489+00 | | |
| public | r_user_site | 5090 | 14 | 0.00 | 0.00 | | 2024-11-05 00:04:23.577201+00 | | |
| public | r_zone_category | 3364 | 18 | 0.00 | 0.00 | | 2024-10-31 23:45:25.867365+00 | | 2024-10-21 14:08:10.484709+00 |
| public | t_ai_history | 17 | 0 | 0.00 | 0.00 | | 2024-11-08 00:21:33.428976+00 | | |
| public | t_attendance | 1598774 | 8781 | 0.00 | 0.00 | | 2024-11-06 22:01:32.841628+00 | | 2024-11-04 23:45:17.608246+00 |
| public | t_general | 2726 | 7 | 0.00 | 0.00 | | 2024-11-05 00:04:23.871727+00 | | |
| public | t_mobile_device_history | 655684 | 0 | 0.00 | 0.00 | | 2024-11-06 06:01:41.437322+00 | | |
| public | t_news | 3 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.697153+00 | | |
| public | t_notify_history | 3356555 | 7967 | 0.00 | 0.00 | | 2024-11-05 09:48:44.694461+00 | | 2024-10-24 22:46:31.398488+00 |
| public | t_operation_log | 12530926 | 51 | 0.00 | 0.00 | | 2024-11-01 01:01:53.828826+00 | | |
| public | t_plan | 14126096 | 1340123 | 0.00 | 8.00 | | 2024-10-29 23:27:26.161738+00 | | 2024-11-07 00:56:51.866672+00 |
| public | t_plan_detail | 24383344 | 1185326 | 0.00 | 4.00 | | 2024-11-01 16:22:50.242868+00 | | 2024-11-06 04:57:45.778793+00 |
| public | t_plan_sync | 42032 | 5161 | 0.00 | 10.00 | | 2024-11-08 00:33:33.898963+00 | | 2024-11-08 00:38:10.925441+00 |
| public | t_position_history | 68 | 0 | 0.00 | 0.00 | | 2024-11-05 00:04:23.918041+00 | | |
| public | t_presence_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.824769+00 | | |
| public | t_proximity | 0 | 0 | 0 | 0 | | 2024-11-05 00:04:23.752067+00 | | |
| public | t_recv_position_history | 117816 | 45200 | 0.00 | 27.00 | | 2024-11-08 00:52:41.563841+00 | 2024-11-07 13:30:08.564952+00 | 2024-11-08 00:52:41.971346+00 |
| public | t_sensor_history | 0 | 0 | 0 | 0 | | 2024-11-05 00:03:18.855061+00 | | |
| public | t_terminal | 105174 | 3367 | 0.00 | 3.00 | | 2024-11-02 18:58:26.981845+00 | | 2024-11-07 20:19:01.521727+00 |
| public | t_terminal_log | 12156915 | 0 | 0.00 | 0.00 | | 2024-10-31 12:58:45.492243+00 | | |
| public | w_arrival_notify | 81 | 29 | 0.00 | 26.00 | | 2024-11-06 15:01:11.429242+00 | | 2024-11-07 03:57:43.367706+00 |
| public | w_latest_position | 61880 | 10238 | 0.00 | 14.00 | | 2024-11-08 00:52:42.090584+00 | | 2024-11-08 00:52:42.208305+00 |
| public | w_latest_presence | 231288 | 81491 | 0.00 | 26.00 | | 2024-11-08 00:52:47.067932+00 | | 2024-11-08 00:52:47.475568+00 |
| public | w_latest_sensor | 340 | 203 | 0.00 | 37.00 | | 2024-11-08 00:52:42.865584+00 | | 2024-11-08 00:52:42.978115+00 |
| public | w_lock | 14762 | 0 | 0.00 | 0.00 | | 2024-10-30 04:41:31.350151+00 | | |
| public | w_master_update | 96 | 66 | 0.00 | 40.00 | | 2024-11-07 23:02:03.891934+00 | | 2024-11-08 00:31:33.145948+00 |
| public | w_migration | 795 | 29 | 0.00 | 3.00 | | 2024-11-05 00:57:21.916025+00 | | |
| public | w_plan_sync_retry | 0 | 0 | 0 | 0 | | 2024-11-04 10:00:57.243378+00 | | |
| public | w_plan_with_detail | 14193848 | 650303 | 0.00 | 4.00 | | 2024-11-05 06:56:57.073794+00 | | 2024-11-07 00:48:32.214541+00 |