Ray,
Only explains when we run into a trouble query. It's a large data warehouse in greenplum. So I think we're running
over1m sql's a day now.
I actually think the pgadmin window does a good job visually depicting the explain. Haven't used it all that much, but
beingnew to PG. pgadmin helps a lot, since I'm too old to remember syntax.
Cheers
-----Original Message-----
From: Raymond O'Donnell [mailto:rod@iol.ie]
Sent: Sunday, February 07, 2010 10:47 AM
To: Little, Douglas
Cc: Guillaume Lelarge; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Controlling Server status log download
On 07/02/2010 16:40, Little, Douglas wrote:
> Morning, You guys are great! I love the responsiveness. So much
> better than we get from our paid vendor.
Heh heh - even when suggestions like mine aren't all that helpful! :-)
> I'd like to see a function that would disable the log download. Most
> of the time I'm looking it's to investigate queries that are poorly
> performing. The log feature is currently interfering with this use.
That being the case, are you doing a lot of EXPLAIN ANALYZEs? If so, it
might be easier to do these directly in a terminal window via psql,
rather than using pgAdmin.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie