Answered by : magnificent-markhor-7umecig90oye

SELECT * FROM pg_stat_activity;

Source : https://stackoverflow.com/questions/27435839/how-to-list-active-connections-on-postgresql | Last Update : Mon, 24 Aug 20

Answered by : nutty-narwhal-4m67hx751hn9

tail -f /usr/local/var/log/postgres.log

Source : | Last Update : Mon, 21 Mar 22

Answered by : obedient-osprey-vco5wit6fryu

/var/log/postgresql/postgresql-9.3-main.log

Source : | Last Update : Thu, 02 Jun 22

Answered by : uninterested-unicorn-ukqwzk5i7wly

{"tags":[{"tag":"p","content":"In your data/postgresql.conf file:"},{"tag":"textarea","content":"log_directory = 'pg_log' \nlog_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'\nlog_statement = 'all'","code_language":"whatever"},{"tag":"p","content":"And restart PostgreSQL service"}]}

Source : https://stackoverflow.com/questions/722221/how-to-log-postgresql-queries | Last Update : Sat, 04 Feb 23

Answered by : mitchaloha

Here you can find all the informations about logs and how to
set them with your preferences:
https://www.postgresql.org/docs/9.1/runtime-config-logging.html

Source : | Last Update : Sat, 06 Nov 21