Why do postgres database row counts differ between the dashboard and my queries?

Resolution

Do not be alarmed if the row count you see in your dashboard or pg:info differ slightly from direct count queries.

To limit impact on your database we use the statistics provided by the catalog table pg_class, you can learn more here. To increase response time we also aggressively cache these metrics.