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

Re: Unexplained query activity.

From: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Unexplained query activity.
Date: 2010-08-03 19:50:29
Message-ID: 8585BA53443004458E0BAA6134C5A7FB0CB29066@EGEXCMB01.oww.root.lcl (view raw or whole thread)
Lists: pgadmin-support
325 logon roles,  24 groups


-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info] 
Sent: Tuesday, August 03, 2010 2:49 PM
To: Little, Douglas
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Unexplained query activity.

Le 03/08/2010 21:38, Little, Douglas a écrit :
> [...]
> Running PGAdmin 1.10.3  on win xp sp3 against Greenplum (PG 8.1.4)
> I'm looking over my pgadmin log and seeing frequent executions of these queries.
> In this particular instance, the sql was executed 304 times (in 2 seconds),  but why is it being executed so often.
> I had resource_groups selected in display.  I've turned off, but not been able to determine if it suppressed execution.
> Any thoughts?

How many roles do you have? 304? that would be the only reason why you
should have this. If I'm right, this could be easy to fix.


In response to


pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-08-03 20:08:26
Subject: Re: Unexplained query activity.
Previous:From: Guillaume LelargeDate: 2010-08-03 19:48:47
Subject: Re: Unexplained query activity.

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