GS_BLOCKLIST_QUERY

GS_BLOCKLIST_QUERY is used to query job blocklist and exception information. This view is obtained by associating system catalogs GS_BLOCKLIST_QUERY and GS_WLM_SESSION_INFO, and deduplicating query results. If the GS_WLM_SESSION_INFO table is large, the query may take a long time.

**Table 1** GS_BLOCKLIST_QUERY columns
Name	Type	Reference	Description
unique_sql_id	bigint	-	Unique query ID generated based on the query parsing tree.
block_list	boolean	-	Check whether a job is in the blocklist.
except_num	integer	-	Query the number of job exceptions.
except_time	timestamp	-	Query the time when the last job exception occurred.
query	text	-	Statement to be executed.

This view can be queried only in the gaussdb database. If it is queried in other databases, an error will be reported.
Generally, constant values are ignored during unique SQL ID calculation in DML statements. However, constant values cannot be ignored in DDL, DCL, and parameter setting statements. A unique_sql_id may correspond to one or more queries.

Parent topic: System Views

Previous topic: GS_ALL_CONTROL_GROUP_INFO

Next topic: GS_CLUSTER_RESOURCE_INFO