EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t_1.c1 = t_2.c1)
-> Index Scan using t1_i1 on t1 t_1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t_1.c1 = t_2.c1)
-> Index Scan using t1_i1 on t1 t_1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s2.t1 WHERE s1.t1.c1 = s2.t1.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t1_1.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t1_1.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t1_1.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s2.t1 s2t1 WHERE s1.t1.c1 = s2t1.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = s2t1.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = s2t1.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT *, (SELECT max(t1.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
InitPlan 1 (returns $0)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
InitPlan 1 (returns $0)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
InitPlan 1 (returns $0)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
DETAIL: Unrecognized hint keyword "".
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2, s1.t3 WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Merge Join (cost=xxx..xxx rows=1000 width=xxx)
DETAIL: Unrecognized hint keyword "".
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=100 width=xxx)
-> Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.p1 t1, s1.p1 t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=301 width=xxx)
Hash Cond: (t1.c1 = t2.c1)
-> Append (cost=xxx..xxx rows=301 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (t1.c1 = t2.c1)
-> Append (cost=xxx..xxx rows=301 width=xxx)
EXPLAIN SELECT * FROM s1.ul1 t1, s1.ul1 t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1130 width=xxx)
Hash Cond: (t1.c1 = t2.c1)
-> Seq Scan on ul1 t1 (cost=xxx..xxx rows=1130 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (t1.c1 = t2.c1)
-> Seq Scan on ul1 t1 (cost=xxx..xxx rows=1130 width=xxx)
EXPLAIN SELECT * FROM tm1 t1, tm1 t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1130 width=xxx)
Hash Cond: (t1.c1 = t2.c1)
-> Seq Scan on tm1 t1 (cost=xxx..xxx rows=1130 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (t1.c1 = t2.c1)
-> Seq Scan on tm1 t1 (cost=xxx..xxx rows=1130 width=xxx)
EXPLAIN SELECT * FROM t_pg_class t1, t_pg_class t2 WHERE t1.oid = t2.oid;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=450 width=xxx)
Hash Cond: (t1.oid = t2.oid)
-> Seq Scan on t_pg_class t1 (cost=xxx..xxx rows=300 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (t1.oid = t2.oid)
-> Seq Scan on t_pg_class t1 (cost=xxx..xxx rows=300 width=xxx)
EXPLAIN SELECT * FROM s1.f1() t1, s1.f1() t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (t1.c1 = t2.c1)
-> Function Scan on f1 t1 (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (t1.c1 = t2.c1)
-> Function Scan on f1 t1 (cost=xxx..xxx rows=1 width=xxx)
EXPLAIN SELECT * FROM (VALUES(1,1,1,'1'), (2,2,2,'2'), (3,3,3,'3')) AS t1 (c1, c2, c3, c4), s1.t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=3 width=xxx)
Hash Cond: (t2.c1 = "*VALUES*".column1)
-> Seq Scan on t2 (cost=xxx..xxx rows=100 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=3 width=xxx)
Hash Cond: (t2.c1 = "*VALUES*".column1)
-> Seq Scan on t2 (cost=xxx..xxx rows=100 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (t2.c1 = "*VALUES*".column1)
-> Seq Scan on t2 (cost=xxx..xxx rows=100 width=xxx)
EXPLAIN WITH c1(c1) AS (SELECT max(t1.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1) SELECT * FROM s1.t1, c1 WHERE t1.c1 = c1.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Merge Join (cost=xxx..xxx rows=100 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=2 width=xxx)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Merge Join (cost=xxx..xxx rows=1 width=xxx)
EXPLAIN SELECT * FROM s1.v1 t1, s1.v1 t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1000 width=xxx)
Hash Cond: (v1t1.c1 = v1t1_1.c1)
-> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1000 width=xxx)
Hash Cond: (v1t1.c1 = v1t1_1.c1)
-> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (v1t1.c1 = v1t1_.c1)
-> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.c1 = (SELECT max(st1.c1) FROM s1.t1 st1, s1.t2 st2 WHERE st1.c1 = st2.c1);
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $0)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $0)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
EXPLAIN SELECT * FROM s1.t1, (SELECT t2.c1 FROM s1.t2) st2 WHERE t1.c1 = st2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $1)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $1)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $1)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $1)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (bmt1.c1 = bmt2.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (bmt2.c1 = bmt1.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (bmt1.c1 = bmt2.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (bmt2.c1 = bmt1.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $1)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $1)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $1)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $1)
-> Aggregate (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (bmt4.c1 = bmt1.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (bmt4.c1 = bmt1.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Hash Join (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Hash Join (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-----------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $0)
-> Index Only Scan using t1_i1 on t1 b2t1 (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-----------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
InitPlan 1 (returns $0)
-> Index Only Scan using t1_i1 on t1 b2t1 (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=10 width=xxx)
Join Filter: (bmt1.c1 = bmt2.c1)
InitPlan 1 (returns $0)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=10 width=xxx)
Join Filter: (bmt1.c1 = bmt2.c1)
InitPlan 1 (returns $0)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=10 width=xxx)
Join Filter: (bmt1.c1 = bmt4.c1)
InitPlan 1 (returns $1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=10 width=xxx)
Join Filter: (bmt1.c1 = bmt4.c1)
InitPlan 1 (returns $1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=10 width=xxx)
Join Filter: (bmt1.c1 = bmt4.c1)
InitPlan 1 (returns $0)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=10 width=xxx)
Join Filter: (bmt1.c1 = bmt4.c1)
InitPlan 1 (returns $0)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (t1.c1 = t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
Join Filter: (t1.c1 = t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-----------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (b1t1.c1 = b1t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
Join Filter: (b1t1.c1 = b1t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (t1.c1 = t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
Join Filter: (t1.c1 = t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-----------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (b1t1.c1 = b1t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
Join Filter: (b1t1.c1 = b1t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (t1.c1 = t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
Join Filter: (t1.c1 = t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-----------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (b1t1.c1 = b1t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
--------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
Join Filter: (b1t1.c1 = b1t4.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1000 width=xxx)
Hash Cond: (v1t1.c1 = v1t1_1.c1)
-> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1000 width=xxx)
Hash Cond: (v1t1.c1 = v1t1_1.c1)
-> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1000 width=xxx)
-> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
-> Index Scan using t1_i1 on t1 v1t1_ (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
-> Index Scan using t1_i1 on t1 v1t1_ (cost=xxx..xxx rows=1 width=xxx)
DETAIL: Unrecognized hint keyword "RowsHashJoin".
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1000 width=xxx)
Hash Cond: (r4t1.c1 = r4t1_1.c1)
-> Seq Scan on t1 r4t1 (cost=xxx..xxx rows=1000 width=xxx)
DETAIL: Unrecognized hint keyword "RowsHashJoin".
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1000 width=xxx)
Hash Cond: (r4t1.c1 = r4t1_1.c1)
-> Seq Scan on t1 r4t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1000 width=xxx)
-> Seq Scan on t1 r4t1 (cost=xxx..xxx rows=1000 width=xxx)
-> Index Scan using t1_i1 on t1 r5t1 (cost=xxx..xxx rows=1 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Seq Scan on t1 r4t1 (cost=xxx..xxx rows=1000 width=xxx)
-> Index Scan using t1_i1 on t1 r5t1 (cost=xxx..xxx rows=1 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Hash Join (cost=xxx..xxx rows=2 width=xxx)
Hash Cond: (t2.c1 = "*VALUES*".column1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Hash Join (cost=xxx..xxx rows=2 width=xxx)
Hash Cond: (t2.c1 = "*VALUES*".column1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=20 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
-> Values Scan on "*VALUES*" (cost=xxx..xxx rows=2 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4), (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t4 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1 AND t1.c1 = t4.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (t2.c1 = "*VALUES*_1".column1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (t2.c1 = "*VALUES*_1".column1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
---------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
Join Filter: (t2.c1 = "*VALUES*_1".column1)
EXPLAIN SELECT max(bmt1.c1) FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Aggregate (cost=xxx..xxx rows=1 width=xxx)
-> Nested Loop (cost=xxx..xxx rows=100 width=xxx)
-> Merge Join (cost=xxx..xxx rows=100 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=70 width=xxx)
Merge Cond: (bmt1.c1 = bmt2.c1)
-> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=100 width=xxx)
-> Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (bmt1.c1 = bmt2.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=60 width=xxx)
Merge Cond: (bmt1.c1 = bmt2.c1)
-> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Nested Loop (cost=xxx..xxx rows=100 width=xxx)
-> Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (bmt1.c1 = bmt2.c1)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
------------------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=50 width=xxx)
Merge Cond: (bmt1.c1 = bmt2.c1)
-> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=5 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=101 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=99 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=200 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=10 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=301 width=xxx)
Hash Cond: (p2.c1 = p1.c1)
-> Append (cost=xxx..xxx rows=304 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=1 width=xxx)
Hash Cond: (p2.c1 = p1.c1)
-> Append (cost=xxx..xxx rows=304 width=xxx)
EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=301 width=xxx)
Hash Cond: (p2.c1 = p1.c1)
-> Append (cost=xxx..xxx rows=304 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
-------------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Hash Join (cost=xxx..xxx rows=301 width=xxx)
Hash Cond: (p2.c1 = p1.c1)
-> Append (cost=xxx..xxx rows=304 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=1 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=100 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
\o
\! sql/maskout.sh results/ut-R.tmpout
- QUERY PLAN
----------------------------------------------------------------------------
+ QUERY PLAN
+----------------
Merge Join (cost=xxx..xxx rows=101 width=xxx)
Merge Cond: (t1.c1 = t2.c1)
-> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)