[pgAdmin III] #221: A Greenplum query is executed once per role

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #221: A Greenplum query is executed once per role
Date: 2010-08-04 21:31:03
Message-ID: 056.7709bb41fdae3c7907bb0f2b55c28bf8@code.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

#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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2010-08-04 21:36:05 pgAdmin III commit: Don't send the Greenplum query for each user, but i
Previous Message Chuck McDevitt 2010-08-04 20:55:09 Re: Patch on roles query for pgAdmin with a Greenplum database