From: | Chris Morris <chris(at)mysteryscience(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Log Unique Queries without Params? |
Date: | 2020-04-12 04:50:45 |
Message-ID: | CALrUc2XUigpb1QNnxd6gx0N-LxrrrZcm6MXBtj0O9p-qH4zYbQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a local script I've written that will scan a log of PG queries to
extract out unique queries without any specific parameter data. For
example, if these 2 queries are actually run:
SELECT * FROM foo where bar = 1;
SELECT * FROM foo where bar = 2;
It will capture only:
SELECT * FROM foo whee bar = :id;
Are there any existing tools that do this already for me? I'm considering
setting up a server that can have logs forwarded to it and only logging
unique queries like this, but I don't want to build anything that may
already exist out there.
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2020-04-12 04:55:06 | Re: Log Unique Queries without Params? |
Previous Message | AC Gomez | 2020-04-11 21:44:12 | Looping though schemas to grant access will work in PUBLIC loop iteration but fails on next iteration of user schema at: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA |