2015-08-20 18:43 GMT+02:00 Kevin Burke <burke@shyp.com>:
Hi,
Normally I try to annotate incoming queries, to make it easier to diagnose slow ones. For example:
-- Users.findByPhoneNumber
SELECT * FROM ....
The pg_dump and pg_restore commands issue a COPY with no possibility of adding a comment. It would be useful to know who or what exactly is performing a COPY against a database - maybe a nightly backup script, maybe a developer copying a table.
I was wondering if you could have a command line flag that let you attach a comment to the query?
You already have the application name. You just need to log it.
