SELECT reltuples FROM pg_class WHERE oid = 'schema_name.table_name'::regclass;
(replacing schema_name and table_name)
(source)
A piggy bank of commands, fixes, succinct reviews, some mini articles and technical opinions from a (mostly) Perl developer.
Faster count(*) in postgres
For an approximate count you can do:
(replacing schema_name and table_name)
(source)
(replacing schema_name and table_name)
(source)
Labels:
count,
postgresql,
slow,
sql
Posts
