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

Re: Postgres query completion status?

From: Richard Neill <rn214(at)cam(dot)ac(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres query completion status?
Date: 2009-11-20 20:45:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

Thom Brown wrote:
> 2009/11/20 Richard Neill <rn214(at)cam(dot)ac(dot)uk <mailto:rn214(at)cam(dot)ac(dot)uk>>
>         It might also help if you posted your postgresql.conf too.
>     Below (have removed the really non-interesting bits).
>     Thanks,
>     Richard
> I can't actually see anything in your config that would cause this 
> problem. :/
> As for seeing the progress of an update, I would have thought due to the 
> atomic nature of updates, only the transaction in which the update is 
> running would have visibility of the as-yet uncommitted updates.

Yes, but surely the postmaster itself (and any administrative user) 
should be able to find this out.

What I need for slow queries is some kind of progress bar. Any estimate 
(no matter how poor, or non-linear) of the query progress, or time 
remaining would be invaluable.


In response to

pgsql-performance by date

Next:From: Fernando HeviaDate: 2009-11-20 21:07:28
Subject: Re: Postgres query completion status?
Previous:From: Thom BrownDate: 2009-11-20 20:35:58
Subject: Re: Postgres query completion status?

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