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

Re: Unexplained query activity.

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Unexplained query activity.
Date: 2010-08-03 20:20:58
Message-ID: 4C587A2A.20903@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgadmin-support
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

In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-08-03 22:22:16
Subject: Re: Unexplained query activity.
Previous:From: Guillaume LelargeDate: 2010-08-03 20:08:26
Subject: Re: Unexplained query activity.

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