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 service thread start timestamp and a service 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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot