Re: [Pypgsql-users] Monitoring Query progress

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

* Aaron Held <Iam...@ne...> [2002-09-20 11:30 -0400]:
> Is there a way to monitor the progress of a query?

AFAIK not really, apart from

"Chapter 10. Monitoring Database Activity"

http://developer.postgresql.org/docs/postgres/monitoring.html

> I have some queries that take about 15 minutes and I want to ensure
> that they are actively working.  

What else would they do except working?

Did you try to optimize your queries?

You can look at the execution plan of the query by firing up psql and
preprending them with an "explain". This will show where problems are
and which parts of the query you need to optimize.

http://developer.postgresql.org/docs/postgres/performance-tips.html

HTH,

-- Gerhard