Re: [Pypgsql-users] Monitoring Query progress

[Gerhard <ger...@gm...>]

* Aaron Held <aa...@Me...> [2002-09-20 16:03 -0400]:
> >>Is there a way to monitor the progress of a query?
> >"Chapter 10. Monitoring Database Activity"
> 
> 
> >What else would they do except working?
> 
> I have optimized the system as much as possible, but during high loads
> the queries can take a long time.  I would like to give the user
> some indication of how long the search will take.

I don't think that's possible for a single SQL statement (if splitting
it up by rewriting it as a stored procedure isn't possible). At least I
don't know of any way under PostgreSQL. Or Oracle, for that matter.

pyPgSQL has some support for asynchronuous query processing in its
low-level module libpq, but I don't see how that could help in your
case.

I'd try to ask on one of the PostgreSQL lists, perhaps there's still
some creative possibility to achieve your goal.

-- Gerhard