I'm wondering if there is a query I could run to detect long-running
transactions? Basically, I want to know all transactions (either on a
given server or just on a given database) that have been running for
longer than some parameterized amount of time.
I've spent some time with the friendly manual (especially Chapter 42 and
12), and didn't see anything usefull.
I'm having a problem with stupid humans (including yours truely)
forgetting they have a transaction outstanding and wandering off for a
weekend. What I'd like to do is write a quick script that queries the
database every so often, and if it finds a transaction that's been
running to long, send out an email warning people. I might be able to
do this by grovelling through the logs, although it'd be much easier to
do it with a query.
Thanks.
Brian