Getting Network Statistics

From: Jeff Lilienstein <REMOVE-THISjeffhl(at)pacbell(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Getting Network Statistics
Date: 2003-03-26 17:11:34
Message-ID: 3E81DF46.2205AEB4@pacbell.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a subscription based Oracle database that is being converted
to Postgres under Redhat Linux 8.0. Usage is charged based on a
combination of CPU used and the number of bytes sent.

For Postgres I can see how to get CPU usage for the query/connection

from parsing the log for a connect statement, getting the PID and either

getting the CPU from the Postgres log or using the PID to find the Linux

file /proc/xxx/stats (where xxx ix the PID) and parsing the stats file
for the user and system CPU.

I still need to find the number of bytes transmitted to the client.
Oracle provides a "virtual" table, V$SESSTAT that provides that
information, but I have no idea how to get that information from
Postgres, or if that is not possible, from the operating system.

Any suggestions are much appreciated.

Thanks,

Jeff

Browse pgsql-general by date

  From Date Subject
Next Message Chris Smith 2003-03-26 17:13:32 Re: Please help with this error message
Previous Message Dennis Gearon 2003-03-26 17:09:27 Re: Long term read-only records?