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