Sha256: 8ec8ff8384722e35493e57881e12cb8aad6848835a0554bbfb746317864d64a6

Contents?: true

Size: 199 Bytes

Versions: 51

Compression:

Stored size: 199 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
ORDER BY
  n_live_tup DESC;

Version data entries

51 entries across 51 versions & 3 rubygems

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