Re: pgstattuple extension for indexes - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: pgstattuple extension for indexes
Date
Msg-id 200607250149.k6P1nX000866@momjian.us
Whole thread Raw
In response to Re: pgstattuple extension for indexes  ("Satoshi Nagayasu" <nagayasus@nttdata.co.jp>)
List pgsql-patches
Satoshi Nagayasu wrote:
> Hi,
>
> I'm working on an utility for b-tree index, called `pgstatindex`.
>
> It reports b-tree index statistics like a pgstattuple as below.
> ----------------------------------------------------------------
> pgbench=# \x
> Expanded display is on.
> pgbench=# SELECT * FROM pgstatindex('accounts_pkey1');
> -[ RECORD 1 ]------+---------
> version            | 2
> tree_level         | 2
> index_size         | 17956864
> root_block_no      | 361
> internal_pages     | 8
> leaf_pages         | 2184
> empty_pages        | 0
> deleted_pages      | 0
> avg_leaf_density   | 90.07
> leaf_fragmentation | 0
>
> pgbench=#
> ----------------------------------------------------------------
>
> I want to make this to contrib module like a pgstattuple,
> and to make this open to public in a few days.
>
> Do you think this is useful?

Yes, for performance debugging, I think.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Resurrecting per-page cleaner for btree
Next
From: Bruce Momjian
Date:
Subject: Re: LDAP patch & feature freeze