-----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@xxxxxxxxxxxx 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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
