# SHOW PIPELINES

You can see all existing pipelines in a database and their current state by using the `SHOW PIPELINES` statement.

Possible states are `Running`, `Testing`, `Profiling`, `Running...Foreground`, `Stopped`, and `Error`, and they are described in the [Pipelines Information Schema Tables](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest.md) topic.

Background pipelines will show True in the Scheduled column until the task is finished. Background pipelines could show False if the pipeline is in an error state or during a batch interval period while waiting for data. It can also show False if there’s a delay starting the pipeline due to system load, etc.

Non-background pipelines will always show False in the Scheduled column.

## Syntax

```sql
SHOW PIPELINES

```

## Example

```sql
SHOW PIPELINES;

```

```output

+------------------------+---------+-----------+
| Pipelines_exp_db       | State   | Scheduled |
+------------------------+---------+-----------+
| color_list             | Running | True      |
| color_list2            | Running | False     |
+------------------------+---------+-----------+

```

## Related Topics

* [Pipelines Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/pipelines-commands.md)

***

Modified at: September 24, 2024

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

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