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-21 17:49:11
Message-ID: 3E7B5097.D1C20B2E@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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Schapachnik 2003-03-21 17:54:10 Re: Posts get losts
Previous Message Tom Lane 2003-03-21 17:46:59 Re: FIPS 127-2