You
Is there a fast approximate count for a huge table?
ChatGPT
For monitoring, read reltuples from pg_class, which the planner keeps roughly current. It is off by a few percent between vacuums, which is fine for a dashboard and wrong for invoicing.