Sha256: 4957d4a8143902b362013ddaab50f966f75a233a84992557fc822438f1500911

Contents?: true

Size: 195 Bytes

Versions: 30

Compression:

Stored size: 195 Bytes

Contents

/* Count of sequential scans by table descending by order */

SELECT relname AS name,
       seq_scan as count
FROM
  pg_stat_user_tables
WHERE
  schemaname = '%{schema}'
ORDER BY seq_scan DESC;

Version data entries

30 entries across 30 versions & 1 rubygems

Version Path
ruby-pg-extras-5.4.5 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.4.4 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.4.3 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.4.2 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.4.1 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.4.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.3.1 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.3.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.2.5 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.2.4 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.2.3 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.2.2 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.2.1 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.2.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.1.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-5.0.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.13.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.12.2 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.12.1 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.12.0 lib/ruby_pg_extras/queries/seq_scans.sql