Re: Unexplained query activity.

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@2ndQuadrant.com   www.2ndQuadrant.us