opentelemetry-sqlcommenter
Postgresql
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 |