$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.8 2006/09/04 03:49:05 momjian Exp $

bt_metap

--------

bt_metap() ��btree����ǥå����Υ᥿�ڡ����˴ؤ��������ֵѤ��ޤ���

test=> SELECT * FROM bt_metap('pg_cast_oid_index');

-[ RECORD 1 ]-----

magic | 340322

version | 2

root | 1

level | 0

fastroot | 1

fastlevel | 0

bt_page_stats

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

bt_page_stats() �ϡ�btree��ñ��Υڡ����˴ؤ�������ɽ�����ޤ���

test=> SELECT * FROM bt_page_stats('pg_cast_oid_index', 1);

-[ RECORD 1 ]-+-----

blkno | 1

type | l

live_items | 256

dead_items | 0

avg_item_size | 12

page_size | 8192

free_size | 4056

btpo_prev | 0

btpo_next | 0

btpo | 0

btpo_flags | 3

bt_page_items

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

bt_page_items() �ϡ���btree�ڡ����θ��̤Υ����ƥ�˴ؤ�������ɽ�����ޤ���

test=> SELECT * FROM bt_page_items('pg_cast_oid_index', 1);

itemoffset | ctid | itemlen | nulls | vars | data

------------+---------+---------+-------+------+-------------

1 | (0,1) | 12 | f | f | 23 27 00 00

2 | (0,2) | 12 | f | f | 24 27 00 00

3 | (0,3) | 12 | f | f | 25 27 00 00

4 | (0,4) | 12 | f | f | 26 27 00 00

5 | (0,5) | 12 | f | f | 27 27 00 00

6 | (0,6) | 12 | f | f | 28 27 00 00

7 | (0,7) | 12 | f | f | 29 27 00 00

8 | (0,8) | 12 | f | f | 2a 27 00 00