Sha256: 2d3deb78e510dbc6f2dad07ce012985064ea01296024ab22d78ae7c60201f285

Contents?: true

Size: 476 Bytes

Versions: 8

Compression:

Stored size: 476 Bytes

Contents

/* 10 queries that have highest frequency of execution */

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

8 entries across 8 versions & 1 rubygems

Version Path
ruby-pg-extras-1.2.4 lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-1.2.3 lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-1.2.2 lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-1.2.1 lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-1.2.0 lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-1.1.0 lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-1.0.0 lib/ruby-pg-extras/queries/calls.sql
ruby-pg-extras-0.7.0 lib/ruby-pg-extras/queries/calls.sql