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 |
|---|---|
| The related query text for a given |
| An |
| The |
| The timestamp at which a given query was started. |
| The timestamp at which a given query was ended. |
| The total runtime, in milliseconds, of a given query. |
| The time, in milliseconds, it took for a given query to compile. |