# LMV\_ASYNC\_COMPILES

This view shows the queries being compiled.

| Column              | Description                                                                                         |
| ------------------- | --------------------------------------------------------------------------------------------------- |
| `ID`                | The unique ID of the compilation task. Can be used to kill the compilation via`KILL QUERY COMPILE`. |
| `PID`               | The process ID.                                                                                     |
| `QUERY_TEXT`        | The query being compiled.                                                                           |
| `TIME_SINCE_SUBMIT` | Elapsed time in seconds since the query was submitted.                                              |
| `STATUS`            | Status of the query.                                                                                |

***

Modified at: January 22, 2024

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

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