Re: Interpreting query debug output - Mailing list pgsql-admin

From Tom Lane
Subject Re: Interpreting query debug output
Date
Msg-id 10080.1084928803@sss.pgh.pa.us
Whole thread Raw
In response to Interpreting query debug output  (Steve Lane <slane@moyergroup.com>)
Responses Re: Interpreting query debug output  (Steve Lane <slane@moyergroup.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: "IDENT authentication failed" but I'm not using ident
Next
From: mike g
Date:
Subject: Re: Set Timestamp