var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Tool for optimizing Query in Postgresql
Can anybody suggest a tool that can be used to explain query execution plan, suggest alternative queries for the original query and choose the best query from a list of queries?
I know for Oracle we have tools but not sure about postgresql.
Those tools for Oracle are darn expensive. It won't suggest alternate queries, but PgAdmin does have a visual explain tool.
Using EXPLAIN - PostgreSQL Wiki
Reading PgAdmin Graphical Explain Plans - Postgres OnLine Journal