GV_SESSION

sid

bigint

Name of the database where the hot key is located.

serial#

integer

Name of the schema where the hot key is located.

schemaname

name

Name of the table where the hot key is located.

user#

oid

Value of a hot key.

username

name

Hash value of the hot key in the database. If the table is a list or range distribution table, the value of this field is 0.

machine

text

Frequency of accessing the hot key.

sql_id

bigint

SQL OID.

client_info

text

Client information.

event

text

Queuing status of a statement. The value must be one of the following:

• waiting in queue: The statement is in the queue.
• Empty: The statement is running.

sql_exec_start

timestamp

SQL statement execution start time.

program

text

Name of the application connected to the backend.

status

text

Overall status of this backend. The value must be one of the following:

• active: The backend is executing a query.
• idle: The backend is waiting for a new client command.
• idle in transaction: The backend is in a transaction, but there is no statement being executed in the transaction.
• idle in transaction (aborted): The backend is in a transaction, but there are statements failed in the transaction.
• fastpath function call: The backend is executing a fast-path function.
• disabled: This state is reported if track_activities is disabled in this backend.