Search Postgresql Archives

how to use all the options of EXPLAIN?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux