sql - Fast way to discover the row count of a table in PostgreSQL - Stack Overflow

PHOTO EMBED

Fri Apr 30 2021 19:03:55 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

SELECT reltuples AS estimate FROM pg_class where relname = 'mytable';
content_copyCOPY

https://stackoverflow.com/questions/7943233/fast-way-to-discover-the-row-count-of-a-table-in-postgresql