Re: Interpreting query debug output

Steve Lane <slane@moyergroup.com> writes:
> I have a database that is exhibiting sluggishness under load. Suspecting
> that some queries may be poorly optimized, I turned on a fair amount of
> debugging output in the logs. But I could use some help interpreting it.

I think you're going at this all wrong.  EXPLAIN ANALYZE should be the
first tool you turn to, not low-level stats.  Browsing the archives of
the pgsql-performance mailing list may help you get started.

            regards, tom lane