SHOW PROFILELIST
SHOW PROFILELIST lists the query profile records cached in your StarRocks cluster. For more information about query profile, see Query Profile Overview.
This feature is supported from v3.1 onwards.
No privilege is required to perform this operation.
Syntaxβ
SHOW PROFILELIST [LIMIT n]
Parametersβ
LIMIT n: lists n most recent records.
Return valueβ
| Return | Description |
|---|---|
| QueryId | The ID of the query. |
| StartTime | The start time of the query. |
| Time | The latency of the query. |
| State | The status of the query, including:Error: The query encounters an error.Finished: The query is finished.Running: The query is running. |
| Statement | The statement of the query. |
Examplesβ
Example 1: Show five most recent query profile records.
SHOW PROFILELIST LIMIT 5;