From: | Chris Morris <chris(at)mysteryscience(dot)com> |
---|---|
To: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Log Unique Queries without Params? |
Date: | 2020-04-13 05:37:09 |
Message-ID: | CALrUc2WhM9PAivNNYdvSx83BOavEw6fN=mBA7R+xYa0nuqrf6Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thx!
On Sat, Apr 11, 2020 at 11:55 PM Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:
> On Sun, Apr 12, 2020 at 6:51 AM Chris Morris <chris(at)mysteryscience(dot)com>
> wrote:
> >
> > 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.
>
> pgbadger (http://pgbadger.darold.net/#about) will do that and much
> more. Depending on what you want to achieve maybe pg_stat_statements
> (https://www.postgresql.org/docs/current/pgstatstatements.html) is
> also an alternative.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rene Romero Benavides | 2020-04-13 06:20:29 | Re: Log Unique Queries without Params? |
Previous Message | AC Gomez | 2020-04-13 00:23:00 | Database lock on command: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA, while looping though schemas |