Created
January 19, 2016 19:33
-
-
Save akrzos/b37cef47acb1e563a158 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| tablename | indexname | num_rows | table_size | index_size | unique | number_of_scans | tuples_read | tuples_fetched | |
| ----------------------------------------------------+----------------------------------------------------------------+-------------+------------+------------+--------+-----------------+-------------+---------------- | |
| accounts | accounts_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| accounts | index_accounts_on_accttype | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| accounts | index_accounts_on_host_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| accounts | index_accounts_on_vm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| advanced_settings | advanced_settings_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| advanced_settings | index_advanced_settings_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| assigned_server_roles | assigned_server_roles_pkey | 27 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| assigned_server_roles | index_assigned_server_roles_on_miq_server_id | 27 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| assigned_server_roles | index_assigned_server_roles_on_server_role_id | 27 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| audit_events | audit_events_pkey | 8100 | 1584 kB | 200 kB | Y | 0 | 0 | 0 | |
| audit_events | index_audit_events_on_target_id_and_target_class | 8100 | 1584 kB | 448 kB | N | 0 | 0 | 0 | |
| authentications | authentications_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| authentications | index_authentications_on_resource_id_and_resource_type | 1 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| availability_zones | availability_zones_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| availability_zones | index_availability_zones_on_ems_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| binary_blob_parts | binary_blob_parts_pkey | 16 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| binary_blob_parts | index_binary_blob_parts_on_binary_blob_id | 16 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| binary_blobs | binary_blobs_pkey | 6 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| binary_blobs | index_binary_blobs_on_resource_id_and_resource_type | 6 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| bottleneck_events | bottleneck_events_pkey | 1.2119e+06 | 1054 MB | 26 MB | Y | 0 | 0 | 0 | |
| bottleneck_events | index_bottleneck_events_on_resource_id_and_resource_type | 1.2119e+06 | 1054 MB | 50 MB | N | 1650365 | 93817 | 93773 | |
| chargeback_rate_details | chargeback_rate_details_pkey | 12 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| chargeback_rate_details | index_chargeback_rate_details_on_chargeback_rate_id | 12 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| chargeback_rates | chargeback_rates_pkey | 2 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| classifications | classifications_pkey | 129 | 16 kB | 16 kB | Y | 0 | 0 | 0 | |
| classifications | index_classifications_on_parent_id | 129 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| classifications | index_classifications_on_tag_id | 129 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| cloud_networks | cloud_networks_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| cloud_object_store_containers | cloud_object_store_containers_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| cloud_object_store_objects | cloud_object_store_objects_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| cloud_resource_quotas | cloud_resource_quotas_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| cloud_subnets | cloud_subnets_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| cloud_tenants | cloud_tenants_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| cloud_tenants_vms | | 0 | 0 bytes | | N | | | | |
| cloud_volume_snapshots | cloud_volume_snapshots_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| cloud_volumes | cloud_volumes_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| compliance_details | compliance_details_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| compliance_details | index_compliance_details_on_compliance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| compliance_details | index_compliance_details_on_condition_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| compliance_details | index_compliance_details_on_miq_policy_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| compliances | compliances_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| compliances | index_compliances_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| computer_systems | computer_systems_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| computer_systems | index_computer_systems_managed_entity | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| conditions | conditions_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| conditions | index_conditions_on_guid | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| conditions | index_conditions_on_miq_policy_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| conditions_miq_policies | | 0 | 0 bytes | | N | | | | |
| configuration_locations | configuration_locations_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| configuration_locations | index_configuration_locations_on_manager_ref | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_locations | index_configuration_locations_on_provisioning_manager_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_locations_configuration_profiles | index_configuration_locations_configuration_profiles_location | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_locations_configuration_profiles | index_configuration_locations_configuration_profiles_profile | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_organizations | configuration_organizations_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| configuration_organizations | index_configuration_organizations_on_manager_ref | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_organizations | index_configuration_organizations_on_provisioning_manager_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_organizations_configuration_profiles | index_configuration_organizations_configuration_profiles_org | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_organizations_configuration_profiles | index_configuration_organizations_configuration_profiles_p | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles | configuration_profiles_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| configuration_profiles | index_configuration_profiles_on_configuration_manager_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles | index_configuration_profiles_on_customization_script_medium_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles | index_configuration_profiles_on_customization_script_ptable_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles | index_configuration_profiles_on_manager_ref | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles | index_configuration_profiles_on_operating_system_flavor_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles_configuration_tags | configuration_profiles_configuration_tags_profile_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles_configuration_tags | configuration_profiles_configuration_tags_tag_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles_configuration_tags | index_direct_configuration_profiles_tags_profile_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_profiles_configuration_tags | index_direct_configuration_profiles_tags_tag_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_tags | configuration_tags_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| configuration_tags_configured_systems | configured_systems_configuration_system_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configuration_tags_configured_systems | configured_systems_configuration_tag_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configurations | configurations_pkey | 4 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| configurations | index_configurations_on_miq_server_id | 4 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| configured_systems | configured_systems_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| configured_systems | index_configured_systems_on_configuration_manager_id_and_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configured_systems | index_configured_systems_on_manager_ref | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| configured_systems | index_configured_systems_on_operating_system_flavor_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| container_definitions | container_definitions_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| container_groups | container_groups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| container_groups | index_container_groups_on_ems_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| container_groups_container_services | | 0 | 0 bytes | | N | | | | |
| container_nodes | container_nodes_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| container_nodes | index_container_nodes_on_ems_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| container_port_configs | container_port_configs_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| container_replication_controllers | container_replication_controllers_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| container_services | container_services_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| container_services | index_container_services_on_ems_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| containers | containers_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| custom_attributes | custom_attributes_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| custom_attributes | index_custom_attributes_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 30000 | 0 | 0 | |
| custom_buttons | automation_uris_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| customization_scripts | customization_scripts_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| customization_scripts | index_customization_scripts_on_manager_ref | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| customization_scripts | index_on_customization_script_provisioning_manager_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| customization_scripts_operating_system_flavors | index_on_customization_scripts_operating_system_flavors_i1 | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| customization_scripts_operating_system_flavors | index_on_customization_scripts_operating_system_flavors_i2 | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| customization_specs | customization_specs_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| customization_specs | index_customization_specs_on_ems_id | 0 | 0 bytes | 8192 bytes | N | 3 | 0 | 0 | |
| customization_templates | customization_templates_pkey | 6 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| database_backups | database_backups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| dialog_fields | dialog_fields_pkey | 22 | 160 kB | 40 kB | Y | 528 | 550 | 528 | |
| dialog_groups | dialog_groups_pkey | 9 | 8192 bytes | 32 kB | Y | 0 | 0 | 0 | |
| dialog_tabs | dialog_tabs_pkey | 3 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| dialogs | dialogs_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| direct_configuration_profiles_configuration_tags | | 0 | 0 bytes | | N | | | | |
| direct_configuration_tags_configured_systems | index_direct_configured_systems_tag_tag_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| direct_configuration_tags_configured_systems | index_direct_configured_systems_tags_system_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| disks | disks_pkey | 10000 | 1952 kB | 240 kB | Y | 0 | 0 | 0 | |
| disks | index_disks_on_device_name | 10000 | 1952 kB | 400 kB | N | 0 | 0 | 0 | |
| disks | index_disks_on_device_type | 10000 | 1952 kB | 304 kB | N | 0 | 0 | 0 | |
| disks | index_disks_on_hardware_id | 10000 | 1952 kB | 240 kB | N | 427802 | 427802 | 427802 | |
| disks | index_disks_on_storage_id | 10000 | 1952 kB | 288 kB | N | 0 | 0 | 0 | |
| drift_states | index_drift_states_on_timestamp | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| drift_states | index_states_on_resource_id_and_resource_type_and_timestamp | 0 | 0 bytes | 8192 bytes | N | 30000 | 0 | 0 | |
| drift_states | states_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ems_clusters | ems_clusters_pkey | 20 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| ems_clusters | index_ems_clusters_on_ems_id | 20 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| ems_clusters | index_ems_clusters_on_uid | 20 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| ems_events | ems_events_pkey | 20175 | 19 MB | 464 kB | Y | 0 | 0 | 0 | |
| ems_events | index_ems_events_on_chain_id_and_ems_id | 20175 | 19 MB | 640 kB | N | 0 | 0 | 0 | |
| ems_events | index_ems_events_on_dest_host_id | 20175 | 19 MB | 560 kB | N | 0 | 0 | 0 | |
| ems_events | index_ems_events_on_dest_vm_or_template_id | 20175 | 19 MB | 568 kB | N | 0 | 0 | 0 | |
| ems_events | index_ems_events_on_ems_cluster_id | 20175 | 19 MB | 568 kB | N | 0 | 0 | 0 | |
| ems_events | index_ems_events_on_ems_id | 20175 | 19 MB | 592 kB | N | 2 | 2 | 0 | |
| ems_events | index_ems_events_on_event_type | 20175 | 19 MB | 944 kB | N | 0 | 0 | 0 | |
| ems_events | index_ems_events_on_host_id | 20175 | 19 MB | 600 kB | N | 0 | 0 | 0 | |
| ems_events | index_ems_events_on_service_id | 20175 | 19 MB | 584 kB | N | 0 | 0 | 0 | |
| ems_events | index_ems_events_on_timestamp | 20175 | 19 MB | 464 kB | N | 20 | 15 | 10 | |
| ems_events | index_ems_events_on_vm_or_template_id | 20175 | 19 MB | 632 kB | N | 0 | 0 | 0 | |
| ems_folders | ems_folders_pkey | 4 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| ems_folders | index_ems_folders_on_ems_id | 4 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| ems_folders | index_ems_folders_on_uid | 4 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| event_logs | event_logs_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| event_logs | index_event_logs_on_event_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| event_logs | index_event_logs_on_operating_system_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ext_management_systems | ext_management_systems_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| ext_management_systems | index_ext_management_systems_on_guid | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| file_depots | file_depots_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| filesystems | filesystems_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| filesystems | index_filesystems_on_host_service_group_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| filesystems | index_filesystems_on_miq_set_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| filesystems | index_filesystems_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| filesystems | index_filesystems_on_scan_item_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| firewall_rules | firewall_rules_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| firewall_rules | index_firewall_rules_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| flavors | flavors_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| flavors | index_flavors_on_ems_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| floating_ips | floating_ips_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| guest_applications | guest_applications_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| guest_applications | index_guest_applications_on_host_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| guest_applications | index_guest_applications_on_typename | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| guest_applications | index_guest_applications_on_vm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| guest_devices | guest_devices_pkey | 11000 | 1576 kB | 400 kB | Y | 0 | 0 | 0 | |
| guest_devices | index_guest_devices_on_device_name | 11000 | 1576 kB | 632 kB | N | 0 | 0 | 0 | |
| guest_devices | index_guest_devices_on_device_type | 11000 | 1576 kB | 488 kB | N | 0 | 0 | 0 | |
| guest_devices | index_guest_devices_on_hardware_id | 11000 | 1576 kB | 376 kB | N | 101836 | 106636 | 106636 | |
| guest_devices | index_guest_devices_on_lan_id | 11000 | 1576 kB | 360 kB | N | 0 | 0 | 0 | |
| guest_devices | index_guest_devices_on_switch_id | 11000 | 1576 kB | 384 kB | N | 0 | 0 | 0 | |
| hardwares | hardwares_pkey | 10200 | 1816 kB | 240 kB | Y | 72 | 72 | 72 | |
| hardwares | index_hardwares_on_computer_system_id | 10200 | 1816 kB | 296 kB | N | 0 | 0 | 0 | |
| hardwares | index_hardwares_on_host_id | 10200 | 1816 kB | 320 kB | N | 95331 | 95331 | 95331 | |
| hardwares | index_hardwares_on_vm_id | 10200 | 1816 kB | 448 kB | N | 477826 | 477826 | 477826 | |
| host_service_groups | host_service_groups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| hosts | hosts_pkey | 200 | 560 kB | 16 kB | Y | 7954942 | 8227441 | 4397511 | |
| hosts | index_hosts_on_availability_zone_id | 200 | 560 kB | 40 kB | N | 0 | 0 | 0 | |
| hosts | index_hosts_on_ems_id | 200 | 560 kB | 32 kB | N | 36 | 0 | 0 | |
| hosts | index_hosts_on_guid | 200 | 560 kB | 40 kB | Y | 0 | 0 | 0 | |
| hosts | index_hosts_on_hostname | 200 | 560 kB | 56 kB | N | 0 | 0 | 0 | |
| hosts | index_hosts_on_ipaddress | 200 | 560 kB | 56 kB | N | 0 | 0 | 0 | |
| hosts_storages | index_hosts_storages_on_host_id_and_storage_id | 600 | 32 kB | 40 kB | Y | 13278619 | 39763841 | 36008 | |
| import_file_uploads | import_file_uploads_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| iso_datastores | iso_datastores_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| iso_images | iso_images_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| jobs | index_jobs_on_agent_id_and_agent_class | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| jobs | index_jobs_on_dispatch_status | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| jobs | index_jobs_on_guid | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| jobs | index_jobs_on_miq_server_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| jobs | index_jobs_on_state | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| jobs | index_jobs_on_target_id_and_target_class | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| jobs | jobs_pkey | 0 | 0 bytes | 8192 bytes | Y | 5556 | 0 | 0 | |
| key_pairs_vms | | 0 | 0 bytes | | N | | | | |
| lans | index_lans_on_switch_id | 400 | 48 kB | 16 kB | N | 600 | 1200 | 0 | |
| lans | lans_pkey | 400 | 48 kB | 16 kB | Y | 0 | 0 | 0 | |
| ldap_domains | index_ldap_domains_on_ldap_region_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ldap_domains | ldap_servers_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ldap_groups | index_ldap_groups_on_ldap_domain_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ldap_groups | ldap_groups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ldap_managements | ldap_managements_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ldap_regions | index_ldap_regions_on_zone_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ldap_regions | ldap_regions_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ldap_servers | index_ldap_servers_on_ldap_domain_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ldap_servers | ldap_servers_pkey1 | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ldap_users | index_ldap_users_on_ldap_domain_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ldap_users | ldap_users_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| lifecycle_events | index_lifecycle_events_on_guid | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| lifecycle_events | index_lifecycle_events_on_vm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| lifecycle_events | lifecycle_events_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| log_files | index_log_files_on_miq_task_id | 0 | 0 bytes | 8192 bytes | N | 4568 | 0 | 0 | |
| log_files | index_log_files_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 12 | 0 | 0 | |
| log_files | log_files_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| metric_rollups | metric_rollups_pkey | 0 | 0 bytes | 432 kB | Y | 593079 | 391408 | 384450 | |
| metric_rollups_01 | index_metric_rollups_01_on_resource_and_ts | 1.97463e+06 | 3108 MB | 203 MB | N | 6758437 | 132565577 | 132347005 | |
| metric_rollups_01 | index_metric_rollups_01_on_ts_and_capture_interval_name | 1.97463e+06 | 3108 MB | 171 MB | N | 21396045 | 21611509 | 21350296 | |
| metric_rollups_01 | metric_rollups_01_pkey | 1.97463e+06 | 3108 MB | 91 MB | Y | 1196124 | 1225472 | 1196124 | |
| metric_rollups_02 | index_metric_rollups_02_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_02 | index_metric_rollups_02_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_02 | metric_rollups_02_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_03 | index_metric_rollups_03_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_03 | index_metric_rollups_03_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_03 | metric_rollups_03_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_04 | index_metric_rollups_04_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_04 | index_metric_rollups_04_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_04 | metric_rollups_04_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_05 | index_metric_rollups_05_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_05 | index_metric_rollups_05_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_05 | metric_rollups_05_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_06 | index_metric_rollups_06_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_06 | index_metric_rollups_06_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_06 | metric_rollups_06_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_07 | index_metric_rollups_07_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_07 | index_metric_rollups_07_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_07 | metric_rollups_07_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_08 | index_metric_rollups_08_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_08 | index_metric_rollups_08_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_08 | metric_rollups_08_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_09 | index_metric_rollups_09_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_09 | index_metric_rollups_09_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_09 | metric_rollups_09_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_10 | index_metric_rollups_10_on_resource_and_ts | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| metric_rollups_10 | index_metric_rollups_10_on_ts_and_capture_interval_name | 0 | 0 bytes | 8192 bytes | N | 12309826 | 0 | 0 | |
| metric_rollups_10 | metric_rollups_10_pkey | 0 | 0 bytes | 8192 bytes | Y | 489000 | 0 | 0 | |
| metric_rollups_11 | index_metric_rollups_11_on_resource_and_ts | 3.7803e+06 | 5664 MB | 370 MB | N | 0 | 0 | 0 | |
| metric_rollups_11 | index_metric_rollups_11_on_ts_and_capture_interval_name | 3.7803e+06 | 5664 MB | 309 MB | N | 39060655 | 23618458 | 23618408 | |
| metric_rollups_11 | metric_rollups_11_pkey | 3.7803e+06 | 5664 MB | 165 MB | Y | 1196124 | 0 | 0 | |
| metric_rollups_12 | index_metric_rollups_12_on_resource_and_ts | 4.08874e+06 | 6024 MB | 415 MB | N | 6132724 | 136199538 | 136199538 | |
| metric_rollups_12 | index_metric_rollups_12_on_ts_and_capture_interval_name | 4.08874e+06 | 6024 MB | 338 MB | N | 22826404 | 13516931 | 13516881 | |
| metric_rollups_12 | metric_rollups_12_pkey | 4.08874e+06 | 6024 MB | 182 MB | Y | 1196124 | 0 | 0 | |
| metrics | metrics_pkey | 16853 | 11 MB | 21 MB | Y | 110275798 | 64446619 | 64426075 | |
| metrics_00 | index_metrics_00_on_resource_and_ts | 0 | 0 bytes | 194 MB | N | 525117 | 4866098 | 586337 | |
| metrics_00 | index_metrics_00_on_ts_and_capture_interval_name | 0 | 0 bytes | 161 MB | N | 1058281 | 1772573 | 477503 | |
| metrics_00 | metrics_00_pkey | 0 | 0 bytes | 49 MB | Y | 18166939 | 2836070 | 2834590 | |
| metrics_01 | index_metrics_01_on_resource_and_ts | 0 | 0 bytes | 198 MB | N | 521326 | 4729818 | 571104 | |
| metrics_01 | index_metrics_01_on_ts_and_capture_interval_name | 0 | 0 bytes | 144 MB | N | 1013161 | 1782689 | 491662 | |
| metrics_01 | metrics_01_pkey | 0 | 0 bytes | 50 MB | Y | 20122431 | 2835801 | 2833552 | |
| metrics_02 | index_metrics_02_on_resource_and_ts | 0 | 0 bytes | 190 MB | N | 515053 | 4602237 | 555171 | |
| metrics_02 | index_metrics_02_on_ts_and_capture_interval_name | 0 | 0 bytes | 141 MB | N | 1008436 | 1754581 | 478639 | |
| metrics_02 | metrics_02_pkey | 0 | 0 bytes | 46 MB | Y | 14823636 | 2814394 | 2812162 | |
| metrics_03 | index_metrics_03_on_resource_and_ts | 0 | 0 bytes | 181 MB | N | 513983 | 4714387 | 564767 | |
| metrics_03 | index_metrics_03_on_ts_and_capture_interval_name | 0 | 0 bytes | 148 MB | N | 1546826 | 1773926 | 481175 | |
| metrics_03 | metrics_03_pkey | 0 | 0 bytes | 46 MB | Y | 32500477 | 2821968 | 2819047 | |
| metrics_04 | index_metrics_04_on_resource_and_ts | 0 | 0 bytes | 177 MB | N | 495844 | 4899583 | 639434 | |
| metrics_04 | index_metrics_04_on_ts_and_capture_interval_name | 0 | 0 bytes | 146 MB | N | 1084573 | 1811590 | 518629 | |
| metrics_04 | metrics_04_pkey | 0 | 0 bytes | 47 MB | Y | 14822275 | 2827232 | 2824847 | |
| metrics_05 | index_metrics_05_on_resource_and_ts | 0 | 0 bytes | 176 MB | N | 652504 | 4784312 | 572754 | |
| metrics_05 | index_metrics_05_on_ts_and_capture_interval_name | 0 | 0 bytes | 146 MB | N | 1220057 | 1795865 | 508369 | |
| metrics_05 | metrics_05_pkey | 0 | 0 bytes | 45 MB | Y | 18234806 | 2835352 | 2830292 | |
| metrics_06 | index_metrics_06_on_resource_and_ts | 0 | 0 bytes | 176 MB | N | 484990 | 4834716 | 629849 | |
| metrics_06 | index_metrics_06_on_ts_and_capture_interval_name | 0 | 0 bytes | 145 MB | N | 1183809 | 1790713 | 495751 | |
| metrics_06 | metrics_06_pkey | 0 | 0 bytes | 45 MB | Y | 14833890 | 2836816 | 2834967 | |
| metrics_07 | index_metrics_07_on_resource_and_ts | 0 | 0 bytes | 178 MB | N | 495825 | 4754055 | 621403 | |
| metrics_07 | index_metrics_07_on_ts_and_capture_interval_name | 0 | 0 bytes | 148 MB | N | 1186802 | 1759536 | 470038 | |
| metrics_07 | metrics_07_pkey | 0 | 0 bytes | 46 MB | Y | 14850269 | 2830617 | 2828380 | |
| metrics_08 | index_metrics_08_on_resource_and_ts | 0 | 0 bytes | 176 MB | N | 507330 | 4756253 | 604451 | |
| metrics_08 | index_metrics_08_on_ts_and_capture_interval_name | 0 | 0 bytes | 146 MB | N | 1237835 | 1767571 | 477259 | |
| metrics_08 | metrics_08_pkey | 0 | 0 bytes | 45 MB | Y | 14857018 | 2835213 | 2833694 | |
| metrics_09 | index_metrics_09_on_resource_and_ts | 0 | 0 bytes | 178 MB | N | 783167 | 4759866 | 626109 | |
| metrics_09 | index_metrics_09_on_ts_and_capture_interval_name | 0 | 0 bytes | 146 MB | N | 1833216 | 1757787 | 464112 | |
| metrics_09 | metrics_09_pkey | 0 | 0 bytes | 46 MB | Y | 35935539 | 2828158 | 2823183 | |
| metrics_10 | index_metrics_10_on_resource_and_ts | 0 | 0 bytes | 181 MB | N | 789269 | 4673614 | 570026 | |
| metrics_10 | index_metrics_10_on_ts_and_capture_interval_name | 0 | 0 bytes | 148 MB | N | 1375357 | 1753039 | 463531 | |
| metrics_10 | metrics_10_pkey | 0 | 0 bytes | 47 MB | Y | 18259381 | 2832811 | 2827604 | |
| metrics_11 | index_metrics_11_on_resource_and_ts | 17015 | 0 bytes | 178 MB | N | 805058 | 4609916 | 552458 | |
| metrics_11 | index_metrics_11_on_ts_and_capture_interval_name | 17015 | 0 bytes | 148 MB | N | 1776682 | 1779580 | 498167 | |
| metrics_11 | metrics_11_pkey | 17015 | 0 bytes | 48 MB | Y | 29570377 | 2828814 | 2823246 | |
| metrics_12 | index_metrics_12_on_resource_and_ts | 0 | 44 MB | 180 MB | N | 543767 | 4680291 | 566522 | |
| metrics_12 | index_metrics_12_on_ts_and_capture_interval_name | 0 | 44 MB | 152 MB | N | 1452337 | 7000737 | 495047 | |
| metrics_12 | metrics_12_pkey | 0 | 44 MB | 48 MB | Y | 16505134 | 2831015 | 2829290 | |
| metrics_13 | index_metrics_13_on_resource_and_ts | 0 | 0 bytes | 183 MB | N | 1073349 | 4682351 | 551381 | |
| metrics_13 | index_metrics_13_on_ts_and_capture_interval_name | 0 | 0 bytes | 162 MB | N | 1643370 | 1824989 | 532665 | |
| metrics_13 | metrics_13_pkey | 0 | 0 bytes | 47 MB | Y | 18391882 | 2839794 | 2834251 | |
| metrics_14 | index_metrics_14_on_resource_and_ts | 58235 | 491 MB | 189 MB | N | 950624 | 4726837 | 554032 | |
| metrics_14 | index_metrics_14_on_ts_and_capture_interval_name | 58235 | 491 MB | 162 MB | N | 1707181 | 1802879 | 510806 | |
| metrics_14 | metrics_14_pkey | 58235 | 491 MB | 49 MB | Y | 18120375 | 2800714 | 2797633 | |
| metrics_15 | index_metrics_15_on_resource_and_ts | 681634 | 490 MB | 187 MB | N | 756239 | 4798494 | 587608 | |
| metrics_15 | index_metrics_15_on_ts_and_capture_interval_name | 681634 | 490 MB | 148 MB | N | 2013813 | 1343965 | 480410 | |
| metrics_15 | metrics_15_pkey | 681634 | 490 MB | 47 MB | Y | 34755659 | 1884925 | 1880177 | |
| metrics_16 | index_metrics_16_on_resource_and_ts | 883744 | 490 MB | 188 MB | N | 456803 | 4696887 | 561889 | |
| metrics_16 | index_metrics_16_on_ts_and_capture_interval_name | 883744 | 490 MB | 147 MB | N | 1212112 | 1978946 | 463027 | |
| metrics_16 | metrics_16_pkey | 883744 | 490 MB | 47 MB | Y | 32456261 | 2399496 | 2397923 | |
| metrics_17 | index_metrics_17_on_resource_and_ts | 897713 | 490 MB | 185 MB | N | 624626 | 4642332 | 552689 | |
| metrics_17 | index_metrics_17_on_ts_and_capture_interval_name | 897713 | 490 MB | 144 MB | N | 813019 | 2237037 | 460959 | |
| metrics_17 | metrics_17_pkey | 897713 | 490 MB | 47 MB | Y | 15209145 | 2811838 | 2806297 | |
| metrics_18 | index_metrics_18_on_resource_and_ts | 423464 | 329 MB | 189 MB | N | 572549 | 3433049 | 552079 | |
| metrics_18 | index_metrics_18_on_ts_and_capture_interval_name | 423464 | 329 MB | 147 MB | N | 1298707 | 50648730 | 553538 | |
| metrics_18 | metrics_18_pkey | 423464 | 329 MB | 47 MB | Y | 32120840 | 2933727 | 2929110 | |
| metrics_19 | index_metrics_19_on_resource_and_ts | 2430 | 1312 kB | 190 MB | N | 999697 | 4539976 | 547357 | |
| metrics_19 | index_metrics_19_on_ts_and_capture_interval_name | 2430 | 1312 kB | 149 MB | N | 812182 | 2601113 | 481571 | |
| metrics_19 | metrics_19_pkey | 2430 | 1312 kB | 48 MB | Y | 14435506 | 3634307 | 3629348 | |
| metrics_20 | index_metrics_20_on_resource_and_ts | 0 | 0 bytes | 194 MB | N | 478079 | 4906130 | 730638 | |
| metrics_20 | index_metrics_20_on_ts_and_capture_interval_name | 0 | 0 bytes | 162 MB | N | 736215 | 1766746 | 642251 | |
| metrics_20 | metrics_20_pkey | 0 | 0 bytes | 49 MB | Y | 15443169 | 2964726 | 2962454 | |
| metrics_21 | index_metrics_21_on_resource_and_ts | 0 | 0 bytes | 177 MB | N | 524025 | 4651655 | 568158 | |
| metrics_21 | index_metrics_21_on_ts_and_capture_interval_name | 0 | 0 bytes | 161 MB | N | 709813 | 1853918 | 444849 | |
| metrics_21 | metrics_21_pkey | 0 | 0 bytes | 45 MB | Y | 12961046 | 2814196 | 2813244 | |
| metrics_22 | index_metrics_22_on_resource_and_ts | 0 | 0 bytes | 202 MB | N | 670414 | 4657324 | 594812 | |
| metrics_22 | index_metrics_22_on_ts_and_capture_interval_name | 0 | 0 bytes | 208 MB | N | 767493 | 1853107 | 457995 | |
| metrics_22 | metrics_22_pkey | 0 | 0 bytes | 52 MB | Y | 17306738 | 2823502 | 2821619 | |
| metrics_23 | index_metrics_23_on_resource_and_ts | 10013 | 489 MB | 182 MB | N | 520655 | 4637691 | 471812 | |
| metrics_23 | index_metrics_23_on_ts_and_capture_interval_name | 10013 | 489 MB | 160 MB | N | 1209177 | 1751360 | 472226 | |
| metrics_23 | metrics_23_pkey | 10013 | 489 MB | 47 MB | Y | 28634440 | 2815778 | 2814589 | |
| miq_actions | index_miq_actions_on_guid | 31 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_actions | miq_actions_pkey | 31 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_ae_classes | index_miq_ae_classes_on_namespace_id | 85 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_classes | index_miq_ae_classes_on_updated_by_user_id | 85 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_classes | miq_ae_classes_pkey | 85 | 16 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_ae_fields | index_miq_ae_fields_on_ae_class_id | 776 | 136 kB | 40 kB | N | 424 | 6572 | 6572 | |
| miq_ae_fields | index_miq_ae_fields_on_method_id | 776 | 136 kB | 48 kB | N | 0 | 0 | 0 | |
| miq_ae_fields | index_miq_ae_fields_on_updated_by_user_id | 776 | 136 kB | 40 kB | N | 0 | 0 | 0 | |
| miq_ae_fields | miq_ae_fields_pkey | 776 | 136 kB | 40 kB | Y | 1113 | 1113 | 1113 | |
| miq_ae_instances | index_miq_ae_instances_on_ae_class_id | 258 | 32 kB | 16 kB | N | 159 | 2809 | 2809 | |
| miq_ae_instances | index_miq_ae_instances_on_updated_by_user_id | 258 | 32 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_instances | miq_ae_instances_pkey | 258 | 32 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_ae_methods | index_miq_ae_methods_on_class_id | 200 | 160 kB | 16 kB | N | 53 | 159 | 159 | |
| miq_ae_methods | index_miq_ae_methods_on_updated_by_user_id | 200 | 160 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_methods | miq_ae_methods_pkey | 200 | 160 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_ae_namespaces | index_miq_ae_namespaces_on_parent_id | 59 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_namespaces | index_miq_ae_namespaces_on_updated_by_user_id | 59 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_namespaces | miq_ae_namespaces_pkey | 59 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_ae_values | index_miq_ae_values_on_field_id | 305 | 40 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_values | index_miq_ae_values_on_instance_id | 305 | 40 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_values | index_miq_ae_values_on_updated_by_user_id | 305 | 40 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_ae_values | miq_ae_values_pkey | 305 | 40 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_ae_workspaces | miq_ae_workspaces_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_alert_statuses | index_miq_alert_statuses_on_miq_alert_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_alert_statuses | index_miq_alert_statuses_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_alert_statuses | miq_alert_statuses_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_alerts | miq_alerts_pkey | 25 | 24 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_approvals | index_miq_approvals_on_approver_id_and_approver_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_approvals | index_miq_approvals_on_miq_request_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_approvals | index_miq_approvals_on_stamper_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_approvals | miq_approvals_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_cim_associations | index_miq_cim_associations_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_associations | index_miq_cim_associations_on_result_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_associations | index_on_miq_cim_associations_for_gen_query | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_associations | index_on_miq_cim_associations_for_point_to_point | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_associations | miq_cim_associations_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_cim_derived_metrics | index_miq_cim_derived_metrics_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_derived_metrics | miq_cim_derived_stats_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_cim_instances | index_miq_cim_instances_on_agent_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_instances | index_miq_cim_instances_on_agent_top_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_instances | index_miq_cim_instances_on_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_instances | index_miq_cim_instances_on_metric_top_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_instances | index_miq_cim_instances_on_obj_name_str | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_cim_instances | index_miq_cim_instances_on_top_managed_element_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_instances | index_miq_cim_instances_on_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_cim_instances | miq_cim_instances_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_databases | miq_databases_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_dialogs | miq_dialogs_pkey | 14 | 24 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_enterprises | miq_enterprises_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_events | index_miq_events_on_guid | 116 | 32 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_events | miq_events_pkey | 116 | 32 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_globals | miq_globals_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_groups | index_miq_groups_on_miq_user_role_id | 12 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_groups | index_miq_groups_on_resource_id_and_resource_type | 12 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_groups | index_miq_groups_on_ui_task_set_id | 12 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_groups | miq_groups_pkey | 12 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_groups_users | index_miq_groups_users_on_user_id_and_miq_group_id | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_policies | miq_policies_pkey | 0 | 0 bytes | 8192 bytes | Y | 12 | 0 | 0 | |
| miq_policy_contents | index_miq_policy_contents_on_miq_action_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_policy_contents | index_miq_policy_contents_on_miq_event_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_policy_contents | index_miq_policy_contents_on_miq_policy_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_policy_contents | miq_policy_contents_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_product_features | index_miq_product_features_on_parent_id | 783 | 128 kB | 56 kB | N | 783 | 936 | 782 | |
| miq_product_features | miq_product_features_pkey | 783 | 128 kB | 40 kB | Y | 736 | 1044 | 736 | |
| miq_queue | index_miq_queue_on_task_id | 14591 | 4848 kB | 3848 kB | N | 30366 | 43192 | 28223 | |
| miq_queue | miq_queue_get_idx | 14591 | 4848 kB | 2920 kB | N | 1494128 | 131552066 | 2893543 | |
| miq_queue | miq_queue_get_sub_idx | 14591 | 4848 kB | 16 kB | N | 9928 | 10788 | 1063 | |
| miq_queue | miq_queue_pkey | 14591 | 4848 kB | 1840 kB | Y | 8107388 | 10596757 | 7865676 | |
| miq_queue | miq_queue_put_idx | 14591 | 4848 kB | 5704 kB | N | 2301740 | 470724812 | 134496640 | |
| miq_regions | miq_regions_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_report_result_details | miq_report_result_details_idx | 40209 | 14 MB | 6480 kB | N | 11 | 16624 | 0 | |
| miq_report_result_details | miq_report_result_details_pkey | 40209 | 14 MB | 2104 kB | Y | 160024 | 160024 | 145024 | |
| miq_report_results | index_miq_report_results_on_miq_group_id | 6 | 32 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_report_results | index_miq_report_results_on_miq_report_id | 6 | 32 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_report_results | index_miq_report_results_on_miq_task_id | 6 | 32 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_report_results | miq_report_results_pkey | 6 | 32 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_reports | index_miq_reports_on_db | 120 | 392 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_reports | index_miq_reports_on_miq_group_id | 120 | 392 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_reports | index_miq_reports_on_rpt_type | 120 | 392 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_reports | index_miq_reports_on_template_type | 120 | 392 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_reports | index_miq_reports_on_time_profile_id | 120 | 392 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_reports | miq_reports_pkey | 120 | 392 kB | 16 kB | Y | 1573 | 94656 | 94656 | |
| miq_request_tasks | index_miq_request_tasks_on_destination_id_and_destination_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_request_tasks | index_miq_request_tasks_on_miq_request_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_request_tasks | index_miq_request_tasks_on_source_id_and_source_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_request_tasks | miq_provisions_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_requests | index_miq_requests_on_destination_id_and_destination_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_requests | index_miq_requests_on_requester_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_requests | index_miq_requests_on_source_id_and_source_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| miq_requests | miq_requests_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_roles_features | | 756 | 40 kB | | N | | | | |
| miq_schedules | index_miq_schedules_on_miq_search_id | 9 | 24 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_schedules | index_miq_schedules_on_zone_id | 9 | 24 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_schedules | miq_schedules_pkey | 9 | 24 kB | 16 kB | Y | 6 | 6 | 6 | |
| miq_scsi_luns | index_miq_scsi_luns_on_miq_scsi_target_id | 400 | 72 kB | 16 kB | N | 1200 | 1200 | 0 | |
| miq_scsi_luns | miq_scsi_luns_pkey | 400 | 72 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_scsi_targets | index_miq_scsi_targets_on_guest_device_id | 400 | 56 kB | 40 kB | N | 1200 | 1205 | 1200 | |
| miq_scsi_targets | miq_scsi_targets_pkey | 400 | 56 kB | 40 kB | Y | 1200 | 1205 | 1200 | |
| miq_searches | miq_searches_pkey | 116 | 136 kB | 16 kB | Y | 1428 | 1428 | 1428 | |
| miq_servers | index_miq_servers_on_guid | 4 | 80 kB | 16 kB | Y | 4707823 | 14563157 | 11 | |
| miq_servers | index_miq_servers_on_vm_id | 4 | 80 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_servers | index_miq_servers_on_zone_id | 4 | 80 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_servers | miq_servers_pkey | 4 | 80 kB | 16 kB | Y | 681949 | 1625887 | 63078 | |
| miq_servers_product_updates | | 0 | 0 bytes | | N | | | | |
| miq_sets | index_miq_sets_on_group_id | 16 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_sets | index_miq_sets_on_guid | 16 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_sets | index_miq_sets_on_name | 16 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_sets | index_miq_sets_on_owner_id_and_owner_type | 16 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_sets | index_miq_sets_on_set_type | 16 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_sets | index_miq_sets_on_userid | 16 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| miq_sets | miq_sets_pkey | 16 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_shortcuts | miq_shortcuts_pkey | 44 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_storage_metrics | miq_cim_stats_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_tasks | index_miq_tasks_on_miq_server_id | 12092 | 3728 kB | 2216 kB | N | 12 | 0 | 0 | |
| miq_tasks | miq_tasks_pkey | 12092 | 3728 kB | 1288 kB | Y | 106011 | 479613 | 152895 | |
| miq_user_roles | miq_user_roles_pkey | 12 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| miq_widget_contents | index_miq_widget_contents_on_miq_report_result_id | 8 | 40 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_widget_contents | index_miq_widget_contents_on_miq_widget_id | 8 | 40 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_widget_contents | index_miq_widget_contents_on_user_id | 8 | 40 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_widget_contents | miq_widget_contents_pkey | 8 | 40 kB | 16 kB | Y | 0 | 0 | 0 | |
| miq_widget_shortcuts | miq_widget_shortcuts_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| miq_widgets | index_miq_widgets_on_miq_schedule_id | 9 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_widgets | index_miq_widgets_on_miq_task_id | 9 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_widgets | index_miq_widgets_on_resource_id_and_resource_type | 9 | 16 kB | 40 kB | N | 0 | 0 | 0 | |
| miq_widgets | index_miq_widgets_on_user_id | 9 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| miq_widgets | miq_widgets_pkey | 9 | 16 kB | 16 kB | Y | 808 | 912 | 808 | |
| miq_workers | index_miq_workers_on_guid | 8 | 816 kB | 288 kB | Y | 290 | 291 | 242 | |
| miq_workers | index_miq_workers_on_miq_server_id | 8 | 816 kB | 112 kB | N | 324390 | 13741555 | 1488 | |
| miq_workers | index_miq_workers_on_queue_name | 8 | 816 kB | 160 kB | N | 0 | 0 | 0 | |
| miq_workers | index_miq_workers_on_status | 8 | 816 kB | 128 kB | N | 111 | 1917 | 335 | |
| miq_workers | index_miq_workers_on_worker_type | 8 | 816 kB | 192 kB | N | 4564713 | 32872008 | 151110 | |
| miq_workers | miq_workers_pkey | 8 | 816 kB | 112 kB | Y | 1832643 | 2540575 | 1192474 | |
| networks | index_networks_on_device_id | 0 | 0 bytes | 128 kB | N | 10000 | 0 | 0 | |
| networks | index_networks_on_hardware_id | 0 | 0 bytes | 144 kB | N | 30648 | 0 | 0 | |
| networks | networks_pkey | 0 | 0 bytes | 104 kB | Y | 0 | 0 | 0 | |
| ontap_aggregate_derived_metrics | index_ontap_aggregate_derived_metrics_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_aggregate_derived_metrics | index_ontap_aggregate_derived_metrics_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_aggregate_derived_metrics | index_ontap_aggregate_derived_metrics_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_aggregate_derived_metrics | ontap_aggregate_derived_stats_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_aggregate_metrics_rollups | index_ontap_aggregate_metrics_rollups_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_aggregate_metrics_rollups | index_ontap_aggregate_metrics_rollups_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_aggregate_metrics_rollups | index_ontap_aggregate_metrics_rollups_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_aggregate_metrics_rollups | index_ontap_aggregate_metrics_rollups_on_time_profile_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_aggregate_metrics_rollups | ontap_aggregate_metrics_rollups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_disk_derived_metrics | index_ontap_disk_derived_metrics_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_disk_derived_metrics | index_ontap_disk_derived_metrics_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_disk_derived_metrics | index_ontap_disk_derived_metrics_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_disk_derived_metrics | ontap_disk_derived_stats_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_disk_metrics_rollups | index_ontap_disk_metrics_rollups_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_disk_metrics_rollups | index_ontap_disk_metrics_rollups_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_disk_metrics_rollups | index_ontap_disk_metrics_rollups_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_disk_metrics_rollups | index_ontap_disk_metrics_rollups_on_time_profile_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_disk_metrics_rollups | ontap_disk_metrics_rollups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_lun_derived_metrics | index_ontap_lun_derived_metrics_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_lun_derived_metrics | index_ontap_lun_derived_metrics_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_lun_derived_metrics | index_ontap_lun_derived_metrics_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_lun_derived_metrics | ontap_lun_derived_stats_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_lun_metrics_rollups | index_ontap_lun_metrics_rollups_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_lun_metrics_rollups | index_ontap_lun_metrics_rollups_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_lun_metrics_rollups | index_ontap_lun_metrics_rollups_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_lun_metrics_rollups | index_ontap_lun_metrics_rollups_on_time_profile_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_lun_metrics_rollups | ontap_lun_metrics_rollups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_system_derived_metrics | index_ontap_system_derived_metrics_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_system_derived_metrics | index_ontap_system_derived_metrics_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_system_derived_metrics | index_ontap_system_derived_metrics_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_system_derived_metrics | ontap_system_derived_stats_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_system_metrics_rollups | index_ontap_system_metrics_rollups_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_system_metrics_rollups | index_ontap_system_metrics_rollups_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_system_metrics_rollups | index_ontap_system_metrics_rollups_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_system_metrics_rollups | index_ontap_system_metrics_rollups_on_time_profile_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_system_metrics_rollups | ontap_system_metrics_rollups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_volume_derived_metrics | index_ontap_volume_derived_metrics_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_volume_derived_metrics | index_ontap_volume_derived_metrics_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_volume_derived_metrics | index_ontap_volume_derived_metrics_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_volume_derived_metrics | ontap_volume_derived_stats_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| ontap_volume_metrics_rollups | index_ontap_volume_metrics_rollups_on_miq_cim_instance_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_volume_metrics_rollups | index_ontap_volume_metrics_rollups_on_miq_storage_metric_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_volume_metrics_rollups | index_ontap_volume_metrics_rollups_on_smm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_volume_metrics_rollups | index_ontap_volume_metrics_rollups_on_time_profile_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ontap_volume_metrics_rollups | ontap_volume_metrics_rollups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| operating_system_flavors | index_operating_system_flavors_on_manager_ref | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| operating_system_flavors | index_operating_system_flavors_on_provisioning_manager_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| operating_system_flavors | operating_system_flavors_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| operating_systems | index_operating_systems_on_computer_system_id | 10200 | 1016 kB | 288 kB | N | 0 | 0 | 0 | |
| operating_systems | index_operating_systems_on_host_id | 10200 | 1016 kB | 304 kB | N | 1400 | 1400 | 1400 | |
| operating_systems | index_operating_systems_on_vm_id | 10200 | 1016 kB | 448 kB | N | 110000 | 110000 | 110000 | |
| operating_systems | operating_systems_pkey | 10200 | 1016 kB | 240 kB | Y | 0 | 0 | 0 | |
| orchestration_stack_outputs | index_orchestration_stack_outputs_on_stack_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| orchestration_stack_outputs | orchestration_stack_outputs_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| orchestration_stack_parameters | index_orchestration_stack_parameters_on_stack_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| orchestration_stack_parameters | orchestration_stack_parameters_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| orchestration_stack_resources | index_orchestration_stack_resources_on_stack_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| orchestration_stack_resources | orchestration_stack_resources_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| orchestration_stacks | index_orchestration_stacks_on_ancestry | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| orchestration_stacks | index_orchestration_stacks_on_orchestration_template_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| orchestration_stacks | orchestration_stacks_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| orchestration_templates | index_orchestration_templates_on_md5 | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| orchestration_templates | orchestration_templates_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| os_processes | index_os_processes_on_operating_system_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| os_processes | os_processes_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| partitions | index_partitions_on_disk_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| partitions | index_partitions_on_hardware_id_and_volume_group | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| partitions | partitions_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| patches | index_patches_on_host_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| patches | index_patches_on_vm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| patches | patches_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| pictures | pictures_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| policy_event_contents | index_policy_event_contents_on_policy_event_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_event_contents | index_policy_event_contents_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_event_contents | policy_event_contents_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| policy_events | index_policy_events_on_chain_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_events | index_policy_events_on_ems_cluster_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_events | index_policy_events_on_ems_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_events | index_policy_events_on_host_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_events | index_policy_events_on_miq_event_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_events | index_policy_events_on_miq_policy_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_events | index_policy_events_on_target_id_and_target_class | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| policy_events | policy_events_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| providers | providers_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| pxe_image_types | pxe_image_types_pkey | 4 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| pxe_images | index_pxe_images_on_pxe_server_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| pxe_images | os_images_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| pxe_menus | pxe_menus_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| pxe_servers | tftp_servers_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| registry_items | index_registry_items_on_miq_set_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| registry_items | index_registry_items_on_scan_item_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| registry_items | index_registry_items_on_vm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| registry_items | registry_items_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| relationships | index_relationships_on_ancestry | 20389 | 3376 kB | 3200 kB | N | 5692 | 82624 | 82624 | |
| relationships | index_relationships_on_resource_and_relationship | 20389 | 3376 kB | 1992 kB | N | 9758994 | 12969211 | 3247354 | |
| relationships | relationships_pkey | 20389 | 3376 kB | 464 kB | Y | 25926560 | 25926560 | 25926560 | |
| repositories | index_repositories_on_storage_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| repositories | repositories_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| reserves | index_reserves_on_resource_id_and_resource_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| reserves | reserves_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| resource_actions | resource_actions_pkey | 22 | 24 kB | 40 kB | Y | 0 | 0 | 0 | |
| resource_pools | index_resource_pools_on_ems_id | 220 | 64 kB | 16 kB | N | 6 | 1320 | 1320 | |
| resource_pools | index_resource_pools_on_uid | 220 | 64 kB | 16 kB | N | 0 | 0 | 0 | |
| resource_pools | resource_pools_pkey | 220 | 64 kB | 16 kB | Y | 3244843 | 3244843 | 3244843 | |
| rss_feeds | index_rss_feeds_on_name | 21 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| rss_feeds | rss_feeds_pkey | 21 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| scan_histories | index_scan_histories_on_vm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| scan_histories | scan_histories_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| scan_items | index_scan_items_on_guid | 6 | 16 kB | 16 kB | Y | 0 | 0 | 0 | |
| scan_items | index_scan_items_on_item_type | 6 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| scan_items | index_scan_items_on_name | 6 | 16 kB | 16 kB | N | 0 | 0 | 0 | |
| scan_items | scan_items_pkey | 6 | 16 kB | 16 kB | Y | 0 | 0 | 0 | |
| schema_migrations | unique_schema_migrations | 424 | 24 kB | 32 kB | Y | 0 | 0 | 0 | |
| security_groups | security_groups_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| security_groups_vms | | 0 | 0 bytes | | N | | | | |
| server_roles | server_roles_pkey | 23 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| service_resources | service_resources_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| service_template_catalogs | service_template_catalogs_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| service_templates | services_and_templates_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| services | services_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| sessions | index_sessions_on_session_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| sessions | index_sessions_on_updated_at | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| sessions | sessions_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| snapshots | index_snapshots_on_parent_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| snapshots | index_snapshots_on_parent_uid | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| snapshots | index_snapshots_on_uid | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| snapshots | index_snapshots_on_vm_id | 0 | 0 bytes | 8192 bytes | N | 30000 | 0 | 0 | |
| snapshots | snapshots_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| storage_files | index_storage_files_on_storage_id | 0 | 0 bytes | 8192 bytes | N | 47073 | 0 | 0 | |
| storage_files | index_storage_files_on_vm_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| storage_files | storage_files_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| storage_managers | index_storage_managers_on_parent_agent_id | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| storage_managers | index_storage_managers_on_zone_id | 0 | 0 bytes | 8192 bytes | N | 2 | 0 | 0 | |
| storage_managers | miq_smis_agents_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| storage_metrics_metadata | storage_metrics_metadata_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| storages | index_storages_on_location | 221 | 248 kB | 72 kB | N | 0 | 0 | 0 | |
| storages | index_storages_on_name | 221 | 248 kB | 40 kB | N | 0 | 0 | 0 | |
| storages | storages_pkey | 221 | 248 kB | 16 kB | Y | 637872 | 638178 | 637872 | |
| storages_vms_and_templates | index_storages_vms_on_vm_id_and_storage_id | 10000 | 440 kB | 328 kB | Y | 387802 | 387802 | 0 | |
| switches | index_switches_on_host_id | 200 | 24 kB | 16 kB | N | 0 | 0 | 0 | |
| switches | index_switches_on_name | 200 | 24 kB | 16 kB | N | 0 | 0 | 0 | |
| switches | switches_pkey | 200 | 24 kB | 16 kB | Y | 0 | 0 | 0 | |
| system_services | index_system_services_on_host_id | 400 | 88 kB | 40 kB | N | 1200 | 1864 | 600 | |
| system_services | index_system_services_on_host_service_group_id | 400 | 88 kB | 48 kB | N | 0 | 0 | 0 | |
| system_services | index_system_services_on_typename | 400 | 88 kB | 40 kB | N | 0 | 0 | 0 | |
| system_services | index_system_services_on_vm_id | 400 | 88 kB | 40 kB | N | 0 | 0 | 0 | |
| system_services | system_services_pkey | 400 | 88 kB | 40 kB | Y | 1200 | 1232 | 1200 | |
| taggings | index_taggings_on_tag_id | 20036 | 2272 kB | 1120 kB | N | 0 | 0 | 0 | |
| taggings | index_taggings_on_taggable_id_and_taggable_type | 20036 | 2272 kB | 1496 kB | N | 3890552562 | 843268834 | 1650 | |
| taggings | taggings_pkey | 20036 | 2272 kB | 896 kB | Y | 0 | 0 | 0 | |
| tags | tags_pkey | 132 | 16 kB | 16 kB | Y | 0 | 0 | 0 | |
| time_profiles | time_profiles_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| ui_tasks | index_ui_tasks_on_area_and_typ_and_task | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| ui_tasks | ui_tasks_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| users | index_users_on_current_group_id | 1 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| users | index_users_on_ui_task_set_id | 1 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| users | index_users_on_userid_and_region | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| users | users_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| vim_performance_operating_ranges | index_vpor_on_resource | 8 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| vim_performance_operating_ranges | index_vpor_on_time_profile_id | 8 | 8192 bytes | 16 kB | N | 0 | 0 | 0 | |
| vim_performance_operating_ranges | vim_performance_operating_ranges_pkey | 8 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| vim_performance_states | index_vim_performance_states_on_resource_and_timestamp | 9.44383e+06 | 4933 MB | 813 MB | N | 27824026 | 43686004 | 43685891 | |
| vim_performance_states | vim_performance_states_pkey | 9.44383e+06 | 4933 MB | 203 MB | Y | 0 | 0 | 0 | |
| vim_performance_tag_values | index_vim_performance_tag_values_on_metric_id_and_metric_type | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| vim_performance_tag_values | vim_performance_tag_values_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| vmdb_database_metrics | vmdb_database_metrics_pkey | 1790 | 224 kB | 56 kB | Y | 0 | 0 | 0 | |
| vmdb_databases | vmdb_databases_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| vmdb_indexes | vmdb_indexes_pkey | 840 | 184 kB | 56 kB | Y | 58032 | 58032 | 58032 | |
| vmdb_metrics | index_vmdb_metrics_on_resource_and_timestamp | 1.62168e+06 | 252 MB | 143 MB | N | 6960 | 6960 | 6960 | |
| vmdb_metrics | vmdb_metrics_pkey | 1.62168e+06 | 252 MB | 35 MB | Y | 0 | 0 | 0 | |
| vmdb_tables | vmdb_tables_pkey | 462 | 224 kB | 40 kB | Y | 22878 | 22878 | 22878 | |
| vms | index_vms_on_availability_zone_id | 10000 | 5664 kB | 1912 kB | N | 0 | 0 | 0 | |
| vms | index_vms_on_ems_id | 10000 | 5664 kB | 1920 kB | N | 12 | 0 | 0 | |
| vms | index_vms_on_evm_owner_id | 10000 | 5664 kB | 1872 kB | N | 0 | 0 | 0 | |
| vms | index_vms_on_flavor_id | 10000 | 5664 kB | 1888 kB | N | 0 | 0 | 0 | |
| vms | index_vms_on_guid | 10000 | 5664 kB | 976 kB | Y | 0 | 0 | 0 | |
| vms | index_vms_on_host_id | 10000 | 5664 kB | 408 kB | N | 240611 | 12384371 | 0 | |
| vms | index_vms_on_location | 10000 | 5664 kB | 1232 kB | N | 0 | 0 | 0 | |
| vms | index_vms_on_miq_group_id | 10000 | 5664 kB | 1864 kB | N | 0 | 0 | 0 | |
| vms | index_vms_on_name | 10000 | 5664 kB | 744 kB | N | 0 | 0 | 0 | |
| vms | index_vms_on_storage_id | 10000 | 5664 kB | 1920 kB | N | 31382 | 0 | 0 | |
| vms | index_vms_on_vmm_uuid | 10000 | 5664 kB | 808 kB | N | 30000 | 30745 | 30000 | |
| vms | vms_pkey | 10000 | 5664 kB | 400 kB | Y | 4997802 | 5009961 | 1976602 | |
| volumes | index_volumes_on_hardware_id_and_volume_group | 0 | 0 bytes | 8192 bytes | N | 0 | 0 | 0 | |
| volumes | volumes_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| windows_images | windows_images_pkey | 0 | 0 bytes | 8192 bytes | Y | 0 | 0 | 0 | |
| zones | zones_pkey | 1 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| (632 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment