Thread: FAQ: how to read EXPLAYN ANALYZE and act upon
The subjects says it all. I'm looking for a tutorial that will teach me how to read explain analyze and maybe point me to some solutions (rewriting the query, adding some indexes, tune postgres.conf...). I notice I HUGE difference reordering join. Are there guidelines to reorder joint too? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it
On Wed, Sep 17, 2008 at 9:43 AM, Ivan Sergio Borgonovo <mail@webthatworks.it> wrote: > The subjects says it all. A couple of links that may be of use: http://pooteeweet.org/files/phpworks06/explaining_explain.pdf http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf Good luck.
On Wed, 17 Sep 2008, Ivan Sergio Borgonovo wrote: > I'm looking for a tutorial that will teach me how to read explain > analyze and maybe point me to some solutions (rewriting the query, > adding some indexes, tune postgres.conf...). All of the EXPLAIN tutorials and tools I'm aware of are listed at http://wiki.postgresql.org/wiki/Using_EXPLAIN and the primary things to tune in the postgresql.conf are described at http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD