Request a Demo
Home   >   mailing lists

Explain Analyze understanding - Mailing list pgsql-general

From Carlos Henrique Reimer
Subject Explain Analyze understanding
Date
Msg-id CAJnnue3SfwpP27nkEj1nxA2oJTW890i=-9jdRYCwPVDfMeqTWw@mail.gmail.com
Whole thread Raw
Responses Re: Explain Analyze understanding
List pgsql-general
Tree view
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.reimer@opendb.com.br

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: init script or procedure
Next
From: Greg Smith
Date:
Subject: Re: question regarding full_page_write