Sha256: a27470c46f6d10f24b30c9dc7e22e8327a78dba4b91b425bae128cd560d237b8

Contents?: true

Size: 162 Bytes

Versions: 50

Compression:

Stored size: 162 Bytes

Contents

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

SELECT relname AS name,
       seq_scan as count
FROM
  pg_stat_user_tables
ORDER BY seq_scan DESC;

Version data entries

50 entries across 50 versions & 3 rubygems

Version Path
ruby-pg-extras-4.4.4 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.4.3 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.4.2 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.4.1 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.4.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.2.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.1.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.0.1 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-4.0.0 lib/ruby_pg_extras/queries/seq_scans.sql
ruby-pg-extras-3.3.0 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.2.7 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.2.6 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.2.5 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.2.4 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.2.3 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.2.2 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.2.1 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.2.0 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.1.0 lib/ruby-pg-extras/queries/seq_scans.sql
ruby-pg-extras-3.0.6 lib/ruby-pg-extras/queries/seq_scans.sql