LMV_PROFILE_STATS

This view contains statistics collected with PROFILE. The table shows only the PROFILE from the last query instance of a given activity.

This view has the LMV suffix, meaning it is a local view per node. Each node in a given cluster has its own version of this view with node-specific data.

Column Name

Description

QUERY_TEXT

The related query text for a given PROFILE.

ACTIVITY_NAME

An ID shared by all instances of the same activity.

PROFILE_JSON

The PROFILE in JSON object form.

START_TIME

The timestamp at which a given query was started.

END_TIME

The timestamp at which a given query was ended.

DURATION_MS

The total runtime, in milliseconds, of a given query.

COMPILE_TIME_MS

The time, in milliseconds, it took for a given query to compile.

Last modified: August 29, 2022

Was this article helpful?