---

pageinspect--1.5.sql

/* contrib/pageinspect/pageinspect--1.5.sql */ -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION pageinspect" to load this file. \quit -- -- get_raw_page() -- CREATE FUNCTION get_raw_page(text, int4) RETURNS bytea AS 'MODULE_PATHNAME', 'get_raw_page' LANGUAGE C STRICT PARALLEL SAFE; CREATE FUNCTION get_raw_page(text, text, int4) RETURNS bytea AS 'MODULE_PATHNAME', 'get_raw_page_fork' LANGUAGE C STRICT PARALLEL SAFE; -- -- page_header() -- CREATE FUNCTION page_header(IN page bytea, OUT lsn pg_lsn, OUT checksum smallint, OUT flags smallint, OUT lower smallint, OUT upper smallint, OUT special smallint, OUT pagesize smallint, OUT version smallint, OUT prune_xid xid) AS 'MODULE_PATHNAME', 'page_header' LANGUAGE C STRICT PARALLEL SAFE; -- -- heap_page_items() -- CREATE FUNCTION heap_page_items(IN page bytea, OUT lp smallint, OUT lp_off smallint, OUT lp_flags smallint, OUT lp_len smallint, OUT t_xmin xid, OUT t_xmax xid, OUT t_field3 int4, OUT t_ctid tid, OUT t_infomask2 integer, OUT t_infomask integer, OUT t_hoff smallint, OUT t_bits text, OUT t_oid oid, OUT t_data bytea) RETURNS SETOF record AS 'MODULE_PATHNAME', 'heap_page_items' LANGUAGE C STRICT PARALLEL SAFE; -- -- tuple_data_split() -- CREATE FUNCTION tuple_data_split(rel_oid oid, t_data bytea, t_infomask integer, t_infomask2 integer, t_bits text) RETURNS bytea[] AS 'MODULE_PATHNAME','tuple_data_split' LANGUAGE C PARALLEL SAFE; CREATE FUNCTION tuple_data_split(rel_oid oid, t_data bytea, t_infomask integer, t_infomask2 integer, t_bits text, do_detoast bool) RETURNS bytea[] AS 'MODULE_PATHNAME','tuple_data_split' LANGUAGE C PARALLEL SAFE; -- -- heap_page_item_attrs() -- CREATE FUNCTION heap_page_item_attrs( IN page bytea, IN rel_oid regclass, IN do_detoast bool, OUT lp smallint, OUT lp_off smallint, OUT lp_flags smallint, OUT lp_len smallint, OUT t_xmin xid, OUT t_xmax xid, OUT t_field3 int4, OUT t_ctid tid, OUT t_infomask2 integer, OUT t_infomask integer, OUT t_hoff smallint, OUT t_bits text, OUT t_oid oid, OUT t_attrs bytea[] ) RETURNS SETOF record AS $$ SELECT lp, lp_off, lp_flags, lp_len, t_xmin, t_xmax, t_field3, t_ctid, t_infomask2, t_infomask, t_hoff, t_bits, t_oid, tuple_data_split( rel_oid, t_data, t_infomask, t_infomask2, t_bits, do_detoast) AS t_attrs FROM heap_page_items(page); $$ LANGUAGE SQL PARALLEL SAFE; CREATE FUNCTION heap_page_item_attrs(IN page bytea, IN rel_oid regclass, OUT lp smallint, OUT lp_off smallint, OUT lp_flags smallint, OUT lp_len smallint, OUT t_xmin xid, OUT t_xmax xid, OUT t_field3 int4, OUT t_ctid tid, OUT t_infomask2 integer, OUT t_infomask integer, OUT t_hoff smallint, OUT t_bits text, OUT t_oid oid, OUT t_attrs bytea[] ) RETURNS SETOF record AS $$ SELECT * from heap_page_item_attrs(page, rel_oid, false); $$ LANGUAGE SQL PARALLEL SAFE; -- -- bt_metap() -- CREATE FUNCTION bt_metap(IN relname text, OUT magic int4, OUT version int4, OUT root int4, OUT level int4, OUT fastroot int4, OUT fastlevel int4) AS 'MODULE_PATHNAME', 'bt_metap' LANGUAGE C STRICT PARALLEL SAFE; -- -- bt_page_stats() -- CREATE FUNCTION bt_page_stats(IN relname text, IN blkno int4, OUT blkno int4, OUT type "char", OUT live_items int4, OUT dead_items int4, OUT avg_item_size int4, OUT page_size int4, OUT free_size int4, OUT btpo_prev int4, OUT btpo_next int4, OUT btpo int4, OUT btpo_flags int4) AS 'MODULE_PATHNAME', 'bt_page_stats' LANGUAGE C STRICT PARALLEL SAFE; -- -- bt_page_items() -- CREATE FUNCTION bt_page_items(IN relname text, IN blkno int4, OUT itemoffset smallint, OUT ctid tid, OUT itemlen smallint, OUT nulls bool, OUT vars bool, OUT data text) RETURNS SETOF record AS 'MODULE_PATHNAME', 'bt_page_items' LANGUAGE C STRICT PARALLEL SAFE; -- -- brin_page_type() -- CREATE FUNCTION brin_page_type(IN page bytea) RETURNS text AS 'MODULE_PATHNAME', 'brin_page_type' LANGUAGE C STRICT PARALLEL SAFE; -- -- brin_metapage_info() -- CREATE FUNCTION brin_metapage_info(IN page bytea, OUT magic text, OUT version integer, OUT pagesperrange integer, OUT lastrevmappage bigint) AS 'MODULE_PATHNAME', 'brin_metapage_info' LANGUAGE C STRICT PARALLEL SAFE; -- -- brin_revmap_data() -- CREATE FUNCTION brin_revmap_data(IN page bytea, OUT pages tid) RETURNS SETOF tid AS 'MODULE_PATHNAME', 'brin_revmap_data' LANGUAGE C STRICT PARALLEL SAFE; -- -- brin_page_items() -- CREATE FUNCTION brin_page_items(IN page bytea, IN index_oid regclass, OUT itemoffset int, OUT blknum int, OUT attnum int, OUT allnulls bool, OUT hasnulls bool, OUT placeholder bool, OUT value text) RETURNS SETOF record AS 'MODULE_PATHNAME', 'brin_page_items' LANGUAGE C STRICT PARALLEL SAFE; -- -- fsm_page_contents() -- CREATE FUNCTION fsm_page_contents(IN page bytea) RETURNS text AS 'MODULE_PATHNAME', 'fsm_page_contents' LANGUAGE C STRICT PARALLEL SAFE; -- -- GIN functions -- -- -- gin_metapage_info() -- CREATE FUNCTION gin_metapage_info(IN page bytea, OUT pending_head bigint, OUT pending_tail bigint, OUT tail_free_size int4, OUT n_pending_pages bigint, OUT n_pending_tuples bigint, OUT n_total_pages bigint, OUT n_entry_pages bigint, OUT n_data_pages bigint, OUT n_entries bigint, OUT version int4) AS 'MODULE_PATHNAME', 'gin_metapage_info' LANGUAGE C STRICT PARALLEL SAFE; -- -- gin_page_opaque_info() -- CREATE FUNCTION gin_page_opaque_info(IN page bytea, OUT rightlink bigint, OUT maxoff int4, OUT flags text[]) AS 'MODULE_PATHNAME', 'gin_page_opaque_info' LANGUAGE C STRICT PARALLEL SAFE; -- -- gin_leafpage_items() -- CREATE FUNCTION gin_leafpage_items(IN page bytea, OUT first_tid tid, OUT nbytes int2, OUT tids tid[]) RETURNS SETOF record AS 'MODULE_PATHNAME', 'gin_leafpage_items' LANGUAGE C STRICT PARALLEL SAFE;

---

docroot: /var/www/469ed2f6-4d4b-4a8a-9f5e-ee4ef04d3bc8/public_html

---

curdir: /usr/share/postgresql/16/extension

	.		36864
	..		4096
X	adminpack--1.0--1.1.sql		274
X	adminpack--1.0.sql		1535
X	adminpack--1.1--2.0.sql		1682
X	adminpack--2.0--2.1.sql		595
X	adminpack.control		176
X	amcheck--1.0--1.1.sql		931
X	amcheck--1.0.sql		704
X	amcheck--1.1--1.2.sql		705
X	amcheck--1.2--1.3.sql		852
X	amcheck.control		154
X	autoinc--1.0.sql		249
X	autoinc.control		149
X	bloom--1.0.sql		666
X	bloom.control		156
X	btree_gin--1.0--1.1.sql		1372
X	btree_gin--1.0.sql		24818
X	btree_gin--1.1--1.2.sql		1445
X	btree_gin--1.2--1.3.sql		4571
X	btree_gin.control		175
X	btree_gist--1.0--1.1.sql		3739
X	btree_gist--1.1--1.2.sql		5048
X	btree_gist--1.2--1.3.sql		1955
X	btree_gist--1.2.sql		41115
X	btree_gist--1.3--1.4.sql		1932
X	btree_gist--1.4--1.5.sql		1872
X	btree_gist--1.5--1.6.sql		13417
X	btree_gist--1.6--1.7.sql		2170
X	btree_gist.control		178
X	citext--1.0--1.1.sql		1028
X	citext--1.1--1.2.sql		3424
X	citext--1.2--1.3.sql		850
X	citext--1.3--1.4.sql		668
X	citext--1.4--1.5.sql		2284
X	citext--1.4.sql		13466
X	citext--1.5--1.6.sql		427
X	citext.control		173
X	cube--1.0--1.1.sql		1594
X	cube--1.1--1.2.sql		3815
X	cube--1.2--1.3.sql		365
X	cube--1.2.sql		9761
X	cube--1.3--1.4.sql		2387
X	cube--1.4--1.5.sql		591
X	cube.control		157
X	dblink--1.0--1.1.sql		419
X	dblink--1.1--1.2.sql		2832
X	dblink--1.2.sql		6645
X	dblink.control		170
X	dict_int--1.0.sql		711
X	dict_int.control		173
X	dict_xsyn--1.0.sql		694
X	dict_xsyn.control		179
X	earthdistance--1.0--1.1.sql		671
X	earthdistance--1.1--1.2.sql		2194
X	earthdistance--1.1.sql		3319
X	earthdistance.control		202
X	file_fdw--1.0.sql		475
X	file_fdw.control		155
X	fuzzystrmatch--1.0--1.1.sql		788
X	fuzzystrmatch--1.1--1.2.sql		351
X	fuzzystrmatch--1.1.sql		1576
X	fuzzystrmatch.control		190
X	hstore--1.1--1.2.sql		1639
X	hstore--1.2--1.3.sql		525
X	hstore--1.3--1.4.sql		5310
X	hstore--1.4--1.5.sql		409
X	hstore--1.4.sql		13765
X	hstore--1.5--1.6.sql		455
X	hstore--1.6--1.7.sql		1061
X	hstore--1.7--1.8.sql		508
X	hstore.control		173
X	insert_username--1.0.sql		273
X	insert_username.control		170
X	intagg--1.0--1.1.sql		897
X	intagg--1.1.sql		1089
X	intagg.control		119
X	intarray--1.0--1.1.sql		1794
X	intarray--1.1--1.2.sql		5525
X	intarray--1.2--1.3.sql		663
X	intarray--1.2.sql		12293
X	intarray--1.3--1.4.sql		692
X	intarray--1.4--1.5.sql		282
X	intarray.control		191
X	isn--1.0--1.1.sql		12333
X	isn--1.1--1.2.sql		5264
X	isn--1.1.sql		69885
X	isn.control		175
X	lo--1.0--1.1.sql		223
X	lo--1.1.sql		722
X	lo.control		141
X	ltree--1.0--1.1.sql		6336
X	ltree--1.1--1.2.sql		5217
X	ltree--1.1.sql		19375
X	ltree.control		170
X	moddatetime--1.0.sql		261
X	moddatetime.control		165
X	old_snapshot--1.0.sql		549
X	old_snapshot.control		168
X	pageinspect--1.0--1.1.sql		560
X	pageinspect--1.1--1.2.sql		562
X	pageinspect--1.10--1.11.sql		1570
X	pageinspect--1.11--1.12.sql		1165
X	pageinspect--1.2--1.3.sql		1946
X	pageinspect--1.3--1.4.sql		2566
X	pageinspect--1.4--1.5.sql		1347
X	pageinspect--1.5--1.6.sql		2252
X	pageinspect--1.5.sql		6262
X	pageinspect--1.6--1.7.sql		698
X	pageinspect--1.7--1.8.sql		1711
X	pageinspect--1.8--1.9.sql		3398
X	pageinspect--1.9--1.10.sql		589
X	pageinspect.control		174
X	pg_buffercache--1.0--1.1.sql		508
X	pg_buffercache--1.1--1.2.sql		271
X	pg_buffercache--1.2--1.3.sql		328
X	pg_buffercache--1.2.sql		794
X	pg_buffercache--1.3--1.4.sql		1021
X	pg_buffercache.control		157
X	pg_freespacemap--1.0--1.1.sql		335
X	pg_freespacemap--1.1--1.2.sql		377
X	pg_freespacemap--1.1.sql		899
X	pg_freespacemap.control		160
X	pg_prewarm--1.0--1.1.sql		281
X	pg_prewarm--1.1--1.2.sql		458
X	pg_prewarm--1.1.sql		475
X	pg_prewarm.control		139
X	pg_stat_statements--1.0--1.1.sql		1246
X	pg_stat_statements--1.1--1.2.sql		1336
X	pg_stat_statements--1.2--1.3.sql		1454
X	pg_stat_statements--1.3--1.4.sql		345
X	pg_stat_statements--1.4--1.5.sql		305
X	pg_stat_statements--1.4.sql		1427
X	pg_stat_statements--1.5--1.6.sql		376
X	pg_stat_statements--1.6--1.7.sql		806
X	pg_stat_statements--1.7--1.8.sql		1744
X	pg_stat_statements--1.8--1.9.sql		2128
X	pg_stat_statements--1.9--1.10.sql		2114
X	pg_stat_statements.control		205
X	pg_surgery--1.0.sql		608
X	pg_surgery.control		168
X	pg_trgm--1.0--1.1.sql		536
X	pg_trgm--1.1--1.2.sql		2192
X	pg_trgm--1.2--1.3.sql		3498
X	pg_trgm--1.3--1.4.sql		2045
X	pg_trgm--1.3.sql		7942
X	pg_trgm--1.4--1.5.sql		858
X	pg_trgm--1.5--1.6.sql		418
X	pg_trgm.control		192
X	pg_visibility--1.0--1.1.sql		883
X	pg_visibility--1.1--1.2.sql		833
X	pg_visibility--1.1.sql		2825
X	pg_visibility.control		186
X	pg_walinspect--1.0--1.1.sql		1296
X	pg_walinspect--1.0.sql		3665
X	pg_walinspect.control		183
X	pgcrypto--1.0--1.1.sql		307
X	pgcrypto--1.1--1.2.sql		483
X	pgcrypto--1.2--1.3.sql		2346
X	pgcrypto--1.3.sql		5708
X	pgcrypto.control		152
X	pgrowlocks--1.0--1.1.sql		651
X	pgrowlocks--1.1--1.2.sql		253
X	pgrowlocks--1.2.sql		555
X	pgrowlocks.control		152
X	pgstattuple--1.0--1.1.sql		400
X	pgstattuple--1.1--1.2.sql		1435
X	pgstattuple--1.2--1.3.sql		1126
X	pgstattuple--1.3--1.4.sql		623
X	pgstattuple--1.4--1.5.sql		5506
X	pgstattuple--1.4.sql		3764
X	pgstattuple.control		147
X	plpgsql--1.0.sql		658
X	plpgsql.control		193
X	postgres_fdw--1.0--1.1.sql		626
X	postgres_fdw--1.0.sql		507
X	postgres_fdw.control		172
X	refint--1.0.sql		343
X	refint.control		169
X	seg--1.0--1.1.sql		3005
X	seg--1.1--1.2.sql		360
X	seg--1.1.sql		8142
X	seg--1.2--1.3.sql		2344
X	seg--1.3--1.4.sql		259
X	seg.control		187
X	sslinfo--1.0--1.1.sql		375
X	sslinfo--1.1--1.2.sql		746
X	sslinfo--1.2.sql		1534
X	sslinfo.control		146
X	tablefunc--1.0.sql		2153
X	tablefunc.control		189
X	tcn--1.0.sql		274
X	tcn.control		149
X	tsm_system_rows--1.0.sql		327
X	tsm_system_rows.control		201
X	tsm_system_time--1.0.sql		327
X	tsm_system_time.control		207
X	unaccent--1.0--1.1.sql		445
X	unaccent--1.1.sql		910
X	unaccent.control		172
X	uuid-ossp--1.0--1.1.sql		688
X	uuid-ossp--1.1.sql		1516
X	uuid-ossp.control		178
X	xml2--1.0--1.1.sql		944
X	xml2--1.1.sql		2049
X	xml2.control		182