Skip to content

Commit e609ede

Browse files
committed
Adding in the pg_stat functions.
1 parent 57691f5 commit e609ede

File tree

2 files changed

+10
-0
lines changed

2 files changed

+10
-0
lines changed

function/ap/pg_stat_statements.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,5 @@
1+
CREATE OR REPLACE FUNCTION ap.pg_stat_statements(showtext boolean, OUT userid oid, OUT dbid oid, OUT queryid bigint, OUT query text, OUT calls bigint, OUT total_time double precision, OUT min_time double precision, OUT max_time double precision, OUT mean_time double precision, OUT stddev_time double precision, OUT rows bigint, OUT shared_blks_hit bigint, OUT shared_blks_read bigint, OUT shared_blks_dirtied bigint, OUT shared_blks_written bigint, OUT local_blks_hit bigint, OUT local_blks_read bigint, OUT local_blks_dirtied bigint, OUT local_blks_written bigint, OUT temp_blks_read bigint, OUT temp_blks_written bigint, OUT blk_read_time double precision, OUT blk_write_time double precision)
2+
RETURNS SETOF record
3+
LANGUAGE c
4+
PARALLEL SAFE STRICT
5+
AS '$libdir/pg_stat_statements', $function$pg_stat_statements_1_3$function$
Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,5 @@
1+
CREATE OR REPLACE FUNCTION ap.pg_stat_statements_reset()
2+
RETURNS void
3+
LANGUAGE c
4+
PARALLEL SAFE
5+
AS '$libdir/pg_stat_statements', $function$pg_stat_statements_reset$function$

0 commit comments

Comments
 (0)