[ADMIN] How to determine database activity???

Hi, Is there a way to actually determine if the database is doing anything after a query is send to the backend during *long* lasting queries besides waiting and hoping? -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416

Re: [ADMIN] How to determine database activity???

Joost Kraaijeveld wrote: > Is there a way to actually determine if the database is doing > anything after a query is send to the backend during *long* lasting > queries besides waiting and hoping? strace or ltrace will give you an idea, but I think you will find that the answer is usually "yes" a

Re: [ADMIN] How to determine database activity???

Try this query that displays current activity:-   select  datid,  datname as "DB Name",  substr(procpid,1,6) as "Procpid",  substr(usesysid,1,5) AS "UseSysid",  usename,  current_query as SQL,  query_startfrom  pg_stat_activityorder by  procpid   You may need to turn on some of the parameters in p