“Word of caution: do NOT use your production Postgres instance for data reporting / metrics.”
Most companies don’t have big data. They have a few hundred gigabytes and a Snowflake invoice. A tuned Postgres replica handles that fine. The cloud warehouse vendors would rather you never find out.