GS_SPM_SYS_BASELINE
GS_SPM_SYS_BASELINE is used to view baseline information in the database. The user with the SYSADMIN permission and initial users can access this view.
Name |
Type |
Description |
---|---|---|
sql_hash |
bigint |
Unique ID of the SQL statement in the SPM. |
plan_hash |
bigint |
Unique ID of a plan in the current SQL statement. |
unique_sql_id |
bigint |
Unique ID of an SQL statement in the database. |
outline |
text |
Outline text, which can be used to fix a group of hints of the current plan. |
status |
integer |
Plan status. The options are as follows:
|
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