> For the complete documentation index, see [llms.txt](https://docs.starrocks.io/llms.txt). This page is also available as Markdown at its `.md` URL.

# SHOW PROFILELIST

SHOW PROFILELIST lists the query profile records cached in your StarRocks cluster. For more information about query profile, see [Query Profile Overview](https://docs.starrocks.io/docs/best_practices/query_tuning/query_profile_overview.md).

This feature is supported from v3.1 onwards.

No privilege is required to perform this operation.

## Syntax[​](#syntax "Direct link to Syntax")

```sql
SHOW PROFILELIST [LIMIT n]

```

## Parameters[​](#parameters "Direct link to Parameters")

`LIMIT n`: lists n most recent records.

## Return value[​](#return-value "Direct link to 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[​](#examples "Direct link to Examples")

Example 1: Show five most recent query profile records.

```sql
SHOW PROFILELIST LIMIT 5;

```

## Relevant SQLs[​](#relevant-sqls "Direct link to Relevant SQLs")

* [ANALYZE PROFILE](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/plan_profile/ANALYZE_PROFILE.md)
* [EXPLAIN ANALYZE](https://docs.starrocks.io/docs/sql-reference/sql-statements/cluster-management/plan_profile/EXPLAIN_ANALYZE.md)