- Notifications
You must be signed in to change notification settings - Fork4.9k
Commit45e0ba3
committed
pg_stat_statements: Add tests for nested queries with level tracking
There have never been any regression tests in PGSS for various querypatterns for nested queries combined with level tracking, like:- Multi-statements.- CREATE TABLE AS- CREATE/REFRESH MATERIALIZED VIEW- DECLARE CURSOR- EXPLAIN, with a subset of the above supported.- COPY.All the tests added here track historical, sometimes confusing, existingbehaviors. For example, EXPLAIN stores two PGSS entries with the sametop-level query string but two different query IDs as one is calculatedfor the top-level EXPLAIN (this part is right) and a second one for theinner query in the EXPLAIN (this part is not right).A couple of patches are under discussion to improve the situation, andall the tests added here will prove useful to evaluate the changesdiscussed.Author: Anthonin BonnefoyReviewed-by: Michael Paquier, Jian HeDiscussion:https://postgr.es/m/CAO6_XqqM6S9bQ2qd=75W+yKATwoazxSNhv5sjW06fjGAtHbTUA@mail.gmail.com1 parent68ad981 commit45e0ba3
File tree
2 files changed
+1397
-0
lines changed- contrib/pg_stat_statements
- expected
- sql
2 files changed
+1397
-0
lines changed0 commit comments
Comments
(0)