diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/pageinspect.sgml | 50 |
1 files changed, 49 insertions, 1 deletions
diff --git a/doc/src/sgml/pageinspect.sgml b/doc/src/sgml/pageinspect.sgml index d4ee34ee0fd..04aca998e7f 100644 --- a/doc/src/sgml/pageinspect.sgml +++ b/doc/src/sgml/pageinspect.sgml @@ -326,7 +326,7 @@ allequalimage | f <listitem> <para> <function>bt_page_stats</function> returns summary information about - single pages of B-tree indexes. For example: + a data page of a B-tree index. For example: <screen> test=# SELECT * FROM bt_page_stats('pg_cast_oid_index', 1); -[ RECORD 1 ]-+----- @@ -348,6 +348,54 @@ btpo_flags | 3 <varlistentry> <term> + <function>bt_multi_page_stats(relname text, blkno bigint, blk_count bigint) returns setof record</function> + <indexterm> + <primary>bt_multi_page_stats</primary> + </indexterm> + </term> + + <listitem> + <para> + <function>bt_multi_page_stats</function> returns the same information + as <function>bt_page_stats</function>, but does so for each page of the + range of pages beginning at <parameter>blkno</parameter> and extending + for <parameter>blk_count</parameter> pages. + If <parameter>blk_count</parameter> is negative, all pages + from <parameter>blkno</parameter> to the end of the index are reported + on. For example: +<screen> +test=# SELECT * FROM bt_multi_page_stats('pg_proc_oid_index', 5, 2); +-[ RECORD 1 ]-+----- +blkno | 5 +type | l +live_items | 367 +dead_items | 0 +avg_item_size | 16 +page_size | 8192 +free_size | 808 +btpo_prev | 4 +btpo_next | 6 +btpo_level | 0 +btpo_flags | 1 +-[ RECORD 2 ]-+----- +blkno | 6 +type | l +live_items | 367 +dead_items | 0 +avg_item_size | 16 +page_size | 8192 +free_size | 808 +btpo_prev | 5 +btpo_next | 7 +btpo_level | 0 +btpo_flags | 1 +</screen> + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term> <function>bt_page_items(relname text, blkno bigint) returns setof record</function> <indexterm> <primary>bt_page_items</primary> |