Teach contrib/pg_stat_statements to handle multi-statement commands better.
Make use of the statement boundary info added by commit ab1f0c822
to let pg_stat_statements behave more sanely when multiple SQL queries
are jammed into one query string. It now records just the relevant
part of the source string, not the whole thing, for each individual
query.
Even when no multi-statement strings are involved, users may notice small
changes in the output: leading and trailing whitespace and semicolons will
be stripped from statements, which did not happen before.
Also, significantly expand pg_stat_statements' regression test script.
Fabien Coelho, reviewed by Craig Ringer and Kyotaro Horiguchi,
some mods by me
Discussion: https://postgr.es/m/alpine.DEB.2.20.1612200926310.29821@lancre
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/83f2061dd037477ec8479ee160367840e203a722
Modified Files
--------------
.../expected/pg_stat_statements.out | 362 ++++++++++++++++++++-
contrib/pg_stat_statements/pg_stat_statements.c | 103 ++++--
.../pg_stat_statements/sql/pg_stat_statements.sql | 179 +++++++++-
3 files changed, 606 insertions(+), 38 deletions(-)