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/
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 |