Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit70bc947

Browse files
committed
Update Japanese readme for pgstattuple.
1 parentc9a6490 commit70bc947

File tree

1 file changed

+103
-27
lines changed

1 file changed

+103
-27
lines changed

‎contrib/pgstattuple/README.pgstattuple.euc_jp

Lines changed: 103 additions & 27 deletions
Original file line numberDiff line numberDiff line change
@@ -1,39 +1,115 @@
1-
$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.7 2006/07/06 02:18:07 momjian Exp $
1+
$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.8 2006/09/04 03:49:05 momjian Exp $
22

33
pgstattuple README2002/08/22 �а�ã��
44

5-
1.pgstattuple�Ȥ
5+
1.���ݡ��Ȥ���Ƥ���ؿ
66

7+
pgstattuple
8+
-----------
79
pgstattuple�ϡ�UPDATE��DELETE�Ǻ��줿��졼�����Υ����ΰ���礭����
810
��졼������Τ�ʪ��Ū���礭�����Ф���ѡ�����ơ������ֵѤ��ޤ�����
911
�ޤꡤ�ֵ��ͤ��礭����С�����������ߤ�¿���Τǡ�vacuum�򤫤���ɬ
1012
�פ�����Ȥ���Ƚ�Ǥν����ˤʤ�櫓�Ǥ�������ʳ��ˤ⤤�������ʾ���
1113
���֤�ޤ���
12-
13-
test=# \x
14-
Expanded display is on.
15-
test=# select * from pgstattuple('pg_proc');
16-
-[ RECORD 1 ]------+-------
17-
table_len | 458752
18-
tuple_count | 1470
19-
tuple_len | 438896
20-
tuple_percent | 95.67
21-
dead_tuple_count | 11
22-
dead_tuple_len | 3157
23-
dead_tuple_percent | 0.69
24-
free_space | 8932
25-
free_percent | 1.95
26-
27-
�ƹ��ܤ������Ǥ���
28-
29-
table_len-- ��졼������ʪ��Ū���礭��(�Х���)
30-
tuple_count-- ���ץ��
31-
tuple_len-- ���ץ�Ĺ�ι��(�Х���)
32-
tuple_percent-- ���ץ�γ�硥table_len���Ф���tuple_len����Ψ��
33-
dead_tuple_len-- �ǥåɥ��ץ��
34-
dead_tuple_percent-- �ǥåɥ��ץ�γ�硥table_len���Ф���tuple_len����Ψ��
35-
free_space-- �����Ѳ�ǽ���ΰ�(�Х���)
36-
free_percent-- �����Ѳ�ǽ���ΰ补table_len���Ф���free_space����Ψ��
14+
pgstattuple() �ϡ���졼������Ĺ���䡢���ץ��"�����ΰ�"�γ��ʤɤ�
15+
������ֵѤ��ޤ��������ξ���ϡ�vacuum ��ɬ�פ��ɤ������桼����Ƚ��
16+
����Τ���Ω�ĤǤ��礦���㤨�аʲ��Τ褦�ʷ��ˤʤ�ޤ���
17+
18+
test=> \x
19+
Expanded display is on.
20+
test=> SELECT * FROM pgstattuple('pg_catalog.pg_proc');
21+
-[ RECORD 1 ]------+-------
22+
table_len | 458752
23+
tuple_count | 1470
24+
tuple_len | 438896
25+
tuple_percent | 95.67
26+
dead_tuple_count | 11
27+
dead_tuple_len | 3157
28+
dead_tuple_percent | 0.69
29+
free_space | 8932
30+
free_percent | 1.95
31+
32+
�ʲ����ƹ��ܤ����ƤǤ���
33+
34+
table_len-- ��졼������ʪ��Ū���礭��(�Х���)
35+
tuple_count-- ���ץ��
36+
tuple_len-- ���ץ�Ĺ�ι��(�Х���)
37+
tuple_percent-- ���ץ�γ�硥table_len���Ф���tuple_len����Ψ��
38+
dead_tuple_len-- �ǥåɥ��ץ��
39+
dead_tuple_percent-- �ǥåɥ��ץ�γ�硥table_len���Ф���tuple_len����Ψ��
40+
free_space-- �����Ѳ�ǽ���ΰ�(�Х���)
41+
free_percent-- �����Ѳ�ǽ���ΰ补table_len���Ф���free_space����Ψ��
42+
43+
pg_relpages
44+
-----------
45+
pg_relpages() �ϥ�졼�����Υڡ��������ֵѤ��ޤ���
46+
47+
pgstatindex
48+
-----------
49+
pgstatindex() �ϥ���ǥå����˴ؤ��������ֵѤ��ޤ���
50+
51+
test=> \x
52+
Expanded display is on.
53+
test=> SELECT * FROM pgstatindex('pg_cast_oid_index');
54+
-[ RECORD 1 ]------+------
55+
version | 2
56+
tree_level | 0
57+
index_size | 8192
58+
root_block_no | 1
59+
internal_pages | 0
60+
leaf_pages | 1
61+
empty_pages | 0
62+
deleted_pages | 0
63+
avg_leaf_density | 50.27
64+
leaf_fragmentation | 0
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+
37113

38114
2. pgstattuple�Υ��󥹥ȡ���
39115

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp