@@ -71,24 +71,28 @@ SELECT x FROM frgn WHERE x < -10; -- AQO ignores constants
7171(4 rows)
7272
7373-- Trivial JOIN push-down.
74- EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
74+ EXPLAIN (COSTS OFF)
7575SELECT * FROM frgn AS a, frgn AS b WHERE a.x=b.x;
76-
77- ---------------------------------------------------------------------------
78- Merge Join (actual rows=1 loops=1) (AQO not used)
76+ QUERY PLAN
77+ ------------------------------------
78+ Merge Join
7979 Merge Cond: (a.x = b.x)
80- -> Sort (actual rows=1 loops=1) (AQO not used)
80+ -> Sort
8181 Sort Key: a.x
82- Sort Method: quicksort Memory: 25kB
83- -> Foreign Scan on frgn a (actual rows=1 loops=1) (AQO not used)
84- -> Sort (actual rows=1 loops=1) (AQO not used)
82+ -> Foreign Scan on frgn a
83+ -> Sort
8584 Sort Key: b.x
86- Sort Method: quicksort Memory: 25kB
87- -> Foreign Scan on frgn b (actual rows=1 loops=1) (AQO not used)
85+ -> Foreign Scan on frgn b
8886 Using aqo: true
8987 AQO mode: LEARN
9088 JOINS: 0
91- (13 rows)
89+ (11 rows)
90+
91+ SELECT * FROM frgn AS a, frgn AS b WHERE a.x=b.x;
92+ x | x
93+ ---+---
94+ 1 | 1
95+ (1 row)
9296
9397EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF, VERBOSE)
9498SELECT * FROM frgn AS a, frgn AS b WHERE a.x=b.x;
