Update Japanese readme for pgstattuple.

bmomjian · bmomjian · commit 70bc947dc9e5 · 2006-09-04T03:49:05.000Z
diff --git a/contrib/pgstattuple/README.pgstattuple.euc_jp b/contrib/pgstattuple/README.pgstattuple.euc_jp
@@ -1,39 +1,115 @@
-$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.7 2006/07/06 02:18:07 momjian Exp $
+$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.8 2006/09/04 03:49:05 momjian Exp $
 
 pgstattuple README		2002/08/22 �а�ã��
 
-1. pgstattuple�Ȥ�
+1. ���ݡ��Ȥ���Ƥ���ؿ�
 
+   pgstattuple
+   -----------
    pgstattuple�ϡ�UPDATE��DELETE�Ǻ��줿��졼�����Υ����ΰ���礭����
    ��졼������Τ�ʪ��Ū���礭�����Ф���ѡ�����ơ������ֵѤ��ޤ�����
    �ޤꡤ�ֵ��ͤ��礭����С�����������ߤ�¿���Τǡ�vacuum�򤫤���ɬ
    �פ�����Ȥ���Ƚ�Ǥν����ˤʤ�櫓�Ǥ�������ʳ��ˤ⤤�������ʾ���
    ���֤�ޤ���
-
-test=# \x
-Expanded display is on.
-test=# select * from pgstattuple('pg_proc');
--[ RECORD 1 ]------+-------
-table_len          | 458752
-tuple_count        | 1470
-tuple_len          | 438896
-tuple_percent      | 95.67
-dead_tuple_count   | 11
-dead_tuple_len     | 3157
-dead_tuple_percent | 0.69
-free_space         | 8932
-free_percent       | 1.95
-
-�ƹ��ܤ������Ǥ���
-
-table_len		-- ��졼������ʪ��Ū���礭��(�Х���)
-tuple_count		-- ���ץ��
-tuple_len		-- ���ץ�Ĺ�ι��(�Х���)
-tuple_percent		-- ���ץ�γ�硥table_len���Ф���tuple_len����Ψ��
-dead_tuple_len		-- �ǥåɥ��ץ��
-dead_tuple_percent	-- �ǥåɥ��ץ�γ�硥table_len���Ф���tuple_len����Ψ��
-free_space		-- �����Ѳ�ǽ���ΰ�(�Х���)
-free_percent		-- �����Ѳ�ǽ���ΰ补table_len���Ф���free_space����Ψ��
+   pgstattuple() �ϡ���졼������Ĺ���䡢���ץ��"�����ΰ�"�γ��ʤɤ�
+   ������ֵѤ��ޤ��������ξ���ϡ�vacuum ��ɬ�פ��ɤ������桼����Ƚ��
+   ����Τ���Ω�ĤǤ��礦���㤨�аʲ��Τ褦�ʷ��ˤʤ�ޤ���
+
+       test=> \x
+       Expanded display is on.
+       test=> SELECT * FROM pgstattuple('pg_catalog.pg_proc');
+       -[ RECORD 1 ]------+-------
+       table_len          | 458752
+       tuple_count        | 1470
+       tuple_len          | 438896
+       tuple_percent      | 95.67
+       dead_tuple_count   | 11
+       dead_tuple_len     | 3157
+       dead_tuple_percent | 0.69
+       free_space         | 8932
+       free_percent       | 1.95
+
+   �ʲ����ƹ��ܤ����ƤǤ���
+
+       table_len		-- ��졼������ʪ��Ū���礭��(�Х���)
+       tuple_count		-- ���ץ��
+       tuple_len		-- ���ץ�Ĺ�ι��(�Х���)
+       tuple_percent	-- ���ץ�γ�硥table_len���Ф���tuple_len����Ψ��
+       dead_tuple_len	-- �ǥåɥ��ץ��
+       dead_tuple_percent	-- �ǥåɥ��ץ�γ�硥table_len���Ф���tuple_len����Ψ��
+       free_space		-- �����Ѳ�ǽ���ΰ�(�Х���)
+       free_percent	-- �����Ѳ�ǽ���ΰ补table_len���Ф���free_space����Ψ��
+
+   pg_relpages
+   -----------
+   pg_relpages() �ϥ�졼�����Υڡ��������ֵѤ��ޤ���
+
+   pgstatindex
+   -----------
+   pgstatindex() �ϥ���ǥå����˴ؤ��������ֵѤ��ޤ���
+
+       test=> \x
+       Expanded display is on.
+       test=> SELECT * FROM pgstatindex('pg_cast_oid_index');
+       -[ RECORD 1 ]------+------
+       version            | 2
+       tree_level         | 0
+       index_size         | 8192
+       root_block_no      | 1
+       internal_pages     | 0
+       leaf_pages         | 1
+       empty_pages        | 0
+       deleted_pages      | 0
+       avg_leaf_density   | 50.27
+       leaf_fragmentation | 0
+
+   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
+ 
 
 2. pgstattuple�Υ��󥹥ȡ���
 
