Re: Get bytes sent to client

I have had similar interest in my applications raw byte traffic on the
network and
just ended up using on Linux iptraf monitor. You can reset it then
execute a query
in the client to see exactly the bytes being transmitted/received. I'm
sure there must
be something similar for other platforms.

danap.

> I had some thoughts about extending ProtocolConnectionImpl, PGStream
> and so on (to account bytes on client side, when PGStream calls
> pg_input  methods), but they have a lot of private fields and
> methods... It is also is quite time-consuming... Are there any other
> ideas? The idea is to account size of raw data sent to client...
>
> Alexander Pyhalov wrote:
>
>> Hello.
>> I'd like to collect some statistics in my application (using JDBC).
>> In Oracle I could collect data, sent to client, using the following
>> query:
>>
>> SELECT S.value FROM V$MYSTAT S,SYS.V_$STATNAME NAMES
>> WHERE NAMES.STATISTIC#=S.STATISTIC#
>> AND NAMES.NAME='bytes sent via SQL*Net to client';
>>
>> Can I do something like this in PostgreSQL? I'd like to estimate
>> query result size, to be more precise, amount of network traffic,
>> which is generated in response to a query.
>>