Breaking News: Grepper is joining You.com. Read the official announcement!

how to see execution plan in postgresql

MazelTov27 answered on February 15, 2023 Popularity 7/10 Helpfulness 7/10

answer how to see execution plan in postgresql

how to see execution plan in postgresql

Comment

-- Use EXPLAIN keyword
EXPLAIN [ANALYZE | VERBOSE | COSTS | SETTINGS | BUFFERS | WAL | TIMING | SUMMARY]
SELECT ....;

/* Description: 
 * - ANALYZE: Show actual run times and other statistics
 * - VERBOSE: Display additional information regarding the plan. 
 * - COSTS: Include information on the estimated startup and total cost of each plan node.
 * - SETTINGS: Include information on configuration parameters.
 * - BUFFERS: Include information on buffer usage.
 * - WAL: Include information on WAL record generation.
 * - TIMING: Include actual startup time and time spent in each node in the output. 
 * - SUMMARY: Include summary information (e.g., totaled timing information) after the query plan. 
 * - FORMAT: Specify the output format, which can be TEXT, XML, JSON, or YAML.
 */

https://www.postgresql.org/docs/current/sql-explain.html

Popularity 7/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: execution postgresql sql

Link to this answer
Share Copy Link

Contributed on Feb 15 2023

MazelTov27

0 Answers Avg Quality 2/10

how to see execution plan in postgresql

Contents

More Related Answers

how to see execution plan in postgresql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.