Could anyone please tell me how to use all the options of explain in
Postgresql 9.
http://www.postgresql.org/docs/9.0/static/sql-explain.html

I can use EXPLAIN ANALYZE.

FORMAT:


explain     (format yaml)   select * from tab1;
              QUERY PLAN
---------------------------------------
 - Plan:                              +
     Node Type: "Seq Scan"            +
     Relation Name: "tab1"+
     Alias: "tab1"        +
     Startup Cost: 0.00               +
     Total Cost: 21558.94             +
     Plan Rows: 1688234               +
     Plan Width: 333
(1 row)

But

explain     (format yaml)  analyze  select * from tab1;
ERROR:  syntax error at or near "analyze"
LINE 1: explain     (format yaml)  analyze  select * from tab1


BUFFERS:

explain  (buffers true)   select * from tab1;
ERROR:  EXPLAIN option BUFFERS requires ANALYZE

But

explain  (buffers true) analyze  select * from tab1;
ERROR:  syntax error at or near "analyze"
LINE 1: explain  (buffers true) analyze  select * from tab1...


Same for COSTS.

Does any of our experts use these options? If yes, please tell me how.

Thanks.

Reply via email to