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 over 1m 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 being new to PG. pgadmin helps a lot, since I'm too old to remember syntax.

Cheers
-----Original Message-----
From: Raymond O'Donnell [mailto:rod(at)iol(dot)ie]
Sent: Sunday, February 07, 2010 10:47 AM
To: Little, Douglas
Cc: Guillaume Lelarge; pgadmin-support(at)postgresql(dot)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(at)iol(dot)ie