Contents

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

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

Version data entries

18 entries across 18 versions & 1 rubygems

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