pg_stat_statements(showtext boolean, OUT userid oid, OUT dbid oid, OUT toplevel boolean, OUT queryid bigint, OUT query text, OUT plans bigint, OUT total_plan_time double precision, OUT min_plan_time double precision, OUT max_plan_time double precision, OUT mean_plan_time double precision, OUT stddev_plan_time double precision, OUT calls bigint, OUT total_exec_time double precision, OUT min_exec_time double precision, OUT max_exec_time double precision, OUT mean_exec_time double precision, OUT stddev_exec_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, OUT wal_records bigint, OUT wal_fpi bigint, OUT wal_bytes numeric)


Parameters

Name Type Mode
showtext boolean IN
userid oid OUT
dbid oid OUT
toplevel boolean OUT
queryid bigint OUT
query text OUT
plans bigint OUT
total_plan_time double precision OUT
min_plan_time double precision OUT
max_plan_time double precision OUT
mean_plan_time double precision OUT
stddev_plan_time double precision OUT
calls bigint OUT
total_exec_time double precision OUT
min_exec_time double precision OUT
max_exec_time double precision OUT
mean_exec_time double precision OUT
stddev_exec_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 OUT
wal_records bigint OUT
wal_fpi bigint OUT
wal_bytes numeric OUT

Definition