Unexplained query activity.

Hi,
Running PGAdmin 1.10.3 on win xp sp3 against Greenplum 3.3.6.6 (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?

2010-08-03 14:15:18.654622 CDT

LOG

statement: SELECT rsqname FROM pg_resqueue WHERE pg_resqueue.oid = 1496028

con755

cmd15

postgres

.... 303 rows identical calls.

2010-08-03 14:15:20.019774 CDT

LOG

statement: SELECT rsqname FROM pg_resqueue WHERE pg_resqueue.oid = 1496028

con755

cmd318

postgres

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
Douglas(dot)Little(at)orbitz(dot)com<mailto:Douglas(dot)Little(at)orbitz(dot)com>
[cid:image001(dot)jpg(at)01CB3319(dot)7A5D3980] orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>

Le 03/08/2010 21:38, Little, Douglas a écrit :
> [...]
> Running PGAdmin 1.10.3 on win xp sp3 against Greenplum 3.3.6.6 (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.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

325 logon roles, 24 groups

Doug

-----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 3.3.6.6 (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.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Le 03/08/2010 21:50, Little, Douglas a écrit :
> 325 logon roles, 24 groups
>

I suppose some of them don't have a ressource queue configured.

BTW, please, don't top-post.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Little, Douglas wrote:

> Running PGAdmin 1.10.3 on win xp sp3 against Greenplum 3.3.6.6 (PG 8.1.4)
>

I think you mean PG 8.2.4 there.

If you're not already familiar with how Greenplum uses resource queues,
some background there might help explain why the things you're looking
at require queries against it:

http://www.greenplum.com/docs/3300/CREATE_RESOURCE_QUEUE.html
http://www.greenplum.com/docs/3300/sql-alterrole.html
http://www.greenplum.com/docs/3300/DROP_RESOURCE_QUEUE.html

The DROP page in particular shows examples that retrieve similar things
to the pg_resqueue query you're seeing run.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us

Le 03/08/2010 22:08, Guillaume Lelarge a écrit :
> Le 03/08/2010 21:50, Little, Douglas a écrit :
>> 325 logon roles, 24 groups
>>
>
> I suppose some of them don't have a ressource queue configured.
>
> BTW, please, don't top-post.
>

If you can compile it on windows, here is a patch that should fix this.
I can't test it because I don't have a Greenplum database.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Le 04/08/2010 00:22, Guillaume Lelarge a écrit :
> Le 03/08/2010 22:08, Guillaume Lelarge a écrit :
>> Le 03/08/2010 21:50, Little, Douglas a écrit :
>>> 325 logon roles, 24 groups
>>>
>>
>> I suppose some of them don't have a ressource queue configured.
>>
>> BTW, please, don't top-post.
>>
>
> If you can compile it on windows, here is a patch that should fix this.
> I can't test it because I don't have a Greenplum database.
>

BTW, the patch is commited.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com