diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-05-17 19:11:25 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-05-17 19:11:25 +0000 |
| commit | 64058429c54afb49a679c58e5ff699640bd42502 (patch) | |
| tree | 6bfe22b07c3f52747c8e5d8a400d3cea274602e9 /contrib/pgstattuple/pgstattuple.sql.in | |
| parent | 3b0347b36e1f59e5db95e8994948d850bfc90472 (diff) | |
| download | postgresql-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.in | 56 |
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) |
