Skip to content

Instantly share code, notes, and snippets.

@blomquisg
Created August 18, 2017 19:33
Show Gist options
  • Save blomquisg/583997822e6f5e7f2bbe6e8ecd05840a to your computer and use it in GitHub Desktop.
Save blomquisg/583997822e6f5e7f2bbe6e8ecd05840a to your computer and use it in GitHub Desktop.
------------- sorted by counts ------------
CustomAttribute: 3626164
ContainerEnvVar: 719951
ContainerVolume: 306119
SecurityContext: 136416
ContainerCondition: 132173
ContainerPortConfig: 107817
ContainerImage: 83902
Tagging: 22522
Container: 16014
ManageIQ::Providers::Kubernetes::ContainerManager::ContainerGroup: 16009
ContainerGroup: 16009
ContainerQuotaItem: 12440
ContainerReplicator: 8128
ContainerLimitItem: 6224
ContainerBuildPod: 6205
ContainerTemplateParameter: 5644
ContainerServicePortConfig: 4254
ContainerRoute: 3076
ContainerService: 2708
PersistentVolume: 2216
ContainerProject: 1659
PersistentVolumeClaim: 1616
ContainerLimit: 1556
ContainerQuota: 1555
ContainerBuild: 1446
ContainerTemplate: 536
Tag: 480
OperatingSystem: 216
ManageIQ::Providers::Kubernetes::ContainerManager::ContainerNode: 216
Hardware: 216
ContainerNode: 216
ComputerSystem: 216
MiqEventDefinition: 175
ContainerLabelTagMapping: 154
ServerRole: 24
MiqGroup: 17
User: 8
ContainerImageRegistry: 8
Authentication: 6
Endpoint: 4
MiqServer: 3
ExtManagementSystem: 2
Tenant: 1
Vm: 0
ContainerComponentStatus: 0
------------- sorted with soft deleted by counts ------------
CustomAttribute: 3626164
ContainerEnvVar: 719951
ContainerVolume: 306119
ContainerImage: 196463
SecurityContext: 136416
ManageIQ::Providers::Kubernetes::ContainerManager::ContainerGroup: 133520
ContainerGroup: 133520
ContainerCondition: 132173
Container: 132148
ContainerPortConfig: 107817
Tagging: 22522
ContainerQuotaItem: 12440
ContainerReplicator: 8128
ContainerProject: 7347
ContainerLimitItem: 6224
ContainerBuildPod: 6205
ContainerTemplateParameter: 5644
ContainerServicePortConfig: 4254
ContainerRoute: 3076
ContainerService: 2708
PersistentVolume: 2216
PersistentVolumeClaim: 1616
ContainerLimit: 1556
ContainerQuota: 1555
ContainerBuild: 1446
ContainerTemplate: 536
Tag: 480
OperatingSystem: 216
ManageIQ::Providers::Kubernetes::ContainerManager::ContainerNode: 216
Hardware: 216
ContainerNode: 216
ComputerSystem: 216
MiqEventDefinition: 175
ContainerLabelTagMapping: 154
ServerRole: 24
MiqGroup: 17
User: 8
ContainerImageRegistry: 8
Authentication: 6
Endpoint: 4
MiqServer: 3
ExtManagementSystem: 2
Tenant: 1
Vm: 0
ContainerComponentStatus: 0
-------------------------------------------
Total: 5244321 records
Total with soft deleted: 5713726 records
---------------------------------------------------------------------------------
EMS [CTC DMZ] specific relations counts
---------------------------------------------------------------------------------
--------------------------Handpicked relations--------------------------------
container_images: 20399
container_images custom_attributes: 452710
container_replicators: 3541
container_replicators custom_attributes: 22042
container_build_pods: 3172
container_build_pods custom_attributes: 12421
container_groups: 2551
container_groups custom_attributes: 17782
container_routes: 1108
container_routes custom_attributes: 1744
container_services: 1095
container_services custom_attributes: 3746
container_projects: 475
container_projects custom_attributes: 7269
container_builds: 382
container_builds custom_attributes: 800
container_templates: 207
container_templates custom_attributes: 14
container_nodes: 91
container_nodes custom_attributes: 449
--------------------------All relations--------------------------------------------
ems_events: 4704211
container_images: 20399
miq_events: 11961
vim_performance_states: 5188
metric_rollups: 4450
container_replicators: 3541
container_build_pods: 3172
containers: 2586
container_groups: 2562
container_routes: 1111
container_services: 1097
persistent_volumes: 868
persistent_volume_claims: 599
container_projects: 475
container_limits: 448
container_quotas: 448
container_builds: 382
container_templates: 207
container_nodes: 91
container_image_registries: 3
authentications: 2
endpoints: 2
vim_performance_operating_ranges: 1
tags: 1
taggings: 1
container_component_statuses: 0
all_relationships: 0
compliances: 0
cloud_subnets: 0
metrics: 0
storage_profiles: 0
customization_specs: 0
resource_pools: 0
ems_clusters: 0
ems_folders: 0
blacklisted_events: 0
policy_events: 0
storages: 0
vms: 0
miq_templates: 0
vms_and_templates: 0
hosts: 0
container_deployments: 0
miq_custom_attributes: 0
custom_attributes: 0
---------------------------------------------------------------------------------
EMS [CTC Core] specific relations counts
---------------------------------------------------------------------------------
--------------------------Handpicked relations--------------------------------
container_images: 63503
container_images custom_attributes: 1001175
container_groups: 13458
container_groups custom_attributes: 85543
container_replicators: 4587
container_replicators custom_attributes: 23748
container_build_pods: 3033
container_build_pods custom_attributes: 10296
container_routes: 1968
container_routes custom_attributes: 2129
container_services: 1613
container_services custom_attributes: 4242
container_projects: 1184
container_projects custom_attributes: 16184
container_builds: 1064
container_builds custom_attributes: 1458
container_templates: 329
container_templates custom_attributes: 15
container_nodes: 125
container_nodes custom_attributes: 627
--------------------------All relations--------------------------------------------
ems_events: 8980045
container_images: 63503
container_groups: 13458
containers: 13437
miq_events: 10490
metric_rollups: 4654
container_replicators: 4587
vim_performance_states: 4367
container_build_pods: 3033
container_routes: 1968
container_services: 1613
persistent_volumes: 1348
container_projects: 1184
container_limits: 1108
container_quotas: 1107
container_builds: 1064
persistent_volume_claims: 1017
container_templates: 329
container_nodes: 125
container_image_registries: 5
authentications: 3
endpoints: 2
vim_performance_operating_ranges: 1
container_component_statuses: 0
all_relationships: 0
tags: 0
taggings: 0
compliances: 0
cloud_subnets: 0
metrics: 0
storage_profiles: 0
customization_specs: 0
resource_pools: 0
ems_clusters: 0
ems_folders: 0
blacklisted_events: 0
policy_events: 0
storages: 0
vms: 0
miq_templates: 0
vms_and_templates: 0
hosts: 0
container_deployments: 0
miq_custom_attributes: 0
custom_attributes: 0
@cben
Copy link

cben commented Aug 22, 2017

counts from CTC_Core.yml

container_nodes: count 129
container_projects: count 1188
container_quotas: count 1112
container_limits: count 1113
container_replicators: count 4653
persistent_volume_claims: count 1023
persistent_volumes: count 1352
container_groups: count 4298
container_image_registries: count 5
container_endpoints: count 2046
container_services: count 2046
container_component_statuses: count 0
container_images: count 64925
container_routes: count 2449
container_builds: count 1061
container_build_pods: count 2998
container_templates: count 395

@cben
Copy link

cben commented Aug 22, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment