(0,0,0,0,0,0,0,0,0)

(1 row)

select * from pgstatindex('test_pkey');

select version, tree_level,

index_size / current_setting('block_size')::int as index_size,

root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages,

avg_leaf_density, leaf_fragmentation

from pgstatindex('test_pkey');

version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation

---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+--------------------

2 | 0 |0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN

2 | 0 |1 | 0 | 0 | 0 | 0 | 0 | NaN | NaN

(1 row)

select * from pgstatindex('test_pkey'::text);

select version, tree_level,

index_size / current_setting('block_size')::int as index_size,

root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages,

avg_leaf_density, leaf_fragmentation

from pgstatindex('test_pkey'::text);

version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation

---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+--------------------

2 | 0 |0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN

2 | 0 |1 | 0 | 0 | 0 | 0 | 0 | NaN | NaN

(1 row)

select * from pgstatindex('test_pkey'::name);

select version, tree_level,

index_size / current_setting('block_size')::int as index_size,

root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages,

avg_leaf_density, leaf_fragmentation

from pgstatindex('test_pkey'::name);

version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation

---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+--------------------

2 | 0 |0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN

2 | 0 |1 | 0 | 0 | 0 | 0 | 0 | NaN | NaN

(1 row)

select * from pgstatindex('test_pkey'::regclass);

select version, tree_level,

index_size / current_setting('block_size')::int as index_size,

root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages,

avg_leaf_density, leaf_fragmentation

from pgstatindex('test_pkey'::regclass);

version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation

---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+--------------------

2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | NaN

(1 row)

select pgstatindex(oid) from pg_class where relname = 'test_pkey';

pgstatindex

---------------------------

(2,0,0,0,0,0,0,0,NaN,NaN)

(1 row)

select pgstatindex(relname) from pg_class where relname = 'test_pkey';

pgstatindex

---------------------------

(2,0,0,0,0,0,0,0,NaN,NaN)

2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | NaN | NaN

(1 row)

select pg_relpages('test');

uint32level;

BlockNumberroot_blkno;

uint64root_pages;

uint64internal_pages;

uint64leaf_pages;

uint64empty_pages;

}

indexStat.root_pages=0;

indexStat.internal_pages=0;

indexStat.leaf_pages=0;

indexStat.empty_pages=0;

if (P_ISLEAF(opaque))

if (P_ISDELETED(opaque))

indexStat.deleted_pages++;

elseif (P_IGNORE(opaque))

indexStat.empty_pages++;/* this is the "half dead" state */

elseif (P_ISLEAF(opaque))

{

intmax_avail;

if (opaque->btpo_next!=P_NONE&&opaque->btpo_next<blkno)

indexStat.fragments++;

}

elseif (P_ISDELETED(opaque))

indexStat.deleted_pages++;

elseif (P_IGNORE(opaque))

indexStat.empty_pages++;

elseif (P_ISROOT(opaque))

indexStat.root_pages++;

indexStat.internal_pages++;

values[j++]=psprintf("%d",indexStat.version);

values[j++]=psprintf("%d",indexStat.level);

values[j++]=psprintf(INT64_FORMAT,

(indexStat.root_pages+

(1+/* include the metapage in index_size */

indexStat.leaf_pages+

indexStat.internal_pages+

indexStat.deleted_pages+

select pgstattuple(oid)from pg_classwhere relname='test';

select pgstattuple(relname)from pg_classwhere relname='test';

select*from pgstatindex('test_pkey');

select*from pgstatindex('test_pkey'::text);

select*from pgstatindex('test_pkey'::name);

select*from pgstatindex('test_pkey'::regclass);

select pgstatindex(oid)from pg_classwhere relname='test_pkey';

select pgstatindex(relname)from pg_classwhere relname='test_pkey';

select version, tree_level,

index_size/ current_setting('block_size')::intas index_size,

root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages,

avg_leaf_density, leaf_fragmentation

from pgstatindex('test_pkey');

select version, tree_level,

index_size/ current_setting('block_size')::intas index_size,

root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages,

avg_leaf_density, leaf_fragmentation

from pgstatindex('test_pkey'::text);

select version, tree_level,

index_size/ current_setting('block_size')::intas index_size,

root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages,

avg_leaf_density, leaf_fragmentation

from pgstatindex('test_pkey'::name);

select version, tree_level,

index_size/ current_setting('block_size')::intas index_size,

root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages,

avg_leaf_density, leaf_fragmentation

from pgstatindex('test_pkey'::regclass);

select pg_relpages('test');

select pg_relpages('test_pkey');

<listitem>

<para>

This is the same as <function>pgstattuple(regclass)</function>, except

that the target relation is specifiedby TEXT. This function is kept

that the target relation is specifiedas TEXT. This function is kept

because of backward-compatibility so far, and will be deprecated in

the future release.

some future release.

</para>

</listitem>

</varlistentry>

-[ RECORD 1 ]------+------

version | 2

tree_level | 0

index_size |8192

index_size |16384

root_block_no | 1

internal_pages | 0

leaf_pages | 1

empty_pages | 0

deleted_pages | 0

avg_leaf_density |50.27

avg_leaf_density |54.27

leaf_fragmentation | 0

</programlisting>

</para>

<row>

<entry><structfield>index_size</structfield></entry>

<entry><type>bigint</type></entry>

<entry>Totalnumber of pagesinindex</entry>

<entry>Totalindex sizeinbytes</entry>

</row>

<row>

<entry><structfield>root_block_no</structfield></entry>

<entry><type>bigint</type></entry>

<entry>Location of rootblock</entry>

<entry>Location of rootpage (zero if none)</entry>

</row>

<row>

</informaltable>

</para>

<para>

The reported <literal>index_size</> will normally correspond to one more

page than is accounted for by <literal>internal_pages + leaf_pages +

empty_pages + deleted_pages</literal>, because it also includes the

index's metapage.

</para>

<para>

As with <function>pgstattuple</>, the results are accumulated

page-by-page, and should not be expected to represent an

<listitem>

<para>

This is the same as <function>pgstatindex(regclass)</function>, except

that the target index is specifiedby TEXT. This function is kept

that the target index is specifiedas TEXT. This function is kept

because of backward-compatibility so far, and will be deprecated in

the future release.

some future release.

</para>

</listitem>

</varlistentry>

<listitem>

<para>

This is the same as <function>pg_relpages(regclass)</function>, except

that the target relation is specifiedby TEXT. This function is kept

that the target relation is specifiedas TEXT. This function is kept

because of backward-compatibility so far, and will be deprecated in

the future release.

some future release.

</para>

</listitem>

</varlistentry>

<para>

<function>pgstattuple_approx</function> is a faster alternative to

<function>pgstattuple</function> that returns approximate results.

The argument is the target relation's OID.

The argument is the target relation'sname orOID.

For example:

<programlisting>

test=> SELECT * FROM pgstattuple_approx('pg_catalog.pg_proc'::regclass);

{

(void)ZeroSUBTRANSPage(startPage);

startPage++;

if (startPage>TransactionIdToPage(MaxTransactionId))

startPage=0;

}

(void)ZeroSUBTRANSPage(startPage);

deletion_script_file_name);

pg_log(PG_REPORT,

"directory. The old cluster's contents must be deleted manually.\n");

"be deleted manually.\n");

}

{

FILE*script=NULL;

inttblnum;

charold_cluster_pgdata[MAXPGPATH];

charold_cluster_pgdata[MAXPGPATH],new_cluster_pgdata[MAXPGPATH];

*deletion_script_file_name=psprintf("%sdelete_old_cluster.%s",

SCRIPT_PREFIX,SCRIPT_EXT);

strlcpy(old_cluster_pgdata,old_cluster.pgdata,MAXPGPATH);

canonicalize_path(old_cluster_pgdata);

strlcpy(new_cluster_pgdata,new_cluster.pgdata,MAXPGPATH);

canonicalize_path(new_cluster_pgdata);

if (path_is_prefix_of_path(old_cluster_pgdata,new_cluster_pgdata))

{

pg_log(PG_WARNING,

"\nWARNING: new data directory should not be inside the old data directory, e.g. %s\n",old_cluster_pgdata);

unlink(*deletion_script_file_name);

pg_free(*deletion_script_file_name);

*deletion_script_file_name=NULL;

return;

}

strlcpy(old_cluster_pgdata,old_cluster.pgdata,MAXPGPATH);

canonicalize_path(old_cluster_pgdata);

for (tblnum=0;tblnum<os_info.num_old_tablespaces;tblnum++)

{

charold_tablespace_dir[MAXPGPATH];