From b5e3942f50cc8fb57d36581ceabcba035212eb7d Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 1 Nov 2016 12:00:00 -0400 Subject: [PATCH] Add subsection headers in pageinspect documentation extracted from a patch from Jesper Pedersen --- doc/src/sgml/pageinspect.sgml | 68 ++++++++++++++++++++++------------- 1 file changed, 43 insertions(+), 25 deletions(-) diff --git a/doc/src/sgml/pageinspect.sgml b/doc/src/sgml/pageinspect.sgml index 5c816c0226..d12dbac32d 100644 --- a/doc/src/sgml/pageinspect.sgml +++ b/doc/src/sgml/pageinspect.sgml @@ -14,7 +14,7 @@ - Functions + General Functions @@ -160,7 +160,36 @@ test=# SELECT * FROM heap_page_item_attrs(get_raw_page('pg_class', 0), 'pg_class - + + + + fsm_page_contents(page bytea) returns text + + fsm_page_contents + + + + + + fsm_page_contents shows the internal node structure + of a FSM page. The output is a multiline string, with one line per + node in the binary tree within the page. Only those nodes that are not + zero are printed. The so-called "next" pointer, which points to the + next slot to be returned from the page, is also printed. + + + See src/backend/storage/freespace/README for more + information on the structure of an FSM page. + + + + + + + + B-tree Functions + + bt_metap(relname text) returns record @@ -261,7 +290,13 @@ test=# SELECT * FROM bt_page_items('pg_cast_oid_index', 1); + + + + BRIN Functions + + brin_page_type(page bytea) returns text @@ -365,7 +400,13 @@ test=# SELECT * FROM brin_page_items(get_raw_page('brinidx', 5), + + + + + GIN Functions + gin_metapage_info(page bytea) returns record @@ -449,29 +490,6 @@ test=# SELECT first_tid, nbytes, tids[0:5] AS some_tids - - - - fsm_page_contents(page bytea) returns text - - fsm_page_contents - - - - - - fsm_page_contents shows the internal node structure - of a FSM page. The output is a multiline string, with one line per - node in the binary tree within the page. Only those nodes that are not - zero are printed. The so-called "next" pointer, which points to the - next slot to be returned from the page, is also printed. - - - See src/backend/storage/freespace/README for more - information on the structure of an FSM page. - - - -- 2.40.0