Add functions to 'pageinspect' to inspect GiST indexes.

Author: Andrey Borodin and me
Discussion: https://www.postgresql.org/message-id/3E4F9093-A1B5-4DF8-A292-0B48692E3954%40yandex-team.ru

1 files changed, 87 insertions, 0 deletions

diff --git a/contrib/pageinspect/expected/gist.out b/contrib/pageinspect/expected/gist.out
new file mode 100644
index 00000000000..89294b5a17d
--- /dev/null
+++ b/contrib/pageinspect/expected/gist.out
@@ -0,0 +1,87 @@
+CREATE TABLE test_gist AS SELECT point(i,i) p, i::text t FROM
+    generate_series(1,1000) i;
+CREATE INDEX test_gist_idx ON test_gist USING gist (p);
+-- Page 0 is the root, the rest are leaf pages
+SELECT * FROM gist_page_opaque_info(get_raw_page('test_gist_idx', 0));
+ lsn | nsn | rightlink  | flags 
+-----+-----+------------+-------
+ 0/1 | 0/0 | 4294967295 | {}
+(1 row)
+
+SELECT * FROM gist_page_opaque_info(get_raw_page('test_gist_idx', 1));
+ lsn | nsn | rightlink  | flags  
+-----+-----+------------+--------
+ 0/1 | 0/0 | 4294967295 | {leaf}
+(1 row)
+
+SELECT * FROM gist_page_opaque_info(get_raw_page('test_gist_idx', 2));
+ lsn | nsn | rightlink | flags  
+-----+-----+-----------+--------
+ 0/1 | 0/0 |         1 | {leaf}
+(1 row)
+
+SELECT * FROM gist_page_items(get_raw_page('test_gist_idx', 0), 'test_gist_idx');
+ itemoffset |   ctid    | itemlen |       keys        
+------------+-----------+---------+-------------------
+          1 | (1,65535) |      40 | (p)=((166,166))
+          2 | (2,65535) |      40 | (p)=((332,332))
+          3 | (3,65535) |      40 | (p)=((498,498))
+          4 | (4,65535) |      40 | (p)=((664,664))
+          5 | (5,65535) |      40 | (p)=((830,830))
+          6 | (6,65535) |      40 | (p)=((996,996))
+          7 | (7,65535) |      40 | (p)=((1000,1000))
+(7 rows)
+
+SELECT * FROM gist_page_items(get_raw_page('test_gist_idx', 1), 'test_gist_idx') LIMIT 5;
+ itemoffset | ctid  | itemlen |    keys     
+------------+-------+---------+-------------
+          1 | (0,1) |      40 | (p)=((1,1))
+          2 | (0,2) |      40 | (p)=((2,2))
+          3 | (0,3) |      40 | (p)=((3,3))
+          4 | (0,4) |      40 | (p)=((4,4))
+          5 | (0,5) |      40 | (p)=((5,5))
+(5 rows)
+
+SELECT * FROM gist_page_items(get_raw_page('test_gist_idx', 2), 'test_gist_idx') LIMIT 5;
+ itemoffset |  ctid  | itemlen |      keys       
+------------+--------+---------+-----------------
+          1 | (1,10) |      40 | (p)=((167,167))
+          2 | (1,11) |      40 | (p)=((168,168))
+          3 | (1,12) |      40 | (p)=((169,169))
+          4 | (1,13) |      40 | (p)=((170,170))
+          5 | (1,14) |      40 | (p)=((171,171))
+(5 rows)
+
+SELECT * FROM gist_page_items_bytea(get_raw_page('test_gist_idx', 0));
+ itemoffset |   ctid    | itemlen |                                      key_data                                      
+------------+-----------+---------+------------------------------------------------------------------------------------
+          1 | (1,65535) |      40 | \x00000100ffff28000000000000c064400000000000c06440000000000000f03f000000000000f03f
+          2 | (2,65535) |      40 | \x00000200ffff28000000000000c074400000000000c074400000000000e064400000000000e06440
+          3 | (3,65535) |      40 | \x00000300ffff28000000000000207f400000000000207f400000000000d074400000000000d07440
+          4 | (4,65535) |      40 | \x00000400ffff28000000000000c084400000000000c084400000000000307f400000000000307f40
+          5 | (5,65535) |      40 | \x00000500ffff28000000000000f089400000000000f089400000000000c884400000000000c88440
+          6 | (6,65535) |      40 | \x00000600ffff28000000000000208f400000000000208f400000000000f889400000000000f88940
+          7 | (7,65535) |      40 | \x00000700ffff28000000000000408f400000000000408f400000000000288f400000000000288f40
+(7 rows)
+
+SELECT * FROM gist_page_items_bytea(get_raw_page('test_gist_idx', 1)) LIMIT 5;
+ itemoffset | ctid  | itemlen |                                      key_data                                      
+------------+-------+---------+------------------------------------------------------------------------------------
+          1 | (0,1) |      40 | \x0000000001002800000000000000f03f000000000000f03f000000000000f03f000000000000f03f
+          2 | (0,2) |      40 | \x00000000020028000000000000000040000000000000004000000000000000400000000000000040
+          3 | (0,3) |      40 | \x00000000030028000000000000000840000000000000084000000000000008400000000000000840
+          4 | (0,4) |      40 | \x00000000040028000000000000001040000000000000104000000000000010400000000000001040
+          5 | (0,5) |      40 | \x00000000050028000000000000001440000000000000144000000000000014400000000000001440
+(5 rows)
+
+SELECT * FROM gist_page_items_bytea(get_raw_page('test_gist_idx', 2)) LIMIT 5;
+ itemoffset |  ctid  | itemlen |                                      key_data                                      
+------------+--------+---------+------------------------------------------------------------------------------------
+          1 | (1,10) |      40 | \x000001000a0028000000000000e064400000000000e064400000000000e064400000000000e06440
+          2 | (1,11) |      40 | \x000001000b0028000000000000006540000000000000654000000000000065400000000000006540
+          3 | (1,12) |      40 | \x000001000c0028000000000000206540000000000020654000000000002065400000000000206540
+          4 | (1,13) |      40 | \x000001000d0028000000000000406540000000000040654000000000004065400000000000406540
+          5 | (1,14) |      40 | \x000001000e0028000000000000606540000000000060654000000000006065400000000000606540
+(5 rows)
+
+DROP TABLE test_gist;