Contents

/* 10 queries that have longest execution time in aggregate */

SELECT query AS qry,
interval '1 millisecond' * total_time AS exec_time,
to_char((total_time/sum(total_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 10;

Version data entries

10 entries across 10 versions & 3 rubygems

Version	Path
pg-stats-1.0.0	queries/slow-statements.sql
ruby-pg-extras-0.6.2	lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-0.6.1	lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-0.6.0	lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-0.0.3	lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-0.0.2	lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-0.0.1	lib/ruby-pg-extras/queries/calls.sql
rails-pg-extras-0.5.2	lib/rails-pg-extras/queries/calls.sql
rails-pg-extras-0.5.1	lib/rails-pg-extras/queries/calls.sql
rails-pg-extras-0.5.0	lib/rails-pg-extras/queries/calls.sql