|
1 | | -$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.8 2006/09/04 03:49:05 momjian Exp $ |
| 1 | +$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.9 2007/06/07 09:56:25 mha Exp $ |
2 | 2 |
|
3 | 3 | pgstattuple README2002/08/22 �а�ã�� |
4 | 4 |
|
@@ -63,53 +63,6 @@ pgstattuple README2002/08/22 |
63 | 63 | avg_leaf_density | 50.27 |
64 | 64 | leaf_fragmentation | 0 |
65 | 65 |
|
66 | | - bt_metap |
67 | | - -------- |
68 | | - bt_metap() ��btree����ǥå����Υ�ڡ����˴ؤ��������ֵѤ��ޤ��� |
69 | | - |
70 | | - test=> SELECT * FROM bt_metap('pg_cast_oid_index'); |
71 | | - -[ RECORD 1 ]----- |
72 | | - magic | 340322 |
73 | | - version | 2 |
74 | | - root | 1 |
75 | | - level | 0 |
76 | | - fastroot | 1 |
77 | | - fastlevel | 0 |
78 | | - |
79 | | - bt_page_stats |
80 | | - ------------- |
81 | | - bt_page_stats() �ϡ�btree��ñ��Υڡ����˴ؤ�������ɽ�����ޤ��� |
82 | | - |
83 | | - test=> SELECT * FROM bt_page_stats('pg_cast_oid_index', 1); |
84 | | - -[ RECORD 1 ]-+----- |
85 | | - blkno | 1 |
86 | | - type | l |
87 | | - live_items | 256 |
88 | | - dead_items | 0 |
89 | | - avg_item_size | 12 |
90 | | - page_size | 8192 |
91 | | - free_size | 4056 |
92 | | - btpo_prev | 0 |
93 | | - btpo_next | 0 |
94 | | - btpo | 0 |
95 | | - btpo_flags | 3 |
96 | | - |
97 | | - bt_page_items |
98 | | - ------------- |
99 | | - bt_page_items() �ϡ���btree�ڡ����θ��̤Υ����ƥ�˴ؤ�������ɽ�����ޤ��� |
100 | | - |
101 | | - test=> SELECT * FROM bt_page_items('pg_cast_oid_index', 1); |
102 | | - itemoffset | ctid | itemlen | nulls | vars | data |
103 | | - ------------+---------+---------+-------+------+------------- |
104 | | - 1 | (0,1) | 12 | f | f | 23 27 00 00 |
105 | | - 2 | (0,2) | 12 | f | f | 24 27 00 00 |
106 | | - 3 | (0,3) | 12 | f | f | 25 27 00 00 |
107 | | - 4 | (0,4) | 12 | f | f | 26 27 00 00 |
108 | | - 5 | (0,5) | 12 | f | f | 27 27 00 00 |
109 | | - 6 | (0,6) | 12 | f | f | 28 27 00 00 |
110 | | - 7 | (0,7) | 12 | f | f | 29 27 00 00 |
111 | | - 8 | (0,8) | 12 | f | f | 2a 27 00 00 |
112 | | - |
113 | 66 |
|
114 | 67 | 2. pgstattuple�Υ��ȡ��� |
115 | 68 |
|
|