Bruce,

I'll fix it in this week. Please wait a few days.
Thanks.

Bruce Momjian wrote:
> 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 <[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
> 


-- 
NAGAYASU Satoshi <[EMAIL PROTECTED]>
Phone: +81-3-3523-8122

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to