contrib/pg_stat_statements/pg_stat_statements.sql.in

   1 /* $PostgreSQL$ */
   2
   3 -- Adjust this setting to control where the objects get created.
   4 SET search_path = public;
   5
   6 -- Register functions.
   7 CREATE FUNCTION pg_stat_statements_reset()
   8 RETURNS void
   9 AS 'MODULE_PATHNAME'
  10 LANGUAGE C;
  11
  12 CREATE FUNCTION pg_stat_statements(
  13     OUT userid oid,
  14     OUT dbid oid,
  15     OUT query text,
  16     OUT calls int8,
  17     OUT total_time float8,
  18     OUT rows int8
  19 )
  20 RETURNS SETOF record
  21 AS 'MODULE_PATHNAME'
  22 LANGUAGE C;
  23
  24 -- Register a view on the function for ease of use.
  25 CREATE VIEW pg_stat_statements AS
  26   SELECT * FROM pg_stat_statements();
  27
  28 GRANT SELECT ON pg_stat_statements TO PUBLIC;
  29
  30 -- Don't want this to be available to non-superusers.
  31 REVOKE ALL ON FUNCTION pg_stat_statements_reset() FROM PUBLIC;