Re: PostgreSQL 8.3 index page count clarification

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Srinivas Karthik V <skarthikv(dot)iitb(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.3 index page count clarification
Date: 2015-05-20 14:03:37
Message-ID: 555C9439.8030107@iki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2015-05-20 14:06:46 Re: [PATCH] Generalized JSON output functions
Previous Message Heikki Linnakangas 2015-05-20 13:59:22 Re: Typo in tablecmds.c