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:r...@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 r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
