Explain Analyze understanding

From: Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Explain Analyze understanding
Date: 2011-08-24 16:18:37
Message-ID: CAJnnue3SfwpP27nkEj1nxA2oJTW890i=-9jdRYCwPVDfMeqTWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I need to improve performance for a particular SQL command but facing
difficulties to understand the explain results.

Is there somewhere a tool could help on this?

I've stored the SQL code and corresponding explain analyze at

SQL: http://www.opendb.com.br/v1/sql.txt
Explain: http://www.opendb.com.br/v1/explain.txt

in case some one could identify some improvement that could be done to the
SQL or table structures in order to get better command performance.

Thank you!

--
Reimer
47-3347-1724 47-9183-0547 msn: carlos(dot)reimer(at)opendb(dot)com(dot)br

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2011-08-24 16:21:57 Re: question regarding full_page_write
Previous Message Merlin Moncure 2011-08-24 15:51:03 Re: init script or procedure