GS_PLAN_TRACE

The GS_PLAN_TRACE system catalog stores plan traces. It records details about the plan generation process of DML statements. Only initial users have the write permission on this system catalog. Users with the sysadmin permission can read this system catalog.

**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)