)
FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
;
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
)
FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
;
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b2t4"): t4_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b2t4): t4_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
/*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
*/
EXPLAIN (COSTS false) SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, (SELECT * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = sbmt4.c1;
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(bmt1)
/*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
*/
EXPLAIN (COSTS false) SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, (SELECT * FROM s1.t3 bmt3) sbmt3, (SELECT * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(bmt1)
SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
)
;
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
)
;
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b2t4"): t4_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b2t4): t4_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
AND bmt1.c1 = c1.c1
;
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
AND bmt1.c1 = c1.c1
AND bmt1.c1 = c2.c1
;
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b2t4"): t4_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b2t4): t4_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
SELECT max(b3t1.c1) FROM s1.t1 b3t1 WHERE b3t1.ctid = '(1,1)' AND b3t1.c1 = 1
)
;
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b3t1"): t1_pkey
-LOG: available indexes for IndexScan("b3t1"): t1_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b3t1): t1_pkey
+LOG: available indexes for IndexScan(b3t1): t1_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
SELECT max(b3t1.c1) FROM s1.t1 b3t1, s1.t2 b3t2 WHERE b3t1.ctid = '(1,1)' AND b3t1.c1 = b3t2.c1 AND b3t2.ctid = '(1,1)'
)
;
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b3t1"): t1_pkey
-LOG: available indexes for BitmapScan("b3t2"): t2_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b3t1): t1_pkey
+LOG: available indexes for BitmapScan(b3t2): t2_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
SELECT max(b3t1.c1) FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.ctid = '(1,1)' AND b3t1.c1 = b3t2.c1 AND b3t2.ctid = '(1,1)' AND b3t1.c1 = b3t3.c1 AND b3t3.ctid = '(1,1)' AND b3t1.c1 = b3t4.c1 AND b3t4.ctid = '(1,1)'
)
;
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b2t4"): t4_pkey
-LOG: available indexes for IndexScan("b3t1"): t1_pkey
-LOG: available indexes for BitmapScan("b3t2"): t2_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b2t4): t4_pkey
+LOG: available indexes for IndexScan(b3t1): t1_pkey
+LOG: available indexes for BitmapScan(b3t2): t2_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
SELECT max(b3t1.c1) FROM s1.t1 b3t1 WHERE b3t1.ctid = '(1,1)'
)
;
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b3t1"): t1_pkey
-LOG: available indexes for IndexScan("b3t1"): t1_pkey
-LOG: available indexes for IndexScan("bmt2"): t2_pkey
-LOG: available indexes for BitmapScan("bmt3"): t3_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b3t1): t1_pkey
+LOG: available indexes for IndexScan(b3t1): t1_pkey
+LOG: available indexes for IndexScan(bmt2): t2_pkey
+LOG: available indexes for BitmapScan(bmt3): t3_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
/*+TidScan(t1)SeqScan(t2)IndexScan(t3 t3_pkey)BitmapScan(t4 t4_pkey)
SeqScan(r1)*/
EXPLAIN (COSTS false) UPDATE s1.r1 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("t3"): t3_pkey
-LOG: available indexes for BitmapScan("t4"): t4_pkey
+LOG: available indexes for IndexScan(t3): t3_pkey
+LOG: available indexes for BitmapScan(t4): t4_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(r1)
/*+TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
SeqScan(r1_)*/
EXPLAIN (COSTS false) UPDATE s1.r1_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
/*+TidScan(t1)SeqScan(t2)IndexScan(t3 t3_pkey)BitmapScan(t4 t4_pkey)
SeqScan(r2)*/
EXPLAIN (COSTS false) UPDATE s1.r2 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("t3"): t3_pkey
-LOG: available indexes for BitmapScan("t4"): t4_pkey
+LOG: available indexes for IndexScan(t3): t3_pkey
+LOG: available indexes for BitmapScan(t4): t4_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(r2)
duplication hint:
error hint:
-LOG: available indexes for IndexScan("t3"): t3_pkey
-LOG: available indexes for BitmapScan("t4"): t4_pkey
+LOG: available indexes for IndexScan(t3): t3_pkey
+LOG: available indexes for BitmapScan(t4): t4_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(r2)
BitmapScan(b2t1 t1_pkey)TidScan(b2t2)SeqScan(b2t3)IndexScan(b2t4 t4_pkey)
SeqScan(r2_)*/
EXPLAIN (COSTS false) UPDATE s1.r2_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
duplication hint:
error hint:
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b2t4"): t4_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b2t4): t4_pkey
LOG: pg_hint_plan:
used hint:
BitmapScan(b2t1 t1_pkey)
/*+TidScan(t1)SeqScan(t2)IndexScan(t3 t3_pkey)BitmapScan(t4 t4_pkey)
SeqScan(r3)*/
EXPLAIN (COSTS false) UPDATE s1.r3 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("t3"): t3_pkey
-LOG: available indexes for BitmapScan("t4"): t4_pkey
+LOG: available indexes for IndexScan(t3): t3_pkey
+LOG: available indexes for BitmapScan(t4): t4_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(r3)
duplication hint:
error hint:
-LOG: available indexes for IndexScan("t3"): t3_pkey
-LOG: available indexes for BitmapScan("t4"): t4_pkey
+LOG: available indexes for IndexScan(t3): t3_pkey
+LOG: available indexes for BitmapScan(t4): t4_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(r3)
duplication hint:
error hint:
-LOG: available indexes for IndexScan("t3"): t3_pkey
-LOG: available indexes for BitmapScan("t4"): t4_pkey
+LOG: available indexes for IndexScan(t3): t3_pkey
+LOG: available indexes for BitmapScan(t4): t4_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(r3)
IndexScan(b3t1 t1_pkey)BitmapScan(b3t2 t2_pkey)TidScan(b3t3)SeqScan(b3t4)
SeqScan(r3_)*/
EXPLAIN (COSTS false) UPDATE s1.r3_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("b1t3"): t3_pkey
-LOG: available indexes for BitmapScan("b1t4"): t4_pkey
+LOG: available indexes for IndexScan(b1t3): t3_pkey
+LOG: available indexes for BitmapScan(b1t4): t4_pkey
LOG: pg_hint_plan:
used hint:
TidScan(b1t1)
duplication hint:
error hint:
-LOG: available indexes for BitmapScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b2t4"): t4_pkey
+LOG: available indexes for BitmapScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b2t4): t4_pkey
LOG: pg_hint_plan:
used hint:
BitmapScan(b2t1 t1_pkey)
duplication hint:
error hint:
-LOG: available indexes for IndexScan("b3t1"): t1_pkey
-LOG: available indexes for BitmapScan("b3t2"): t2_pkey
+LOG: available indexes for IndexScan(b3t1): t1_pkey
+LOG: available indexes for BitmapScan(b3t2): t2_pkey
LOG: pg_hint_plan:
used hint:
IndexScan(b3t1 t1_pkey)
-- No. S-3-3-1
/*+IndexScan(ti1 ti1_i3)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_i3
+LOG: available indexes for IndexScan(ti1): ti1_i3
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_i3)
-- No. S-3-3-2
/*+IndexScan(ti1 ti1_i3 ti1_i2)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_i3 ti1_i2
+LOG: available indexes for IndexScan(ti1): ti1_i3 ti1_i2
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_i3 ti1_i2)
-- No. S-3-3-3
/*+IndexScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_i4 ti1_i3 ti1_i2 ti1_i1
+LOG: available indexes for IndexScan(ti1): ti1_i4 ti1_i3 ti1_i2 ti1_i1
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)
-- No. S-3-3-4
/*+BitmapScan(ti1 ti1_i3)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_i3
+LOG: available indexes for BitmapScan(ti1): ti1_i3
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_i3)
-- No. S-3-3-5
/*+BitmapScan(ti1 ti1_i3 ti1_i2)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_i3 ti1_i2
+LOG: available indexes for BitmapScan(ti1): ti1_i3 ti1_i2
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_i3 ti1_i2)
-- No. S-3-3-6
/*+BitmapScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_i4 ti1_i3 ti1_i2 ti1_i1
+LOG: available indexes for BitmapScan(ti1): ti1_i4 ti1_i3 ti1_i2 ti1_i1
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)
-- No. S-3-4-1
/*+IndexScan(ti1 ti1_btree)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_btree
+LOG: available indexes for IndexScan(ti1): ti1_btree
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_btree)
-- No. S-3-4-2
/*+IndexScan(ti1 ti1_hash)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_hash
+LOG: available indexes for IndexScan(ti1): ti1_hash
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_hash)
-- No. S-3-4-3
/*+IndexScan(ti1 ti1_gist)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_gist
+LOG: available indexes for IndexScan(ti1): ti1_gist
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_gist)
-- No. S-3-4-4
/*+IndexScan(ti1 ti1_gin)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_gin
+LOG: available indexes for IndexScan(ti1): ti1_gin
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_gin)
-- No. S-3-4-5
/*+IndexScan(ti1 ti1_expr)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_expr
+LOG: available indexes for IndexScan(ti1): ti1_expr
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_expr)
-- No. S-3-4-6
/*+IndexScan(ti1 ti1_pred)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_pred
+LOG: available indexes for IndexScan(ti1): ti1_pred
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_pred)
-- No. S-3-4-7
/*+IndexScan(ti1 ti1_uniq)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_uniq
+LOG: available indexes for IndexScan(ti1): ti1_uniq
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_uniq)
-- No. S-3-4-8
/*+IndexScan(ti1 ti1_multi)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_multi
+LOG: available indexes for IndexScan(ti1): ti1_multi
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_multi)
-- No. S-3-4-9
/*+IndexScan(ti1 ti1_ts)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_ts
+LOG: available indexes for IndexScan(ti1): ti1_ts
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_ts)
-- No. S-3-4-10
/*+IndexScan(ti1 ti1_pkey)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_pkey
+LOG: available indexes for IndexScan(ti1): ti1_pkey
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_pkey)
-- No. S-3-4-11
/*+IndexScan(ti1 ti1_c2_key)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_c2_key
+LOG: available indexes for IndexScan(ti1): ti1_c2_key
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_c2_key)
-- No. S-3-4-12
/*+BitmapScan(ti1 ti1_btree)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_btree
+LOG: available indexes for BitmapScan(ti1): ti1_btree
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_btree)
-- No. S-3-4-13
/*+BitmapScan(ti1 ti1_hash)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_hash
+LOG: available indexes for BitmapScan(ti1): ti1_hash
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_hash)
-- No. S-3-4-14
/*+BitmapScan(ti1 ti1_gist)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_gist
+LOG: available indexes for BitmapScan(ti1): ti1_gist
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_gist)
-- No. S-3-4-15
/*+BitmapScan(ti1 ti1_gin)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_gin
+LOG: available indexes for BitmapScan(ti1): ti1_gin
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_gin)
-- No. S-3-4-16
/*+BitmapScan(ti1 ti1_expr)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_expr
+LOG: available indexes for BitmapScan(ti1): ti1_expr
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_expr)
-- No. S-3-4-17
/*+BitmapScan(ti1 ti1_pred)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_pred
+LOG: available indexes for BitmapScan(ti1): ti1_pred
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_pred)
-- No. S-3-4-18
/*+BitmapScan(ti1 ti1_uniq)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_uniq
+LOG: available indexes for BitmapScan(ti1): ti1_uniq
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_uniq)
-- No. S-3-4-19
/*+BitmapScan(ti1 ti1_multi)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_multi
+LOG: available indexes for BitmapScan(ti1): ti1_multi
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_multi)
-- No. S-3-4-20
/*+BitmapScan(ti1 ti1_ts)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_ts
+LOG: available indexes for BitmapScan(ti1): ti1_ts
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_ts)
-- No. S-3-4-10
/*+BitmapScan(ti1 ti1_pkey)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_pkey
+LOG: available indexes for BitmapScan(ti1): ti1_pkey
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_pkey)
-- No. S-3-4-11
/*+BitmapScan(ti1 ti1_c2_key)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 < 100 AND c2 = 1 AND lower(c4) = '1' AND to_tsvector('english', c4) @@ 'a & b' AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_c2_key
+LOG: available indexes for BitmapScan(ti1): ti1_c2_key
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_c2_key)
-- No. S-3-5-1
/*+IndexScan(ti1 ti1_pred)*/
EXPLAIN (COSTS true) SELECT * FROM s1.ti1 WHERE c1 = 100;
-LOG: available indexes for IndexScan("ti1"): ti1_pred
+LOG: available indexes for IndexScan(ti1): ti1_pred
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_pred)
-- No. S-3-5-2
/*+BitmapScan(ti1 ti1_pred)*/
EXPLAIN (COSTS true) SELECT * FROM s1.ti1 WHERE c1 = 100;
-LOG: available indexes for BitmapScan("ti1"): ti1_pred
+LOG: available indexes for BitmapScan(ti1): ti1_pred
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_pred)
-- No. S-3-6-1
/*+IndexScan(ti1 not_exist)*/
EXPLAIN (COSTS true) SELECT * FROM s1.ti1 WHERE c1 = 100;
-LOG: available indexes for IndexScan("ti1"):
+LOG: available indexes for IndexScan(ti1):
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 not_exist)
-- No. S-3-6-2
/*+BitmapScan(ti1 not_exist)*/
EXPLAIN (COSTS true) SELECT * FROM s1.ti1 WHERE c1 = 100;
-LOG: available indexes for BitmapScan("ti1"):
+LOG: available indexes for BitmapScan(ti1):
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 not_exist)
SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
) FROM s1.t1 b3t1 WHERE b3t1.c1 = (
SELECT max(b4t1.c1) FROM s1.t1 b4t1 WHERE b4t1.c1 = 1);
-LOG: available indexes for IndexScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b2t1"): t1_pkey
-LOG: available indexes for BitmapScan("b3t1"): t1_pkey
-LOG: available indexes for BitmapScan("b3t1"): t1_pkey
+LOG: available indexes for IndexScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b2t1): t1_pkey
+LOG: available indexes for BitmapScan(b3t1): t1_pkey
+LOG: available indexes for BitmapScan(b3t1): t1_pkey
LOG: pg_hint_plan:
used hint:
IndexScan(b2t1 t1_pkey)
SELECT max(b2t1.c1) FROM s1.t1 b2t1 JOIN s1.t2 b2t2 ON(b2t1.c1 = b2t2.c1) WHERE b2t1.c1 = 1
) FROM s1.t1 b3t1 JOIN s1.t2 b3t2 ON(b3t1.c1 = b3t2.c1) JOIN cte1 ON(b3t1.c1 = cte1.c1) WHERE b3t1.c1 = (
SELECT max(b4t1.c1) FROM s1.t1 b4t1 JOIN s1.t2 b4t2 ON(b4t1.c1 = b4t2.c1) WHERE b4t1.c1 = 1);
-LOG: available indexes for IndexScan("b2t1"): t1_pkey
-LOG: available indexes for BitmapScan("b4t2"): t2_pkey
-LOG: available indexes for BitmapScan("b3t1"): t1_pkey
-LOG: available indexes for IndexScan("b3t2"): t2_pkey
+LOG: available indexes for IndexScan(b2t1): t1_pkey
+LOG: available indexes for BitmapScan(b4t2): t2_pkey
+LOG: available indexes for BitmapScan(b3t1): t1_pkey
+LOG: available indexes for IndexScan(b3t2): t2_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(b1t1)
SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
) FROM s1.t1 b3t1 JOIN s1.t2 b3t2 ON(b3t1.c1 = b3t2.c1) JOIN cte1 ON(b3t1.c1 = cte1.c1) WHERE b3t1.c1 = (
SELECT max(b4t1.c1) FROM s1.t1 b4t1 WHERE b4t1.c1 = 1);
-LOG: available indexes for IndexScan("b2t1"): t1_pkey
-LOG: available indexes for IndexScan("b2t1"): t1_pkey
-LOG: available indexes for BitmapScan("b3t1"): t1_pkey
-LOG: available indexes for IndexScan("b3t2"): t2_pkey
+LOG: available indexes for IndexScan(b2t1): t1_pkey
+LOG: available indexes for IndexScan(b2t1): t1_pkey
+LOG: available indexes for BitmapScan(b3t1): t1_pkey
+LOG: available indexes for IndexScan(b3t2): t2_pkey
LOG: pg_hint_plan:
used hint:
SeqScan(b1t1)
-- No. S-3-11-3
/*+IndexScan(p2 p2_pkey p2c1_pkey p2c1c1_pkey)*/
EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1;
-LOG: available indexes for IndexScan("p2"):
-LOG: available indexes for IndexScan("p2"): p2_pkey
-LOG: available indexes for IndexScan("p2c1"): p2c1_pkey
-LOG: available indexes for IndexScan("p2c2"):
-LOG: available indexes for IndexScan("p2c3"):
-LOG: available indexes for IndexScan("p2c1c1"): p2c1c1_pkey
-LOG: available indexes for IndexScan("p2c1c2"):
-LOG: available indexes for IndexScan("p2c2c1"):
-LOG: available indexes for IndexScan("p2c2c2"):
-LOG: available indexes for IndexScan("p2c3c1"):
-LOG: available indexes for IndexScan("p2c3c2"):
+LOG: available indexes for IndexScan(p2):
+LOG: available indexes for IndexScan(p2): p2_pkey
+LOG: available indexes for IndexScan(p2c1): p2c1_pkey
+LOG: available indexes for IndexScan(p2c2):
+LOG: available indexes for IndexScan(p2c3):
+LOG: available indexes for IndexScan(p2c1c1): p2c1c1_pkey
+LOG: available indexes for IndexScan(p2c1c2):
+LOG: available indexes for IndexScan(p2c2c1):
+LOG: available indexes for IndexScan(p2c2c2):
+LOG: available indexes for IndexScan(p2c3c1):
+LOG: available indexes for IndexScan(p2c3c2):
LOG: pg_hint_plan:
used hint:
IndexScan(p2 p2_pkey p2c1_pkey p2c1c1_pkey)
-- No. S-3-11-4
/*+IndexScan(p2 p2c1_pkey)*/
EXPLAIN (COSTS true) SELECT * FROM s1.p2 WHERE c1 = 1;
-LOG: available indexes for IndexScan("p2"):
-LOG: available indexes for IndexScan("p2"):
-LOG: available indexes for IndexScan("p2c1"): p2c1_pkey
-LOG: available indexes for IndexScan("p2c2"):
-LOG: available indexes for IndexScan("p2c3"):
-LOG: available indexes for IndexScan("p2c1c1"):
-LOG: available indexes for IndexScan("p2c1c2"):
-LOG: available indexes for IndexScan("p2c2c1"):
-LOG: available indexes for IndexScan("p2c2c2"):
-LOG: available indexes for IndexScan("p2c3c1"):
-LOG: available indexes for IndexScan("p2c3c2"):
+LOG: available indexes for IndexScan(p2):
+LOG: available indexes for IndexScan(p2):
+LOG: available indexes for IndexScan(p2c1): p2c1_pkey
+LOG: available indexes for IndexScan(p2c2):
+LOG: available indexes for IndexScan(p2c3):
+LOG: available indexes for IndexScan(p2c1c1):
+LOG: available indexes for IndexScan(p2c1c2):
+LOG: available indexes for IndexScan(p2c2c1):
+LOG: available indexes for IndexScan(p2c2c2):
+LOG: available indexes for IndexScan(p2c3c1):
+LOG: available indexes for IndexScan(p2c3c2):
LOG: pg_hint_plan:
used hint:
IndexScan(p2 p2c1_pkey)
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
INFO: hint syntax error at or near "IndexScan(ti1 ti1_pkey) BitmapScan(ti1 ti1_btree)"
DETAIL: Conflict scan method hint.
-LOG: available indexes for BitmapScan("ti1"): ti1_btree
+LOG: available indexes for BitmapScan(ti1): ti1_btree
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_btree)
DETAIL: Conflict scan method hint.
INFO: hint syntax error at or near "IndexScan(ti1 ti1_pkey) BitmapScan(ti1 ti1_btree)"
DETAIL: Conflict scan method hint.
-LOG: available indexes for BitmapScan("ti1"): ti1_btree
+LOG: available indexes for BitmapScan(ti1): ti1_btree
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_btree)
-- No. S-3-13-5
/*+IndexScan(ti1 ti1_pkey)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_pkey
+LOG: available indexes for IndexScan(ti1): ti1_pkey
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_pkey)
-- No. S-3-13-6
/*+IndexScan(ti1 ti1_pkey ti1_btree)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for IndexScan("ti1"): ti1_btree ti1_pkey
+LOG: available indexes for IndexScan(ti1): ti1_btree ti1_pkey
LOG: pg_hint_plan:
used hint:
IndexScan(ti1 ti1_pkey ti1_btree)
-- No. S-3-13-8
/*+BitmapScan(ti1 ti1_pkey)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_pkey
+LOG: available indexes for BitmapScan(ti1): ti1_pkey
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_pkey)
-- No. S-3-13-9
/*+BitmapScan(ti1 ti1_pkey ti1_btree)*/
EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
-LOG: available indexes for BitmapScan("ti1"): ti1_btree ti1_pkey
+LOG: available indexes for BitmapScan(ti1): ti1_btree ti1_pkey
LOG: pg_hint_plan:
used hint:
BitmapScan(ti1 ti1_pkey ti1_btree)