diff options
Diffstat (limited to 'contrib/pgstattuple/pgstattuple.sql.in')
| -rw-r--r-- | contrib/pgstattuple/pgstattuple.sql.in | 31 |
1 files changed, 18 insertions, 13 deletions
diff --git a/contrib/pgstattuple/pgstattuple.sql.in b/contrib/pgstattuple/pgstattuple.sql.in index 7ac7b6c11c..5489c93812 100644 --- a/contrib/pgstattuple/pgstattuple.sql.in +++ b/contrib/pgstattuple/pgstattuple.sql.in @@ -1,17 +1,22 @@ +-- Adjust this setting to control where the objects get created. +SET search_path = public; + +SET autocommit TO 'on'; + DROP TYPE pgstattuple_type CASCADE; CREATE TYPE pgstattuple_type AS ( - table_len BIGINT, -- physical table length in bytes - tuple_count BIGINT, -- number of live tuples - tuple_len BIGINT, -- total tuples length in bytes - tuple_percent FLOAT, -- live tuples in % - dead_tuple_count BIGINT, -- number of dead tuples - dead_tuple_len BIGINT, -- total dead tuples length in bytes - dead_tuple_percent FLOAT, -- dead tuples in % - free_space BIGINT, -- free space in bytes - free_percent FLOAT -- free space in % + table_len BIGINT, -- physical table length in bytes + tuple_count BIGINT, -- number of live tuples + tuple_len BIGINT, -- total tuples length in bytes + tuple_percent FLOAT, -- live tuples in % + dead_tuple_count BIGINT, -- number of dead tuples + dead_tuple_len BIGINT, -- total dead tuples length in bytes + dead_tuple_percent FLOAT, -- dead tuples in % + free_space BIGINT, -- free space in bytes + free_percent FLOAT -- free space in % ); -CREATE OR REPLACE FUNCTION pgstattuple(text) RETURNS pgstattuple_type - AS 'MODULE_PATHNAME', 'pgstattuple' - LANGUAGE 'c' WITH (isstrict); -GRANT EXECUTE ON FUNCTION pgstattuple(text) TO PUBLIC; +CREATE OR REPLACE FUNCTION pgstattuple(text) +RETURNS pgstattuple_type +AS 'MODULE_PATHNAME', 'pgstattuple' +LANGUAGE 'C' WITH (isstrict); |