Skip to main content
Version: Latest-3.3

SHOW PROFILELIST

Description

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

ReturnDescription
QueryIdThe ID of the query.
StartTimeThe start time of the query.
TimeThe latency of the query.
StateThe status of the query, including:Error: The query encounters an error.Finished: The query is finished.Running: The query is running.
StatementThe statement of the query.

Examples

Example 1: Show five most recent query profile records.

SHOW PROFILELIST LIMIT 5;

Relevant SQLs