---
title: "DROP RESOURCE GROUP"
source: https://cloudberry.apache.org/docs/sql-stmts/drop-resource-group
---

# DROP RESOURCE GROUP

Removes a resource group.

## Synopsis

```sql
DROP RESOURCE GROUP <group_name>
```

## Description

This command removes a resource group from Apache Cloudberry. Only a superuser can drop a resource group. When you drop a resource group, the memory and CPU resources reserved by the group are returned to Apache Cloudberry.

To drop a role resource group, the group cannot be assigned to any roles, nor can it have any statements pending or running in the group. If you drop a resource group that you created for an external component, the behavior is determined by the external component. For example, dropping a resource group that you assigned to a PL/Container runtime stops running containers in the group.

You cannot drop the pre-defined `admin_group` and `default_group` resource groups.

## Parameters

**`group_name`**

The name of the resource group to remove.

## Notes

You cannot submit a `DROP RESOURCE GROUP` command in an explicit transaction or sub-transaction.

Use [ALTER ROLE](/docs/sql-stmts/alter-role.md) to remove a resource group assigned to a specific user/role.

Perform the following query to view all of the currently active queries for all resource groups:

```sql
SELECT usename, query, waiting, pid,
    rsgid, rsgname, rsgqueueduration 
  FROM pg_stat_activity;
```

To view the resource group assignments, perform the following query on the `pg_roles` and `pg_resgroup` system catalog tables:

```sql
SELECT rolname, rsgname 
  FROM pg_roles, pg_resgroup
  WHERE pg_roles.rolresgroup=pg_resgroup.oid;
```

## Examples

Remove the resource group assigned to a role. This operation then assigns the default resource group `default_group` to the role:

```sql
ALTER ROLE bob RESOURCE GROUP NONE;
```

Remove the resource group named `adhoc`:

```sql
DROP RESOURCE GROUP adhoc;
```

## Compatibility

The `DROP RESOURCE GROUP` statement is a Apache Cloudberry extension.

## See also

[ALTER RESOURCE GROUP](/docs/sql-stmts/alter-resource-group.md), [CREATE RESOURCE GROUP](/docs/sql-stmts/create-resource-group.md), [ALTER ROLE](/docs/sql-stmts/alter-role.md)