dirty select

Lists: pgsql-general
From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: dirty select
Date: 2008-04-08 11:39:32
Message-ID: ftflhi$1fjd$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Is there any way to do a dirty select to find out what a process is up
to? I have a process that is writing 150,000 rows to a table and it is
taking way longer then I thought it would. I would like to read the
table to make sure that it is not looping through the data or anything
like that.

Thank you
SIm

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: dirty select
Date: 2008-04-08 14:11:38
Message-ID: 20080408141138.GA8310@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Tue, Apr 08, 2008 at 02:39:32PM +0300, Sim Zacks wrote:
> Is there any way to do a dirty select to find out what a process is up
> to?

No.