contrib/pgstattuple/pgstattuple.sql.in


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

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 %
);

CREATE OR REPLACE FUNCTION pgstattuple(text) RETURNS pgstattuple_type
  AS 'MODULE_PATHNAME', 'pgstattuple'
  LANGUAGE 'c' WITH (isstrict);