pgsql: Teach pg_stat_statements not to ignore FOR UPDATE clauses

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема pgsql: Teach pg_stat_statements not to ignore FOR UPDATE clauses
Дата
Msg-id E1hmcW1-00061u-7R@gemulon.postgresql.org
обсуждение исходный текст
Список 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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: pgsql: Fix documentation for pgbench tpcb-like.
Следующее
От: Alexander Korotkov
Дата:
Сообщение: pgsql: Add support for <-> (box, point) operator to SP-GiST box_ops