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