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.

LMV_PROFILE_STATS

Was this article helpful?

Was this article helpful?