Log Unique Queries without Params?

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.

Responses

Browse pgsql-general by date

  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