1. What is pgstattuple?

pgstattuple returns thetable length, percentage of the "dead"

tuples of atable and other info. This may help users to determine

pgstattuple returns therelation length, percentage of the "dead"

tuples of arelation and other info. This may help users to determine

whether vacuum is necessary or not. Here is an example session:

test=# \x

Here are explanations for each column:

table_len-- physicaltable length in bytes

table_len-- physicalrelation length in bytes

tuple_count-- number of live tuples

tuple_len-- total tuples length in bytes

tuple_percent-- live tuples in %

3. Using pgstattuple

pgstattuple may be called as atable function and is

pgstattuple may be called as arelation function and is

defined as follows:

CREATE OR REPLACE FUNCTION pgstattuple(text) RETURNS pgstattuple_type

AS 'MODULE_PATHNAME', 'pgstattuplebyid'

LANGUAGE C STRICT;

The argument is thetable name (optionally it may be qualified)

or the OID of thetable. Note that pgstattuple only returns

The argument is therelation name (optionally it may be qualified)

or the OID of therelation. Note that pgstattuple only returns

one row.

4. Notes

pgstattuple acquires only a read lock on thetable. So concurrent

pgstattuple acquires only a read lock on therelation. So concurrent

update may affect the result.

pgstattuple judges a tuple is "dead" if HeapTupleSatisfiesNow()

returns false.

5. History

2006/06/28

Extended to work against indexes.

$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.6 2006/02/27 16:09:49 petere Exp $

$PostgreSQL: pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp,v 1.7 2006/07/06 02:18:07 momjian Exp $

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

1. pgstattuple�Ȥ�

pgstattuple�ϡ�UPDATE��DELETE�Ǻ��줿�ơ��֥�Υ����ΰ���礭����

�ơ��֥뼫�Τ�ʪ��Ū���礭�����Ф���ѡ�����ơ������ֵѤ��ޤ�����

pgstattuple�ϡ�UPDATE��DELETE�Ǻ��줿��졼�����Υ����ΰ���礭����

��졼������Τ�ʪ��Ū���礭�����Ф���ѡ�����ơ������ֵѤ��ޤ�����

�ޤꡤ�ֵ��ͤ��礭����С�����������ߤ�¿���Τǡ�vacuum�򤫤���ɬ

�פ�����Ȥ���Ƚ�Ǥν����ˤʤ�櫓�Ǥ�������ʳ��ˤ⤤�������ʾ���

���֤�ޤ���

�ƹ��ܤ������Ǥ���

table_len-- �ơ��֥��ʪ��Ū���礭��(�Х���)

table_len-- ��졼������ʪ��Ū���礭��(�Х���)

tuple_count-- ���ץ��

tuple_len-- ���ץ�Ĺ�ι��(�Х���)

tuple_percent-- ���ץ�γ�硥table_len���Ф���tuple_len����Ψ��

AS 'MODULE_PATHNAME', 'pgstattuple'

LANGUAGE C STRICT;

������: �ơ��֥�̾

������: ��졼�����̾

�ؿ�������pgstattuple_type���Ǥ���

pgstattuple�ϥơ��֥��AccessShareLock���������ʤ��Τǡ�

pgstattuple ��¹���˳����ơ��֥�˹���������ȯ������ȡ�������

pgstattuple�ϥ�졼������AccessShareLock���������ʤ��Τǡ�

pgstattuple ��¹���˳�����졼�����˹���������ȯ������ȡ�������

�ʤ���̤��֤���ǽ��������ޤ���

pgstattuple�����ץ��֥��ߡפ�Ƚ�Ǥ�����ϡ�

5. ��������

2006/06/28

����ǥå������Ф��Ƥ�ư���褦�˳�ĥ��

2002/09/04

SRF�ѹ���ȼ����Tom Lane���������󥿡��ե������ν�����Ԥä���