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   [EMAIL PROTECTED]
  EnterpriseDB    http://www.enterprisedb.com

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to