ADM_HIST_SQL_PLAN
ADM_HIST_SQL_PLAN displays plan information collected by the current user by running the EXPLAIN PLAN statement. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| dbid | text | Database ID |
| sql_id | character varying(30) | Session that inserts the data. Its value consists of a worker thread start timestamp and a worker thread ID. Values are constrained by NOT NULL. |
| plan_hash_value | bigint | Query ID. |
| id | integer | Number assigned to each step in the execution plan |
| operation | character varying(30) | Operation description |
| options | character varying(255) | Operation action |
| object_node | character varying(128) | Not supported. Set it to NULL. |
| object# | numeric | Not supported. Set it to NULL. |
| object_owner | name | Object number of a table or an index |
| object_name | name | Name of an operated object. It is defined by users. |
| object_alias | character varying(261) | Not supported. Set it to NULL. |
| object_type | character varying(30) | Object type |
| optimizer | character varying(20) | Not supported. Set it to NULL. |
| parent_id | numeric | Not supported. Set it to NULL. |
| depth | numeric | Not supported. Set it to NULL. |
| position | numeric | Not supported. Set it to NULL. |
| search_columns | numeric | Not supported. Set it to NULL. |
| cost | double precision | Execution cost estimated by the optimizer for an operator |
| cardinality | double precision | Cardinality estimated by the optimizer for an operator to access table records. |
| bytes | numeric | Not supported. Set it to NULL. |
| other_tag | character varying(35) | Not supported. Set it to NULL. |
| partition_start | character varying(64) | Not supported. Set it to NULL. |
| partition_stop | character varying(64) | Not supported. Set it to NULL. |
| partition_id | numeric | Not supported. Set it to NULL. |
| other | character varying(4000) | Not supported. Set it to NULL. |
| distribution | character varying(20) | Not supported. Set it to NULL. |
| cpu_cost | numeric | Not supported. Set it to NULL. |
| io_cost | numeric | Not supported. Set it to NULL. |
| temp_space | numeric | Not supported. Set it to NULL. |
| access_predicates | character varying(4000) | Not supported. Set it to NULL. |
| filter_predicates | character varying(4000) | Not supported. Set it to NULL. |
| projection | character varying(4000) | Returned column information |
| time | numeric | Not supported. Set it to NULL. |
| qblock_name | character varying(128) | Not supported. Set it to NULL. |
| remarks | character varying(4000) | Not supported. Set it to NULL. |
| timestamp | date | Not supported. Set it to NULL. |
| other_xml | clob | Not supported. Set it to NULL. |
| con_dbid | text | Database ID of a container, which is currently set to a value the same as that of dbid. |
| con_id | numeric | Container ID. Containers are not supported and this field is set to 0. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
