# LMV\_PROFILE\_STATS

This view contains statistics collected with [PROFILE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/profile.md). 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. |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-profile-stats/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-profile-stats/)

(An index of the documentation is available at /llms.txt)