Re: [PATCHES] pgstattuple extension for indexes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCHES] pgstattuple extension for indexes
Date
Msg-id 200608100156.k7A1unU21775@momjian.us
Whole thread Raw
In response to Re: [PATCHES] pgstattuple extension for indexes  (satoshi nagayasu <nagayasus@nttdata.co.jp>)
Responses Re: [PATCHES] pgstattuple extension for indexes  (Satoshi Nagayasu <nagayasus@nttdata.co.jp>)
List pgsql-hackers
nagayasu-san,

This looks good, but we would like the code added to
/contrib/pgstattuple, rather than it being its own /contrib module.  Can
you make that adjustment?  Thanks.

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

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 <nagayasus@nttdata.co.jp>
>
> -----------------------------------------------------
> 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   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] WIN32 Build?
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: /contrib/cube improvements: Update