GS_PLAN_TRACE

GS_PLAN_TRACE is used to store plan traces. It records details about the plan generation process of DML statements. Only users with the sysadmin permission can use this system catalog. The plan trace feature is not supported in the distributed scenario. Therefore, no data is displayed in this view in the distributed scenario.

**Table 1** GS_PLAN_TRACE columns
Name	Type	Description
query_id	text	Unique ID of the current request
query	text	SQL statement of the current request. The value of this field cannot exceed the value of track_activity_query_size.
unique_sql_id	bigint	Unique ID of the SQL statement of the current request
plan	text	Query plan text corresponding to the current request SQL statement. The value of this field cannot exceed 10 KB.
plan_trace	text	Details about the query plan generation process corresponding to the SQL statement of the current request. The value of this field cannot exceed 300 MB.
owner	oid	OID of the user who initiates the current SQL request
modifydate	timestamp with time zone	Time when the current plan trace is updated (that is, time when the plan trace is created)