View zfindb.public.pg_stat_statements Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
userid oid 10  √  null
dbid oid 10  √  null
queryid int8 19  √  null
query text 2147483647  √  null
plans int8 19  √  null
total_plan_time float8 17,17  √  null
min_plan_time float8 17,17  √  null
max_plan_time float8 17,17  √  null
mean_plan_time float8 17,17  √  null
stddev_plan_time float8 17,17  √  null
calls int8 19  √  null
total_exec_time float8 17,17  √  null
min_exec_time float8 17,17  √  null
max_exec_time float8 17,17  √  null
mean_exec_time float8 17,17  √  null
stddev_exec_time float8 17,17  √  null
rows int8 19  √  null
shared_blks_hit int8 19  √  null
shared_blks_read int8 19  √  null
shared_blks_dirtied int8 19  √  null
shared_blks_written int8 19  √  null
local_blks_hit int8 19  √  null
local_blks_read int8 19  √  null
local_blks_dirtied int8 19  √  null
local_blks_written int8 19  √  null
temp_blks_read int8 19  √  null
temp_blks_written int8 19  √  null
blk_read_time float8 17,17  √  null
blk_write_time float8 17,17  √  null
wal_records int8 19  √  null
wal_fpi int8 19  √  null
wal_bytes numeric 131089  √  null

Analyzed at Wed Sep 15 00:41 PDT 2021