Sha256: a9635c74579f09436a6a21a663d8c3538338c0e917e7e2438a6ce390ab31f927
Contents?: true
Size: 498 Bytes
Versions: 18
Compression:
Stored size: 498 Bytes
Contents
/* 10 queries that have longest execution time in aggregate */ SELECT interval '1 millisecond' * total_time AS total_exec_time, to_char((total_time/sum(total_time) OVER()) * 100, 'FM90D0') || '%' AS prop_exec_time, to_char(calls, 'FM999G999G999G990') AS ncalls, interval '1 millisecond' * (blk_read_time + blk_write_time) AS sync_io_time, query AS query FROM pg_stat_statements WHERE userid = (SELECT usesysid FROM pg_user WHERE usename = current_user LIMIT 1) ORDER BY total_time DESC LIMIT 10;
Version data entries
18 entries across 18 versions & 3 rubygems