Help Center/ GaussDB/ Centralized_2.x/ System Catalogs and System Views/ System Views/ ADM_HIST_SQL_PLAN

Updated on 2023-10-23 GMT+08:00

View PDF

ADM_HIST_SQL_PLAN

ADM_HIST_SQL_PLAN displays plan information collected by the current user by running the EXPLAIN PLAN statement. By default, only the system administrator can access this view. Common users can access the view only after being authorized.

**Table 1** ADM_HIST_SQL_PLAN columns
Name	Type	Description
SQL_ID	character varying(30)	Session that inserts the data. Its value consists of a service thread start timestamp and a service thread ID. Values are constrained by NOT NULL.
PLAN_HASH_VALUE	bigint	Query ID.
OPERATION	character varying(30)	Operation description.
OPTIONS	character varying(255)	Operation action.
OBJECT_NAME	name	Name of an operated object. It is defined by users.

Parent topic: System Views

Previous topic: ADM_HIST_SNAPSHOT

Next topic: ADM_HIST_SQLSTAT

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.