METRIC QUERY TABLE (Release 1.1)

This table stores query statistics information gathered during the compilation and execution of queries that run longer than the configured interval time.

Column Name	Data Type	Default	Description
INSTANCE_ID	INT UNSIGNED	NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED	Unique ID that identifies the instance from which the metric originated.
TENANT_ID	INT UNSIGNED	NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED	Unique ID that identifies the tenant (if any) from which the metric originated. Value is 0 (zero) if there is no tenant.
COMPONENT_ID	INT UNSIGNED	DEFAULT NULL SERIALIZED	Unique ID for the component, 1 through 16.
PROCESS_ID	INT	DEFAULT NULL SERIALIZED	Unique ID from the operating system, which identifies the process associated with the metric.
THREAD_ID	INT UNSIGNED	DEFAULT NULL SERIALIZED	Thread ID for the process.
NODE_ID	INT UNSIGNED	DEFAULT NULL SERIALIZED	Logical node ID from the foundation layer, which is a numeric identifier for the current node.
PNID_ID	INT UNSIGNED	DEFAULT NULL SERIALIZED	Physical node ID from the foundation layer.
HOST_ID	INT UNSIGNED	NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED	Host ID from the operating system, which is a numeric identifier for the current host.
IP_ADDRESS_ID	CHAR(32) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Internet Protocol (IP) address of the node from which the data for this table originated.
SEQUENCE_NUMBER	INT UNSIGNED	DEFAULT NULL SERIALIZED	Sequence ID generated by the data producer.
PROCESS_NAME	CHAR(32) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Logical process name of the DCS server that is handling the query and that reported the statistics.
EXEC_START_UTC_TS	TIMESTAMP(6)	NO DEFAULT NOT NULL NOT DROPPABLE	Primary Key Timestamp, in Coordinated Universal Time, indicating when query execution began (that is, when an execute statement was issued for the prepared query).
QUERY_ID	CHAR(160) CHARACTER SET ISO88591 COLLATE DEFAULT	NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED	Primary Key Unique ID for the SQL statement, generated by the SQL compiler.
USER_NAME	CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Name of the user connected to the instance.
ROLE_NAME	CHAR(256 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Name of the role that was granted to the user.
START_PRIORITY	INT UNSIGNED	DEFAULT NULL SERIALIZED	Reserved for future use.
MASTER_PROCESS_ID	CHAR(64) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Process ID of the CPU of the DCS server that is handling the query and that reported the statistics.
SESSION_ID	CHAR(108) CHARACTER SET ISO88591 COLLATE DEFAULT	NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED	Unique session ID generated by the DCS server when the connection was established.
CLIENT_NAME	VARCHAR(256 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Name of the client workstation.
APPLICATION_NAME	CHAR(130) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Name of the client application connected to the database.
STATEMENT_ID	CHAR(160) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Unique statement ID generated by the DCS server at the time the prepare command was received.
STATEMENT_TYPE	CHAR(36) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Type of SQL statement specified by the SQL compiler. For details, see the STATEMENT_TYPE field.
STATEMENT_SUBTYPE	CHAR(36) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Subtype of the query, which is either: SQL_STMT_CTAS for a CREATE TABLE AS statement SQL_STMT_NA for a statement other than CREATE TABLE AS
SUBMIT_UTC_TS	TIMESTAMP(6)	DEFAULT NULL	Timestamp, in Coordinated Universal Time, indicating when the query first started executing. Currently, this field is same as EXEC_START_UTC_TS but will change in a future release.
COMPILE_START_UTC_TS	TIMESTAMP(6)	DEFAULT NULL	Timestamp, in Coordinated Universal Time indicating when query compilation began (that is, when a prepare statement was issued for the query).
COMPILE_END_UTC_TS	TIMESTAMP(6)	DEFAULT NULL	Timestamp, in Coordinated Universal Time, indicating when query compilation ended (that is, when the prepare statement completed for this query).
COMPILE_ELAPSED_TIME	LARGEINT	DEFAULT NULL SERIALIZED	Calculated compile time in microseconds, computed as compilation end time minus compilation start time. This value is the amount of time needed to prepare the query and is obtained from the compiler.
CMP_AFFINITY_NUM	LARGEINT	DEFAULT NULL SERIALIZED	Affinity value used by the compiler to determine the CPU subset for placing ESPs for the query evenly across the available processors.
CMP_DOP	LARGEINT	DEFAULT NULL SERIALIZED	Degree of parallelism used by the query, which is the number of ESP operators that are reused to parallelize a single fragment of the query plan. If different fragments in the same plan are parallelized to different extents, this counter reports the degree of parallelization of the fragment that is parallelized the most.
CMP_TXN_NEEDED	LARGEINT	DEFAULT NULL SERIALIZED	Indicates whether the query is required to execute under a transaction. All SQL statements require a transaction except SELECT statements that use the READ UNCOMMITTED isolation level. Value is: 1 = True 0 = False
CMP_MANDATORY_X_PROD	LARGEINT	DEFAULT NULL SERIALIZED	Flags queries in which a join has been specified with no predicates. Joins with no predicates might result from predicate movement during optimization or simply because no predicate was specified for the join. Value is: 1 = True 0 = False
CMP_MISSING_STATS	LARGEINT	DEFAULT NULL SERIALIZED	Indicates whether single-column missing statistics warnings were raised during compilation (SQLCODE 6008 or 6011). Value is: 1 = True 0 = False Multi-column missing statistics warnings (SQLCODE 6007 or 6010) are not flagged in this field.
CMP_NUM_JOINS	LARGEINT	DEFAULT NULL SERIALIZED	Number of joins in the query plan.
CMP_FULL_SCAN_ON_TABLE	LARGEINT	DEFAULT NULL SERIALIZED	Indicates whether the query plan will perform a full scan on at least one table. Value is: 1 = True 0 = False
CMP_ROWS_ACCESSED_FULL_SCAN	DOUBLE PRECISION	DEFAULT NULL	Estimated number of rows accessed by a full scan of a table. Valid only if the query plan specifies `full scan on table`. If the query plan contains more than one full scan operation, the largest number of rows accessed by all scans is reported here. Value is: Largest number of rows accessed 0.0 when a full scan was performed on an empty table -1.0 when the query plan did not specify `full scan on table`
EST_ACCESSED_ROWS	DOUBLE PRECISION	DEFAULT NULL	Estimate of the total ROWS_ACCESSED.
EST_USED_ROWS	DOUBLE PRECISION	DEFAULT NULL	Estimate of the total ROWS_RETRIEVED.
CMP_COMPILER_ID	CHAR(28) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Unique ID for a compiler process, including a timestamp, CPU number, PIN number, and node number.
CMP_CPU_PATH_LENGTH	LARGEINT	DEFAULT NULL SERIALIZED	Estimated CPU path length for a query. The estimate is determined when the query is prepared.
CMP_CPU_BINDER	LARGEINT	DEFAULT NULL SERIALIZED	Estimated CPU usage in the binder for a query. The estimate is determined when the query is prepared.
CMP_CPU_NORMALIZER	LARGEINT	DEFAULT NULL	Estimated CPU usage in the normalizer for a query. The estimate is determined when the query is prepared.
CMP_CPU_ANALYZER	LARGEINT	DEFAULT NULL SERIALIZED	Estimated CPU usage in the analyzer for a query. The estimate is determined when the query is prepared.
CMP_CPU_OPTIMIZER	LARGEINT	DEFAULT NULL SERIALIZED	Estimated CPU usage in the optimizer for a query. The estimate is determined when the query is prepared.
CMP_CPU_GENERATOR	LARGEINT	DEFAULT NULL SERIALIZED	Estimated CPU usage in the generator for a query. The estimate is determined when the query is prepared.
CMP_METADATA_CACHE_HITS	LARGEINT	DEFAULT NULL SERIALIZED	Number of hits to the metadata table. The estimate is determined when the query is prepared.
CMP_METADATA_CACHE_LOOKUPS	LARGEINT	DEFAULT NULL SERIALIZED	Number of lookups on the metadata table. The estimate is determined when the query is prepared.
CMP_QUERY_CACHE_STATUS	LARGEINT	DEFAULT NULL SERIALIZED	Indicates the query cache state for a specific compilation, such as query is cacheable, hit, miss, and so on.
CMP_HISTOGRAM_CACHE_HITS	LARGEINT	DEFAULT NULL SERIALIZED	Number of hits to the histogram cache.
CMP_HISTOGRAM_CACHE_LOOKUPS	LARGEINT	DEFAULT NULL	Number of lookups on the histogram cache.
CMP_STMT_HEAP_SIZE	LARGEINT	DEFAULT NULL SERIALIZED	Size of the statement heap in MB. The estimate is determined when the query is prepared.
CMP_CONTEXT_HEAP_SIZE	LARGEINT	DEFAULT NULL SERIALIZED	Size of the context heap in MB.
CMP_OPTIMIZATION_TASKS	LARGEINT	DEFAULT NULL SERIALIZED	Number of optimization tasks created for a query. The estimate is determined when query is prepared.
CMP_OPTIMIZATION_CONTEXTS	LARGEINT	DEFAULT NULL SERIALIZED	Number of contexts created for a query. The estimate is determined when query is prepared.
CMP_IS_RECOMPILE	SMALLINT	DEFAULT NULL SERIALIZED	Indicates if query is re-compiled or not.
EST_NUM_SEQ_IOS	DOUBLE PRECISION	DEFAULT NULL	Estimated number of sequential IOs for a query. The estimate is determined when query is prepared.
EST_NUM_RAND_IOS	DOUBLE PRECISION	DEFAULT NULL	Estimated number of random IOs for a query. The estimate is determined when query is prepared.
EST_COST	DOUBLE PRECISION	DEFAULT NULL	Estimated total cost (time in seconds) of the SQL operations for this query in the Master Executor. The estimate is determined when the query is prepared.
EST_CARDINALITY	DOUBLE PRECISION	DEFAULT NULL	Estimated number of rows that will be returned. The estimate is determined when the query is prepared.
EST_IO_TIME	DOUBLE PRECISION	DEFAULT NULL	Estimate of the number of seconds of I/O time (seeks plus data transfer) to perform the I/O for this query. The estimate is determined when the query is prepared.
EST_MSG_TIME	DOUBLE PRECISION	DEFAULT NULL	Estimate of the number of seconds required for the messaging for this query, including local and remote messages and the amount of data sent. The estimate is determined when the query is prepared.
EST_IDLE_TIME	DOUBLE PRECISION	DEFAULT NULL	Estimate of the number of seconds to wait for an operation to complete (for example, opening a table or starting a process). The estimate is determined when the query is prepared.
EST_CPU_TIME	DOUBLE PRECISION	DEFAULT NULL	Estimate of the number of seconds of processor time it might take to execute instructions for this operator. The estimate is determined when the query is prepared.
EST_TOTAL_TIME	DOUBLE PRECISION	DEFAULT NULL	Estimated time in seconds for the SQL operations for this query. This estimate includes estimates of I/O time, Message time, and Node time and does not include Idle time. The estimate is determined when the query is prepared.
EST_TOTAL_MEM	DOUBLE PRECISION	DEFAULT NULL	Estimate, in kilobytes, of the memory that the query plan will use. The value is computed based on operators that could potentially consume large amounts of memory: Hash Join, Hash Groupby, Sort, Merge Join, and Sequence.
EST_RESOURCE_USAGE	LARGEINT	DEFAULT NULL SERIALIZED	Estimate of the number of seconds of processor time that it might take to execute the query. The estimate is determined when the query is prepared.
AGGREGATE_OPTION	CHAR(3) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Indicates whether this is an aggregated record. Value is Yes or No.
CMP_NUMBER_OF_BMOS	INT	DEFAULT NULL SERIALIZED	Number of Big Memory Operators (BMOs) in the query execution plan. The BMOs are hash join, hash groupby, sort, and merge join. When the quota or limit is reached on the BMOs' memory usage in an executor process, the memory overflow is written to a scratch file.
CMP_OVERFLOW_MODE	CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Type of overflow mode that has been configured for the system. The overflow mode represents the type of device to which the memory overflow is written. The overflow mode might one of these values: DISK for a hard disk drive SSD for a solid-state drive
CMP_OVERFLOW_SIZE	LARGEINT	DEFAULT NULL SERIALIZED	Overflow size in kilobytes.
AGGREGATE_TOTAL	LARGEINT	DEFAULT NULL SERIALIZED	Total number of queries aggregated.
STATS_ERROR_CODE	INT	DEFAULT NULL SERIALIZED	Internal error code, if any, returned by the Runtime Management System (RMS) infrastructure while obtaining statistics for the query. This error code indicates whether the query completed successfully or with warnings or errors: Positive number – warning Negative number – error Zero (0) or 100 – success Example: Warning 8922 – one or more nodes did not report statistics for this query.
QUERY_ELAPSED_TIME	LARGEINT	DEFAULT NULL SERIALIZED	Elapsed clock time, in microseconds, from the time when the query started executing to the time when the results were returned.
SQL_PROCESS_BUSY_TIME	LARGEINT	DEFAULT NULL SERIALIZED	An approximation, in microseconds, of the total node time spent in the Master Executor process and all ESPs involved in the query. This value is cumulative across all ESPs across all nodes.
DISK_PROCESS_BUSY_TIME	LARGEINT	DEFAULT NULL SERIALIZED	CPU time, in microseconds, for all disk processes involved in executing the query.
DISK_IOS	LARGEINT	DEFAULT NULL SERIALIZED	Number of physical disk I/O operations (reads or writes) caused by accessing the table.
NUM_SQL_PROCESSES	LARGEINT	DEFAULT NULL	Number of SQL processes involved in the execution of the query.
SQL_SPACE_ALLOCATED	LARGEINT	DEFAULT NULL SERIALIZED	Amount of static memory, in kilobytes, allocated (reserved) for query processes (Master Executor and ESPs) at the beginning of query execution. This value remains constant for the duration of query execution.
SQL_SPACE_USED	LARGEINT	DEFAULT NULL SERIALIZED	Amount of static memory, in kilobytes, used by query processes (Master Executor and ESPs) at the end of query execution. This value should be less than or equal to the SQL_SPACE_ALLOCATED value.
SQL_HEAP_ALLOCATED	LARGEINT	DEFAULT NULL SERIALIZED	Amount of dynamic memory, in kilobytes, allocated (reserved) for query processes (Master Executor and ESPs) at the beginning of query execution. The processes that execute the query request this memory during execution, thus the amount can change as the query runs.
SQL_HEAP_USED	LARGEINT	DEFAULT NULL SERIALIZED	Amount of dynamic memory, in kilobytes, actually used for query processes (Master Executor and ESPs) during query execution. This is the value at the end of query execution.
TOTAL_MEM_ALLOC	LARGEINT	DEFAULT NULL SERIALIZED	Total memory allocated to the query. This is the sum of SQL_SPACE_USED and SQL_HEAP_USED.
MAX_MEM_USED	LARGEINT	DEFAULT NULL SERIALIZED	Maximum memory, in kilobytes, used during the lifetime of the query.
TRANSACTION_ID	CHAR(25) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Transaction identifier, in internal format, of the transaction involved in executing the query.
NUM_REQUEST_MSGS	LARGEINT	DEFAULT NULL SERIALIZED	Number of messages that are initiated from the Master Executor process to ESPs or from ESP to ESP. This count includes both control and data messages.
NUM_REQUEST_MSG_BYTES	LARGEINT	DEFAULT NULL SERIALIZED	Number of message bytes sent as part of NUM_REQUEST_MSGS.
NUM_REPLY_MSGS	LARGEINT	DEFAULT NULL SERIALIZED	Number of reply messages from ESPs.
NUM_REPLY_MSG_BYTES	LARGEINT	DEFAULT NULL SERIALIZED	Number of bytes sent as part of the replies from ESPs.
FIRST_RESULT_RETURN_UTC_TS	TIMESTAMP(6)	DEFAULT NULL SERIALIZED	Timestamp, in Coordinated Universal Time, when SQL sends the first result row to the Master Executor process.
ROWS_RETURNED_TO_MASTER	LARGEINT	DEFAULT NULL SERIALIZED	Number of rows returned from the root operator to the Master Executor process and to the application in both the regular fetch and rowset fetch.
PARENT_QUERY_ID	CHAR(160) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Query ID for the immediate parent of the query. If the parent query ID is not present, the value returned is NONE. TIP: You can use the parent query ID to relate a child SQL statement to an immediate parent and then trace the relationship to find the original SQL statement.
PARENT_SYSTEM_NAME	CHAR(128) CHARACTER SET ISO88591 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	If the query is the child of a parent query, this value is either: SAME if the child query is running on the same Trafodion cluster as the parent query. Name of the system where the parent query is running if different than the system where the child query is running. If the query is not the child of a parent query, this value is NONE.
EXEC_END_UTC_TS	TIMESTAMP(6)	DEFAULT NULL	Timestamp, in Coordinated Universal Time, indicating when query execution ended. TIP: You can use this value to monitor whether the query is still running.
MASTER_EXECUTION_TIME	LARGEINT	DEFAULT NULL SERIALIZED	CPU processing time, in microseconds, from the time when the query starts executing to the time when the results are returned. It does not include CPU time consumed by SQL executor child processes (ESPs) or disk processes for the query.
MASTER_ELAPSED_TIME	LARGEINT	DEFAULT NULL SERIALIZED	Amount of time, in microseconds, that the query spent executing in the master process from the start of execution to the end of execution.
QUERY_STATUS	CHAR(21) CHARACTER SET UTF8 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	State of the query, which is one of these values: INIT COMPLETED
QUERY_SUB_STATUS	CHAR(30) CHARACTER SET UTF8 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Substate of the query, which is dependent on the QUERY_STATUS.
ERROR_CODE	INT	DEFAULT NULL SERIALIZED	Query error code returned to the client. If the DCS process stops or fails, this field is set to 201. In this case, the last statistics available from SQL are retrievable from this repository table.
SQL_ERROR_CODE	INT	DEFAULT NULL SERIALIZED	Top-level error code returned by the query, indicating whether the query completed successfully or with warnings or errors: A value of 100 indicates a completed SELECT, UPDATE, or DELETE statement with actual end statistics. Zero (0) indicates a completed INSERT statement or an incomplete query. Any other type of positive number indicates a warning. A negative number indicates an error.
ERROR_TEXT	VARCHAR(2000 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Message text of the error returned by SQL. See the SQL_ERROR_CODE field.
QUERY_TEXT	VARCHAR(50000 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	SQL text for the query. A maximum of 14000 characters is written per row.
EXPLAIN_PLAN	VARCHAR(50000 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT	DEFAULT NULL SERIALIZED	Simple, basic information contained in the query execution plan. This information is formatted for readability and limited to 79 characters (one line) per operator. It is similar to the EXPLAIN OPTIONS 'f' output. For more information, see the Trafodion SQL Reference Manual (pdf, 3.98 MB).
LAST_ERROR_BEFORE_AQR	INT	DEFAULT NULL SERIALIZED	Last error code that caused the query to be automatically retried.
DELAY_TIME_BEFORE_AQR_SEC	LARGEINT	DEFAULT NULL SERIALIZED	Delay time in seconds before the query was automatically retried.
TOTAL_NUM_AQR_RETRIES	LARGEINT	DEFAULT NULL SERIALIZED	Total number of times that the query was retried.
MSG_BYTES_TO_DISK	LARGEINT	DEFAULT NULL SERIALIZED	Size, in bytes, of the total amount of message data sent to the disk process.
MSGS_TO_DISK	LARGEINT	DEFAULT NULL SERIALIZED	Number of messages sent to the disk process (that is, the number of messages exchanged between the file system and the disk process).
ROWS_ACCESSED	LARGEINT	DEFAULT NULL SERIALIZED	Total number of rows accessed in each table by all the scan, insert, update, and delete operators in the query plan.
ROWS_RETRIEVED	LARGEINT	DEFAULT NULL SERIALIZED	Total number of rows retrieved and/or actually used by the statement. This value is the number of rows that were returned by the Executor in Disk (EID) process after evaluating non-key predicates.
NUM_ROWS_IUD	LARGEINT	DEFAULT NULL SERIALIZED	Number of rows actually inserted, updated, or deleted in the base tables by the query.
PROCESSES_CREATED	LARGEINT	DEFAULT NULL SERIALIZED	Number of new processes created by the executor on behalf of this process.
PROCESS_CREATE_BUSY_TIME	LARGEINT	DEFAULT NULL	Time, in microseconds, the executor spent creating new processes.
OVF_FILE_COUNT	LARGEINT	DEFAULT NULL SERIALIZED	Number of scratch files that are created to execute the query. The default size of a scratch file is two gigabytes.
OVF_SPACE_ALLOCATED	LARGEINT	DEFAULT NULL SERIALIZED	Space allocated for memory overflow, in kilobytes, which is the number of scratch files that are used multiplied by two gigabytes, which is the maximum size of a scratch file.
OVF_SPACE_USED	LARGEINT	DEFAULT NULL SERIALIZED	Space used for memory overflow, in kilobytes, which is the same as OVF_BUFFER_BYTES_WRITTEN.
OVF_BLOCK_SIZE	LARGEINT	DEFAULT NULL SERIALIZED	Size, in kilobytes, of the buffer block that is used to read from or write to a scratch file.
OVF_WRITE_READ_COUNT	LARGEINT	DEFAULT NULL SERIALIZED	Number of file-system calls involved in writing and reading buffer blocks to and from scratch files, which is the sum of OVF_WRITE_COUNT and OVF_READ_COUNT.
OVF_WRITE_COUNT	LARGEINT	DEFAULT NULL SERIALIZED	Number of file-system calls involved in writing buffer blocks to scratch files. One call writes multiple buffer blocks at once.
OVF_BUFFER_BLOCKS_WRITTEN	LARGEINT	DEFAULT NULL SERIALIZED	Number of buffer blocks written to scratch files.
OVF_BUFFER_BYTES_WRITTEN	LARGEINT	DEFAULT NULL SERIALIZED	Total size of the buffer blocks written to scratch files, in kilobytes, which is OVF_BUFFER_BLOCKS_WRITTEN multiplied by OVF_BLOCK_SIZE.
OVF_READ_COUNT	LARGEINT	DEFAULT NULL SERIALIZED	Number of file-system calls involved in reading buffer blocks from scratch files. One call reads multiple buffer blocks at once.
OVF_BUFFER_BLOCKS_READ	LARGEINT	DEFAULT NULL SERIALIZED	Number of buffer blocks read from scratch files.
OVF_BUFFER_BYTES_READ	LARGEINT	DEFAULT NULL SERIALIZED	Total size of the buffer blocks read from scratch files, in kilobytes, which is OVF_BUFFER_BLOCKS_READ multiplied by OVF_BLOCK_SIZE.
NUM_NODES	LARGEINT	DEFAULT NULL SERIALIZED	Number of SQL nodes that are processing the query.
UDR_PROCESS_BUSY_TIME	LARGEINT	DEFAULT NULL SERIALIZED	If the query is a CALL statement, this value is the total CPU busy time in microseconds spent in the UDR server process. The UDR server process handles the execution of a CALL statement and the stored procedure (that is, Java method) that the CALL statement invokes. If the query is not a CALL statement, this value is 0.
PERTABLE_STATS	INT	DEFAULT NULL SERIALIZED	Indicates whether per-table statistics have been recorded for the query: 1 = True, meaning per-table statistics were collected for the query. 0 = False, meaning per-table statistics were not collected for the query. NULL indicates that the query has not yet finished executing.

Return to the Trafodion Manageability page.

STATEMENT_TYPE Field

The following table provides the compiler-provided values for the STATEMENT_TYPE field of METRIC_QUERY_TABLE. The suffix _UNIQUE indicates that the statement operates on a single row. The suffix _NON_UNIQUE indicates that the statement could operate on multiple rows.

Compiler-Provided Value	Statement or Commands
SQL_SELECT_UNIQUE	SELECT,TABLE
SQL_SELECT_NON_UNIQUE	SELECT,TABLE,EXPLAIN
SQL_INSERT_UNIQUE	INSERT,VALUES
SQL_INSERT_NON_UNIQUE	INSERT,VALUES
SQL_UPDATE_UNIQUE	UPDATE
SQL_UPDATE_NON_UNIQUE	UPDATE
SQL_DELETE_UNIQUE	DELETE
SQL_DELETE_NON_UNIQUE	DELETE
SQL_CONTROL	CONTROL QUERY DEFAULT
SQL_SET_TRANSACTION	SET TRANSACTION
SQL_SET_SCHEMA	SET SCHEMA
SQL_OTHER	ALTER/CREATE/DROP TABLE ALTER/CREATE/DROP VIEW CREATE/DROP INDEX CREATE/DROP SCHEMA GRANT/REVOKE ROLLBACK WORK BEGIN WORK COMMIT WORK
SQL_CALL_NO_RESULT_SETS	CALL statements that do not return result sets
SQL_CALL_WITH_RESULT_SETS	CALL statements that return result sets
SQL_CAT_UTIL	UPDATE STATISTICS, POPULATE INDEX
SQL_EXE_UTIL	PURGEDATA
SQL_EXEC_INSERT_RWRS	Insert using the LOAD command

Return to the Trafodion Manageability page.

Space shortcuts

Page tree

STATEMENT_TYPE Field