GaussDB-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.
| 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 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. |
| modifydate | timestamp with time zone | Time when the current plan trace is updated (that is, time when the plan trace is created). |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
