Re: Interpreting query debug output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Lane <slane(at)moyergroup(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Interpreting query debug output
Date: 2004-05-19 01:06:43
Message-ID: 10080.1084928803@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Steve Lane <slane(at)moyergroup(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mike g 2004-05-19 01:33:32 Re: Set Timestamp
Previous Message Tom Lane 2004-05-19 00:19:03 Re: "IDENT authentication failed" but I'm not using ident