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