Thread: [pgAdmin III] #221: A Greenplum query is executed once per role
#221: A Greenplum query is executed once per role
-----------------------------+----------------------------------------------
Reporter: Little, Douglas | Owner: gleu
Type: feature | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: role greenplum | Platform: all
-----------------------------+----------------------------------------------
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.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/221>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
#221: A Greenplum query is executed once per role
------------------------------+---------------------------------------------
Reporter: Little, Douglas | Owner: gleu
Type: feature | Status: closed
Priority: minor | Milestone: 1.12
Component: pgadmin | Version: 1.10
Resolution: fixed | Keywords: role greenplum
Platform: all |
------------------------------+---------------------------------------------
Changes (by gleu):
* status: new => closed
* resolution: => fixed
* milestone: => 1.12
Comment:
Done in
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=c99cc49a3eb40eb684ca185003522fba3b1d2723
and
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commit;h=6f93c1629447faf41c3936142d8e6588f3912add
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/221#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III