Hi, Some of the queries I run on my Postgresql database take some time to complete (1 hour+). I know you can get the active queries by 'select * from pg_stat_activity', but I was wondering if there is a way to see some information on the progress of the query execution while running (for example the number of updated records , read records). TIA, Patrick -- ------------------------------------------------------------ Patrick Hoogendijk Safepoint Internet Services curacaolaan 144 3131 XG Vlaardingen http://www.safepoint.nl tel: +31 (0)10 4340044 fax: +31 (0)10 4340032 ------------------------------------------------------------ "Walking on water and meeting requirements are both equally easy to do when both are frozen." ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
