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.

**Table 1** ADM_HIST_SQL_PLAN columns
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.