From 428c0cae929b7d2b26a830fbba55619c57ceba55 Mon Sep 17 00:00:00 2001 From: Tomas Vondra Date: Fri, 19 May 2023 01:53:30 +0200 Subject: Show empty BRIN ranges in brin_page_items Commit 3581cbdcd6 added a flag to identify empty BRIN ranges. This adds the new flag to brin_page_items() output. This is kept as a separate commit as it should not be backpatched. Reviewed-by: Justin Pryzby, Matthias van de Meent, Alvaro Herrera Discussion: https://postgr.es/m/402430e4-7d9d-6cf1-09ef-464d80afff3b@enterprisedb.com --- doc/src/sgml/pageinspect.sgml | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/pageinspect.sgml b/doc/src/sgml/pageinspect.sgml index 01f1e96204b..e4225ecd485 100644 --- a/doc/src/sgml/pageinspect.sgml +++ b/doc/src/sgml/pageinspect.sgml @@ -613,14 +613,14 @@ test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx', 2)) LIMIT 5; test=# SELECT * FROM brin_page_items(get_raw_page('brinidx', 5), 'brinidx') ORDER BY blknum, attnum LIMIT 6; - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value -------------+--------+--------+----------+----------+-------------+-------------- - 137 | 0 | 1 | t | f | f | - 137 | 0 | 2 | f | f | f | {1 .. 88} - 138 | 4 | 1 | t | f | f | - 138 | 4 | 2 | f | f | f | {89 .. 176} - 139 | 8 | 1 | t | f | f | - 139 | 8 | 2 | f | f | f | {177 .. 264} + itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value +------------+--------+--------+----------+----------+-------------+-------+-------------- + 137 | 0 | 1 | t | f | f | f | + 137 | 0 | 2 | f | f | f | f | {1 .. 88} + 138 | 4 | 1 | t | f | f | f | + 138 | 4 | 2 | f | f | f | f | {89 .. 176} + 139 | 8 | 1 | t | f | f | f | + 139 | 8 | 2 | f | f | f | f | {177 .. 264} The returned columns correspond to the fields in the BrinMemTuple and BrinValues structs. -- cgit v1.2.3