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. This view exists in both PG_CATALOG and SYS schema.

**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 service thread start timestamp and a service thread ID. Values are constrained by NOT NULL.
id	integer	Number assigned to each step in the execution plan.
plan_hash_value	bigint	Query ID.
operation	character varying(30)	Operation description.
options	character varying(255)	Operation option.
object_name	name	Name of the operated object. It is defined by users.
object_node	character varying(128)	Not supported. Its value is NULL.
object#	numeric	Not supported. Its value is NULL.
object_owner	name	Object number of a table or an index.
object_alias	character varying(261)	Not supported. Its value is NULL.
object_type	character varying(30)	Object type.
optimizer	character varying(20)	Not supported. Its value is NULL.
parent_id	numeric	Not supported. Its value is NULL.
depth	numeric	Not supported. Its value is NULL.
position	numeric	Not supported. Its value is NULL.
search_columns	numeric	Not supported. Its value is 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. Its value is NULL.
other_tag	character varying(35)	Not supported. Its value is NULL.
partition_start	character varying(64)	Not supported. Its value is NULL.
partition_stop	character varying(64)	Not supported. Its value is NULL.
partition_id	numeric	Not supported. Its value is NULL.
other	character varying(4000)	Not supported. Its value is NULL.
distribution	character varying(20)	Not supported. Its value is NULL.
cpu_cost	numeric	Not supported. Its value is NULL.
io_cost	numeric	Not supported. Its value is NULL.
temp_space	numeric	Not supported. Its value is NULL.
access_predicates	character varying(4000)	Not supported. Its value is NULL.
filter_predicates	character varying(4000)	Not supported. Its value is NULL.
projection	character varying(4000)	Returned column information.
time	numeric	Not supported. Its value is NULL.
qblock_name	character varying(128)	Not supported. Its value is NULL.
remarks	character varying(4000)	Not supported. Its value is NULL.
timestamp	timestamp(0) without time zone	Not supported. Its value is NULL.
other_xml	clob	Not supported. Its value is 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. Its value is 0.