Add "tx age >1m" and "tx age >1h" to G002
Be able to understand how many transactions with high age values. Right now we can only see the time spent since
state_change, it's not enough to identify long-running transactions.
TODO / How to implement
Transaction age is determined from
now() - xact_start.
xact_start to understand transactions ages, similar to
xact_start and show two more columns.
As a postgres-checkup user, I'm able to quickly understand:
- how many transactions with age more than 1 hour we have;
- how many transactions with age more than 1 minute we have;
- what's distribution of those transactions with respect to (a) databases, (b) users.