further meta-data in pg_stat_activity? - Mailing list pgsql-hackers

From Andrew Hammond
Subject further meta-data in pg_stat_activity?
Date
Msg-id 1150473802.712349.230170@c74g2000cwc.googlegroups.com
Whole thread Raw
Responses Re: further meta-data in pg_stat_activity?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
How much work would it be to implement and how valuable would people
find the following additions to pg_stat_activity?

1) # of transactions committed on this connection since start
2) # of transactions rolled back
3) milliseconds used processing requests
4) milliseconds idle in transaction
5) milliseconds idle
6) this is the n'th backend spawned since the postmaster started
7) this is the n'th backend for the given client_addr
8) this is the n'th backend for the given user
9) timestamp for start of the current transaction (null if idle?)

Drew



pgsql-hackers by date:

Previous
From: Kris Kennaway
Date:
Subject: Re: postgresql and process titles
Next
From: Tom Lane
Date:
Subject: Re: further meta-data in pg_stat_activity?