Hi!
What I often use is
select procpid, query_start, current_query from pg_stat_activity
... tells you what queries are running right now and how long they take.
greetings,
Stephan
--
Seid unbequem, seid Sand, nicht Öl im Getriebe der Welt! - Günther Eich
,---------------------------------------------------------------------.
| Stephan Plepelits, |
| Technische Universität Wien - Studien Informatik & Raumplanung |
| Projects: |
| > openstreetbrowser.org > couchsurfing.org > tubasis.at > bl.mud.at |
| Contacts: |
| > Mail: [email protected] > Jabber: [email protected] |
| > Blog: plepe.at > Twitter: twitter.com/plepe |
`---------------------------------------------------------------------'
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
