QUERY_CONSUMPTION

Summarizes execution of individual queries. Columns STATEMENT_ID and TRANSACTION_ID combine as unique keys to these queries. One exception applies: a query with multiple plans has as many records.

Column Name	Data Type	Description
START_TIME END_TIME	TIMESTAMP	Demarcate the start and end of query execution, whether successful or not.
SESSION_ID	VARCHAR	Identifies the session where profiling information was captured. This identifier is unique within the cluster at any point in time, but can be reused when the session closes.
USER_ID	INTEGER	Unique numeric user identifier assigned by the Vertica catalog.
USER_NAME	VARCHAR	User name specified by this query profile.
TRANSACTION_ID	INTEGER	Identifies the transaction in which the query ran.
STATEMENT_ID	INTEGER	Numeric identifier of this query, unique within the query transaction.
CPU_CYCLES_US	INTEGER	Sum, in microseconds, of CPU cycles spent by all threads to process this query.
NETWORK_BYTES_SENT NETWORK_BYTES_RECEIVED	INTEGER	Total amount of data sent/received over the network by execution engine operators.
DATA_BYTES_READ DATA_BYTES_WRITTEN	INTEGER	Excluding WOS, total amount of data read/written by storage operators from and to disk, includes all locations: local, HDFS, S3.
DATA_BYTES_LOADED	INTEGER	Total amount of data loaded from external sources: COPY, external tables, and data load.
BYTES_SPILLED	INTEGER	Total amount of data spilled to disk—for example, by SortManager, Join, and NetworkSend operators.
INPUT_ROWS	INTEGER	Number of unfiltered input rows from DataSource and Load operators. INPUT_ROWS shows the number of input rows that the query plan worked with, but excludes intermediate processing. For example, INPUT_ROWS excludes how many times SortManager spilled and read the same row.
INPUT_ROWS_PROCESSED	INTEGER	Value of INPUT_ROWS minus what was filtered by applying query predicates (valindex) and SIPs, and rows rejected by COPY.
PEAK_MEMORY_KB	INTEGER	Peak memory reserved by the resource manager for this query.
THREAD_COUNT	INTEGER	Maximum number of threads opened to process this query.
DURATION_MS	INTEGER	Total wall clock time, in milliseconds, spent to process this query.
RESOURCE_POOL	VARCHAR	Name of the resource pool where the query was executed.
OUTPUT_ROWS	INTEGER	Number of rows output to the client.
REQUEST_TYPE	VARCHAR	Type of query—for example, QUERY or DDL.
LABEL	VARCHAR	Label included as a LABEL hint in this query.
IS_RETRY	BOOLEAN	This query was tried earlier.
SUCCESS	BOOLEAN	This query executed successfully.