Get bytes sent to client

From: Alexander Pyhalov <alp(at)rsu(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Get bytes sent to client
Date: 2009-12-14 08:00:51
Message-ID: 4B25F0B3.9090601@rsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 was suggested to wrap some parts of PostgreSQL JDBC Driver, but it
looks not very good.
Is there any other way to count up raw data, received by client (or sent
by server)?
The purpose is to estimate bandwidth from client to DBMS and size of
query responses...
--
Best regards,
Alexander Pyhalov,
system administrator of Computer Center of South Federal University

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2009-12-14 08:35:31 Visibility of temporary database objects
Previous Message Craig Ringer 2009-12-14 04:25:40 Column privileges and Hibernate