# PROFILE PIPELINE

> **📝 Note**: `PROFILE PIPELINE` command has been deprecated from SingleStore versions 9.0 and later. SingleStore recommends using the `SHOW PROFILE PIPELINE` command instead.

The `PROFILE PIPELINE` command runs a single batch in the foreground to provide detailed resource metrics for each operation in your pipeline. The batch itself is not persisted.

## Syntax

```sql
PROFILE PIPELINE pipeline_name

```

## Remarks

* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* `pipeline_name` is the configured pipeline.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.
* To use `PROFILE PIPELINE`, you must gather data source offsets through `TEST PIPELINE`. Verify that `TEST PIPELINE` does not return an empty set before calling `PROFILE PIPELINE`.

  See [TEST PIPELINE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/test-pipeline.md) for more details.

> **📝 Note**: You cannot run `PROFILE PIPELINE` when the pipeline is in a `Running` or `Error` state.

## Example

The output of `PROFILE PIPELINE` is similar to the `SHOW PROFILE` output described in [PROFILE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/profile.md).

## Example

```sql
TEST PIPELINE kafka LIMIT 10;
+---------+
| id      |
+---------+
| rlkj    |
| slkjrl  |
| sdlkj   |
| sk      |
| slkjrls |
| lkjrljs |
| slkjr   |
+---------+

```

```sql
PROFILE PIPELINE kafka;

```

```output

+------------------------------------------------------------------------------------------------------------------------------------------------------+
| PROFILE                                                                                                                                              |
+------------------------------------------------------------------------------------------------------------------------------------------------------+
| Gather partitions:all est_rows:264 alias:remote_0 actual_rows: 7 exec_time: 0ms                                                                      |
| InsertInto quickstart_kafka.messages [messages_src.id] local:yes est_rows:264 actual_rows: 7 exec_time: 0ms start_time: [00:00:00.259, 00:00:00.280] |
| ExternalIngest pipeline:kafka                                                                                                                        |
| |---CSVParse actual_rows: 7 exec_time: 0ms start_time: [00:00:00.005, 00:00:00.030] end_time: [00:00:00.259, 00:00:00.280]                           |
| |---Transform streamed_bytes: 0.043000 KB exec_time: 4ms start_time: [00:00:00.005, 00:00:00.030] end_time: [00:00:00.259, 00:00:00.280]             |
| +---Extract streamed_bytes: 0.092000 KB exec_time: 269ms start_time: [00:00:00.005, 00:00:00.030] end_time: [00:00:00.256, 00:00:00.278]             |
+------------------------------------------------------------------------------------------------------------------------------------------------------+
```

***

Modified at: June 12, 2026

Source: [/db/v9.1/reference/sql-reference/pipelines-commands/profile-pipeline/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands/profile-pipeline/)

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