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.