gp_resq_priority_statement

The gp_toolkit.gp_resq_priority_statement view shows the resource queue priority, session ID, and other information for all statements currently running in the Greengage DB system. This view is accessible to all users.

Column Description

Column	Description
rqpdatname	The database name that the session is connected to
rqpusename	The user that issued the statement
rqpsession	The session ID
rqpcommand	The number of the statement within this session (the command ID and session ID uniquely identify a statement)
rqppriority	The resource queue priority for this statement (`MAX`, `HIGH`, `MEDIUM`, `LOW`)
rqpweight	An integer value associated with the priority of this statement
rqpquery	The query text of the statement

rqpdatname

The database name that the session is connected to

rqpusename

The user that issued the statement

rqpsession

The session ID

rqpcommand

The number of the statement within this session (the command ID and session ID uniquely identify a statement)

rqppriority

The resource queue priority for this statement (MAX, HIGH, MEDIUM, LOW)

rqpweight

An integer value associated with the priority of this statement

rqpquery

The query text of the statement

gp_resq_priority_backend

gp_resq_role