pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Richard Huxton <dev@archonet.com>
To: Gauri Kanekar <meetgaurikanekar@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Table Size
Date: Tue, 16 Jan 2007 19:24:32 +0000
Message-ID: <45AD2670.7050509@archonet.com> (raw)
In-Reply-To: <7e4ba9550701160548v4980393buba8bbf6926e2b0a0@mail.gmail.com>
References: <7e4ba9550701160548v4980393buba8bbf6926e2b0a0@mail.gmail.com>

Gauri Kanekar wrote:
> Hi,
> 
> Can anybody help me out to get following info of all the tables in a
> database.

1. Have you read up on the information schema and system catalogues?
http://www.postgresql.org/docs/8.2/static/catalogs.html
http://www.postgresql.org/docs/8.2/static/catalogs.html


> table_len
> tuple_count
> tuple_len

2. Not sure what the difference is between "len" and "count" here.

> tuple_percent

3. Or what this "percent" refers to.

> dead_tuple_count
> dead_tuple_len
> dead_tuple_percent
> free_space
> free_percent

4. You might find some of the stats tables useful too:
http://www.postgresql.org/docs/8.2/static/monitoring-stats.html

-- 
   Richard Huxton
   Archonet Ltd

view thread (3+ messages)  latest in thread

Message-ID: <45AD2670.7050509@archonet.com>
Permalink:  ../45AD2670.7050509@archonet.com/
Also on:    postgresql.org/message-id/45AD2670.7050509@archonet.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dev@archonet.com, meetgaurikanekar@gmail.com
  Subject: Re: Table Size
  In-Reply-To: <45AD2670.7050509@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox