summaryrefslogtreecommitdiff
path: root/contrib/pgstattuple/pgstattuple.sql.in
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2007-05-17 19:11:25 +0000
committerBruce Momjian <bruce@momjian.us>2007-05-17 19:11:25 +0000
commit64058429c54afb49a679c58e5ff699640bd42502 (patch)
tree6bfe22b07c3f52747c8e5d8a400d3cea274602e9 /contrib/pgstattuple/pgstattuple.sql.in
parent3b0347b36e1f59e5db95e8994948d850bfc90472 (diff)
downloadpostgresql-64058429c54afb49a679c58e5ff699640bd42502.tar.gz
Add database page inspection /contrib module.
Simon and Heikki
Diffstat (limited to 'contrib/pgstattuple/pgstattuple.sql.in')
-rw-r--r--contrib/pgstattuple/pgstattuple.sql.in56
1 files changed, 0 insertions, 56 deletions
diff --git a/contrib/pgstattuple/pgstattuple.sql.in b/contrib/pgstattuple/pgstattuple.sql.in
index 39220f3536..77a5e2d4b2 100644
--- a/contrib/pgstattuple/pgstattuple.sql.in
+++ b/contrib/pgstattuple/pgstattuple.sql.in
@@ -45,62 +45,6 @@ AS 'MODULE_PATHNAME', 'pgstatindex'
LANGUAGE 'C' STRICT;
--
--- bt_metap()
---
-CREATE TYPE bt_metap_type AS (
- magic int4,
- version int4,
- root int4,
- level int4,
- fastroot int4,
- fastlevel int4
-);
-
-CREATE OR REPLACE FUNCTION bt_metap(text)
-RETURNS bt_metap_type
-AS 'MODULE_PATHNAME', 'bt_metap'
-LANGUAGE 'C' STRICT;
-
---
--- bt_page_stats()
---
-CREATE TYPE bt_page_stats_type AS (
- blkno int4,
- type char,
- live_items int4,
- dead_items int4,
- avg_item_size float,
- page_size int4,
- free_size int4,
- btpo_prev int4,
- btpo_next int4,
- btpo int4,
- btpo_flags int4
-);
-
-CREATE OR REPLACE FUNCTION bt_page_stats(text, int4)
-RETURNS bt_page_stats_type
-AS 'MODULE_PATHNAME', 'bt_page_stats'
-LANGUAGE 'C' STRICT;
-
---
--- bt_page_items()
---
-CREATE TYPE bt_page_items_type AS (
- itemoffset int4,
- ctid tid,
- itemlen int4,
- nulls bool,
- vars bool,
- data text
-);
-
-CREATE OR REPLACE FUNCTION bt_page_items(text, int4)
-RETURNS SETOF bt_page_items_type
-AS 'MODULE_PATHNAME', 'bt_page_items'
-LANGUAGE 'C' STRICT;
-
---
-- pg_relpages()
--
CREATE OR REPLACE FUNCTION pg_relpages(text)