Re: Getting Network Statistics

Jeff Lilienstein <REMOVE-THISjeffhl(at)pacbell(dot)net> writes:

> I still need to find the number of bytes transmitted to the client.
> Oracle provides a "virtual" table, V$SESSTAT that provides that
> information, but I have no idea how to get that information from
> Postgres, or if that is not possible, from the operating system.

There are a couple of possibilities here:

1) Patch Postgres so it tracks bytes sent over a connection socket,
(it definitely doesn't do this now) and writes out the total to a
logfile when the connection is closed. This might not be too hard,
depending on the modularity of the code.

2) Figure out a way to get per-socket statistics from your OS.

-Doug