Hi PostgreSQL admins,
(PostgreSQL v9.5.9)
The author of this SQL indicates that any output for the hot_update_ratio that falls below 0.95 indicates that action needs to be taken over and above the autovacuuming that is setup for this DB based on its levels of bloat.
My questions are:
1. Is this an accurate statement in your opinion for this and all PostgreSQL v9.5.9 DB's?
2. Given that about 60 of the tables qualify for this statement, what would be the best next step(s) to get them to be above 0.95 and remain there at this point?
3. What specific ongoing/regular step(s) need to occur outside of the hourly and weekly commands currently being run on the DB for it to remain in an optimally performant state?
Hourly:
REINDEX TABLE miq_queue
REINDEX TABLE miq_workers
REINDEX TABLE metrics_$(date -u +"%H" --date='+1 hours ' )
Weekly:
\timing
VACUUM full verbose vms ;
vacuum full verbose binary_blob_parts ;
vacuum full verbose binary_blobs ;
vacuum full verbose customization_specs ;
vacuum full verbose firewall_rules ;
Vacuum full verbose hosts ;
vacuum full verbose storages ;
vacuum full verbose miq_schedules ;
vacuum full verbose event_logs ;
vacuum full verbose policy_events ;
vacuum full verbose snapshots ;
vacuum full verbose jobs ;
vacuum full verbose networks ;
vacuum full verbose miq_queue ;
vacuum full verbose miq_request_tasks ;
vacuum full verbose miq_workers;
vacuum full verbose miq_servers;
vacuum full verbose miq_searches;
vacuum full verbose miq_scsi_luns ;
vacuum full verbose miq_scsi_targets;
vacuum full verbose storage_files ;
vacuum full verbose taggings ;
vacuum full verbose vim_performance_states;
--vacuum full verbose ems_events ;
REINDEX TABLE miq_queue
REINDEX TABLE miq_workers
REINDEX TABLE metrics_$(date -u +"%H" --date='+1 hours ' )
Weekly:
\timing
VACUUM full verbose vms ;
vacuum full verbose binary_blob_parts ;
vacuum full verbose binary_blobs ;
vacuum full verbose customization_specs ;
vacuum full verbose firewall_rules ;
Vacuum full verbose hosts ;
vacuum full verbose storages ;
vacuum full verbose miq_schedules ;
vacuum full verbose event_logs ;
vacuum full verbose policy_events ;
vacuum full verbose snapshots ;
vacuum full verbose jobs ;
vacuum full verbose networks ;
vacuum full verbose miq_queue ;
vacuum full verbose miq_request_tasks ;
vacuum full verbose miq_workers;
vacuum full verbose miq_servers;
vacuum full verbose miq_searches;
vacuum full verbose miq_scsi_luns ;
vacuum full verbose miq_scsi_targets;
vacuum full verbose storage_files ;
vacuum full verbose taggings ;
vacuum full verbose vim_performance_states;
--vacuum full verbose ems_events ;
section of postgresql.conf:
#------------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#------------------------------------------------------------------------------
autovacuum = on # MIQ Value;
#autovacuum = on # Enable autovacuum subprocess? 'on'
# requires track_counts to also be on.
log_autovacuum_min_duration = 0 # MIQ Value;
#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and
# their durations, > 0 logs only
# actions running at least this number
# of milliseconds.
#autovacuum_max_workers = 3 # max number of autovacuum subprocesses
# (change requires restart)
autovacuum_naptime = 5min # MIQ Value;
#autovacuum_naptime = 1min # time between autovacuum runs
autovacuum_vacuum_threshold = 500 # MIQ Value;
#autovacuum_vacuum_threshold = 50 # min number of row updates before
# vacuum
autovacuum_analyze_threshold = 500 # MIQ Value;
#autovacuum_analyze_threshold = 50 # min number of row updates before
# analyze
autovacuum_vacuum_scale_factor = 0.05 # MIQ Value;
#autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum
#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze
#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
# (change requires restart)
#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for
# autovacuum, in milliseconds;
# -1 means use vacuum_cost_delay
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
# autovacuum, -1 means use
# vacuum_cost_limit
#------------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#-----------------------------
autovacuum = on # MIQ Value;
#autovacuum = on # Enable autovacuum subprocess? 'on'
log_autovacuum_min_duration = 0 # MIQ Value;
#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and
#autovacuum_max_workers = 3 # max number of autovacuum subprocesses
autovacuum_naptime = 5min # MIQ Value;
#autovacuum_naptime = 1min # time between autovacuum runs
autovacuum_vacuum_threshold = 500 # MIQ Value;
#autovacuum_vacuum_threshold = 50 # min number of row updates before
autovacuum_analyze_threshold = 500 # MIQ Value;
#autovacuum_analyze_threshold = 50 # min number of row updates before
autovacuum_vacuum_scale_factor = 0.05 # MIQ Value;
#autovacuum_vacuum_scale_facto
#autovacuum_analyze_scale_fact
#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
#-----------------------------
Thanks in advance for your advice on this tuning topic.
-bash-4.2$ psql -f bloatcheck.sql vmdb_production CREATE VIEW nspname | relname | n_tup_ins | n_tup_upd | n_tup_del | hot_update_ratio | n_live_tup | n_dead_tup | reltuples | av_threshold | last_vacuum | last_analyze | av_needed | pct_dead ---------+----------------------------------------------------+-----------+-----------+-----------+---------------------+------------+------------+-------------+--------------+------------------------+--------------+-----------+--------- - public | relationships | 274 | 2 | 238 | 0 | 16865 | 79 | 16887 | 1344 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_approvals | 7687 | 7687 | 0 | 0 | 93340 | 2789 | 90559 | 5028 | 2018-03-18 10:43:00+00 | | f | 3 public | sessions | 1579 | 325681 | 1546 | 0 | 69 | 204 | 108 | 505 | 2018-03-22 20:17:00+00 | | f | 189 public | policy_events | 148 | 148 | 411 | 0 | 32 | 559 | 4996 | 750 | | | f | 11 public | networks | 2560 | 1132 | 2537 | 0 | 11502 | 90 | 11492 | 1075 | 2018-03-16 10:20:00+00 | | f | 1 public | guest_devices | 1286 | 63 | 1243 | 0 | 12445 | 446 | 12063 | 1103 | 2018-03-16 08:04:00+00 | | f | 4 public | metrics_04 | 7728558 | 140765 | 0 | 0.00667779632721202 | 10220294 | 68325 | 9.54162e+06 | 477581 | 2018-03-19 05:25:00+00 | | f | 1 public | metrics_03 | 7742038 | 198107 | 0 | 0.00679935590362784 | 10266758 | 106239 | 1.01946e+07 | 510228 | 2018-03-17 22:43:00+00 | | f | 1 public | metrics_02 | 7737370 | 201098 | 0 | 0.00809555540084934 | 10229316 | 122382 | 1.00075e+07 | 500876 | 2018-03-17 15:52:00+00 | | f | 1 public | metrics_05 | 7756692 | 62766 | 0 | 0.00817321479782048 | 10212277 | 0 | 9.55366e+06 | 478183 | 2018-03-22 03:26:00+00 | | f | 0 public | metrics_00 | 7724563 | 195559 | 2232021 | 0.00840155656349235 | 7522185 | 364728 | 7.65498e+06 | 383249 | 2018-03-21 22:35:00+00 | | f | 5 public | metrics_07 | 7923824 | 2121 | 0 | 0.00895803866100896 | 11035442 | 1512 | 1.06203e+07 | 531516 | 2018-03-16 18:24:00+00 | | f | 0 public | metrics_01 | 7744684 | 200453 | 0 | 0.00936877971394791 | 10262207 | 59452 | 9.99866e+06 | 500433 | 2018-03-20 07:09:00+00 | | f | 1 public | metrics_06 | 7773815 | 15936 | 0 | 0.0118599397590361 | 10514880 | 3504 | 9.91114e+06 | 496057 | 2018-03-21 04:34:00+00 | | f | 0 public | metrics_15 | 8266840 | 4520 | 0 | 0.0134955752212389 | 21074415 | 1632 | 2.0933e+07 | 1047152 | 2018-03-20 04:48:00+00 | | f | 0 public | metrics_08 | 7920447 | 1830 | 0 | 0.0153005464480874 | 11038225 | 105 | 1.1035e+07 | 552248 | 2018-03-20 01:58:00+00 | | f | 0 public | miq_queue | 3691605 | 3142465 | 2772041 | 0.0166188008458328 | 1183006 | 47322 | 1.19921e+06 | 60460 | 2018-03-22 17:47:00+00 | | f | 4 public | metrics_16 | 8378442 | 2829 | 0 | 0.0173206079886886 | 33688360 | 30 | 3.30576e+07 | 1653381 | 2018-03-22 16:29:00+00 | | f | 0 public | operating_systems | 95 | 101 | 68 | 0.0198019801980198 | 7172 | 46 | 7174 | 859 | 2018-03-20 23:35:00+00 | | f | 1 public | binary_blobs | 31627 | 12038 | 31371 | 0.0209337099185911 | 24102 | 1554 | 24060 | 1703 | 2018-03-22 00:50:00+00 | | f | 6 public | metrics_19 | 7994097 | 1999 | 0 | 0.0220110055027514 | 63188219 | 3122 | 6.29735e+07 | 3149173 | 2018-03-16 22:47:00+00 | | f | 0 public | metrics_12 | 7879307 | 1457 | 0 | 0.0233356211393274 | 17864558 | 202 | 1.73064e+07 | 865822 | 2018-03-21 05:19:00+00 | | f | 0 public | metrics_18 | 8198678 | 5727 | 0 | 0.0253186659682207 | 64271942 | 9385 | 6.38283e+07 | 3191917 | 2018-03-16 14:05:00+00 | | f | 0 public | vim_performance_tag_values | 28751303 | 672551 | 3551644 | 0.0256872712998717 | 2247525939 | 2833262 | 2.23155e+09 | 111578241 | 2018-03-14 20:44:00+00 | | f | 0 public | metrics_09 | 7488116 | 1538 | 0 | 0.0273081924577373 | 12207365 | 678 | 1.2078e+07 | 604400 | 2018-03-17 22:58:00+00 | | f | 0 public | metrics_14 | 8221821 | 3191 | 0 | 0.0291444688185522 | 19982841 | 140 | 1.99822e+07 | 999609 | 2018-03-19 10:26:00+00 | | f | 0 public | metrics_17 | 8305477 | 2304 | 0 | 0.0347222222222222 | 63422942 | 1001 | 6.2881e+07 | 3144550 | 2018-03-16 04:30:00+00 | | f | 0 public | metrics_13 | 7797992 | 2651 | 0 | 0.038853262919653 | 18002230 | 225 | 1.74231e+07 | 871656 | 2018-03-21 07:47:00+00 | | f | 0 public | metrics_20 | 7796794 | 1017 | 0 | 0.04031465093412 | 62773682 | 381 | 6.27844e+07 | 3139722 | 2018-03-16 23:18:00+00 | | f | 0 public | metrics_11 | 7757587 | 1022 | 0 | 0.0450097847358121 | 14624606 | 181 | 1.42438e+07 | 712691 | 2018-03-21 06:58:00+00 | | f | 0 public | metrics_21 | 7743360 | 575 | 0 | 0.0521739130434783 | 62200111 | 649 | 6.22214e+07 | 3111572 | 2018-03-17 06:17:00+00 | | f | 0 public | metrics_10 | 7275585 | 690 | 0 | 0.0623188405797101 | 12154026 | 129 | 1.15579e+07 | 578397 | 2018-03-19 09:21:00+00 | | f | 0 public | metrics_23 | 7717655 | 516 | 0 | 0.0794573643410853 | 62464104 | 133 | 6.18317e+07 | 3092085 | 2018-03-17 13:27:00+00 | | f | 0 public | miq_searches | 0 | 3025 | 0 | 0.0852892561983471 | 156 | 0 | 156 | 508 | 2018-03-21 11:21:00+00 | | f | 0 public | jobs | 79 | 553 | 0 | 0.106690777576854 | 79 | 497 | 8689 | 934 | | | f | 6 public | metrics_22 | 7615447 | 512 | 0 | 0.107421875 | 62359993 | 134 | 6.17214e+07 | 3086571 | 2018-03-17 18:39:00+00 | | f | 0 public | miq_reports | 0 | 1925 | 0 | 0.137662337662338 | 789 | 535 | 1328 | 566 | 2018-03-21 11:17:00+00 | | f | 40 public | metric_rollups_03 | 530991 | 56625 | 0 | 0.206905077262693 | 1316367 | 18916 | 1.22644e+06 | 61822 | 2018-03-17 14:44:00+00 | | f | 2 public | disks | 1585 | 415 | 1548 | 0.296385542168675 | 7011 | 340 | 7251 | 863 | 2018-03-16 15:55:00+00 | | f | 5 public | snapshots | 1431 | 973797 | 1403 | 0.334799758060458 | 6610 | 0 | 6610 | 830 | 2018-03-22 20:23:00+00 | | f | 0 public | miq_tasks | 92522 | 478763 | 64658 | 0.366222953737026 | 422222 | 13624 | 422155 | 21608 | 2018-03-22 03:43:00+00 | | f | 3 public | hardwares | 95 | 226 | 68 | 0.526548672566372 | 7172 | 35 | 7169 | 858 | 2018-03-20 15:54:00+00 | | f | 0 public | miq_widgets | 0 | 3722 | 0 | 0.534390112842558 | 47 | 391 | 47 | 502 | 2018-03-21 11:16:00+00 | | f | 832 public | miq_report_results | 38305 | 31257 | 38337 | 0.577630610743194 | 823 | 41 | 842 | 542 | 2018-03-22 18:06:00+00 | | f | 5 public | event_streams | 319474 | 222918 | 48325 | 0.596986335782664 | 13995751 | 43251 | 1.39563e+07 | 698313 | 2018-03-18 08:59:00+00 | | f | 0 public | miq_workers | 80815 | 24917923 | 80815 | 0.655719459442908 | 370 | 436 | 370 | 518 | 2018-03-22 20:23:00+00 | | f | 118 public | vms | 93 | 407167 | 68 | 0.704165612635602 | 6660 | 444 | 6660 | 833 | 2018-03-22 19:56:00+00 | | f | 7 public | vim_performance_operating_ranges | 2 | 5324 | 53 | 0.750375657400451 | 4872 | 579 | 4895 | 745 | 2018-03-19 15:48:00+00 | | f | 12 public | storages | 4 | 28360 | 0 | 0.81311706629055 | 160 | 281 | 160 | 508 | 2018-03-22 07:36:00+00 | | f | 176 public | miq_sets | 0 | 11 | 0 | 0.818181818181818 | 304 | 0 | 304 | 515 | 2018-03-20 23:35:00+00 | | f | 0 public | service_orders | 38 | 76 | 0 | 0.828947368421053 | 436 | 31 | 419 | 521 | 2018-03-18 02:06:00+00 | | f | 7 public | dialog_fields | 450 | 450 | 450 | 0.855555555555556 | 1738 | 497 | 2278 | 614 | 2018-03-21 11:18:00+00 | | f | 22 public | miq_servers | 0 | 1060045 | 0 | 0.894521458994665 | 23 | 271 | 23 | 501 | 2018-03-22 20:16:00+00 | | f | 1178 public | services | 81 | 2102 | 25 | 0.89581351094196 | 2666 | 449 | 2652 | 633 | 2018-03-16 03:56:00+00 | | f | 17 public | miq_widget_contents | 0 | 14829 | 0 | 0.913210600849686 | 608 | 248 | 608 | 530 | 2018-03-21 03:00:00+00 | | f | 41 public | resource_actions | 475 | 25 | 450 | 0.92 | 2181 | 468 | 2175 | 609 | 2018-03-18 02:06:00+00 | | f | 22 public | users | 6 | 854 | 0 | 0.92271662763466 | 433 | 119 | 431 | 522 | 2018-03-19 15:33:00+00 | | f | 28 public | hosts | 2 | 18433 | 0 | 0.922909998372484 | 452 | 237 | 452 | 523 | 2018-03-16 15:04:00+00 | | f | 52 public | miq_requests | 7687 | 83604 | 0 | 0.92530261709966 | 93292 | 4382 | 92978 | 5149 | 2018-03-18 18:27:00+00 | | f | 5 public | miq_schedules | 0 | 4426 | 0 | 0.929281518300949 | 63 | 57 | 63 | 503 | 2018-03-17 13:00:00+00 | | f | 90 public | miq_request_tasks | 7687 | 45284 | 0 | 0.95172687925095 | 92420 | 3378 | 91602 | 5080 | 2018-03-15 15:57:00+00 | | f | 4 public | miq_shortcuts | 0 | 225 | 0 | 0.96 | 98 | 79 | 98 | 505 | 2018-03-20 23:35:00+00 | | f | 81 public | authentications | 0 | 32627 | 0 | 0.961718821834677 | 77 | 39 | 77 | 504 | 2018-03-19 15:33:00+00 | | f | 51 public | conditions | 0 | 50 | 0 | 0.98 | 98 | 8 | 98 | 505 | 2018-03-20 15:54:00+00 | | f | 8 public | custom_attributes | 666 | 72 | 571 | 0.986111111111111 | 7765 | 0 | 7753 | 888 | 2018-03-22 03:15:00+00 | | f | 0 public | ext_management_systems | 0 | 1006 | 0 | 0.999005964214712 | 3 | 71 | 3 | 500 | 2018-03-21 03:01:00+00 | | f | 2367 public | dialog_tabs | 50 | 50 | 50 | 1 | 112 | 100 | 112 | 506 | 2018-03-18 01:56:00+00 | | f | 89 public | vmdb_databases | 0 | 25 | 0 | 1 | 1 | 22 | 1 | 500 | 2018-03-20 23:35:00+00 | | f | 2200 public | assigned_server_roles | 0 | 314 | 0 | 1 | 261 | 314 | 261 | 513 | 2018-03-16 01:01:00+00 | | f | 120 public | settings_changes | 0 | 6 | 0 | 1 | 4680 | 0 | 4680 | 734 | 2018-03-18 02:06:00+00 | | f | 0 public | resource_pools | 0 | 1 | 1 | 1 | 15 | 0 | 15 | 501 | 2018-03-20 23:35:00+00 | | f | 0 public | dialog_groups | 75 | 75 | 75 | 1 | 436 | 150 | 436 | 522 | 2018-03-18 01:56:00+00 | | f | 34 public | miq_alert_statuses | 69 | 22 | 68 | 1 | 469 | 49 | 468 | 523 | 2018-03-17 14:49:00+00 | | f | 10 public | ems_clusters | 0 | 1 | 1 | 1 | 15 | 0 | 15 | 501 | 2018-03-20 15:54:00+00 | | f | 0 public | metric_rollups_12 | 0 | 0 | 0 | | 3461684 | 0 | 3.46168e+06 | 173584 | 2018-03-16 17:41:00+00 | | f | 0 public | container_definitions | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_component_statuses | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_build_pods | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | configured_systems | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | configuration_tags_configured_systems | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | container_builds | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | configuration_tags | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_conditions | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | configuration_profiles | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | configuration_organizations_configuration_profiles | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | configuration_profiles_configuration_tags | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | configuration_organizations | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | configuration_locations | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | conditions_miq_policies | 0 | 0 | 0 | | 102 | 0 | 102 | 505 | 2018-03-18 01:56:00+00 | | f | 0 public | configuration_scripts | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | compliances | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | compliance_details | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | cloud_volumes | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | configuration_locations_configuration_profiles | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | chargeback_rate_details | 0 | 0 | 0 | | 34 | 0 | 34 | 502 | 2018-03-20 15:54:00+00 | | f | 0 public | cloud_object_store_containers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | middleware_domains | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | middleware_datasources | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | middleware_messagings | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | middleware_server_groups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | middleware_servers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | middleware_deployments | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | miq_ae_instances | 0 | 0 | 0 | | 898 | 0 | 898 | 545 | 2018-03-18 01:57:00+00 | | f | 0 public | miq_actions | 0 | 0 | 0 | | 57 | 0 | 57 | 503 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_ae_classes | 0 | 0 | 0 | | 176 | 0 | 176 | 509 | 2018-03-17 14:49:00+00 | | f | 0 public | miq_ae_fields | 0 | 0 | 0 | | 1498 | 0 | 1498 | 575 | 2018-03-18 01:57:00+00 | | f | 0 public | miq_ae_methods | 0 | 0 | 0 | | 402 | 0 | 402 | 520 | 2018-03-17 14:49:00+00 | | f | 0 public | miq_ae_workspaces | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_ae_values | 0 | 0 | 0 | | 1255 | 0 | 1255 | 563 | 2018-03-18 01:57:00+00 | | f | 0 public | miq_ae_namespaces | 0 | 0 | 0 | | 150 | 0 | 150 | 508 | 2018-03-18 01:57:00+00 | | f | 0 public | miq_alerts | 0 | 0 | 0 | | 49 | 0 | 49 | 502 | 2018-03-20 23:35:00+00 | | f | 0 public | cloud_networks | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | miq_event_definitions | 0 | 0 | 0 | | 183 | 0 | 183 | 509 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_cim_associations | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_dialogs | 0 | 0 | 0 | | 22 | 0 | 22 | 501 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_cim_derived_metrics | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_cim_instances | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_databases | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-17 14:49:00+00 | | f | 0 public | miq_enterprises | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_globals | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_groups | 0 | 0 | 0 | | 91 | 0 | 91 | 505 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_policies | 0 | 0 | 0 | | 102 | 0 | 102 | 505 | 2018-03-20 23:35:00+00 | | f | 0 public | cloud_databases | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | miq_product_features | 0 | 0 | 0 | | 1389 | 0 | 1389 | 569 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_product_features_shares | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | miq_regions | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | classifications | 4 | 0 | 0 | | 2223 | 0 | 2222 | 611 | 2018-03-20 15:54:00+00 | | f | 0 public | chargeback_tiers | 600 | 0 | 0 | | 9336 | 0 | 8736 | 937 | 2018-03-18 01:56:00+00 | | f | 0 public | miq_roles_features | 0 | 0 | 0 | | 1592 | 0 | 1592 | 580 | 2018-03-18 01:57:00+00 | | f | 0 public | cloud_database_flavors | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | storage_files | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | | | f | 0 public | miq_widget_shortcuts | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_storage_metrics | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | chargeback_rates | 0 | 0 | 0 | | 5 | 0 | 5 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | miq_user_roles | 0 | 0 | 0 | | 33 | 0 | 33 | 502 | 2018-03-20 23:35:00+00 | | f | 0 public | chargeback_rate_detail_measures | 0 | 0 | 0 | | 3 | 0 | 3 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | chargeback_rate_detail_currencies | 0 | 0 | 0 | | 4 | 0 | 4 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | network_groups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | network_ports | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | network_ports_security_groups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:57:00+00 | | f | 0 public | network_routers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | notifications | 7737 | 0 | 0 | | 38838 | 0 | 38810 | 2440 | 2018-03-18 02:06:00+00 | | f | 0 public | notification_types | 0 | 0 | 0 | | 28 | 0 | 28 | 501 | 2018-03-18 02:06:00+00 | | f | 0 public | ontap_aggregate_metrics_rollups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | ontap_aggregate_derived_metrics | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | ontap_disk_derived_metrics | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | ontap_disk_metrics_rollups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | ontap_system_metrics_rollups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | ontap_lun_derived_metrics | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | ontap_lun_metrics_rollups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | ontap_system_derived_metrics | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | openscap_results | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | ontap_volume_derived_metrics | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | ontap_volume_metrics_rollups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | openscap_rule_results | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | operating_system_flavors | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | orchestration_stack_outputs | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | orchestration_stack_parameters | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | patches | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | os_processes | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | orchestration_templates | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | partitions | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | miq_scsi_targets | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | | | f | 0 public | pictures | 0 | 0 | 0 | | 11 | 0 | 11 | 501 | 2018-03-20 23:35:00+00 | | f | 0 public | persistent_volume_claims | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | providers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | orchestration_stack_resources | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | pxe_servers | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | pxe_image_types | 0 | 0 | 0 | | 4 | 0 | 4 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | pxe_images | 0 | 0 | 0 | | 3 | 0 | 3 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | pxe_menus | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | registry_items | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | reserves | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | repositories | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | cloud_object_store_objects | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:53:00+00 | | f | 0 public | resource_groups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | blueprints | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | rss_feeds | 0 | 0 | 0 | | 19 | 0 | 19 | 501 | 2018-03-20 23:35:00+00 | | f | 0 public | blacklisted_events | 0 | 0 | 0 | | 37 | 0 | 37 | 502 | 2018-03-20 15:54:00+00 | | f | 0 public | scan_histories | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | scan_items | 0 | 0 | 0 | | 10 | 0 | 10 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | schema_migrations | 0 | 0 | 0 | | 835 | 0 | 835 | 542 | 2018-03-20 23:35:00+00 | | f | 0 public | service_connections | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | security_groups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | server_roles | 0 | 0 | 0 | | 26 | 0 | 26 | 501 | 2018-03-20 23:35:00+00 | | f | 0 public | security_groups_vms | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | service_resources | 79 | 0 | 19 | | 3135 | 0 | 3124 | 656 | 2018-03-20 23:35:00+00 | | f | 0 public | service_template_catalogs | 0 | 0 | 0 | | 4 | 0 | 4 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | service_templates | 0 | 0 | 0 | | 15 | 0 | 15 | 501 | 2018-03-20 23:35:00+00 | | f | 0 public | availability_zones | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | shares | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | storage_managers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | storage_metrics_metadata | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | storage_profile_storages | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | storage_profiles | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | audit_events | 28964 | 0 | 0 | | 404827 | 0 | 399861 | 20493 | 2018-03-20 15:54:00+00 | | f | 0 public | arbitration_settings | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | system_services | 0 | 0 | 0 | | 3883 | 0 | 3883 | 694 | 2018-03-20 23:35:00+00 | | f | 0 public | switches | 16 | 0 | 0 | | 5008 | 0 | 5008 | 750 | 2018-03-17 22:15:00+00 | | f | 0 public | system_consoles | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | tenants | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | tenant_quotas | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | tags | 4 | 0 | 0 | | 2282 | 0 | 2281 | 614 | 2018-03-20 23:35:00+00 | | f | 0 public | time_profiles | 0 | 0 | 0 | | 2 | 0 | 2 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | arbitration_profiles | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | arbitration_rules | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | accounts | 0 | 0 | 0 | | 4088 | 0 | 4088 | 704 | 2018-03-20 15:53:00+00 | | f | 0 public | vmdb_database_metrics | 0 | 0 | 0 | | 3383 | 0 | 3383 | 669 | 2018-03-20 23:35:00+00 | | f | 0 public | vmdb_indexes | 0 | 0 | 0 | | 863 | 0 | 863 | 543 | 2018-03-22 12:29:00+00 | | f | 0 public | vmdb_tables | 0 | 0 | 0 | | 618 | 0 | 618 | 531 | 2018-03-17 22:15:00+00 | | f | 0 public | vmdb_metrics | 0 | 0 | 0 | | 3539144 | 0 | 3.53914e+06 | 177457 | 2018-03-17 22:23:00+00 | | f | 0 public | volumes | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | windows_images | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | zones | 0 | 0 | 1 | | 6 | 0 | 6 | 500 | 2018-03-20 23:35:00+00 | | f | 0 public | advanced_settings | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:53:00+00 | | f | 0 public | customization_specs | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | | | f | 0 public | firewall_rules | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | | | f | 0 public | ar_internal_metadata | 0 | 0 | 0 | | 1 | 0 | 1 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | cloud_volume_snapshots | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:53:00+00 | | f | 0 public | event_logs | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | | | f | 0 public | cloud_volume_backups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | computer_systems | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | container_nodes | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | cloud_tenants_vms | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | security_contexts | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | miq_alert_status_actions | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 02:06:00+00 | | f | 0 public | cloud_tenant_flavors | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | chargeable_fields | 0 | 0 | 0 | | 13 | 0 | 13 | 501 | 2018-03-18 08:58:00+00 | | f | 0 public | authentication_configuration_script_bases | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 08:58:00+00 | | f | 0 public | firmwares | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 08:58:00+00 | | f | 0 public | orchestration_stacks | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 08:58:00+00 | | f | 0 public | authentication_orchestration_stacks | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 08:58:00+00 | | f | 0 public | configuration_script_sources | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 08:58:00+00 | | f | 0 public | physical_servers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 08:58:00+00 | | f | 0 public | cloud_subnets_network_ports | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | cloud_tenants | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:53:00+00 | | f | 0 public | vim_performance_states | 656032 | 0 | 0 | | 60957410 | 0 | 6.06744e+07 | 3034221 | 2018-03-11 17:49:00+00 | | f | 0 public | cloud_subnets | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:53:00+00 | | f | 0 public | cloud_services | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | cloud_resource_quotas | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:53:00+00 | | f | 0 public | miq_scsi_luns | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | | | f | 0 public | container_label_tag_mappings | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | container_projects | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_limits | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_quota_items | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_quotas | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_services | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_replicators | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_routes | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_service_port_configs | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_template_parameters | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | containers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_volumes | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_templates | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | custom_buttons | 0 | 0 | 0 | | 25 | 0 | 25 | 501 | 2018-03-20 15:54:00+00 | | f | 0 public | customization_scripts | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | metrics | 188489197 | 0 | 188489197 | | 3917020 | 239494 | 3.91702e+06 | 196351 | 2018-03-22 19:58:00+00 | | t | 6 public | container_port_configs | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | miq_report_result_details | 9266214 | 0 | 9338397 | | 446560 | 21057 | 446560 | 22828 | 2018-03-22 19:31:00+00 | | f | 5 public | metric_rollups_09 | 0 | 0 | 705658 | | 485989 | 19069 | 505058 | 25753 | 2018-03-22 15:40:00+00 | | f | 4 public | taggings | 1457 | 0 | 1016 | | 441 | 1016 | 52636 | 3132 | | | f | 2 public | metric_rollups | 530991 | 0 | 530991 | | 0 | 494 | 0 | 500 | 2018-03-22 19:27:00+00 | | f | 0 public | binary_blob_parts | 41934 | 0 | 41696 | | 28603 | 272 | 28650 | 1932 | 2018-03-22 15:31:00+00 | | f | 1 public | storages_vms_and_templates | 1645 | 0 | 1621 | | 5538 | 263 | 5750 | 788 | 2018-03-16 16:02:00+00 | | f | 5 public | bottleneck_events | 8703 | 0 | 8502 | | 2708 | 209 | 2778 | 639 | 2018-03-22 12:35:00+00 | | f | 8 public | miq_policy_contents | 100 | 0 | 100 | | 141 | 88 | 141 | 507 | 2018-03-20 23:35:00+00 | | f | 62 public | policy_event_contents | 365 | 0 | 1103 | | 12412 | 79 | 12394 | 1120 | 2018-03-20 23:35:00+00 | | f | 1 public | host_storages | 250 | 0 | 220 | | 3125 | 20 | 3125 | 656 | 2018-03-20 10:19:00+00 | | f | 1 public | notification_recipients | 265904 | 0 | 66 | | 2386550 | 19 | 2.35007e+06 | 118003 | 2018-03-18 01:58:00+00 | | f | 0 public | miq_groups_users | 15 | 0 | 4 | | 1018 | 4 | 1015 | 551 | 2018-03-18 01:57:00+00 | | f | 0 public | ems_folders | 3 | 0 | 6 | | 45 | 3 | 48 | 502 | 2018-03-20 15:54:00+00 | | f | 6 public | customization_scripts_operating_system_flavors | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | container_limit_items | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | customization_templates | 0 | 0 | 0 | | 9 | 0 | 9 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | database_backups | 0 | 0 | 0 | | 8 | 0 | 8 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_images | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | direct_configuration_profiles_configuration_tags | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | dialogs | 0 | 0 | 0 | | 18 | 0 | 18 | 501 | 2018-03-20 15:54:00+00 | | f | 0 public | direct_configuration_tags_configured_systems | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | container_image_registries | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | drift_states | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | entitlements | 0 | 0 | 0 | | 91 | 0 | 91 | 505 | 2018-03-18 01:56:00+00 | | f | 0 public | endpoints | 0 | 0 | 0 | | 6 | 0 | 6 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | file_depots | 0 | 0 | 0 | | 12 | 0 | 12 | 501 | 2018-03-20 15:54:00+00 | | f | 0 public | filesystems | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | flavors | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | container_groups_container_services | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | floating_ips | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | git_repositories | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | generic_object_definitions | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | generic_objects | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | git_references | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | guest_applications | 0 | 0 | 0 | | 31849 | 0 | 31849 | 2092 | 2018-03-20 15:54:00+00 | | f | 0 public | host_aggregates | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | host_aggregate_hosts | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | host_service_groups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | host_switches | 16 | 0 | 0 | | 5008 | 0 | 5008 | 750 | 2018-03-17 14:23:00+00 | | f | 0 public | import_file_uploads | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | key_pairs_vms | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | iso_datastores | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | iso_images | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | ldap_domains | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | lans | 16 | 0 | 0 | | 5023 | 0 | 5023 | 751 | 2018-03-17 14:23:00+00 | | f | 0 public | ldap_groups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | ldap_managements | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | ldap_regions | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | ldap_servers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | ldap_users | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | lifecycle_events | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | load_balancer_health_check_members | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | load_balancer_listeners | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | load_balancer_health_checks | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | load_balancer_listener_pools | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | load_balancer_pool_member_pools | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | load_balancer_pool_members | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | load_balancer_pools | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | load_balancers | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | log_files | 0 | 0 | 0 | | 464 | 0 | 464 | 523 | 2018-03-20 15:54:00+00 | | f | 0 public | metric_rollups_01 | 0 | 0 | 0 | | 2942327 | 0 | 2.94233e+06 | 147616 | 2018-03-20 06:05:00+00 | | f | 0 public | metric_rollups_02 | 0 | 0 | 0 | | 1687497 | 0 | 1.6875e+06 | 84875 | 2018-03-17 20:08:00+00 | | f | 0 public | metric_rollups_08 | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-22 07:36:00+00 | | f | 0 public | metric_rollups_05 | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-21 03:04:00+00 | | f | 0 public | container_groups | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | metric_rollups_04 | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-21 03:05:00+00 | | f | 0 public | metric_rollups_07 | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-17 14:28:00+00 | | f | 0 public | metric_rollups_06 | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 10:22:00+00 | | f | 0 public | container_env_vars | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-20 15:54:00+00 | | f | 0 public | metric_rollups_10 | 0 | 0 | 0 | | 2129830 | 0 | 2.12983e+06 | 106992 | 2018-03-17 21:00:00+00 | | f | 0 public | metric_rollups_11 | 0 | 0 | 0 | | 2545502 | 0 | 2.5455e+06 | 127775 | 2018-03-17 02:05:00+00 | | f | 0 public | container_deployments | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 public | container_deployment_nodes | 0 | 0 | 0 | | 0 | 0 | 0 | 500 | 2018-03-18 01:56:00+00 | | f | 0 (331 rows)
Attachment:
bloatcheck.sql
Description: Binary data
