System catalogs v15

System catalogs store the resource group information used by EDB Resource Manager.

edb_all_resource_groups

The following table lists the information available in the edb_all_resource_groups catalog.

ColumnTypeDescription
group_namenameThe name of the resource group.
active_processesintegerNumber of currently active processes in the resource group.
cpu_rate_limitfloat8Maximum CPU rate limit for the resource group. 0 means no limit.
per_process_cpu_rate_limitfloat8Maximum CPU rate limit per currently active process in the resource group.
dirty_rate_limitfloat8Maximum dirty rate limit for a resource group. 0 means no limit.
per_process_dirty_rate_limitfloat8Maximum dirty rate limit per currently active process in the resource group.

edb_resource_group

The following table lists the information available in the edb_resource_group catalog.

ColumnTypeDescription
rgrpnamenameThe name of the resource group.
rgrpcpuratelimitfloat8Maximum CPU rate limit for a resource group. 0 means no limit.
rgrpdirtyratelimitfloat8Maximum dirty rate limit for a resource group. 0 means no limit.