fast_count
A Ruby gem for quickly getting approximate row counts for large database tables with >99% accuracy for PostgreSQL.
What is fast_count?
FastCount is a Ruby gem that provides fast, approximate row count estimations for large database tables. It solves the problem of expensive and slow exact `COUNT(*)` queries on massive tables by using database statistics to deliver >99% accurate estimates in milliseconds. The gem supports PostgreSQL, MySQL, MariaDB, and SQLite.
Ruby on Rails developers working with large database tables who need quick row count approximations for analytics, pagination, or monitoring without the performance penalty of exact counts.
Developers choose FastCount because it dramatically reduces query times from minutes to milliseconds while maintaining high accuracy, supports multiple databases, and integrates seamlessly with ActiveRecord. It's particularly valuable in production environments where exact counts are impractical.
Overview
Quickly get a count estimation for large tables (>99% of accuracy for PostgreSQL).
Use Cases
Best For
- Getting approximate row counts for large PostgreSQL tables with >99% accuracy
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
