sqlcommenterPostgresql
If you host your own instance of Postgresql, you can run it with logs to examine statements by following the guide at Runtime config logging
i.e. on macOS, edit /usr/local/var/postgres/postgresql.conf and set log_destination to 'stderr' as per:
#------------------------------------------------------------------------------# REPORTING AND LOGGING#------------------------------------------------------------------------------# - Where to Log -log_destination='stderr'# Valid values are combinations of# stderr, csvlog, syslog, and eventlog,# depending on platform. csvlog# requires logging_collector to be on.and then when run as per
$ PGDATA=/usr/local/var/postgres postgres produces such output
2019-05-31 16:27:27.482 PDT [19175] LOG: listening on IPv4 address "127.0.0.1", port 5432 2019-05-31 16:27:27.482 PDT [19175] LOG: listening on IPv6 address "::1", port 5432 2019-05-31 16:27:27.482 PDT [19175] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2019-05-31 16:27:27.503 PDT [19176] LOG: database system was shut down at 2019-05-31 16:27:06 PDT 2019-05-31 16:27:27.508 PDT [19175] LOG: database system is ready to accept connections 2019-05-31 16:27:31.190 PDT [19183] LOG: statement: SET TIME ZONE 'UTC' 2019-05-31 16:27:31.195 PDT [19183] LOG: statement: INSERT INTO "polls_question"("question_text", "pub_date") VALUES ('Wassup?', '2019-05-31T23:27:31.175952+00:00'::timestamptz) RETURNING "polls_question"."id" /*controller='index',db_driver='django.db.backends.postgresql', framework='django%3A2.2.1',route='%5Epolls/%24'*/ References
| Resource | URL |
|---|---|
| Runtime config logging | https://www.postgresql.org/docs/11/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE |
