codekingpro/portable-devtools

1/* contrib/pageinspect/pageinspect--1.11--1.12.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION pageinspect UPDATE TO '1.12'" to load this file. \quit5 6--7-- bt_multi_page_stats()8--9CREATE FUNCTION bt_multi_page_stats(IN relname text, IN blkno int8, IN blk_count int8,10    OUT blkno int8,11    OUT type "char",12    OUT live_items int4,13    OUT dead_items int4,14    OUT avg_item_size int4,15    OUT page_size int4,16    OUT free_size int4,17    OUT btpo_prev int8,18    OUT btpo_next int8,19    OUT btpo_level int8,20    OUT btpo_flags int4)21RETURNS SETOF record22AS 'MODULE_PATHNAME', 'bt_multi_page_stats'23LANGUAGE C STRICT PARALLEL RESTRICTED;24 25--26-- add information about BRIN empty ranges27--28DROP FUNCTION brin_page_items(IN page bytea, IN index_oid regclass);29CREATE FUNCTION brin_page_items(IN page bytea, IN index_oid regclass,30    OUT itemoffset int,31    OUT blknum int8,32    OUT attnum int,33    OUT allnulls bool,34    OUT hasnulls bool,35    OUT placeholder bool,36    OUT empty bool,37    OUT value text)38RETURNS SETOF record39AS 'MODULE_PATHNAME', 'brin_page_items'40LANGUAGE C STRICT PARALLEL RESTRICTED;41