Vertica Analytics Platform Version 9.2.x Documentation

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
END_TIME TIMESTAMP Query completion time, 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 Specifies, in microseconds, the sum 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 The 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 The value of INPUT_ROWS minus what was filtered by applying query predicates (valindex) and SIPs, and rows rejected by COPY.
THREAD_COUNT INTEGER The maximum number of threads that were opened to process this query.
DURATION_MS INTEGER Specifies, in milliseconds, the total wall clock time 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 The type of query—for example, QUERY or DDL.
LABEL VARCHAR The label included as a LABEL hint in this query.
IS_RETRY BOOLEAN Shows whether this query was tried earlier.
SUCCESS BOOLEAN Shows whether this query executed successfully.