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

Unexplained query activity.

From: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Unexplained query activity.
Date: 2010-08-03 19:38:03
Message-ID: 8585BA53443004458E0BAA6134C5A7FB0CB29045@EGEXCMB01.oww.root.lcl (view raw or flat)
Thread:
Lists: pgadmin-support
Hi,
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.

2010-08-03 14:15:20.019774 CDT

LOG

statement: SELECT rsqname FROM pg_resqueue WHERE pg_resqueue.oid = 1496028

con755

cmd318

postgres



Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
Douglas(dot)Little(at)orbitz(dot)com<mailto:Douglas(dot)Little(at)orbitz(dot)com>
 [cid:image001(dot)jpg(at)01CB3319(dot)7A5D3980]   orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-08-03 19:48:47
Subject: Re: Unexplained query activity.
Previous:From: Jeremy PalmerDate: 2010-08-03 03:02:07
Subject: Can not debug plpgsql using PgAdminIII

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