From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp> |
Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, ishii(at)sraoss(dot)co(dot)jp |
Subject: | Re: pgstattuple extension for indexes |
Date: | 2006-07-28 13:31:02 |
Message-ID: | 200607281331.k6SDV2P12212@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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 <nagayasus(at)nttdata(dot)co(dot)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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-07-28 13:34:27 | Re: The vacuum-ignore-vacuum patch |
Previous Message | Tom Lane | 2006-07-28 13:19:13 | Re: [HACKERS] putting CHECK_FOR_INTERRUPTS in qsort_comparetup() |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-07-28 13:34:27 | Re: The vacuum-ignore-vacuum patch |
Previous Message | Tom Lane | 2006-07-28 13:19:13 | Re: [HACKERS] putting CHECK_FOR_INTERRUPTS in qsort_comparetup() |