Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Unanswered: Tool for optimizing Query in Postgresql

    Hi

    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.

    Thanks!

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •