I thought these new functions were going to be merged into
/contrib/pgstattuple.

---------------------------------------------------------------------------

satoshi nagayasu wrote:
> Hi folks,
> 
> As I said on -PATCHES, I've been working on an utility to get
> a b-tree index information. I'm happy to introduce
> my new functions to you.
> 
> pgstattuple module provides a `pgstatindex()`, and other small
> functions, which allow you to get b-tree internal information.
> I believe this module will be helpful to know b-tree index deeply.
> 
> So please try it, send comment to me, and have fun.
> 
> Thanks,
> -- 
> NAGAYASU Satoshi <[EMAIL PROTECTED]>
> 
> -----------------------------------------------------
> pgbench=# \x
> Expanded display is on.
> pgbench=# SELECT * FROM pgstatindex('accounts_pkey');
> -[ RECORD 1 ]------+--------
> version            | 2
> tree_level         | 1
> index_size         | 3588096
> root_block_no      | 3
> internal_pages     | 0
> leaf_pages         | 437
> empty_pages        | 0
> deleted_pages      | 0
> avg_leaf_density   | 59.5
> leaf_fragmentation | 49.89
> -----------------------------------------------------
> 
> 

[ application/x-gzip is not supported, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org

-- 
  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