Fazendo log de queries no PostgreSQL

ALTER DATABASE your_database_nameSET log_statement = 'all';// https://stackoverflow.com/questions/722221/how-to-log-postgresql-queriesSELECT set_config('log_statement', 'all', true);

postgresql.conf#log_directory = 'pg_log' to log_directory = 'pg_log'#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' to log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'#log_statement = 'none' to log_statement = 'all'#logging_collector = off to logging_collector = onOptional: SELECT set_config('log_statement', 'all', true);sudo /etc/init.d/postgresql restart or sudo service postgresql restartFire query in postgresql select 2+2Find current log in /var/lib/pgsql/9.2/data/pg_log/log_directory = 'pg_log'                    log_filename = 'postgresql-dateformat.log'log_statement = 'all'logging_collector = onlog_min_duration_statement = 0https://chartio.com/resources/tutorials/how-to-log-queries-in-postgresql/

https://www.cybertec-postgresql.com/en/exposing-postgresql-server-logs-to-users-via-sql/

http://www.microhowto.info/howto/log_all_queries_to_a_postgresql_server.html

https://stackoverflow.com/questions/8208310/postgresql-how-to-see-which-queries-have-run

https://www.postgresql.org/docs/current/runtime-config-client.html

Não exatamente um Log, mas PgStatsStatement

Uma alternativa - PgStatsStatement
https://www.postgresql.org/docs/current/pgstatstatements.html