[SCM] PostGIS branch master updated. 3.4.0rc1-952-g8b3f16a62

git at osgeo.org git at osgeo.org
Wed Feb 28 09:17:38 PST 2024


This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, master has been updated
       via  8b3f16a628e9d8f03baed963d3ae3a98b8bfae72 (commit)
      from  ea78085af40612926663e0a149bf1a776fa8412b (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 8b3f16a628e9d8f03baed963d3ae3a98b8bfae72
Author: Sandro Santilli <strk at kbt.io>
Date:   Wed Feb 28 18:18:27 2024 +0100

    Show more SQL and less comments in the stats show script

diff --git a/topology/test/perf/show_stats.sql b/topology/test/perf/show_stats.sql
index 52e477f2b..807b976b4 100644
--- a/topology/test/perf/show_stats.sql
+++ b/topology/test/perf/show_stats.sql
@@ -4,12 +4,16 @@ SELECT
   round(total_exec_time) tot_ms,
   substring(
     regexp_replace(
-      regexp_replace(query,'\n',' ','g'),
-      '  *',
-      ' ',
-      'g'
+      regexp_replace(
+        regexp_replace(
+          query,
+          E'--[^\n]*', '', 'g'
+        ),
+        '\n *', ' ','g'
+      ),
+      '  *', ' ', 'g'
     )
-    from 1 for 90
+    from 1 for 120
   ) query
 FROM pg_stat_statements
 ORDER BY total_exec_time desc;

-----------------------------------------------------------------------

Summary of changes:
 topology/test/perf/show_stats.sql | 14 +++++++++-----
 1 file changed, 9 insertions(+), 5 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list