View netapp_model_view.qos_policy_group_full Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
objid bigint 19
uuid varchar 255 Policy group UUID. ZAPIs: qos-policy-group-get-iter.qos-policy-group-info.uuid
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally.
clusterId bigint 19
vserverId bigint 19  √  null ID of the vserver the QoS Policy Group references
policyGroup varchar 255  √  null Name of the policy group. ZAPIs: qos-policy-group-get-iter.qos-policy-group-info.policy-group
pgIdentifier bigint 19  √  null The ID used to identify the policy group. ZAPIs: qos-policy-group-get-iter.qos-policy-group-info.pgid
policyGroupClass enum 14  √  null Class for the policy group. ZAPIs: qos-policy-group-get-iter.qos-policy-group-info.policy-group-class
policyGroupClassRaw varchar 255  √  null
maxThroughput varchar 255  √  null Maximum throughput defined by this policy. It is specified in terms of IOPS or MB/s, and the range is zero to infinity. ZAPIs: qos-policy-group-get-iter.qos-policy-group-info.max-throughput
minThroughput varchar 255  √  null Minimum throughput defined by this policy.
isShared bit 0 1 is limit shared between objects.
isAdaptive bit 0 0 indicates if policy is adaptive QoS policy
minIOPsAllocation varchar 255  √  null Minimum IOPs allowed when object has no used capacity
enforceFloor bit 0  √  null enforce floor iops, applicable for adaptive QoS policies
allocation enum 15  √  null
minAllocation enum 15  √  null Expected IOPS allocation.
blockSize varchar 256  √  null Specifies the block size for the IOPS provisioned.
capacityUnit enum 11  √  null capacity units: GB or TB, applicable for adaptive QoS policies
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `pg`.`objid` AS `objid`,`pg`.`UUID` AS `uuid`,`pg`.`resourceKey` AS `resourceKey`,`pg`.`clusterId` AS `clusterId`,`pgv`.`vserverId` AS `vserverId`,`pg`.`policyGroup` AS `policyGroup`,`pg`.`pgIdentifier` AS `pgIdentifier`,`pg`.`policyGroupClass` AS `policyGroupClass`,`pg`.`policyGroupClassRaw` AS `policyGroupClassRaw`,`pg`.`maxThroughput` AS `maxThroughput`,`pg`.`minThroughput` AS `minThroughput`,`pg`.`isShared` AS `isShared`,`pg`.`isAdaptive` AS `isAdaptive`,`pg`.`minIOPsAllocation` AS `minIOPsAllocation`,`pg`.`enforceFloor` AS `enforceFloor`,`pg`.`allocation` AS `allocation`,`pg`.`minAllocation` AS `minAllocation`,`pg`.`blockSize` AS `blockSize`,`pg`.`capacityUnit` AS `capacityUnit`,`pg`.`createtime` AS `createTime`,`pg`.`updatetime` AS `updateTime`,`pg`.`objState` AS `objState` from (`netapp_model`.`qos_policy_group` `pg` left join `netapp_model`.`qos_policy_group_vserver_relationship` `pgv` on((`pg`.`objid` = `pgv`.`objid`)))