Sha256: 0ac43f8e2368dc2be0530258a8f073a6311a87a9e83b8d14f5853dab1d3ab275
Contents?: true
Size: 495 Bytes
Versions: 56
Compression:
Stored size: 495 Bytes
Contents
/* Queries that have highest frequency of execution */
SELECT query AS qry,
interval '1 millisecond' * total_exec_time AS exec_time,
to_char((total_exec_time/sum(total_exec_time) OVER()) * 100, 'FM90D0') || '%%' AS prop_exec_time,
to_char(calls, 'FM999G999G990') AS ncalls,
interval '1 millisecond' * (blk_read_time + blk_write_time) AS sync_io_time
FROM pg_stat_statements WHERE userid = (SELECT usesysid FROM pg_user WHERE usename = current_user LIMIT 1)
ORDER BY calls DESC LIMIT %{limit};
Version data entries
56 entries across 56 versions & 1 rubygems