Re: Server instrumentation for 8.1

On 2005-05-11, "Jim C. Nasby" <decibel(at)decibel(dot)org> wrote:
> On Wed, May 11, 2005 at 04:44:21PM +0000, Andreas Pflug wrote:
>> There's still a lengthy discussion going on whether it's a good idea to
>> add a forth way to read pgsql's schema (pg_* tables, pg_* views,
>> information_schema, did I miss one?), but I'd like to see helper
>> functions for issues *not* covered in the core package.
>>
>> - dbsize has been in contrib for a long time, though it appears to me as
>> quite a basic functionality to find out about storage needs.
>
> FWIW, I believe the new system views cover all the dbsize cases.

dbsize looks at the actual size of files on disk; newsysviews does not,
it shows estimated sizes as taken from relpages. newsysviews doesn't
allow you to see size info for databases you're not connected to.

However, newsysviews knows about toast tables, and gives a breakdown of
table size by main storage, toast and index.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services