|
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 $ |
2 | 2 |
|
3 | 3 | pgstattuple README2002/08/22 �а�ã��
|
4 | 4 |
|
5 |
| -1.pgstattuple�Ȥ� |
| 5 | +1.���ݡ��Ȥ���Ƥ���ؿ� |
6 | 6 |
|
| 7 | + pgstattuple |
| 8 | + ----------- |
7 | 9 | pgstattuple�ϡ�UPDATE��DELETE�Ǻ��줿��졼�����Υ����ΰ���礭����
|
8 | 10 | ��졼������Τ�ʪ��Ū���礭�����Ф���ѡ�����ơ������ֵѤ��ޤ�����
|
9 | 11 | �ޤꡤ�ֵ��ͤ��礭����С�����������ߤ�¿���Τǡ�vacuum����ɬ
|
10 | 12 | �פ�����Ȥ���Ƚ�Ǥν����ˤʤ�櫓�Ǥ�������ʳ��ˤ⤤�������ʾ���
|
11 | 13 | ���֤�ޤ���
|
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 | + |
37 | 113 |
|
38 | 114 | 2. pgstattuple�Υ��ȡ���
|
39 | 115 |
|
|