IDEA: pg_stat_statements tracking utility statements by tag?

From: Martijn van Oosterhout <kleptog(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: IDEA: pg_stat_statements tracking utility statements by tag?
Date: 2020-07-29 09:24:57
Message-ID: CADWG95trX6B7wzbPb4S5Y4DwMwNsh4v3m=ub77gg7kqMLaeRLQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hoi hackers,

We've been using the pg_stat_statements extension to get an idea of the
queries used in the database, but the table is being filled with entries
like:

SAVEPOINT sa_savepoint_NNN;
RELEASE SAVEPOINT sa_savepoint_NNN;
DECLARE "c_7f9451c4dcc0_5" CURSOR WITHOUT HOLD ...
FETCH FORWARD 250 FROM "c_7f9451b03908_5"

Since the unique id is different for each query, the aggregation does
nothing and there are quite a lot of these drowning out the normal queries
(yes, I'm aware this is an issue of itself). The only way to deal with this
is "pg_stat_statements.track_utility=off". However, it occurs to me that if
you just tracked the tags rather than the full query text you could at
least track the number of such queries and how much time they take. So the
above queries would be tracked under SAVEPOINT, RELEASE, DECLARE CURSOR and
(I guess) FETCH respectively. But it would also catch DDL.

Does this sound like something for which a patch would be accepted?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)gmail(dot)com> http://svana.org/kleptog/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2020-07-29 09:41:16 Re: [PATCH] Tab completion for VACUUM of partitioned tables
Previous Message Michael Paquier 2020-07-29 09:24:54 Re: [PATCH]Fix ja.po error