Обсуждение: PostgreSQL 8.3 index page count clarification

Поиск
Список
Период
Сортировка

PostgreSQL 8.3 index page count clarification

От
Srinivas Karthik V
Дата:
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.


Regards and Thanks,
Srinivas Karthik

Re: PostgreSQL 8.3 index page count clarification

От
Heikki Linnakangas
Дата:
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