| From: | Andrew Gierth <rhodiumtoad(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Teach pg_stat_statements not to ignore FOR UPDATE clauses |
| Date: | 2019-07-14 11:18:01 |
| Message-ID: | E1hmcW1-00061u-7R@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Teach pg_stat_statements not to ignore FOR UPDATE clauses
Performance of a SELECT FOR UPDATE may be quite distinct from the
non-UPDATE version of the query, so treat all of the FOR UPDATE clause
as being significant for distinguishing queries.
Andrew Gierth and Vik Fearing, reviewed by Sergei Kornilov, Thomas
Munro, Tom Lane
Discussion: https://postgr.es/m/87h8e4hfwv.fsf@news-spur.riddles.org.uk
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/6e74c64bcf61eab94091f6b17dfd0ab585b1a77e
Modified Files
--------------
.../expected/pg_stat_statements.out | 87 ++++++++++++++++++++++
contrib/pg_stat_statements/pg_stat_statements.c | 23 +++++-
.../pg_stat_statements/sql/pg_stat_statements.sql | 31 ++++++++
3 files changed, 140 insertions(+), 1 deletion(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2019-07-14 12:18:42 | pgsql: Add missing commutators for distance operators |
| Previous Message | Thomas Munro | 2019-07-14 03:02:45 | pgsql: Fix documentation for pgbench tpcb-like. |