[ boolean ] VERBOSE [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for parameter. It defaults to FALSE. FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output contains the same information as the text output format, but is easier for programs .5.98 rows=1 width=4) Index Cond: (i = 4) (2 rows) Here is the same query, but in YAML output: EXPLAIN (FORMAT YAML) SELECT * FROM foo WHERE i=’4’; QUERY PLAN ------------------------------- - Plan:

[ boolean ] VERBOSE [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for parameter. It defaults to FALSE. FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output con- tains the same information as the text output format, but is easier for programs rows=1 width=4) Index Cond: (i = 4) (2 rows) Here is the same query, but in YAML output: 1240 EXPLAIN EXPLAIN (FORMAT YAML) SELECT * FROM foo WHERE i=’4’; QUERY PLAN ------------------------------- -

program for further analysis, you should use one of its machine-readable output formats (XML, JSON, or YAML) instead. 14.1.1. EXPLAIN Basics The structure of a query plan is a tree of plan nodes. Nodes at [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] TIMING [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for enabled. It defaults to TRUE. FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output con- tains the same information as the text output format, but is easier for programs

program for further analysis, you should use one of its machine-readable output formats (XML, JSON, or YAML) instead. 14.1.1. EXPLAIN Basics The structure of a query plan is a tree of plan nodes. Nodes at [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] TIMING [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for enabled. It defaults to TRUE. FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output contains the same information as the text output format, but is easier for programs

program for further analysis, you should use one of its machine-readable output formats (XML, JSON, or YAML) instead. 14.1.1. EXPLAIN Basics The structure of a query plan is a tree of plan nodes. Nodes at [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] TIMING [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for enabled. It defaults to TRUE. FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output con- tains the same information as the text output format, but is easier for programs

program for further analysis, you should use one of its machine-readable output formats (XML, JSON, or YAML) instead. 14.1.1. EXPLAIN Basics The structure of a query plan is a tree of plan nodes. Nodes at [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] TIMING [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for defaults to TRUE. 1575 EXPLAIN FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output contains the same information as the text output format, but is easier for programs

[ boolean ] VERBOSE [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for parameter. It defaults to FALSE. FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output con- tains the same information as the text output format, but is easier for programs rows=1 width=4) Index Cond: (i = 4) (2 rows) Here is the same query, but in YAML output: 1376 EXPLAIN EXPLAIN (FORMAT YAML) SELECT * FROM foo WHERE i=’4’; QUERY PLAN ------------------------------- -

[ boolean ] VERBOSE [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for parameter. It defaults to FALSE. FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output contains the same information as the text output format, but is easier for programs .5.98 rows=1 width=4) Index Cond: (i = 4) (2 rows) Here is the same query, but in YAML output: EXPLAIN (FORMAT YAML) SELECT * FROM foo WHERE i=’4’; QUERY PLAN ------------------------------- - Plan:

program for further analysis, you should use one of its machine-readable output formats (XML, JSON, or YAML) instead. 14.1.1. EXPLAIN Basics The structure of a query plan is a tree of plan nodes. Nodes at [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] TIMING [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for defaults to TRUE. 1633 EXPLAIN FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output contains the same information as the text output format, but is easier for programs

program for further analysis, you should use one of its machine-readable output formats (XML, JSON, or YAML) instead. 14.1.1. EXPLAIN Basics The structure of a query plan is a tree of plan nodes. Nodes at [ boolean ] COSTS [ boolean ] BUFFERS [ boolean ] TIMING [ boolean ] FORMAT { TEXT | XML | JSON | YAML } Description This command displays the execution plan that the PostgreSQL planner generates for enabled. It defaults to TRUE. FORMAT Specify the output format, which can be TEXT, XML, JSON, or YAML. Non-text output con- tains the same information as the text output format, but is easier for programs