Updated on 2024-05-07 GMT+08:00

GS_MY_PLAN_TRACE

GS_MY_PLAN_TRACE is a view of the GS_PLAN_TRACE system catalog. This view displays the plan traces of the current user. 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_MY_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 column 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 SQL statement of the current request The size of this column 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 column cannot exceed 300 MB.

modifydate

timestamp with time zone

Time when the current plan trace is updated (that is, time when the plan trace is created)