Re: statistical table - Mailing list pgsql-performance

From Joshua Tolley
Subject Re: statistical table
Date
Msg-id 20090917134319.GF25739@eddie
Whole thread Raw
In response to statistical table  (std pik <stdpik@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Lennin Caro
Date:
Subject: Re: statistical table
Next
From: Andy Colson
Date:
Subject: Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition?