Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group