contrib/pageinspect/pageinspect.sql.in

   1 /* $PostgreSQL$ */
   2
   3 -- Adjust this setting to control where the objects get created.
   4 SET search_path = public;
   5
   6 --
   7 -- get_raw_page()
   8 --
   9 CREATE OR REPLACE FUNCTION get_raw_page(text, text, int4)
  10 RETURNS bytea
  11 AS 'MODULE_PATHNAME', 'get_raw_page'
  12 LANGUAGE C STRICT;
  13
  14 CREATE OR REPLACE FUNCTION get_raw_page(text, int4)
  15 RETURNS bytea
  16 AS $$ SELECT get_raw_page($1, 'main', $2); $$
  17 LANGUAGE SQL STRICT;
  18
  19 --
  20 -- page_header()
  21 --
  22 CREATE OR REPLACE FUNCTION page_header(IN page bytea,
  23     OUT lsn text,
  24     OUT tli smallint,
  25     OUT flags smallint,
  26     OUT lower smallint,
  27     OUT upper smallint,
  28     OUT special smallint,
  29     OUT pagesize smallint,
  30     OUT version smallint,
  31     OUT prune_xid xid)
  32 AS 'MODULE_PATHNAME', 'page_header'
  33 LANGUAGE C STRICT;
  34
  35 --
  36 -- heap_page_items()
  37 --
  38 CREATE OR REPLACE FUNCTION heap_page_items(IN page bytea,
  39     OUT lp smallint,
  40     OUT lp_off smallint,
  41     OUT lp_flags smallint,
  42     OUT lp_len smallint,
  43     OUT t_xmin xid,
  44     OUT t_xmax xid,
  45     OUT t_field3 int4,
  46     OUT t_ctid tid,
  47     OUT t_infomask2 smallint,
  48     OUT t_infomask smallint,
  49     OUT t_hoff smallint,
  50     OUT t_bits text,
  51     OUT t_oid oid)
  52 RETURNS SETOF record
  53 AS 'MODULE_PATHNAME', 'heap_page_items'
  54 LANGUAGE C STRICT;
  55
  56 --
  57 -- bt_metap()
  58 --
  59 CREATE OR REPLACE FUNCTION bt_metap(IN relname text,
  60     OUT magic int4,
  61     OUT version int4,
  62     OUT root int4,
  63     OUT level int4,
  64     OUT fastroot int4,
  65     OUT fastlevel int4)
  66 AS 'MODULE_PATHNAME', 'bt_metap'
  67 LANGUAGE C STRICT;
  68
  69 --
  70 -- bt_page_stats()
  71 --
  72 CREATE OR REPLACE FUNCTION bt_page_stats(IN relname text, IN blkno int4,
  73     OUT blkno int4,
  74     OUT type "char",
  75     OUT live_items int4,
  76     OUT dead_items int4,
  77     OUT avg_item_size int4,
  78     OUT page_size int4,
  79     OUT free_size int4,
  80     OUT btpo_prev int4,
  81     OUT btpo_next int4,
  82     OUT btpo int4,
  83     OUT btpo_flags int4)
  84 AS 'MODULE_PATHNAME', 'bt_page_stats'
  85 LANGUAGE C STRICT;
  86
  87 --
  88 -- bt_page_items()
  89 --
  90 CREATE OR REPLACE FUNCTION bt_page_items(IN relname text, IN blkno int4,
  91     OUT itemoffset smallint,
  92     OUT ctid tid,
  93     OUT itemlen smallint,
  94     OUT nulls bool,
  95     OUT vars bool,
  96     OUT data text)
  97 RETURNS SETOF record
  98 AS 'MODULE_PATHNAME', 'bt_page_items'
  99 LANGUAGE C STRICT;
 100
 101 --
 102 -- fsm_page_contents()
 103 --
 104 CREATE OR REPLACE FUNCTION fsm_page_contents(IN page bytea)
 105 RETURNS text
 106 AS 'MODULE_PATHNAME', 'fsm_page_contents'
 107 LANGUAGE C STRICT;