Sha256: 5a17bfba6e70478922349363dea603603795d225cec6b7de8e85e41ed7fda0d8

Contents?: true

Size: 232 Bytes

Versions: 30

Compression:

Stored size: 232 Bytes

Contents

/* All tables and the number of rows in each ordered by number of rows descending */

SELECT
  relname AS name,
  n_live_tup AS estimated_count
FROM
  pg_stat_user_tables
WHERE
  schemaname = '%{schema}'
ORDER BY
  n_live_tup DESC;

Version data entries

30 entries across 30 versions & 1 rubygems

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