| From: | AI Rumman <rummandba(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | how to use all the options of EXPLAIN? |
| Date: | 2011-09-15 05:43:55 |
| Message-ID: | CAGoODpdr0JZKEVXw_wRc7t_zvbPApB7jq3HJOCT2-5tVfgP8eQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Toby Corkindale | 2011-09-15 05:59:20 | Re: how to use all the options of EXPLAIN? |
| Previous Message | Adarsh Sharma | 2011-09-15 04:48:40 | Re: pg_dump with select command |