DROP RESOURCE QUEUE

Description

This command removes a resource queue from Greenplum Database. To drop a resource queue, the queue cannot have any roles assigned to it, nor can it have any statements waiting in the queue. Only a superuser can drop a resource queue.

queue_name

The name of a resource queue to remove.

Notes

To see all the currently active queries for all resource queues, perform the following query of the table joined with the pg_roles and tables:

To see the roles assigned to a resource queue, perform the following query of the pg_roles and system catalog tables:

Remove a role from a resource queue (and move the role to the default resource queue, pg_default):

Compatibility

The DROP RESOURCE QUEUE statement is a Greenplum Database extension.

, CREATE RESOURCE QUEUE,

Parent topic: SQL Command Reference