Re: how to use all the options of EXPLAIN?

On 15/09/11 15:43, AI Rumman wrote:
> 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.
> explain     (format yaml)   select * from tab1;
>
> 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.


Try putting the ANALYZE inside the parentheses..
eg
EXPLAIN (buffers true, analyze) select * from tab1;