Discover a swift method to estimate the row count of PostgreSQL tables, especially useful for large datasets. While the conventional SELECT COUNT(*) FROM table_name; is suitable for smaller tables, it becomes inefficient for substantial datasets. For large tables, where precision is not critical, consider using the following query for an approximate row count
select cl.relname as "table_name" ,cl.reltuples as "approximate_number_of_rows"
from pg_catalog.pg_class cl inner join pg_catalog.pg_statio_user_tables utables
on cl.relname = utables.relname order by cl.reltuples desc;
This query efficiently provides an estimation of the row count for all user tables in the current PostgreSQL database. For additional insights, such as disk space usage for each table, more details are available here https://heyitissimple.com/finding-disk-space-used-by-postgresql-tables/