The pg_loose_count extension looks at the table statistics in the PostgreSQL system tables to get a fast approximate count of the number of rows in a given table:
DB.loose_count(:table) # => 123456
It can also support schema qualified tables:
DB.loose_count(Sequel[:schema][:table]) # => 123456
To get the loose count of all tables in a given schema:
DB.loose_counts(:schema) # => {table: 123456, ...}
How accurate these counts are depends on the number of rows added/deleted from the table since the last time it was analyzed. If the table has not been vacuumed or analyzed yet, this can return 0 or -1 depending on the PostgreSQL version in use.
To load the extension into the database:
DB.extension :pg_loose_count
Related module: Sequel::Postgres::LooseCount