Vertica Analytics Platform Version 9.2.x Documentation

QUERY_PROFILES

Provides information about executed queries.

  Column Name     Data Type    Description
SESSION_ID VARCHAR

The identification of the session for which profiling information is captured. This identifier is unique within the cluster at any point in time but can be reused when the session closes.

TRANSACTION_ID INTEGER

An identifier for the transaction within the session if any; otherwise NULL.

STATEMENT_ID INTEGER

Unique numeric ID for the currently-running statement. NULL indicates that no statement is currently being processed. The combination of TRANSACTION_ID, STATEMENT_ID uniquely identifies a statement within a session.

IDENTIFIER VARCHAR

A string to identify the query in system tables.

Note: You can query the IDENTIFIER column to quickly identify queries you have labeled for profiling and debugging. See Labeling Queries in the Administrator's Guide for details.

NODE_NAME VARCHAR

The node name for which information is listed.

QUERY VARCHAR

The query string used for the query.

QUERY_SEARCH_PATH VARCHAR

A list of schemas in which to look for tables.

SCHEMA_NAME VARCHAR

The schema name in which the query is being profiled, set only for load operations.

TABLE_NAME VARCHAR

The table name in the query being profiled, set only for load operations.

QUERY_DURATION_US NUMERIC(18,0)

The duration of the query in microseconds.

QUERY_START_EPOCH INTEGER

The epoch number at the start of the given query.

QUERY_START VARCHAR

The Linux system time of query execution in a format that can be used as a DATE/TIME expression.

QUERY_TYPE VARCHAR

Is one of INSERT, SELECT, UPDATE, DELETE, UTILITY, or UNKNOWN.

ERROR_CODE INTEGER

The return error code for the query.

USER_NAME VARCHAR

The name of the user who ran the query.

PROCESSED_ROW_COUNT INTEGER

The number of rows returned by the query.

RESERVED_EXTRA_MEMORY_B INTEGER

Shows how much unused memory (in bytes) remains that is reserved for a given query but is unassigned to a specific operator. This is the memory from which unbounded operators pull first.

The MEMORY_INUSE_KB column in system table RESOURCE_ACQUISITIONS shows how much total memory was acquired for each query.

If operators acquire all memory acquired for the query, the plan must request more memory from the Vertica resource manager.

IS_EXECUTING BOOLEAN

Displays information about actively running queries, regardless of whether profiling is enabled.