pgstattuple.sql.in 734 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12
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 %
);
13

14
CREATE OR REPLACE FUNCTION pgstattuple(text) RETURNS pgstattuple_type
15 16
  AS 'MODULE_PATHNAME', 'pgstattuple'
  LANGUAGE 'c' WITH (isstrict);
Tatsuo Ishii's avatar
Tatsuo Ishii committed
17
GRANT EXECUTE ON FUNCTION pgstattuple(text) TO PUBLIC;