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.