Postgres Pro
Downloads
Home   >   mailing lists

Thread: statistical table

statistical table

From
std pik
Date:
Hello all..
I'm using PostgreSQL 8.3..
How can I get information about the hardware utilization:
        - CPU usage.
        - Disk space.
        - Memory allocation.
thank you.

Re: statistical table

From
Lennin Caro
Date:
--- On Tue, 9/15/09, std pik <stdpik@gmail.com> wrote:

From: std pik <stdpik@gmail.com>
Subject: [PERFORM] statistical table
To: pgsql-performance@postgresql.org
Date: Tuesday, September 15, 2009, 9:27 AM

Hello all..
I'm using PostgreSQL 8.3..
How can I get information about the hardware utilization:
        - CPU usage.
        - Disk space.
        - Memory allocation.
thank you.

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

in GNU/linux like debian you can use the sysstat package

Ing. Lennin Caro Pérez
Usuario:GNU/LINUX
PHP Developer
PostgreSQL DBA
Oracle DBA
Linux counter id 474393


Re: statistical table

From
Joshua Tolley
Date:
On Tue, Sep 15, 2009 at 02:27:41AM -0700, std pik wrote:
> Hello all..
> I'm using PostgreSQL 8.3..
> How can I get information about the hardware utilization:
>         - CPU usage.
>         - Disk space.
>         - Memory allocation.
> thank you.

In general, use the utilities provided by your operating system. There are a
series of functions that will tell you the size on disk of various database
objects. See "Database Object Size Functions" on this page:
http://www.postgresql.org/docs/8.4/interactive/functions-admin.html

For CPU or memory usage information, use your operating system.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
Attachment