Re: Controlling Server status log download

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