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; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
