Re: Get bytes sent to client

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.
>

--
С уважением,
Александр Пыхалов,
системный администратор ЮГИНФО ЮФУ.