SQLite Forum

Approximate COUNT(*) using sqlite_stat4
The "[PRAGMA est_count][1]" command was an experimental design to help speed
up ANALYZE for large (tera-byte sized) databases.  The idea was subsequently
folded into trunk.  See the "[PRAGMA analyze_limit][2]" command.  The table
[size estimation logic][3] is in the source tree, but it is not accessible to
application code at this time.

[1]: https://www.sqlite.org/src/timeline?r=est_count_pragma
[2]: https://www.sqlite.org/pragma.html#pragma_analysis_limit
[3]: https://www.sqlite.org/src/info/4da25694985ac8f5?ln=5704-5727