Re: PostgreSQL 8.3 index page count clarification - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: PostgreSQL 8.3 index page count clarification
Date
Msg-id 555C9439.8030107@iki.fi
Whole thread Raw
In response to PostgreSQL 8.3 index page count clarification  (Srinivas Karthik V <skarthikv.iitb@gmail.com>)
List pgsql-hackers
On 05/20/2015 04:14 PM, Srinivas Karthik V wrote:
> Hi,
>        For the user created indexes in PostgreSQL 8.3.6, I would like to
> know in which table (eg: pg_tablename) the index-tuple-count and
> index-page-count meta-data statistics are stored.

pg_class.reltuples and pg_class.relpages.

(I'm sure you're aware that 8.3 is a hopelessly old and unsupported 
version, and 8.3.6 is a hopelessly outdated minor version in that series...)

- Heikki




pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Typo in tablecmds.c
Next
From: Merlin Moncure
Date:
Subject: Re: [PATCH] Generalized JSON output functions