Re: Unexplained query activity.

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>