Postgres Pro
Downloads
Home   >   mailing lists

Re: Unexplained query activity. - Mailing list pgadmin-support

From Greg Smith
Subject Re: Unexplained query activity.
Date
Msg-id 4C587A2A.20903@2ndquadrant.com
Whole thread Raw
In response to Unexplained query activity.  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
List pgadmin-support
Tree view 
Little, Douglas wrote: <br /><br /><blockquote
cite="mid:8585BA53443004458E0BAA6134C5A7FB0CB29045@EGEXCMB01.oww.root.lcl"type="cite"><div class="WordSection1"><p
class="MsoNormal">RunningPGAdmin 1.10.3  on win xp sp3 against Greenplum 3.3.6.6 (PG 8.1.4)</div></blockquote><br /> I
thinkyou mean PG 8.2.4 there.<br /><br /> If you're not already familiar with how Greenplum uses resource queues, some
backgroundthere might help explain why the things you're looking at require queries against it:<br /><br /><a
class="moz-txt-link-freetext"
href="http://www.greenplum.com/docs/3300/CREATE_RESOURCE_QUEUE.html">http://www.greenplum.com/docs/3300/CREATE_RESOURCE_QUEUE.html</a><br
/><aclass="moz-txt-link-freetext"
href="http://www.greenplum.com/docs/3300/sql-alterrole.html">http://www.greenplum.com/docs/3300/sql-alterrole.html</a><br
/><aclass="moz-txt-link-freetext"
href="http://www.greenplum.com/docs/3300/DROP_RESOURCE_QUEUE.html">http://www.greenplum.com/docs/3300/DROP_RESOURCE_QUEUE.html</a><br
/><br/> The DROP page in particular shows examples that retrieve similar things to the pg_resqueue query you're seeing
run.<br/><br /><pre class="moz-signature" cols="72">-- 
 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
<a class="moz-txt-link-abbreviated" href="mailto:greg@2ndQuadrant.com">greg@2ndQuadrant.com</a>   <a
class="moz-txt-link-abbreviated"href="http://www.2ndQuadrant.us">www.2ndQuadrant.us</a>
 
</pre>

pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Unexplained query activity.
Next
From: Guillaume Lelarge
Date:
Subject: Re: Unexplained query activity.