/*+Set(work_mem "1M")*/
EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
INFO: invalid value for parameter "work_mem": "1M"
-HINT: Valid units for this parameter are "kB", "MB", "GB", and "TB".
+HINT: Valid units for this parameter are "B", "kB", "MB", "GB", and "TB".
LOG: pg_hint_plan:
used hint:
not used hint:
-> Index Scan using t2_pkey on t2
(4 rows)
+-- Cannot work
/*+NestLoop(t1 t2)*/
EXPLAIN (COSTS false) SELECT * FROM t1 FULL OUTER JOIN t2 ON (t1.id = t2.id);
LOG: pg_hint_plan:
QUERY PLAN
------------------------------
Hash Full Join
- Hash Cond: (t2.id = t1.id)
- -> Seq Scan on t2
+ Hash Cond: (t1.id = t2.id)
+ -> Seq Scan on t1
-> Hash
- -> Seq Scan on t1
+ -> Seq Scan on t2
(5 rows)
-- inheritance tables test
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
default_statistics_target | 100
force_parallel_mode | off
from_collapse_limit | 8
- jit | on
+ jit | off
join_collapse_limit | 8
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
---- No. S-3-6 query structure
----
EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.ctid = '(1,1)';
- QUERY PLAN
------------------------------------------
- Nested Loop
- Join Filter: (t1.c1 = t2.c1)
- -> Tid Scan on t1
- TID Cond: (ctid = '(1,1)'::tid)
+ QUERY PLAN
+-----------------------------------------------
+ Hash Join
+ Hash Cond: (t2.c1 = t1.c1)
-> Seq Scan on t2
-(5 rows)
+ -> Hash
+ -> Tid Scan on t1
+ TID Cond: (ctid = '(1,1)'::tid)
+(6 rows)
-- No. S-3-6-1
/*+SeqScan(t1)*/