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. |
