Execute plan in PostgreSQL

1, Explain

Explain select * FROM TableName;

2. Explain output JOSN format

Explain (format JSON) SELECT * FROM TableName;

In addition to the JSON format, XML, text, Yaml, and more are supported

3. Explain analyze view actual start-up time

Explain analyze select * from Tablelname;

Another way:

Explain (analyze True) SELECT * FROM TableName;

4, explain only see the implementation of the path, do not look at the cost value

Explain (costs false) SELECT * FROM TableName;

5. See the actual cost and buffer hits through actual execution

Explain (analyze true,buffers true) SELECT * FROM TableName;

Execute plan in PostgreSQL