'How I can access postgres log_connections logs

I see that log_connections enabled by default on Heroku PostgreSQL instance, but how I can get this log?



Solution 1:[1]

This setting in heroku enables connection logging in Postgres per: https://www.postgresql.org/docs/14/runtime-config-logging.html#GUC-LOG-CONNECTIONS.

You can find the logged info in the pg_stat_activity table in your DB.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Tom Tresansky