Re: Better Connection Statistics

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> For instance, I want the number of transactions a specific connection has submitted.
> The number of queries. Total amount of CPU time consumed, etc. So far as I know,
> there is no module, statistic, or view that provides any of this.

For the basic connection information, you could parse the Postgres logs, assuming
you are being verbose enough to capture everything. Certainly you could get
commits/rollbacks/queries/avg_time per connection. For deeper and better introspection,
check out integrating DTrace or SystemTap.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201402081451
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlL2itEACgkQvJuQZxSWSshlIgCgo+jkIYojwc23O4jwLGYxqZ8H
tJgAn3/K7lK+S4c4003xO+nVcWzsc+TK
=uFOM
-----END PGP SIGNATURE-----