Get bytes sent to client

From: Alexander Pyhalov <alp(at)rsu(dot)ru>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Get bytes sent to client
Date: 2009-12-16 08:05:59
Message-ID: 4B2894E7.80407@rsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

--
Best regards,
Alexander Pyhalov,
system administrator of Computer Center of South Federal University

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alexander Pyhalov 2009-12-16 09:29:14 Re: Get bytes sent to client
Previous Message Viktor Usunov 2009-12-15 20:10:12 Bulgarian translation for the PostgreSQL JDBC driver