# PROFILE PIPELINE JSON

The `PROFILE PIPELINE JSON` command is used to estimate the resources needed for a pipeline and outputs the result in JSON format.

## Syntax

```sql
PROFILE PIPELINE <pipeline_name> JSON
```

## Remarks

* Command can only run on a stopped pipeline.
* Command output is in JSON format.
* See the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

## Output

Pipeline details in a JSON format.&#x20;

## Examples

```sql
CREATE TABLE emps(emp_id INT, DATA JSON);
```

```sql
CREATE PIPELINE <pipeline_name> AS LOAD DATA fs '/<file_name.csv>' 
  INTO TABLE emps
  FIELDS TERMINATED BY ','    
  ENCLOSED BY '"'
  IGNORE 1 LINES;
```

```sql
PROFILE PIPELINE <pipeline_name> JSON;


```

```output

{
    "plan_warnings": {
},
    "execution_warnings": {
},
    "mpl_path":"\/var\/lib\/memsql\/73fbb32c-79b7-4b28-bc6e-49142e28a6c5\/plancache\/c1d\/RunPipeline_jtest2_profile_emps__et_al_c1d74837c7e4f23c519ff45b74423fe1ea676d2c15afba6f46602effe1496c89_5e56f6d99b9e220c",
    "profile":[
        {
            "executor":"Gather",
            "keyId":4295163904,
            "partitions":"all",
            "est_rows":"1",
            "est_rows_source":"JOIN",

```

> **📝 Note**: The example above only shows a portion of the output.

***

Modified at: June 17, 2024

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

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