GS_SPM_SQL_BASELINE
GS_SPM_SQL_BASELINE is used to view the baseline information of the current user. Users with permissions higher than common users can access this view.
Name |
Type |
Description |
---|---|---|
sql_namespace |
oid |
OID of a schema. |
sql_hash |
bigint |
Unique ID of an SQL statement in the current schema. |
plan_hash |
bigint |
Unique ID of a plan in the current SQL statement. |
outline |
text |
Outline text, which can be used to fix a group of hints of the current plan. |
status |
text |
Status of a plan. Value range:
|
gplan |
Boolean |
Specifies whether the plan corresponding to the current outline is a gplan. |
cost |
double precision |
Total plan cost. |
sql_text |
text |
SQL text string. |
param_num |
integer |
Number of SQL parameters. |
source |
text |
Baseline source. |
creation_time |
timestamp with time zone |
Time when the baseline is created. |
modification_time |
timestamp with time zone |
Time when the baseline is modified. |
jump_intercept_cnt |
bigint |
Number of baseline interception plan jumps. |
invalid |
Boolean |
Specifies whether the current baseline is invalid. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot