2 SET pg_hint_plan.enable_hint TO on;
3 SET pg_hint_plan.debug_print TO on;
4 SET client_min_messages TO LOG;
5 SET search_path TO public;
6 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
13 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
15 ------------------------------
16 Index Scan using t1_i1 on t1
20 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c3 < 10;
22 ---------------------------------
23 Bitmap Heap Scan on t1
24 Recheck Cond: (c3 < 10)
25 -> Bitmap Index Scan on t1_i
29 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1 AND t1.ctid = '(1,1)';
31 -----------------------------------
33 TID Cond: (ctid = '(1,1)'::tid)
38 ---- No. S-1-1 specified pattern of the object name
42 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
58 EXPLAIN (COSTS false) SELECT * FROM s1.t1 t_1 WHERE t_1.c1 = 1;
67 ----------------------------------
68 Index Scan using t1_i1 on t1 t_1
74 EXPLAIN (COSTS false) SELECT * FROM s1.t1 t_1 WHERE t_1.c1 = 1;
89 ---- No. S-1-2 specified schema name in the hint option
93 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
109 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
118 ------------------------------
119 Index Scan using t1_i1 on t1
124 ---- No. S-1-3 table doesn't exist in the hint option
128 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
144 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
153 ------------------------------
154 Index Scan using t1_i1 on t1
159 ---- No. S-1-4 conflict table name
162 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = 1 AND t1.c1 = t2.c1;
164 ------------------------------------
166 -> Index Scan using t1_i1 on t1
173 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = 1 AND t1.c1 = t2.c1;
182 --------------------------
191 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s2.t1 WHERE s1.t1.c1 = 1 AND s1.t1.c1 = s2.t1.c1;
193 ------------------------------------
195 -> Index Scan using t1_i1 on t1
202 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s2.t1 WHERE s1.t1.c1 = 1 AND s1.t1.c1 = s2.t1.c1;
211 ------------------------------------------
213 -> Bitmap Heap Scan on t1
214 Recheck Cond: (c1 = 1)
215 -> Bitmap Index Scan on t1_i1
217 -> Bitmap Heap Scan on t1
218 Recheck Cond: (c1 = 1)
219 -> Bitmap Index Scan on t1_pkey
224 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s2.t1 s2t1 WHERE s1.t1.c1 = 1 AND s1.t1.c1 = s2t1.c1;
233 ----------------------------------------
235 -> Bitmap Heap Scan on t1
236 Recheck Cond: (c1 = 1)
237 -> Bitmap Index Scan on t1_i1
239 -> Seq Scan on t1 s2t1
243 /*+BitmapScan(s2t1)*/
244 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s2.t1 s2t1 WHERE s1.t1.c1 = 1 AND s1.t1.c1 = s2t1.c1;
253 ------------------------------------------
255 -> Index Scan using t1_i1 on t1
257 -> Bitmap Heap Scan on t1 s2t1
258 Recheck Cond: (c1 = 1)
259 -> Bitmap Index Scan on t1_pkey
264 EXPLAIN (COSTS false) SELECT (SELECT max(c1) FROM s1.t1 WHERE s1.t1.c1 = 1) FROM s1.t1 WHERE s1.t1.c1 = 1;
266 ---------------------------------------------------------------------
267 Index Scan using t1_i1 on t1
269 InitPlan 2 (returns $1)
271 InitPlan 1 (returns $0)
273 -> Index Scan using t1_i1 on t1
274 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
278 EXPLAIN (COSTS false) SELECT (SELECT max(c1) FROM s1.t1 WHERE s1.t1.c1 = 1) FROM s1.t1 WHERE s1.t1.c1 = 1;
287 ---------------------------------------------------------------------------
288 Bitmap Heap Scan on t1
289 Recheck Cond: (c1 = 1)
290 InitPlan 2 (returns $1)
292 InitPlan 1 (returns $0)
294 -> Bitmap Heap Scan on t1
295 Recheck Cond: ((c1 IS NOT NULL) AND (c1 = 1))
296 -> Bitmap Index Scan on t1_i1
297 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
298 -> Bitmap Index Scan on t1_i1
303 EXPLAIN (COSTS false) SELECT (SELECT max(c1) FROM s1.t1 t11 WHERE t11.c1 = 1) FROM s1.t1 t12 WHERE t12.c1 = 1;
312 ---------------------------------------------------------------------------
313 Index Scan using t1_i1 on t1 t12
315 InitPlan 2 (returns $1)
317 InitPlan 1 (returns $0)
319 -> Bitmap Heap Scan on t1 t11
320 Recheck Cond: ((c1 IS NOT NULL) AND (c1 = 1))
321 -> Bitmap Index Scan on t1_i1
322 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
326 EXPLAIN (COSTS false) SELECT (SELECT max(c1) FROM s1.t1 t11 WHERE t11.c1 = 1) FROM s1.t1 t12 WHERE t12.c1 = 1;
335 ---------------------------------------------------------------------
336 Bitmap Heap Scan on t1 t12
337 Recheck Cond: (c1 = 1)
338 InitPlan 2 (returns $1)
340 InitPlan 1 (returns $0)
342 -> Index Scan using t1_i1 on t1 t11
343 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
344 -> Bitmap Index Scan on t1_i1
349 ---- No. S-1-5 object type for the hint
353 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
368 EXPLAIN (COSTS false) SELECT * FROM s1.p1 WHERE p1.c1 = 1;
370 ---------------------------------
375 -> Seq Scan on p1c1 p1
380 EXPLAIN (COSTS false) SELECT * FROM s1.p1 WHERE p1.c1 = 1;
389 ------------------------------------------------
392 -> Index Scan using p1_i on p1
394 -> Index Scan using p1c1_i on p1c1 p1
399 EXPLAIN (COSTS false) SELECT * FROM s1.ul1 WHERE ul1.c1 = 1;
401 ----------------------------------
402 Index Scan using ul1_pkey on ul1
407 EXPLAIN (COSTS false) SELECT * FROM s1.ul1 WHERE ul1.c1 = 1;
422 CREATE TEMP TABLE tm1 (LIKE s1.t1 INCLUDING ALL);
423 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tm1_pkey" for table "tm1"
424 EXPLAIN (COSTS false) SELECT * FROM tm1 WHERE tm1.c1 = 1;
426 ----------------------------------
427 Index Scan using tm1_pkey on tm1
432 EXPLAIN (COSTS false) SELECT * FROM tm1 WHERE tm1.c1 = 1;
447 EXPLAIN (COSTS false) SELECT * FROM pg_catalog.pg_class WHERE oid = 1;
449 -------------------------------------------------
450 Index Scan using pg_class_oid_index on pg_class
451 Index Cond: (oid = 1::oid)
454 /*+SeqScan(pg_class)*/
455 EXPLAIN (COSTS false) SELECT * FROM pg_catalog.pg_class WHERE oid = 1;
464 --------------------------
466 Filter: (oid = 1::oid)
472 EXPLAIN (COSTS false) SELECT * FROM s1.f1() AS ft1 WHERE ft1.c1 = 1;
474 -------------------------
475 Function Scan on f1 ft1
480 EXPLAIN (COSTS false) SELECT * FROM s1.f1() AS ft1 WHERE ft1.c1 = 1;
489 -------------------------
490 Function Scan on f1 ft1
495 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1'), (2,2,2,'2'), (3,3,3,'3')) AS val1 (c1, c2, c3, c4) WHERE val1.c1 = 1;
497 ---------------------------
498 Values Scan on "*VALUES*"
499 Filter: (column1 = 1)
503 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1'), (2,2,2,'2'), (3,3,3,'3')) AS val1 (c1, c2, c3, c4) WHERE val1.c1 = 1;
512 ---------------------------
513 Values Scan on "*VALUES*"
514 Filter: (column1 = 1)
517 /*+SeqScan(*VALUES*)*/
518 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1'), (2,2,2,'2'), (3,3,3,'3')) AS val1 (c1, c2, c3, c4) WHERE val1.c1 = 1;
527 ---------------------------
528 Values Scan on "*VALUES*"
529 Filter: (column1 = 1)
533 EXPLAIN (COSTS false) WITH c1(c1) AS (SELECT max(c1) FROM s1.t1 WHERE t1.c1 = 1)
534 SELECT * FROM s1.t1, c1 WHERE t1.c1 = 1 AND t1.c1 = c1.c1;
536 ---------------------------------------------------------------------
540 InitPlan 1 (returns $0)
542 -> Index Scan using t1_i1 on t1
543 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
544 -> Index Scan using t1_i1 on t1
551 EXPLAIN (COSTS false) WITH c1(c1) AS (SELECT max(c1) FROM s1.t1 WHERE t1.c1 = 1)
552 SELECT * FROM s1.t1, c1 WHERE t1.c1 = 1 AND t1.c1 = c1.c1;
561 ---------------------------------------------------------------------
565 InitPlan 1 (returns $0)
567 -> Index Scan using t1_i1 on t1
568 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
569 -> Index Scan using t1_i1 on t1
576 EXPLAIN (COSTS false) SELECT * FROM s1.v1 WHERE v1.c1 = 1;
578 -----------------------------------
579 Index Scan using t1_i1 on t1 v1t1
584 EXPLAIN (COSTS false) SELECT * FROM s1.v1 WHERE v1.c1 = 1;
593 -----------------------------------
594 Index Scan using t1_i1 on t1 v1t1
599 EXPLAIN (COSTS false) SELECT * FROM (SELECT * FROM s1.t1 WHERE t1.c1 = 1) AS s1 WHERE s1.c1 = 1;
601 ------------------------------
602 Index Scan using t1_i1 on t1
607 EXPLAIN (COSTS false) SELECT * FROM (SELECT * FROM s1.t1 WHERE t1.c1 = 1) AS s1 WHERE s1.c1 = 1;
616 ------------------------------
617 Index Scan using t1_i1 on t1
622 ---- No. S-2-1 complexity query block
625 EXPLAIN (COSTS false)
626 SELECT max(bmt1.c1), (
627 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
629 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
632 -------------------------------------------------------------------
634 InitPlan 1 (returns $0)
637 Merge Cond: (b1t1.c1 = b1t2.c1)
639 Merge Cond: (b1t1.c1 = b1t4.c1)
641 Merge Cond: (b1t1.c1 = b1t3.c1)
642 -> Index Scan using t1_i1 on t1 b1t1
643 -> Index Scan using t3_i1 on t3 b1t3
644 -> Index Scan using t4_i1 on t4 b1t4
647 -> Seq Scan on t2 b1t2
649 Merge Cond: (bmt1.c1 = bmt2.c1)
651 Merge Cond: (bmt1.c1 = bmt4.c1)
653 Merge Cond: (bmt1.c1 = bmt3.c1)
654 -> Index Scan using t1_i1 on t1 bmt1
655 -> Index Scan using t3_i1 on t3 bmt3
656 -> Index Scan using t4_i1 on t4 bmt4
659 -> Seq Scan on t2 bmt2
662 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
663 TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
665 EXPLAIN (COSTS false)
666 SELECT max(bmt1.c1), (
667 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
669 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
675 IndexScan(b1t3 t3_pkey)
676 BitmapScan(b1t4 t4_pkey)
678 IndexScan(bmt2 t2_pkey)
679 BitmapScan(bmt3 t3_pkey)
686 -------------------------------------------------------------------------
688 InitPlan 1 (returns $1)
691 Merge Cond: (b1t1.c1 = b1t2.c1)
694 Merge Cond: (b1t1.c1 = b1t3.c1)
697 -> Seq Scan on t1 b1t1
698 -> Index Scan using t3_pkey on t3 b1t3
699 -> Bitmap Heap Scan on t4 b1t4
700 Recheck Cond: (c1 = b1t1.c1)
701 -> Bitmap Index Scan on t4_pkey
702 Index Cond: (c1 = b1t1.c1)
705 -> Seq Scan on t2 b1t2
707 Hash Cond: (bmt4.c1 = bmt1.c1)
708 -> Seq Scan on t4 bmt4
712 Hash Cond: (bmt1.c1 = bmt2.c1)
713 -> Seq Scan on t1 bmt1
715 -> Index Scan using t2_pkey on t2 bmt2
716 -> Bitmap Heap Scan on t3 bmt3
717 Recheck Cond: (c1 = bmt1.c1)
718 -> Bitmap Index Scan on t3_pkey
719 Index Cond: (c1 = bmt1.c1)
723 EXPLAIN (COSTS false)
724 SELECT max(bmt1.c1), (
725 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
727 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
729 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
732 -------------------------------------------------------------------
734 InitPlan 1 (returns $0)
737 Merge Cond: (b1t1.c1 = b1t2.c1)
739 Merge Cond: (b1t1.c1 = b1t4.c1)
741 Merge Cond: (b1t1.c1 = b1t3.c1)
742 -> Index Scan using t1_i1 on t1 b1t1
743 -> Index Scan using t3_i1 on t3 b1t3
744 -> Index Scan using t4_i1 on t4 b1t4
747 -> Seq Scan on t2 b1t2
748 InitPlan 2 (returns $1)
751 Merge Cond: (b2t1.c1 = b2t2.c1)
753 Merge Cond: (b2t1.c1 = b2t4.c1)
755 Merge Cond: (b2t1.c1 = b2t3.c1)
756 -> Index Scan using t1_i1 on t1 b2t1
757 -> Index Scan using t3_i1 on t3 b2t3
758 -> Index Scan using t4_i1 on t4 b2t4
761 -> Seq Scan on t2 b2t2
763 Merge Cond: (bmt1.c1 = bmt2.c1)
765 Merge Cond: (bmt1.c1 = bmt4.c1)
767 Merge Cond: (bmt1.c1 = bmt3.c1)
768 -> Index Scan using t1_i1 on t1 bmt1
769 -> Index Scan using t3_i1 on t3 bmt3
770 -> Index Scan using t4_i1 on t4 bmt4
773 -> Seq Scan on t2 bmt2
776 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
777 TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
778 BitmapScan(b2t1 t1_pkey)TidScan(b2t2)SeqScan(b2t3)IndexScan(b2t4 t4_pkey)
780 EXPLAIN (COSTS false)
781 SELECT max(bmt1.c1), (
782 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
784 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
786 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
792 IndexScan(b1t3 t3_pkey)
793 BitmapScan(b1t4 t4_pkey)
794 BitmapScan(b2t1 t1_pkey)
797 IndexScan(b2t4 t4_pkey)
799 IndexScan(bmt2 t2_pkey)
800 BitmapScan(bmt3 t3_pkey)
807 ---------------------------------------------------------------------------
809 InitPlan 1 (returns $1)
812 Merge Cond: (b1t1.c1 = b1t2.c1)
815 Merge Cond: (b1t1.c1 = b1t3.c1)
818 -> Seq Scan on t1 b1t1
819 -> Index Scan using t3_pkey on t3 b1t3
820 -> Bitmap Heap Scan on t4 b1t4
821 Recheck Cond: (c1 = b1t1.c1)
822 -> Bitmap Index Scan on t4_pkey
823 Index Cond: (c1 = b1t1.c1)
826 -> Seq Scan on t2 b1t2
827 InitPlan 2 (returns $3)
830 Hash Cond: (b2t3.c1 = b2t1.c1)
831 -> Seq Scan on t3 b2t3
834 Merge Cond: (b2t1.c1 = b2t2.c1)
836 -> Index Scan using t4_pkey on t4 b2t4
837 -> Bitmap Heap Scan on t1 b2t1
838 Recheck Cond: (c1 = b2t4.c1)
839 -> Bitmap Index Scan on t1_pkey
840 Index Cond: (c1 = b2t4.c1)
843 -> Seq Scan on t2 b2t2
845 Hash Cond: (bmt4.c1 = bmt1.c1)
846 -> Seq Scan on t4 bmt4
850 Hash Cond: (bmt1.c1 = bmt2.c1)
851 -> Seq Scan on t1 bmt1
853 -> Index Scan using t2_pkey on t2 bmt2
854 -> Bitmap Heap Scan on t3 bmt3
855 Recheck Cond: (c1 = bmt1.c1)
856 -> Bitmap Index Scan on t3_pkey
857 Index Cond: (c1 = bmt1.c1)
861 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;
863 -----------------------------------------------------------
866 Merge Cond: (bmt1.c1 = bmt2.c1)
868 Merge Cond: (bmt1.c1 = bmt4.c1)
870 Merge Cond: (bmt1.c1 = bmt3.c1)
871 -> Index Scan using t1_i1 on t1 bmt1
872 -> Index Scan using t3_i1 on t3 bmt3
873 -> Index Scan using t4_i1 on t4 bmt4
876 -> Seq Scan on t2 bmt2
879 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
881 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;
885 IndexScan(bmt2 t2_pkey)
886 BitmapScan(bmt3 t3_pkey)
893 -------------------------------------------------------------------------
896 Hash Cond: (bmt4.c1 = bmt1.c1)
897 -> Seq Scan on t4 bmt4
901 Hash Cond: (bmt1.c1 = bmt2.c1)
902 -> Seq Scan on t1 bmt1
904 -> Index Scan using t2_pkey on t2 bmt2
905 -> Bitmap Heap Scan on t3 bmt3
906 Recheck Cond: (c1 = bmt1.c1)
907 -> Bitmap Index Scan on t3_pkey
908 Index Cond: (c1 = bmt1.c1)
912 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;
914 -----------------------------------------------------------
917 Merge Cond: (bmt1.c1 = bmt2.c1)
919 Merge Cond: (bmt1.c1 = bmt4.c1)
921 Merge Cond: (bmt1.c1 = bmt3.c1)
922 -> Index Scan using t1_i1 on t1 bmt1
923 -> Index Scan using t3_i1 on t3 bmt3
924 -> Index Scan using t4_i1 on t4 bmt4
927 -> Seq Scan on t2 bmt2
930 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
932 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;
936 IndexScan(bmt2 t2_pkey)
937 BitmapScan(bmt3 t3_pkey)
944 -------------------------------------------------------------------------
947 Hash Cond: (bmt4.c1 = bmt1.c1)
948 -> Seq Scan on t4 bmt4
952 Hash Cond: (bmt1.c1 = bmt2.c1)
953 -> Seq Scan on t1 bmt1
955 -> Index Scan using t2_pkey on t2 bmt2
956 -> Bitmap Heap Scan on t3 bmt3
957 Recheck Cond: (c1 = bmt1.c1)
958 -> Bitmap Index Scan on t3_pkey
959 Index Cond: (c1 = bmt1.c1)
963 EXPLAIN (COSTS false)
964 SELECT max(bmt1.c1) 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
966 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
970 -------------------------------------------------------------------
972 InitPlan 1 (returns $0)
975 Merge Cond: (b1t1.c1 = b1t2.c1)
977 Merge Cond: (b1t1.c1 = b1t4.c1)
979 Merge Cond: (b1t1.c1 = b1t3.c1)
980 -> Index Scan using t1_i1 on t1 b1t1
981 -> Index Scan using t3_i1 on t3 b1t3
982 -> Index Scan using t4_i1 on t4 b1t4
985 -> Seq Scan on t2 b1t2
987 Merge Cond: (bmt1.c1 = bmt2.c1)
989 Merge Cond: (bmt1.c1 = bmt4.c1)
991 Merge Cond: (bmt1.c1 = bmt3.c1)
992 -> Index Scan using t1_i1 on t1 bmt1
994 -> Index Scan using t3_i1 on t3 bmt3
995 -> Index Scan using t4_i1 on t4 bmt4
998 -> Seq Scan on t2 bmt2
1001 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
1002 TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
1004 EXPLAIN (COSTS false)
1005 SELECT max(bmt1.c1) 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
1007 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
1014 IndexScan(b1t3 t3_pkey)
1015 BitmapScan(b1t4 t4_pkey)
1017 IndexScan(bmt2 t2_pkey)
1018 BitmapScan(bmt3 t3_pkey)
1025 -------------------------------------------------------------------------
1027 InitPlan 1 (returns $1)
1030 Merge Cond: (b1t1.c1 = b1t2.c1)
1033 Merge Cond: (b1t1.c1 = b1t3.c1)
1036 -> Seq Scan on t1 b1t1
1037 -> Index Scan using t3_pkey on t3 b1t3
1038 -> Bitmap Heap Scan on t4 b1t4
1039 Recheck Cond: (c1 = b1t1.c1)
1040 -> Bitmap Index Scan on t4_pkey
1041 Index Cond: (c1 = b1t1.c1)
1044 -> Seq Scan on t2 b1t2
1046 Hash Cond: (bmt4.c1 = bmt1.c1)
1047 -> Seq Scan on t4 bmt4
1051 Hash Cond: (bmt1.c1 = bmt2.c1)
1052 -> Seq Scan on t1 bmt1
1055 -> Index Scan using t2_pkey on t2 bmt2
1056 -> Bitmap Heap Scan on t3 bmt3
1057 Recheck Cond: (c1 = bmt1.c1)
1058 -> Bitmap Index Scan on t3_pkey
1059 Index Cond: (c1 = bmt1.c1)
1063 EXPLAIN (COSTS false)
1064 SELECT max(bmt1.c1) 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
1066 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
1068 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
1072 -------------------------------------------------------------------
1074 InitPlan 1 (returns $0)
1077 Merge Cond: (b1t1.c1 = b1t2.c1)
1079 Merge Cond: (b1t1.c1 = b1t4.c1)
1081 Merge Cond: (b1t1.c1 = b1t3.c1)
1082 -> Index Scan using t1_i1 on t1 b1t1
1083 -> Index Scan using t3_i1 on t3 b1t3
1084 -> Index Scan using t4_i1 on t4 b1t4
1087 -> Seq Scan on t2 b1t2
1088 InitPlan 2 (returns $1)
1091 Merge Cond: (b2t1.c1 = b2t2.c1)
1093 Merge Cond: (b2t1.c1 = b2t4.c1)
1095 Merge Cond: (b2t1.c1 = b2t3.c1)
1096 -> Index Scan using t1_i1 on t1 b2t1
1097 -> Index Scan using t3_i1 on t3 b2t3
1098 -> Index Scan using t4_i1 on t4 b2t4
1101 -> Seq Scan on t2 b2t2
1103 Merge Cond: (bmt1.c1 = bmt2.c1)
1105 Merge Cond: (bmt1.c1 = bmt4.c1)
1107 Merge Cond: (bmt1.c1 = bmt3.c1)
1108 -> Index Scan using t1_i1 on t1 bmt1
1109 Filter: ((c1 <> $0) AND (c1 <> $1))
1110 -> Index Scan using t3_i1 on t3 bmt3
1111 -> Index Scan using t4_i1 on t4 bmt4
1114 -> Seq Scan on t2 bmt2
1117 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
1118 TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
1119 BitmapScan(b2t1 t1_pkey)TidScan(b2t2)SeqScan(b2t3)IndexScan(b2t4 t4_pkey)
1121 EXPLAIN (COSTS false)
1122 SELECT max(bmt1.c1) 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
1124 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
1126 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
1133 IndexScan(b1t3 t3_pkey)
1134 BitmapScan(b1t4 t4_pkey)
1135 BitmapScan(b2t1 t1_pkey)
1138 IndexScan(b2t4 t4_pkey)
1140 IndexScan(bmt2 t2_pkey)
1141 BitmapScan(bmt3 t3_pkey)
1148 ---------------------------------------------------------------------------
1150 InitPlan 1 (returns $1)
1153 Merge Cond: (b1t1.c1 = b1t2.c1)
1156 Merge Cond: (b1t1.c1 = b1t3.c1)
1159 -> Seq Scan on t1 b1t1
1160 -> Index Scan using t3_pkey on t3 b1t3
1161 -> Bitmap Heap Scan on t4 b1t4
1162 Recheck Cond: (c1 = b1t1.c1)
1163 -> Bitmap Index Scan on t4_pkey
1164 Index Cond: (c1 = b1t1.c1)
1167 -> Seq Scan on t2 b1t2
1168 InitPlan 2 (returns $3)
1171 Hash Cond: (b2t3.c1 = b2t1.c1)
1172 -> Seq Scan on t3 b2t3
1175 Merge Cond: (b2t1.c1 = b2t2.c1)
1177 -> Index Scan using t4_pkey on t4 b2t4
1178 -> Bitmap Heap Scan on t1 b2t1
1179 Recheck Cond: (c1 = b2t4.c1)
1180 -> Bitmap Index Scan on t1_pkey
1181 Index Cond: (c1 = b2t4.c1)
1184 -> Seq Scan on t2 b2t2
1186 Hash Cond: (bmt4.c1 = bmt1.c1)
1187 -> Seq Scan on t4 bmt4
1191 Hash Cond: (bmt1.c1 = bmt2.c1)
1192 -> Seq Scan on t1 bmt1
1193 Filter: ((c1 <> $1) AND (c1 <> $3))
1195 -> Index Scan using t2_pkey on t2 bmt2
1196 -> Bitmap Heap Scan on t3 bmt3
1197 Recheck Cond: (c1 = bmt1.c1)
1198 -> Bitmap Index Scan on t3_pkey
1199 Index Cond: (c1 = bmt1.c1)
1203 EXPLAIN (COSTS false)
1205 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
1207 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4
1209 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
1213 -------------------------------------------------------------------
1218 Merge Cond: (b1t1.c1 = b1t2.c1)
1220 Merge Cond: (b1t1.c1 = b1t4.c1)
1222 Merge Cond: (b1t1.c1 = b1t3.c1)
1223 -> Index Scan using t1_i1 on t1 b1t1
1224 -> Index Scan using t3_i1 on t3 b1t3
1225 -> Index Scan using t4_i1 on t4 b1t4
1228 -> Seq Scan on t2 b1t2
1230 Merge Cond: (bmt1.c1 = bmt2.c1)
1232 Merge Cond: (bmt1.c1 = bmt4.c1)
1234 Merge Cond: (bmt1.c1 = bmt3.c1)
1235 -> Index Scan using t1_i1 on t1 bmt1
1236 -> Index Scan using t3_i1 on t3 bmt3
1237 -> Index Scan using t4_i1 on t4 bmt4
1241 Hash Cond: (bmt2.c1 = c1.c1)
1242 -> Seq Scan on t2 bmt2
1247 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
1248 TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
1250 EXPLAIN (COSTS false)
1252 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
1254 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4
1256 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
1263 IndexScan(b1t3 t3_pkey)
1264 BitmapScan(b1t4 t4_pkey)
1266 IndexScan(bmt2 t2_pkey)
1267 BitmapScan(bmt3 t3_pkey)
1274 ---------------------------------------------------------------------
1279 Merge Cond: (b1t1.c1 = b1t2.c1)
1282 Merge Cond: (b1t1.c1 = b1t3.c1)
1285 -> Seq Scan on t1 b1t1
1286 -> Index Scan using t3_pkey on t3 b1t3
1287 -> Bitmap Heap Scan on t4 b1t4
1288 Recheck Cond: (c1 = b1t1.c1)
1289 -> Bitmap Index Scan on t4_pkey
1290 Index Cond: (c1 = b1t1.c1)
1293 -> Seq Scan on t2 b1t2
1295 Hash Cond: (bmt4.c1 = bmt1.c1)
1296 -> Seq Scan on t4 bmt4
1301 Hash Cond: (bmt1.c1 = c1.c1)
1302 -> Seq Scan on t1 bmt1
1305 -> Index Scan using t2_pkey on t2 bmt2
1306 Index Cond: (c1 = bmt1.c1)
1307 -> Bitmap Heap Scan on t3 bmt3
1308 Recheck Cond: (c1 = bmt1.c1)
1309 -> Bitmap Index Scan on t3_pkey
1310 Index Cond: (c1 = bmt1.c1)
1314 EXPLAIN (COSTS false)
1316 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
1319 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
1321 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4
1323 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
1328 -------------------------------------------------------------------
1333 Merge Cond: (b1t1.c1 = b1t2.c1)
1335 Merge Cond: (b1t1.c1 = b1t4.c1)
1337 Merge Cond: (b1t1.c1 = b1t3.c1)
1338 -> Index Scan using t1_i1 on t1 b1t1
1339 -> Index Scan using t3_i1 on t3 b1t3
1340 -> Index Scan using t4_i1 on t4 b1t4
1343 -> Seq Scan on t2 b1t2
1347 Merge Cond: (b2t1.c1 = b2t2.c1)
1349 Merge Cond: (b2t1.c1 = b2t4.c1)
1351 Merge Cond: (b2t1.c1 = b2t3.c1)
1352 -> Index Scan using t1_i1 on t1 b2t1
1353 -> Index Scan using t3_i1 on t3 b2t3
1354 -> Index Scan using t4_i1 on t4 b2t4
1357 -> Seq Scan on t2 b2t2
1359 Join Filter: (bmt1.c1 = c2.c1)
1361 Merge Cond: (bmt1.c1 = bmt2.c1)
1363 Merge Cond: (bmt1.c1 = bmt4.c1)
1365 Merge Cond: (bmt1.c1 = bmt3.c1)
1366 -> Index Scan using t1_i1 on t1 bmt1
1367 -> Index Scan using t3_i1 on t3 bmt3
1368 -> Index Scan using t4_i1 on t4 bmt4
1372 Hash Cond: (bmt2.c1 = c1.c1)
1373 -> Seq Scan on t2 bmt2
1379 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
1380 TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
1381 BitmapScan(b2t1 t1_pkey)TidScan(b2t2)SeqScan(b2t3)IndexScan(b2t4 t4_pkey)
1383 EXPLAIN (COSTS false)
1385 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
1388 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
1390 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4
1392 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
1400 IndexScan(b1t3 t3_pkey)
1401 BitmapScan(b1t4 t4_pkey)
1402 BitmapScan(b2t1 t1_pkey)
1405 IndexScan(b2t4 t4_pkey)
1407 IndexScan(bmt2 t2_pkey)
1408 BitmapScan(bmt3 t3_pkey)
1415 ---------------------------------------------------------------------------
1420 Merge Cond: (b1t1.c1 = b1t2.c1)
1423 Merge Cond: (b1t1.c1 = b1t3.c1)
1426 -> Seq Scan on t1 b1t1
1427 -> Index Scan using t3_pkey on t3 b1t3
1428 -> Bitmap Heap Scan on t4 b1t4
1429 Recheck Cond: (c1 = b1t1.c1)
1430 -> Bitmap Index Scan on t4_pkey
1431 Index Cond: (c1 = b1t1.c1)
1434 -> Seq Scan on t2 b1t2
1438 Hash Cond: (b2t3.c1 = b2t1.c1)
1439 -> Seq Scan on t3 b2t3
1442 Merge Cond: (b2t1.c1 = b2t2.c1)
1444 -> Index Scan using t4_pkey on t4 b2t4
1445 -> Bitmap Heap Scan on t1 b2t1
1446 Recheck Cond: (c1 = b2t4.c1)
1447 -> Bitmap Index Scan on t1_pkey
1448 Index Cond: (c1 = b2t4.c1)
1451 -> Seq Scan on t2 b2t2
1453 Hash Cond: (bmt4.c1 = bmt1.c1)
1454 -> Seq Scan on t4 bmt4
1458 Join Filter: (bmt1.c1 = c2.c1)
1461 Hash Cond: (bmt1.c1 = c1.c1)
1462 -> Seq Scan on t1 bmt1
1465 -> Index Scan using t2_pkey on t2 bmt2
1466 Index Cond: (c1 = bmt1.c1)
1468 -> Bitmap Heap Scan on t3 bmt3
1469 Recheck Cond: (c1 = bmt1.c1)
1470 -> Bitmap Index Scan on t3_pkey
1471 Index Cond: (c1 = bmt1.c1)
1475 ---- No. S-2-2 the number of the tables per quiry block
1478 EXPLAIN (COSTS false)
1480 SELECT max(b1t1.c1) FROM s1.t1 b1t1 WHERE b1t1.ctid = '(1,1)' AND b1t1.c1 = 1
1482 SELECT max(bmt1.c1), (
1483 SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.ctid = '(1,1)' AND b2t1.c1 = 1
1485 FROM s1.t1 bmt1, c1 WHERE bmt1.ctid = '(1,1)' AND bmt1.c1 = 1
1487 SELECT max(b3t1.c1) FROM s1.t1 b3t1 WHERE b3t1.ctid = '(1,1)' AND b3t1.c1 = 1
1491 -----------------------------------------------------------------
1495 InitPlan 1 (returns $0)
1497 -> Tid Scan on t1 b1t1
1498 TID Cond: (ctid = '(1,1)'::tid)
1499 Filter: ((c1 IS NOT NULL) AND (c1 = 1))
1500 InitPlan 4 (returns $3)
1502 InitPlan 3 (returns $2)
1504 -> Tid Scan on t1 b2t1
1505 TID Cond: (ctid = '(1,1)'::tid)
1506 Filter: ((c1 IS NOT NULL) AND (c1 = 1))
1507 InitPlan 6 (returns $5)
1509 InitPlan 5 (returns $4)
1511 -> Tid Scan on t1 b3t1
1512 TID Cond: (ctid = '(1,1)'::tid)
1513 Filter: ((c1 IS NOT NULL) AND (c1 = 1))
1515 -> Tid Scan on t1 bmt1
1516 TID Cond: (ctid = '(1,1)'::tid)
1517 Filter: ((c1 <> $5) AND (c1 = 1))
1523 BitmapScan(b2t1 t1_pkey)
1524 IndexScan(b3t1 t1_pkey)
1526 EXPLAIN (COSTS false)
1528 SELECT max(b1t1.c1) FROM s1.t1 b1t1 WHERE b1t1.ctid = '(1,1)' AND b1t1.c1 = 1
1530 SELECT max(bmt1.c1), (
1531 SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.ctid = '(1,1)' AND b2t1.c1 = 1
1533 FROM s1.t1 bmt1, c1 WHERE bmt1.ctid = '(1,1)' AND bmt1.c1 = 1
1535 SELECT max(b3t1.c1) FROM s1.t1 b3t1 WHERE b3t1.ctid = '(1,1)' AND b3t1.c1 = 1
1541 BitmapScan(b2t1 t1_pkey)
1542 IndexScan(b3t1 t1_pkey)
1549 ---------------------------------------------------------------------------
1553 InitPlan 1 (returns $0)
1555 -> Tid Scan on t1 b1t1
1556 TID Cond: (ctid = '(1,1)'::tid)
1557 Filter: ((c1 IS NOT NULL) AND (c1 = 1))
1558 InitPlan 4 (returns $3)
1560 InitPlan 3 (returns $2)
1562 -> Bitmap Heap Scan on t1 b2t1
1563 Recheck Cond: ((c1 IS NOT NULL) AND (c1 = 1))
1564 Filter: (ctid = '(1,1)'::tid)
1565 -> Bitmap Index Scan on t1_pkey
1566 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
1567 InitPlan 6 (returns $5)
1569 InitPlan 5 (returns $4)
1571 -> Index Scan using t1_pkey on t1 b3t1
1572 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
1573 Filter: (ctid = '(1,1)'::tid)
1575 -> Seq Scan on t1 bmt1
1576 Filter: ((c1 <> $5) AND (ctid = '(1,1)'::tid) AND (c1 = 1))
1581 EXPLAIN (COSTS false)
1583 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2 WHERE b1t1.ctid = '(1,1)' AND b1t1.c1 = b1t2.c1 AND b1t2.ctid = '(1,1)'
1585 SELECT max(bmt1.c1), (
1586 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2 WHERE b2t1.ctid = '(1,1)' AND b2t1.c1 = b2t2.c1 AND b2t2.ctid = '(1,1)'
1588 FROM s1.t1 bmt1, s1.t2 bmt2, c1 WHERE bmt1.ctid = '(1,1)' AND bmt1.c1 = bmt2.c1 AND bmt2.ctid = '(1,1)'
1590 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)'
1594 -------------------------------------------------------
1599 Join Filter: (b1t1.c1 = b1t2.c1)
1600 -> Tid Scan on t1 b1t1
1601 TID Cond: (ctid = '(1,1)'::tid)
1602 -> Seq Scan on t2 b1t2
1603 Filter: (ctid = '(1,1)'::tid)
1604 InitPlan 2 (returns $1)
1607 Join Filter: (b2t1.c1 = b2t2.c1)
1608 -> Tid Scan on t1 b2t1
1609 TID Cond: (ctid = '(1,1)'::tid)
1610 -> Seq Scan on t2 b2t2
1611 Filter: (ctid = '(1,1)'::tid)
1612 InitPlan 3 (returns $2)
1615 Join Filter: (b3t1.c1 = b3t2.c1)
1616 -> Tid Scan on t1 b3t1
1617 TID Cond: (ctid = '(1,1)'::tid)
1618 -> Seq Scan on t2 b3t2
1619 Filter: (ctid = '(1,1)'::tid)
1622 Join Filter: (bmt1.c1 = bmt2.c1)
1623 -> Tid Scan on t1 bmt1
1624 TID Cond: (ctid = '(1,1)'::tid)
1626 -> Seq Scan on t2 bmt2
1627 Filter: (ctid = '(1,1)'::tid)
1631 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)
1632 TidScan(b1t1)SeqScan(b1t2)
1633 BitmapScan(b2t1 t1_pkey)TidScan(b2t2)
1634 IndexScan(b3t1 t1_pkey)BitmapScan(b3t2 t2_pkey)
1636 EXPLAIN (COSTS false)
1638 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2 WHERE b1t1.ctid = '(1,1)' AND b1t1.c1 = b1t2.c1 AND b1t2.ctid = '(1,1)'
1640 SELECT max(bmt1.c1), (
1641 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2 WHERE b2t1.ctid = '(1,1)' AND b2t1.c1 = b2t2.c1 AND b2t2.ctid = '(1,1)'
1643 FROM s1.t1 bmt1, s1.t2 bmt2, c1 WHERE bmt1.ctid = '(1,1)' AND bmt1.c1 = bmt2.c1 AND bmt2.ctid = '(1,1)'
1645 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)'
1652 BitmapScan(b2t1 t1_pkey)
1654 IndexScan(b3t1 t1_pkey)
1655 BitmapScan(b3t2 t2_pkey)
1657 IndexScan(bmt2 t2_pkey)
1663 --------------------------------------------------------------------
1668 Join Filter: (b1t1.c1 = b1t2.c1)
1669 -> Tid Scan on t1 b1t1
1670 TID Cond: (ctid = '(1,1)'::tid)
1671 -> Seq Scan on t2 b1t2
1672 Filter: (ctid = '(1,1)'::tid)
1673 InitPlan 2 (returns $2)
1676 -> Tid Scan on t2 b2t2
1677 TID Cond: (ctid = '(1,1)'::tid)
1678 -> Bitmap Heap Scan on t1 b2t1
1679 Recheck Cond: (c1 = b2t2.c1)
1680 Filter: (ctid = '(1,1)'::tid)
1681 -> Bitmap Index Scan on t1_pkey
1682 Index Cond: (c1 = b2t2.c1)
1683 InitPlan 3 (returns $4)
1686 -> Index Scan using t1_pkey on t1 b3t1
1687 Filter: (ctid = '(1,1)'::tid)
1688 -> Bitmap Heap Scan on t2 b3t2
1689 Recheck Cond: (c1 = b3t1.c1)
1690 Filter: (ctid = '(1,1)'::tid)
1691 -> Bitmap Index Scan on t2_pkey
1692 Index Cond: (c1 = b3t1.c1)
1695 -> Seq Scan on t1 bmt1
1696 Filter: ((c1 <> $4) AND (ctid = '(1,1)'::tid))
1697 -> Index Scan using t2_pkey on t2 bmt2
1698 Index Cond: (c1 = bmt1.c1)
1699 Filter: (ctid = '(1,1)'::tid)
1704 EXPLAIN (COSTS false)
1706 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.ctid = '(1,1)' AND b1t1.c1 = b1t2.c1 AND b1t2.ctid = '(1,1)' AND b1t1.c1 = b1t3.c1 AND b1t3.ctid = '(1,1)' AND b1t1.c1 = b1t4.c1 AND b1t4.ctid = '(1,1)'
1708 SELECT max(bmt1.c1), (
1709 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.ctid = '(1,1)' AND b2t1.c1 = b2t2.c1 AND b2t2.ctid = '(1,1)' AND b2t1.c1 = b2t3.c1 AND b2t3.ctid = '(1,1)' AND b2t1.c1 = b2t4.c1 AND b2t4.ctid = '(1,1)'
1711 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4, c1 WHERE bmt1.ctid = '(1,1)' AND bmt1.c1 = bmt2.c1 AND bmt2.ctid = '(1,1)' AND bmt1.c1 = bmt3.c1 AND bmt3.ctid = '(1,1)' AND bmt1.c1 = bmt4.c1 AND bmt4.ctid = '(1,1)' AND bmt1.c1 = c1.c1
1713 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)'
1717 -------------------------------------------------------------------
1722 Join Filter: (b1t1.c1 = b1t4.c1)
1724 Join Filter: (b1t1.c1 = b1t3.c1)
1726 Join Filter: (b1t1.c1 = b1t2.c1)
1727 -> Tid Scan on t1 b1t1
1728 TID Cond: (ctid = '(1,1)'::tid)
1729 -> Seq Scan on t2 b1t2
1730 Filter: (ctid = '(1,1)'::tid)
1731 -> Tid Scan on t3 b1t3
1732 TID Cond: (ctid = '(1,1)'::tid)
1733 -> Tid Scan on t4 b1t4
1734 TID Cond: (ctid = '(1,1)'::tid)
1735 InitPlan 2 (returns $1)
1738 Join Filter: (b2t1.c1 = b2t4.c1)
1740 Join Filter: (b2t1.c1 = b2t3.c1)
1742 Join Filter: (b2t1.c1 = b2t2.c1)
1743 -> Tid Scan on t1 b2t1
1744 TID Cond: (ctid = '(1,1)'::tid)
1745 -> Seq Scan on t2 b2t2
1746 Filter: (ctid = '(1,1)'::tid)
1747 -> Tid Scan on t3 b2t3
1748 TID Cond: (ctid = '(1,1)'::tid)
1749 -> Tid Scan on t4 b2t4
1750 TID Cond: (ctid = '(1,1)'::tid)
1751 InitPlan 3 (returns $2)
1754 Join Filter: (b3t1.c1 = b3t4.c1)
1756 Join Filter: (b3t1.c1 = b3t3.c1)
1758 Join Filter: (b3t1.c1 = b3t2.c1)
1759 -> Tid Scan on t1 b3t1
1760 TID Cond: (ctid = '(1,1)'::tid)
1761 -> Seq Scan on t2 b3t2
1762 Filter: (ctid = '(1,1)'::tid)
1763 -> Tid Scan on t3 b3t3
1764 TID Cond: (ctid = '(1,1)'::tid)
1765 -> Tid Scan on t4 b3t4
1766 TID Cond: (ctid = '(1,1)'::tid)
1768 Join Filter: (bmt1.c1 = c1.c1)
1770 Join Filter: (bmt1.c1 = bmt2.c1)
1772 Join Filter: (bmt3.c1 = bmt1.c1)
1774 Join Filter: (bmt3.c1 = bmt4.c1)
1775 -> Tid Scan on t3 bmt3
1776 TID Cond: (ctid = '(1,1)'::tid)
1777 -> Tid Scan on t4 bmt4
1778 TID Cond: (ctid = '(1,1)'::tid)
1779 -> Tid Scan on t1 bmt1
1780 TID Cond: (ctid = '(1,1)'::tid)
1782 -> Seq Scan on t2 bmt2
1783 Filter: (ctid = '(1,1)'::tid)
1787 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
1788 TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
1789 BitmapScan(b2t1 t1_pkey)TidScan(b2t2)SeqScan(b2t3)IndexScan(b2t4 t4_pkey)
1790 IndexScan(b3t1 t1_pkey)BitmapScan(b3t2 t2_pkey)TidScan(b3t3)SeqScan(b3t4)
1792 EXPLAIN (COSTS false)
1794 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.ctid = '(1,1)' AND b1t1.c1 = b1t2.c1 AND b1t2.ctid = '(1,1)' AND b1t1.c1 = b1t3.c1 AND b1t3.ctid = '(1,1)' AND b1t1.c1 = b1t4.c1 AND b1t4.ctid = '(1,1)'
1796 SELECT max(bmt1.c1), (
1797 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.ctid = '(1,1)' AND b2t1.c1 = b2t2.c1 AND b2t2.ctid = '(1,1)' AND b2t1.c1 = b2t3.c1 AND b2t3.ctid = '(1,1)' AND b2t1.c1 = b2t4.c1 AND b2t4.ctid = '(1,1)'
1799 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4, c1 WHERE bmt1.ctid = '(1,1)' AND bmt1.c1 = bmt2.c1 AND bmt2.ctid = '(1,1)' AND bmt1.c1 = bmt3.c1 AND bmt3.ctid = '(1,1)' AND bmt1.c1 = bmt4.c1 AND bmt4.ctid = '(1,1)' AND bmt1.c1 = c1.c1
1801 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)'
1808 IndexScan(b1t3 t3_pkey)
1809 BitmapScan(b1t4 t4_pkey)
1810 BitmapScan(b2t1 t1_pkey)
1813 IndexScan(b2t4 t4_pkey)
1814 IndexScan(b3t1 t1_pkey)
1815 BitmapScan(b3t2 t2_pkey)
1819 IndexScan(bmt2 t2_pkey)
1820 BitmapScan(bmt3 t3_pkey)
1827 --------------------------------------------------------------------------------
1834 Join Filter: (b1t1.c1 = b1t2.c1)
1835 -> Tid Scan on t1 b1t1
1836 TID Cond: (ctid = '(1,1)'::tid)
1837 -> Seq Scan on t2 b1t2
1838 Filter: (ctid = '(1,1)'::tid)
1839 -> Index Scan using t3_pkey on t3 b1t3
1840 Index Cond: (c1 = b1t1.c1)
1841 Filter: (ctid = '(1,1)'::tid)
1842 -> Bitmap Heap Scan on t4 b1t4
1843 Recheck Cond: (c1 = b1t1.c1)
1844 Filter: (ctid = '(1,1)'::tid)
1845 -> Bitmap Index Scan on t4_pkey
1846 Index Cond: (c1 = b1t1.c1)
1847 InitPlan 2 (returns $3)
1851 Join Filter: (b2t1.c1 = b2t3.c1)
1853 -> Tid Scan on t2 b2t2
1854 TID Cond: (ctid = '(1,1)'::tid)
1855 -> Bitmap Heap Scan on t1 b2t1
1856 Recheck Cond: (c1 = b2t2.c1)
1857 Filter: (ctid = '(1,1)'::tid)
1858 -> Bitmap Index Scan on t1_pkey
1859 Index Cond: (c1 = b2t2.c1)
1860 -> Seq Scan on t3 b2t3
1861 Filter: (ctid = '(1,1)'::tid)
1862 -> Index Scan using t4_pkey on t4 b2t4
1863 Index Cond: (c1 = b2t1.c1)
1864 Filter: (ctid = '(1,1)'::tid)
1865 InitPlan 3 (returns $5)
1870 Join Filter: (b3t3.c1 = b3t4.c1)
1871 -> Tid Scan on t3 b3t3
1872 TID Cond: (ctid = '(1,1)'::tid)
1873 -> Seq Scan on t4 b3t4
1874 Filter: (ctid = '(1,1)'::tid)
1875 -> Bitmap Heap Scan on t2 b3t2
1876 Recheck Cond: (c1 = b3t3.c1)
1877 Filter: (ctid = '(1,1)'::tid)
1878 -> Bitmap Index Scan on t2_pkey
1879 Index Cond: (c1 = b3t3.c1)
1880 -> Index Scan using t1_pkey on t1 b3t1
1881 Index Cond: (c1 = b3t2.c1)
1882 Filter: (ctid = '(1,1)'::tid)
1885 Join Filter: (bmt1.c1 = c1.c1)
1887 Join Filter: (bmt1.c1 = bmt4.c1)
1889 -> Seq Scan on t1 bmt1
1890 Filter: ((c1 <> $5) AND (ctid = '(1,1)'::tid))
1891 -> Bitmap Heap Scan on t3 bmt3
1892 Recheck Cond: (c1 = bmt1.c1)
1893 Filter: (ctid = '(1,1)'::tid)
1894 -> Bitmap Index Scan on t3_pkey
1895 Index Cond: (c1 = bmt1.c1)
1896 -> Tid Scan on t4 bmt4
1897 TID Cond: (ctid = '(1,1)'::tid)
1899 -> Index Scan using t2_pkey on t2 bmt2
1900 Index Cond: (c1 = bmt1.c1)
1901 Filter: (ctid = '(1,1)'::tid)
1905 EXPLAIN (COSTS false)
1907 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.ctid = '(1,1)' AND b1t1.c1 = b1t2.c1 AND b1t2.ctid = '(1,1)' AND b1t1.c1 = b1t3.c1 AND b1t3.ctid = '(1,1)' AND b1t1.c1 = b1t4.c1 AND b1t4.ctid = '(1,1)'
1909 SELECT max(bmt1.c1), (
1910 SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.ctid = '(1,1)' AND b2t1.c1 = 1
1912 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4, c1 WHERE bmt1.ctid = '(1,1)' AND bmt1.c1 = bmt2.c1 AND bmt2.ctid = '(1,1)' AND bmt1.c1 = bmt3.c1 AND bmt3.ctid = '(1,1)' AND bmt1.c1 = bmt4.c1 AND bmt4.ctid = '(1,1)' AND bmt1.c1 = c1.c1
1914 SELECT max(b3t1.c1) FROM s1.t1 b3t1 WHERE b3t1.ctid = '(1,1)'
1918 -------------------------------------------------------------------
1923 Join Filter: (b1t1.c1 = b1t4.c1)
1925 Join Filter: (b1t1.c1 = b1t3.c1)
1927 Join Filter: (b1t1.c1 = b1t2.c1)
1928 -> Tid Scan on t1 b1t1
1929 TID Cond: (ctid = '(1,1)'::tid)
1930 -> Seq Scan on t2 b1t2
1931 Filter: (ctid = '(1,1)'::tid)
1932 -> Tid Scan on t3 b1t3
1933 TID Cond: (ctid = '(1,1)'::tid)
1934 -> Tid Scan on t4 b1t4
1935 TID Cond: (ctid = '(1,1)'::tid)
1936 InitPlan 3 (returns $2)
1938 InitPlan 2 (returns $1)
1940 -> Tid Scan on t1 b2t1
1941 TID Cond: (ctid = '(1,1)'::tid)
1942 Filter: ((c1 IS NOT NULL) AND (c1 = 1))
1943 InitPlan 4 (returns $3)
1945 -> Tid Scan on t1 b3t1
1946 TID Cond: (ctid = '(1,1)'::tid)
1948 Join Filter: (bmt1.c1 = c1.c1)
1950 Join Filter: (bmt1.c1 = bmt2.c1)
1952 Join Filter: (bmt3.c1 = bmt1.c1)
1954 Join Filter: (bmt3.c1 = bmt4.c1)
1955 -> Tid Scan on t3 bmt3
1956 TID Cond: (ctid = '(1,1)'::tid)
1957 -> Tid Scan on t4 bmt4
1958 TID Cond: (ctid = '(1,1)'::tid)
1959 -> Tid Scan on t1 bmt1
1960 TID Cond: (ctid = '(1,1)'::tid)
1962 -> Seq Scan on t2 bmt2
1963 Filter: (ctid = '(1,1)'::tid)
1967 /*+SeqScan(bmt1)IndexScan(bmt2 t2_pkey)BitmapScan(bmt3 t3_pkey)TidScan(bmt4)
1968 TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
1969 BitmapScan(b2t1 t1_pkey)
1970 IndexScan(b3t1 t1_pkey)
1972 EXPLAIN (COSTS false)
1974 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.ctid = '(1,1)' AND b1t1.c1 = b1t2.c1 AND b1t2.ctid = '(1,1)' AND b1t1.c1 = b1t3.c1 AND b1t3.ctid = '(1,1)' AND b1t1.c1 = b1t4.c1 AND b1t4.ctid = '(1,1)'
1976 SELECT max(bmt1.c1), (
1977 SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.ctid = '(1,1)' AND b2t1.c1 = 1
1979 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4, c1 WHERE bmt1.ctid = '(1,1)' AND bmt1.c1 = bmt2.c1 AND bmt2.ctid = '(1,1)' AND bmt1.c1 = bmt3.c1 AND bmt3.ctid = '(1,1)' AND bmt1.c1 = bmt4.c1 AND bmt4.ctid = '(1,1)' AND bmt1.c1 = c1.c1
1981 SELECT max(b3t1.c1) FROM s1.t1 b3t1 WHERE b3t1.ctid = '(1,1)'
1988 IndexScan(b1t3 t3_pkey)
1989 BitmapScan(b1t4 t4_pkey)
1990 BitmapScan(b2t1 t1_pkey)
1991 IndexScan(b3t1 t1_pkey)
1993 IndexScan(bmt2 t2_pkey)
1994 BitmapScan(bmt3 t3_pkey)
2001 --------------------------------------------------------------------------------
2008 Join Filter: (b1t1.c1 = b1t2.c1)
2009 -> Tid Scan on t1 b1t1
2010 TID Cond: (ctid = '(1,1)'::tid)
2011 -> Seq Scan on t2 b1t2
2012 Filter: (ctid = '(1,1)'::tid)
2013 -> Index Scan using t3_pkey on t3 b1t3
2014 Index Cond: (c1 = b1t1.c1)
2015 Filter: (ctid = '(1,1)'::tid)
2016 -> Bitmap Heap Scan on t4 b1t4
2017 Recheck Cond: (c1 = b1t1.c1)
2018 Filter: (ctid = '(1,1)'::tid)
2019 -> Bitmap Index Scan on t4_pkey
2020 Index Cond: (c1 = b1t1.c1)
2021 InitPlan 3 (returns $3)
2023 InitPlan 2 (returns $2)
2025 -> Bitmap Heap Scan on t1 b2t1
2026 Recheck Cond: ((c1 IS NOT NULL) AND (c1 = 1))
2027 Filter: (ctid = '(1,1)'::tid)
2028 -> Bitmap Index Scan on t1_pkey
2029 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
2030 InitPlan 5 (returns $5)
2032 InitPlan 4 (returns $4)
2034 -> Index Scan Backward using t1_pkey on t1 b3t1
2035 Index Cond: (c1 IS NOT NULL)
2036 Filter: (ctid = '(1,1)'::tid)
2039 Join Filter: (bmt1.c1 = c1.c1)
2041 Join Filter: (bmt1.c1 = bmt4.c1)
2043 -> Seq Scan on t1 bmt1
2044 Filter: ((c1 <> $5) AND (ctid = '(1,1)'::tid))
2045 -> Bitmap Heap Scan on t3 bmt3
2046 Recheck Cond: (c1 = bmt1.c1)
2047 Filter: (ctid = '(1,1)'::tid)
2048 -> Bitmap Index Scan on t3_pkey
2049 Index Cond: (c1 = bmt1.c1)
2050 -> Tid Scan on t4 bmt4
2051 TID Cond: (ctid = '(1,1)'::tid)
2053 -> Index Scan using t2_pkey on t2 bmt2
2054 Index Cond: (c1 = bmt1.c1)
2055 Filter: (ctid = '(1,1)'::tid)
2059 ---- No. S-2-3 RULE definition table
2062 EXPLAIN (COSTS false) UPDATE s1.r1 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2064 -----------------------------------------------------------------
2067 Join Filter: (t1.c1 = t4.c1)
2069 Join Filter: (t1.c1 = t3.c1)
2071 Join Filter: (t2.c1 = t1.c1)
2074 TID Cond: (ctid = '(1,1)'::tid)
2077 Filter: (ctid = '(1,1)'::tid)
2079 TID Cond: (ctid = '(1,1)'::tid)
2081 TID Cond: (ctid = '(1,1)'::tid)
2083 TID Cond: (ctid = '(1,1)'::tid)
2086 /*+TidScan(t1)SeqScan(t2)IndexScan(t3 t3_pkey)BitmapScan(t4 t4_pkey)
2088 EXPLAIN (COSTS false) UPDATE s1.r1 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2094 IndexScan(t3 t3_pkey)
2095 BitmapScan(t4 t4_pkey)
2101 ------------------------------------------------------------------------
2105 Join Filter: (t2.c1 = t1.c1)
2109 Filter: (ctid = '(1,1)'::tid)
2110 -> Index Scan using t3_pkey on t3
2111 Index Cond: (c1 = t2.c1)
2112 Filter: (ctid = '(1,1)'::tid)
2114 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2116 TID Cond: (ctid = '(1,1)'::tid)
2117 -> Bitmap Heap Scan on t4
2118 Recheck Cond: (c1 = t1.c1)
2119 Filter: (ctid = '(1,1)'::tid)
2120 -> Bitmap Index Scan on t4_pkey
2121 Index Cond: (c1 = t1.c1)
2124 EXPLAIN (COSTS false) UPDATE s1.r1_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2126 -----------------------------------------------------------------
2129 Join Filter: (b1t1.c1 = b1t4.c1)
2131 Join Filter: (b1t1.c1 = b1t3.c1)
2133 Join Filter: (b1t2.c1 = b1t1.c1)
2136 TID Cond: (ctid = '(1,1)'::tid)
2138 -> Seq Scan on t2 b1t2
2139 Filter: (ctid = '(1,1)'::tid)
2140 -> Tid Scan on t1 b1t1
2141 TID Cond: (ctid = '(1,1)'::tid)
2142 -> Tid Scan on t3 b1t3
2143 TID Cond: (ctid = '(1,1)'::tid)
2144 -> Tid Scan on t4 b1t4
2145 TID Cond: (ctid = '(1,1)'::tid)
2148 /*+TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
2150 EXPLAIN (COSTS false) UPDATE s1.r1_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2155 IndexScan(b1t3 t3_pkey)
2156 BitmapScan(b1t4 t4_pkey)
2163 ------------------------------------------------------------------------
2167 Join Filter: (b1t2.c1 = b1t1.c1)
2170 -> Seq Scan on t2 b1t2
2171 Filter: (ctid = '(1,1)'::tid)
2172 -> Index Scan using t3_pkey on t3 b1t3
2173 Index Cond: (c1 = b1t2.c1)
2174 Filter: (ctid = '(1,1)'::tid)
2176 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2177 -> Tid Scan on t1 b1t1
2178 TID Cond: (ctid = '(1,1)'::tid)
2179 -> Bitmap Heap Scan on t4 b1t4
2180 Recheck Cond: (c1 = b1t1.c1)
2181 Filter: (ctid = '(1,1)'::tid)
2182 -> Bitmap Index Scan on t4_pkey
2183 Index Cond: (c1 = b1t1.c1)
2187 EXPLAIN (COSTS false) UPDATE s1.r2 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2189 -----------------------------------------------------------------
2192 Join Filter: (t1.c1 = t4.c1)
2194 Join Filter: (t1.c1 = t3.c1)
2196 Join Filter: (t2.c1 = t1.c1)
2199 TID Cond: (ctid = '(1,1)'::tid)
2202 Filter: (ctid = '(1,1)'::tid)
2204 TID Cond: (ctid = '(1,1)'::tid)
2206 TID Cond: (ctid = '(1,1)'::tid)
2208 TID Cond: (ctid = '(1,1)'::tid)
2212 Join Filter: (t1.c1 = t4.c1)
2214 Join Filter: (t1.c1 = t3.c1)
2216 Join Filter: (t2.c1 = t1.c1)
2219 TID Cond: (ctid = '(1,1)'::tid)
2222 Filter: (ctid = '(1,1)'::tid)
2224 TID Cond: (ctid = '(1,1)'::tid)
2226 TID Cond: (ctid = '(1,1)'::tid)
2228 TID Cond: (ctid = '(1,1)'::tid)
2231 /*+TidScan(t1)SeqScan(t2)IndexScan(t3 t3_pkey)BitmapScan(t4 t4_pkey)
2233 EXPLAIN (COSTS false) UPDATE s1.r2 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2239 IndexScan(t3 t3_pkey)
2240 BitmapScan(t4 t4_pkey)
2250 IndexScan(t3 t3_pkey)
2251 BitmapScan(t4 t4_pkey)
2257 ------------------------------------------------------------------------
2261 Join Filter: (t2.c1 = t1.c1)
2265 Filter: (ctid = '(1,1)'::tid)
2266 -> Index Scan using t3_pkey on t3
2267 Index Cond: (c1 = t2.c1)
2268 Filter: (ctid = '(1,1)'::tid)
2270 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2272 TID Cond: (ctid = '(1,1)'::tid)
2273 -> Bitmap Heap Scan on t4
2274 Recheck Cond: (c1 = t1.c1)
2275 Filter: (ctid = '(1,1)'::tid)
2276 -> Bitmap Index Scan on t4_pkey
2277 Index Cond: (c1 = t1.c1)
2282 Join Filter: (t2.c1 = t1.c1)
2286 Filter: (ctid = '(1,1)'::tid)
2287 -> Index Scan using t3_pkey on t3
2288 Index Cond: (c1 = t2.c1)
2289 Filter: (ctid = '(1,1)'::tid)
2291 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2293 TID Cond: (ctid = '(1,1)'::tid)
2294 -> Bitmap Heap Scan on t4
2295 Recheck Cond: (c1 = t1.c1)
2296 Filter: (ctid = '(1,1)'::tid)
2297 -> Bitmap Index Scan on t4_pkey
2298 Index Cond: (c1 = t1.c1)
2301 EXPLAIN (COSTS false) UPDATE s1.r2_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2303 -----------------------------------------------------------------
2306 Join Filter: (b1t1.c1 = b1t4.c1)
2308 Join Filter: (b1t1.c1 = b1t3.c1)
2310 Join Filter: (b1t2.c1 = b1t1.c1)
2313 TID Cond: (ctid = '(1,1)'::tid)
2315 -> Seq Scan on t2 b1t2
2316 Filter: (ctid = '(1,1)'::tid)
2317 -> Tid Scan on t1 b1t1
2318 TID Cond: (ctid = '(1,1)'::tid)
2319 -> Tid Scan on t3 b1t3
2320 TID Cond: (ctid = '(1,1)'::tid)
2321 -> Tid Scan on t4 b1t4
2322 TID Cond: (ctid = '(1,1)'::tid)
2326 Join Filter: (b2t1.c1 = b2t4.c1)
2328 Join Filter: (b2t1.c1 = b2t3.c1)
2330 Join Filter: (b2t2.c1 = b2t1.c1)
2333 TID Cond: (ctid = '(1,1)'::tid)
2335 -> Seq Scan on t2 b2t2
2336 Filter: (ctid = '(1,1)'::tid)
2337 -> Tid Scan on t1 b2t1
2338 TID Cond: (ctid = '(1,1)'::tid)
2339 -> Tid Scan on t3 b2t3
2340 TID Cond: (ctid = '(1,1)'::tid)
2341 -> Tid Scan on t4 b2t4
2342 TID Cond: (ctid = '(1,1)'::tid)
2345 /*+TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
2346 BitmapScan(b2t1 t1_pkey)TidScan(b2t2)SeqScan(b2t3)IndexScan(b2t4 t4_pkey)
2348 EXPLAIN (COSTS false) UPDATE s1.r2_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2353 IndexScan(b1t3 t3_pkey)
2354 BitmapScan(b1t4 t4_pkey)
2357 BitmapScan(b2t1 t1_pkey)
2360 IndexScan(b2t4 t4_pkey)
2366 BitmapScan(b2t1 t1_pkey)
2369 IndexScan(b2t4 t4_pkey)
2374 IndexScan(b1t3 t3_pkey)
2375 BitmapScan(b1t4 t4_pkey)
2380 ------------------------------------------------------------------------
2384 Join Filter: (b1t2.c1 = b1t1.c1)
2387 -> Seq Scan on t2 b1t2
2388 Filter: (ctid = '(1,1)'::tid)
2389 -> Index Scan using t3_pkey on t3 b1t3
2390 Index Cond: (c1 = b1t2.c1)
2391 Filter: (ctid = '(1,1)'::tid)
2393 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2394 -> Tid Scan on t1 b1t1
2395 TID Cond: (ctid = '(1,1)'::tid)
2396 -> Bitmap Heap Scan on t4 b1t4
2397 Recheck Cond: (c1 = b1t1.c1)
2398 Filter: (ctid = '(1,1)'::tid)
2399 -> Bitmap Index Scan on t4_pkey
2400 Index Cond: (c1 = b1t1.c1)
2407 Join Filter: (b2t2.c1 = b2t3.c1)
2408 -> Tid Scan on t2 b2t2
2409 TID Cond: (ctid = '(1,1)'::tid)
2410 -> Seq Scan on t3 b2t3
2411 Filter: (ctid = '(1,1)'::tid)
2413 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2414 -> Bitmap Heap Scan on t1 b2t1
2415 Recheck Cond: (c1 = b2t2.c1)
2416 Filter: (ctid = '(1,1)'::tid)
2417 -> Bitmap Index Scan on t1_pkey
2418 Index Cond: (c1 = b2t2.c1)
2419 -> Index Scan using t4_pkey on t4 b2t4
2420 Index Cond: (c1 = b2t1.c1)
2421 Filter: (ctid = '(1,1)'::tid)
2425 EXPLAIN (COSTS false) UPDATE s1.r3 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2427 -----------------------------------------------------------------
2430 Join Filter: (t1.c1 = t4.c1)
2432 Join Filter: (t1.c1 = t3.c1)
2434 Join Filter: (t2.c1 = t1.c1)
2437 TID Cond: (ctid = '(1,1)'::tid)
2440 Filter: (ctid = '(1,1)'::tid)
2442 TID Cond: (ctid = '(1,1)'::tid)
2444 TID Cond: (ctid = '(1,1)'::tid)
2446 TID Cond: (ctid = '(1,1)'::tid)
2450 Join Filter: (t1.c1 = t4.c1)
2452 Join Filter: (t1.c1 = t3.c1)
2454 Join Filter: (t2.c1 = t1.c1)
2457 TID Cond: (ctid = '(1,1)'::tid)
2460 Filter: (ctid = '(1,1)'::tid)
2462 TID Cond: (ctid = '(1,1)'::tid)
2464 TID Cond: (ctid = '(1,1)'::tid)
2466 TID Cond: (ctid = '(1,1)'::tid)
2470 Join Filter: (t1.c1 = t4.c1)
2472 Join Filter: (t1.c1 = t3.c1)
2474 Join Filter: (t2.c1 = t1.c1)
2477 TID Cond: (ctid = '(1,1)'::tid)
2480 Filter: (ctid = '(1,1)'::tid)
2482 TID Cond: (ctid = '(1,1)'::tid)
2484 TID Cond: (ctid = '(1,1)'::tid)
2486 TID Cond: (ctid = '(1,1)'::tid)
2489 /*+TidScan(t1)SeqScan(t2)IndexScan(t3 t3_pkey)BitmapScan(t4 t4_pkey)
2491 EXPLAIN (COSTS false) UPDATE s1.r3 SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2497 IndexScan(t3 t3_pkey)
2498 BitmapScan(t4 t4_pkey)
2508 IndexScan(t3 t3_pkey)
2509 BitmapScan(t4 t4_pkey)
2519 IndexScan(t3 t3_pkey)
2520 BitmapScan(t4 t4_pkey)
2526 ------------------------------------------------------------------------
2530 Join Filter: (t2.c1 = t1.c1)
2534 Filter: (ctid = '(1,1)'::tid)
2535 -> Index Scan using t3_pkey on t3
2536 Index Cond: (c1 = t2.c1)
2537 Filter: (ctid = '(1,1)'::tid)
2539 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2541 TID Cond: (ctid = '(1,1)'::tid)
2542 -> Bitmap Heap Scan on t4
2543 Recheck Cond: (c1 = t1.c1)
2544 Filter: (ctid = '(1,1)'::tid)
2545 -> Bitmap Index Scan on t4_pkey
2546 Index Cond: (c1 = t1.c1)
2551 Join Filter: (t2.c1 = t1.c1)
2555 Filter: (ctid = '(1,1)'::tid)
2556 -> Index Scan using t3_pkey on t3
2557 Index Cond: (c1 = t2.c1)
2558 Filter: (ctid = '(1,1)'::tid)
2560 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2562 TID Cond: (ctid = '(1,1)'::tid)
2563 -> Bitmap Heap Scan on t4
2564 Recheck Cond: (c1 = t1.c1)
2565 Filter: (ctid = '(1,1)'::tid)
2566 -> Bitmap Index Scan on t4_pkey
2567 Index Cond: (c1 = t1.c1)
2572 Join Filter: (t2.c1 = t1.c1)
2576 Filter: (ctid = '(1,1)'::tid)
2577 -> Index Scan using t3_pkey on t3
2578 Index Cond: (c1 = t2.c1)
2579 Filter: (ctid = '(1,1)'::tid)
2581 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2583 TID Cond: (ctid = '(1,1)'::tid)
2584 -> Bitmap Heap Scan on t4
2585 Recheck Cond: (c1 = t1.c1)
2586 Filter: (ctid = '(1,1)'::tid)
2587 -> Bitmap Index Scan on t4_pkey
2588 Index Cond: (c1 = t1.c1)
2591 EXPLAIN (COSTS false) UPDATE s1.r3_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2593 -----------------------------------------------------------------
2596 Join Filter: (b1t1.c1 = b1t4.c1)
2598 Join Filter: (b1t1.c1 = b1t3.c1)
2600 Join Filter: (b1t2.c1 = b1t1.c1)
2603 TID Cond: (ctid = '(1,1)'::tid)
2605 -> Seq Scan on t2 b1t2
2606 Filter: (ctid = '(1,1)'::tid)
2607 -> Tid Scan on t1 b1t1
2608 TID Cond: (ctid = '(1,1)'::tid)
2609 -> Tid Scan on t3 b1t3
2610 TID Cond: (ctid = '(1,1)'::tid)
2611 -> Tid Scan on t4 b1t4
2612 TID Cond: (ctid = '(1,1)'::tid)
2616 Join Filter: (b2t1.c1 = b2t4.c1)
2618 Join Filter: (b2t1.c1 = b2t3.c1)
2620 Join Filter: (b2t2.c1 = b2t1.c1)
2623 TID Cond: (ctid = '(1,1)'::tid)
2625 -> Seq Scan on t2 b2t2
2626 Filter: (ctid = '(1,1)'::tid)
2627 -> Tid Scan on t1 b2t1
2628 TID Cond: (ctid = '(1,1)'::tid)
2629 -> Tid Scan on t3 b2t3
2630 TID Cond: (ctid = '(1,1)'::tid)
2631 -> Tid Scan on t4 b2t4
2632 TID Cond: (ctid = '(1,1)'::tid)
2636 Join Filter: (b3t1.c1 = b3t4.c1)
2638 Join Filter: (b3t1.c1 = b3t3.c1)
2640 Join Filter: (b3t2.c1 = b3t1.c1)
2643 TID Cond: (ctid = '(1,1)'::tid)
2645 -> Seq Scan on t2 b3t2
2646 Filter: (ctid = '(1,1)'::tid)
2647 -> Tid Scan on t1 b3t1
2648 TID Cond: (ctid = '(1,1)'::tid)
2649 -> Tid Scan on t3 b3t3
2650 TID Cond: (ctid = '(1,1)'::tid)
2651 -> Tid Scan on t4 b3t4
2652 TID Cond: (ctid = '(1,1)'::tid)
2655 /*+TidScan(b1t1)SeqScan(b1t2)IndexScan(b1t3 t3_pkey)BitmapScan(b1t4 t4_pkey)
2656 BitmapScan(b2t1 t1_pkey)TidScan(b2t2)SeqScan(b2t3)IndexScan(b2t4 t4_pkey)
2657 IndexScan(b3t1 t1_pkey)BitmapScan(b3t2 t2_pkey)TidScan(b3t3)SeqScan(b3t4)
2659 EXPLAIN (COSTS false) UPDATE s1.r3_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
2664 IndexScan(b1t3 t3_pkey)
2665 BitmapScan(b1t4 t4_pkey)
2668 BitmapScan(b2t1 t1_pkey)
2671 IndexScan(b2t4 t4_pkey)
2672 IndexScan(b3t1 t1_pkey)
2673 BitmapScan(b3t2 t2_pkey)
2681 BitmapScan(b2t1 t1_pkey)
2684 IndexScan(b2t4 t4_pkey)
2689 IndexScan(b1t3 t3_pkey)
2690 BitmapScan(b1t4 t4_pkey)
2691 IndexScan(b3t1 t1_pkey)
2692 BitmapScan(b3t2 t2_pkey)
2700 IndexScan(b3t1 t1_pkey)
2701 BitmapScan(b3t2 t2_pkey)
2708 IndexScan(b1t3 t3_pkey)
2709 BitmapScan(b1t4 t4_pkey)
2710 BitmapScan(b2t1 t1_pkey)
2713 IndexScan(b2t4 t4_pkey)
2718 ------------------------------------------------------------------------
2722 Join Filter: (b1t2.c1 = b1t1.c1)
2725 -> Seq Scan on t2 b1t2
2726 Filter: (ctid = '(1,1)'::tid)
2727 -> Index Scan using t3_pkey on t3 b1t3
2728 Index Cond: (c1 = b1t2.c1)
2729 Filter: (ctid = '(1,1)'::tid)
2731 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2732 -> Tid Scan on t1 b1t1
2733 TID Cond: (ctid = '(1,1)'::tid)
2734 -> Bitmap Heap Scan on t4 b1t4
2735 Recheck Cond: (c1 = b1t1.c1)
2736 Filter: (ctid = '(1,1)'::tid)
2737 -> Bitmap Index Scan on t4_pkey
2738 Index Cond: (c1 = b1t1.c1)
2745 Join Filter: (b2t2.c1 = b2t3.c1)
2746 -> Tid Scan on t2 b2t2
2747 TID Cond: (ctid = '(1,1)'::tid)
2748 -> Seq Scan on t3 b2t3
2749 Filter: (ctid = '(1,1)'::tid)
2751 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2752 -> Bitmap Heap Scan on t1 b2t1
2753 Recheck Cond: (c1 = b2t2.c1)
2754 Filter: (ctid = '(1,1)'::tid)
2755 -> Bitmap Index Scan on t1_pkey
2756 Index Cond: (c1 = b2t2.c1)
2757 -> Index Scan using t4_pkey on t4 b2t4
2758 Index Cond: (c1 = b2t1.c1)
2759 Filter: (ctid = '(1,1)'::tid)
2763 Join Filter: (b3t1.c1 = b3t4.c1)
2767 -> Tid Scan on t3 b3t3
2768 TID Cond: (ctid = '(1,1)'::tid)
2769 -> Bitmap Heap Scan on t2 b3t2
2770 Recheck Cond: (c1 = b3t3.c1)
2771 Filter: (ctid = '(1,1)'::tid)
2772 -> Bitmap Index Scan on t2_pkey
2773 Index Cond: (c1 = b3t3.c1)
2775 Filter: ((ctid = '(1,1)'::tid) AND (c1 = 1))
2776 -> Index Scan using t1_pkey on t1 b3t1
2777 Index Cond: (c1 = b3t2.c1)
2778 Filter: (ctid = '(1,1)'::tid)
2779 -> Seq Scan on t4 b3t4
2780 Filter: (ctid = '(1,1)'::tid)
2784 ---- No. S-2-4 VALUES clause
2787 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1')) AS t1 (c1) WHERE t1.c1 = 1;
2789 ---------------------------
2790 Values Scan on "*VALUES*"
2791 Filter: (column1 = 1)
2795 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1')) AS t1 (c1) WHERE t1.c1 = 1;
2804 ---------------------------
2805 Values Scan on "*VALUES*"
2806 Filter: (column1 = 1)
2809 /*+SeqScan(*VALUES*)*/
2810 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1')) AS t1 (c1) WHERE t1.c1 = 1;
2819 ---------------------------
2820 Values Scan on "*VALUES*"
2821 Filter: (column1 = 1)
2825 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1')) AS t1 (c1, c2, c3, c4), (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t2 (c1, c2) WHERE t1.c1 = t2.c1;
2827 ----------------------------------------------------------
2829 Join Filter: ("*VALUES*".column1 = "*VALUES*".column1)
2830 -> Values Scan on "*VALUES*"
2831 -> Values Scan on "*VALUES*"
2835 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1')) AS t1 (c1, c2, c3, c4), (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t2 (c1, c2) WHERE t1.c1 = t2.c1;
2836 INFO: hint syntax error at or near ""
2837 DETAIL: SeqScan hint requires only one relation.
2846 ----------------------------------------------------------
2848 Join Filter: ("*VALUES*".column1 = "*VALUES*".column1)
2849 -> Values Scan on "*VALUES*"
2850 -> Values Scan on "*VALUES*"
2853 /*+SeqScan(*VALUES*)*/
2854 EXPLAIN (COSTS false) SELECT * FROM (VALUES(1,1,1,'1')) AS t1 (c1, c2, c3, c4), (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t2 (c1, c2) WHERE t1.c1 = t2.c1;
2863 ----------------------------------------------------------
2865 Join Filter: ("*VALUES*".column1 = "*VALUES*".column1)
2866 -> Values Scan on "*VALUES*"
2867 -> Values Scan on "*VALUES*"
2871 ---- No. S-3-1 scan method hint
2874 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
2876 ---------------------
2882 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
2891 ---------------------
2897 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
2899 ------------------------------
2900 Index Scan using t1_i1 on t1
2901 Index Cond: (c1 = 1)
2905 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
2914 --------------------
2920 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
2922 ------------------------------
2923 Index Scan using t1_i1 on t1
2924 Index Cond: (c1 = 1)
2928 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
2937 ------------------------------
2938 Index Scan using t1_i1 on t1
2939 Index Cond: (c1 = 1)
2943 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
2945 ---------------------
2951 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
2960 ------------------------------
2961 Index Scan using t1_i1 on t1
2962 Index Cond: (c1 >= 1)
2966 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c3 < 10;
2968 ---------------------------------
2969 Bitmap Heap Scan on t1
2970 Recheck Cond: (c3 < 10)
2971 -> Bitmap Index Scan on t1_i
2972 Index Cond: (c3 < 10)
2976 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c3 < 10;
2985 ---------------------------------
2986 Bitmap Heap Scan on t1
2987 Recheck Cond: (c3 < 10)
2988 -> Bitmap Index Scan on t1_i
2989 Index Cond: (c3 < 10)
2993 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
2995 ------------------------------
2996 Index Scan using t1_i1 on t1
2997 Index Cond: (c1 = 1)
3001 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3010 ----------------------------------
3011 Bitmap Heap Scan on t1
3012 Recheck Cond: (c1 = 1)
3013 -> Bitmap Index Scan on t1_i1
3014 Index Cond: (c1 = 1)
3018 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1 AND t1.ctid = '(1,1)';
3020 -----------------------------------
3022 TID Cond: (ctid = '(1,1)'::tid)
3027 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1 AND t1.ctid = '(1,1)';
3036 -----------------------------------
3038 TID Cond: (ctid = '(1,1)'::tid)
3043 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1 AND t1.ctid IN ('(1,1)', '(2,2)', '(3,3)');
3045 -------------------------------------------------------------
3046 Index Scan using t1_i1 on t1
3047 Index Cond: (c1 = 1)
3048 Filter: (ctid = ANY ('{"(1,1)","(2,2)","(3,3)"}'::tid[]))
3052 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1 AND t1.ctid IN ('(1,1)', '(2,2)', '(3,3)');
3061 ---------------------------------------------------------------
3063 TID Cond: (ctid = ANY ('{"(1,1)","(2,2)","(3,3)"}'::tid[]))
3068 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
3070 ---------------------
3076 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
3085 ------------------------------
3086 Index Scan using t1_i1 on t1
3087 Index Cond: (c1 >= 1)
3091 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3093 ------------------------------
3094 Index Scan using t1_i1 on t1
3095 Index Cond: (c1 = 1)
3099 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3108 ------------------------------
3109 Index Scan using t1_i1 on t1
3110 Index Cond: (c1 = 1)
3114 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3116 ------------------------------
3117 Index Scan using t1_i1 on t1
3118 Index Cond: (c1 = 1)
3121 /*+NoIndexScan(t1)*/
3122 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3131 ----------------------------------
3132 Bitmap Heap Scan on t1
3133 Recheck Cond: (c1 = 1)
3134 -> Bitmap Index Scan on t1_i1
3135 Index Cond: (c1 = 1)
3139 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
3141 ---------------------
3146 /*+NoIndexScan(t1)*/
3147 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 >= 1;
3156 ---------------------
3162 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c3 < 10;
3164 ---------------------------------
3165 Bitmap Heap Scan on t1
3166 Recheck Cond: (c3 < 10)
3167 -> Bitmap Index Scan on t1_i
3168 Index Cond: (c3 < 10)
3171 /*+NoBitmapScan(t1)*/
3172 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c3 < 10;
3181 ---------------------
3187 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3189 ------------------------------
3190 Index Scan using t1_i1 on t1
3191 Index Cond: (c1 = 1)
3194 /*+NoBitmapScan(t1)*/
3195 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3204 ------------------------------
3205 Index Scan using t1_i1 on t1
3206 Index Cond: (c1 = 1)
3210 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1 AND t1.ctid = '(1,1)';
3212 -----------------------------------
3214 TID Cond: (ctid = '(1,1)'::tid)
3219 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1 AND t1.ctid = '(1,1)';
3228 ---------------------------------
3229 Index Scan using t1_i1 on t1
3230 Index Cond: (c1 = 1)
3231 Filter: (ctid = '(1,1)'::tid)
3235 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3237 ------------------------------
3238 Index Scan using t1_i1 on t1
3239 Index Cond: (c1 = 1)
3243 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3252 ------------------------------
3253 Index Scan using t1_i1 on t1
3254 Index Cond: (c1 = 1)
3258 EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 = 1;
3260 ------------------------------
3261 Index Scan using t1_i1 on t1
3262 Index Cond: (c1 = 1)
3265 /*+IndexOnlyScan(t1)*/
3266 EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 = 1;
3267 INFO: hint syntax error at or near "IndexOnlyScan(t1)"
3268 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
3270 ------------------------------
3271 Index Scan using t1_i1 on t1
3272 Index Cond: (c1 = 1)
3276 EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 >= 1;
3278 ---------------------
3283 /*+IndexOnlyScan(t1)*/
3284 EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 >= 1;
3285 INFO: hint syntax error at or near "IndexOnlyScan(t1)"
3286 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
3288 ---------------------
3294 EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 = 1;
3296 ------------------------------
3297 Index Scan using t1_i1 on t1
3298 Index Cond: (c1 = 1)
3301 /*+NoIndexOnlyScan(t1)*/
3302 EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 = 1;
3303 INFO: hint syntax error at or near "NoIndexOnlyScan(t1)"
3304 DETAIL: Unrecognized hint keyword "NoIndexOnlyScan".
3306 ------------------------------
3307 Index Scan using t1_i1 on t1
3308 Index Cond: (c1 = 1)
3312 EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 >= 1;
3314 ---------------------
3319 /*+NoIndexOnlyScan(t1)*/
3320 EXPLAIN (COSTS false) SELECT c1 FROM s1.t1 WHERE t1.c1 >= 1;
3321 INFO: hint syntax error at or near "NoIndexOnlyScan(t1)"
3322 DETAIL: Unrecognized hint keyword "NoIndexOnlyScan".
3324 ---------------------
3330 ---- No. S-3-3 index name specified
3332 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3334 -----------------------------------
3336 TID Cond: (ctid = '(1,1)'::tid)
3340 SET enable_tidscan TO off;
3341 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3343 ---------------------------------
3344 Index Scan using ti1_i2 on ti1
3345 Index Cond: (c2 = 1)
3346 Filter: (ctid = '(1,1)'::tid)
3349 SET enable_indexscan TO off;
3350 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3352 -----------------------------------
3353 Bitmap Heap Scan on ti1
3354 Recheck Cond: (c2 = 1)
3355 Filter: (ctid = '(1,1)'::tid)
3356 -> Bitmap Index Scan on ti1_i2
3357 Index Cond: (c2 = 1)
3360 RESET enable_tidscan;
3361 RESET enable_indexscan;
3362 EXPLAIN (COSTS false) SELECT c2 FROM s1.ti1 WHERE ti1.c2 >= 1;
3364 ---------------------
3370 /*+IndexScan(ti1 ti1_i3)*/
3371 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3374 IndexScan(ti1 ti1_i3)
3380 ---------------------------------
3381 Index Scan using ti1_i3 on ti1
3382 Index Cond: (c2 = 1)
3383 Filter: (ctid = '(1,1)'::tid)
3387 /*+IndexScan(ti1 ti1_i3 ti1_i2)*/
3388 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3391 IndexScan(ti1 ti1_i3 ti1_i2)
3397 ---------------------------------
3398 Index Scan using ti1_i2 on ti1
3399 Index Cond: (c2 = 1)
3400 Filter: (ctid = '(1,1)'::tid)
3404 /*+IndexScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)*/
3405 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3408 IndexScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)
3414 ---------------------------------
3415 Index Scan using ti1_i2 on ti1
3416 Index Cond: (c2 = 1)
3417 Filter: (ctid = '(1,1)'::tid)
3421 /*+BitmapScan(ti1 ti1_i3)*/
3422 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3425 BitmapScan(ti1 ti1_i3)
3431 -----------------------------------
3432 Bitmap Heap Scan on ti1
3433 Recheck Cond: (c2 = 1)
3434 Filter: (ctid = '(1,1)'::tid)
3435 -> Bitmap Index Scan on ti1_i3
3436 Index Cond: (c2 = 1)
3440 /*+BitmapScan(ti1 ti1_i3 ti1_i2)*/
3441 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3444 BitmapScan(ti1 ti1_i3 ti1_i2)
3450 -----------------------------------
3451 Bitmap Heap Scan on ti1
3452 Recheck Cond: (c2 = 1)
3453 Filter: (ctid = '(1,1)'::tid)
3454 -> Bitmap Index Scan on ti1_i2
3455 Index Cond: (c2 = 1)
3459 /*+BitmapScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)*/
3460 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE ti1.c2 = 1 AND ctid = '(1,1)';
3463 BitmapScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)
3469 -----------------------------------
3470 Bitmap Heap Scan on ti1
3471 Recheck Cond: (c2 = 1)
3472 Filter: (ctid = '(1,1)'::tid)
3473 -> Bitmap Index Scan on ti1_i2
3474 Index Cond: (c2 = 1)
3478 /*+IndexOnlyScan(ti1 ti1_i3)*/
3479 EXPLAIN (COSTS false) SELECT c2 FROM s1.ti1 WHERE ti1.c2 >= 1;
3480 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_i3)"
3481 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
3483 ---------------------
3489 /*+IndexOnlyScan(ti1 ti1_i3 ti1_i2)*/
3490 EXPLAIN (COSTS false) SELECT c2 FROM s1.ti1 WHERE ti1.c2 >= 1;
3491 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_i3 ti1_i2)"
3492 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
3494 ---------------------
3500 /*+IndexOnlyScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)*/
3501 EXPLAIN (COSTS false) SELECT c2 FROM s1.ti1 WHERE ti1.c2 >= 1;
3502 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_i4 ti1_i3 ti1_i2 ti1_i1)"
3503 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
3505 ---------------------
3511 ---- No. S-3-4 index type
3515 Column | Type | Modifiers
3516 --------+---------+-----------
3517 c1 | integer | not null
3522 "ti1_pkey" PRIMARY KEY, btree (c1)
3523 "ti1_c2_key" UNIQUE CONSTRAINT, btree (c2)
3524 "ti1_uniq" UNIQUE, btree (c1)
3525 "ti1_btree" btree (c1)
3526 "ti1_expr" btree ((c1 < 100))
3528 "ti1_gist" gist (c1)
3529 "ti1_hash" hash (c1)
3531 "ti1_i2" btree (c2, c4)
3532 "ti1_i3" btree (c2, c4, c4)
3533 "ti1_i4" btree (c2, c4, c4, c4)
3534 "ti1_multi" btree (c1, c2, c3, c4)
3535 "ti1_pred" btree (lower(c4))
3536 "ti1_ts" gin (to_tsvector('english'::regconfig, c4))
3538 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)';
3540 -----------------------------------------------------------------------------------------------------------------------------------------
3542 TID Cond: (ctid = '(1,1)'::tid)
3543 Filter: ((c1 < 100) AND (c2 = 1) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3547 /*+IndexScan(ti1 ti1_btree)*/
3548 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)';
3551 IndexScan(ti1 ti1_btree)
3557 ----------------------------------------------------------------------------------------------------------------------------------------------------
3558 Index Scan using ti1_btree on ti1
3559 Index Cond: (c1 < 100)
3560 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3564 /*+IndexScan(ti1 ti1_hash)*/
3565 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)';
3568 IndexScan(ti1 ti1_hash)
3574 ----------------------------------------------------------------------------------------------------------------------------------------------------
3575 Index Scan using ti1_hash on ti1
3576 Index Cond: (c1 = 100)
3577 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3581 /*+IndexScan(ti1 ti1_gist)*/
3582 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)';
3585 IndexScan(ti1 ti1_gist)
3591 ----------------------------------------------------------------------------------------------------------------------------------------------------
3592 Index Scan using ti1_gist on ti1
3593 Index Cond: (c1 < 100)
3594 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3598 /*+IndexScan(ti1 ti1_gin)*/
3599 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)';
3602 IndexScan(ti1 ti1_gin)
3608 -----------------------------------------------------------------------------------------------------------------------------------------
3610 TID Cond: (ctid = '(1,1)'::tid)
3611 Filter: ((c1 < 100) AND (c2 = 1) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3615 /*+IndexScan(ti1 ti1_expr)*/
3616 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)';
3619 IndexScan(ti1 ti1_expr)
3625 -------------------------------------------------------------------------------------------------------------------------------------------------------------------
3626 Index Scan using ti1_expr on ti1
3627 Index Cond: ((c1 < 100) = true)
3628 Filter: ((c1 < 100) AND (c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3632 /*+IndexScan(ti1 ti1_pred)*/
3633 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)';
3636 IndexScan(ti1 ti1_pred)
3642 ---------------------------------------------------------------------------------------------------------------------------------------
3643 Index Scan using ti1_pred on ti1
3644 Index Cond: (lower(c4) = '1'::text)
3645 Filter: ((c1 < 100) AND (c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery))
3649 /*+IndexScan(ti1 ti1_uniq)*/
3650 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)';
3653 IndexScan(ti1 ti1_uniq)
3659 ----------------------------------------------------------------------------------------------------------------------------------------------------
3660 Index Scan using ti1_uniq on ti1
3661 Index Cond: (c1 < 100)
3662 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3666 /*+IndexScan(ti1 ti1_multi)*/
3667 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)';
3670 IndexScan(ti1 ti1_multi)
3676 ---------------------------------------------------------------------------------------------------------------------------------------
3677 Index Scan using ti1_multi on ti1
3678 Index Cond: ((c1 < 100) AND (c2 = 1))
3679 Filter: ((ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3683 /*+IndexScan(ti1 ti1_ts)*/
3684 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)';
3687 IndexScan(ti1 ti1_ts)
3693 -----------------------------------------------------------------------------------------------------------------------------------------
3695 TID Cond: (ctid = '(1,1)'::tid)
3696 Filter: ((c1 < 100) AND (c2 = 1) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3700 /*+IndexScan(ti1 ti1_pkey)*/
3701 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)';
3704 IndexScan(ti1 ti1_pkey)
3710 ----------------------------------------------------------------------------------------------------------------------------------------------------
3711 Index Scan using ti1_pkey on ti1
3712 Index Cond: (c1 < 100)
3713 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3717 /*+IndexScan(ti1 ti1_c2_key)*/
3718 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)';
3721 IndexScan(ti1 ti1_c2_key)
3727 ------------------------------------------------------------------------------------------------------------------------------------------------------
3728 Index Scan using ti1_c2_key on ti1
3729 Index Cond: (c2 = 1)
3730 Filter: ((c1 < 100) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3734 /*+BitmapScan(ti1 ti1_btree)*/
3735 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)';
3738 BitmapScan(ti1 ti1_btree)
3744 ----------------------------------------------------------------------------------------------------------------------------------------------------
3745 Bitmap Heap Scan on ti1
3746 Recheck Cond: (c1 < 100)
3747 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3748 -> Bitmap Index Scan on ti1_btree
3749 Index Cond: (c1 < 100)
3753 /*+BitmapScan(ti1 ti1_hash)*/
3754 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)';
3757 BitmapScan(ti1 ti1_hash)
3763 ----------------------------------------------------------------------------------------------------------------------------------------------------
3764 Bitmap Heap Scan on ti1
3765 Recheck Cond: (c1 = 100)
3766 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3767 -> Bitmap Index Scan on ti1_hash
3768 Index Cond: (c1 = 100)
3772 /*+BitmapScan(ti1 ti1_gist)*/
3773 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)';
3776 BitmapScan(ti1 ti1_gist)
3782 ----------------------------------------------------------------------------------------------------------------------------------------------------
3783 Bitmap Heap Scan on ti1
3784 Recheck Cond: (c1 < 100)
3785 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3786 -> Bitmap Index Scan on ti1_gist
3787 Index Cond: (c1 < 100)
3791 /*+BitmapScan(ti1 ti1_gin)*/
3792 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)';
3795 BitmapScan(ti1 ti1_gin)
3801 ----------------------------------------------------------------------------------------------------------------------------------------------------
3802 Bitmap Heap Scan on ti1
3803 Recheck Cond: (c1 < 100)
3804 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3805 -> Bitmap Index Scan on ti1_gin
3806 Index Cond: (c1 < 100)
3810 /*+BitmapScan(ti1 ti1_expr)*/
3811 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)';
3814 BitmapScan(ti1 ti1_expr)
3820 -------------------------------------------------------------------------------------------------------------------------------------------------------------------
3821 Bitmap Heap Scan on ti1
3822 Filter: ((c1 < 100) AND (c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3823 -> Bitmap Index Scan on ti1_expr
3824 Index Cond: ((c1 < 100) = true)
3828 /*+BitmapScan(ti1 ti1_pred)*/
3829 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)';
3832 BitmapScan(ti1 ti1_pred)
3838 ---------------------------------------------------------------------------------------------------------------------------------------
3839 Bitmap Heap Scan on ti1
3840 Recheck Cond: (lower(c4) = '1'::text)
3841 Filter: ((c1 < 100) AND (c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery))
3842 -> Bitmap Index Scan on ti1_pred
3843 Index Cond: (lower(c4) = '1'::text)
3847 /*+BitmapScan(ti1 ti1_uniq)*/
3848 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)';
3851 BitmapScan(ti1 ti1_uniq)
3857 ----------------------------------------------------------------------------------------------------------------------------------------------------
3858 Bitmap Heap Scan on ti1
3859 Recheck Cond: (c1 < 100)
3860 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3861 -> Bitmap Index Scan on ti1_uniq
3862 Index Cond: (c1 < 100)
3866 /*+BitmapScan(ti1 ti1_multi)*/
3867 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)';
3870 BitmapScan(ti1 ti1_multi)
3876 ---------------------------------------------------------------------------------------------------------------------------------------
3877 Bitmap Heap Scan on ti1
3878 Recheck Cond: ((c1 < 100) AND (c2 = 1))
3879 Filter: ((ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3880 -> Bitmap Index Scan on ti1_multi
3881 Index Cond: ((c1 < 100) AND (c2 = 1))
3885 /*+BitmapScan(ti1 ti1_ts)*/
3886 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)';
3889 BitmapScan(ti1 ti1_ts)
3895 -------------------------------------------------------------------------------------------
3896 Bitmap Heap Scan on ti1
3897 Recheck Cond: (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery)
3898 Filter: ((c1 < 100) AND (c2 = 1) AND (ctid = '(1,1)'::tid) AND (lower(c4) = '1'::text))
3899 -> Bitmap Index Scan on ti1_ts
3900 Index Cond: (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery)
3904 /*+BitmapScan(ti1 ti1_pkey)*/
3905 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)';
3908 BitmapScan(ti1 ti1_pkey)
3914 ----------------------------------------------------------------------------------------------------------------------------------------------------
3915 Bitmap Heap Scan on ti1
3916 Recheck Cond: (c1 < 100)
3917 Filter: ((c2 = 1) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3918 -> Bitmap Index Scan on ti1_pkey
3919 Index Cond: (c1 < 100)
3923 /*+BitmapScan(ti1 ti1_c2_key)*/
3924 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)';
3927 BitmapScan(ti1 ti1_c2_key)
3933 ------------------------------------------------------------------------------------------------------------------------------------------------------
3934 Bitmap Heap Scan on ti1
3935 Recheck Cond: (c2 = 1)
3936 Filter: ((c1 < 100) AND (ctid = '(1,1)'::tid) AND (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery) AND (lower(c4) = '1'::text))
3937 -> Bitmap Index Scan on ti1_c2_key
3938 Index Cond: (c2 = 1)
3942 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
3944 ---------------------
3949 /*+IndexOnlyScan(ti1 ti1_btree)*/
3950 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
3951 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_btree)"
3952 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
3954 ---------------------
3960 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 = 1;
3962 ----------------------------------
3963 Index Scan using ti1_uniq on ti1
3964 Index Cond: (c1 = 1)
3967 /*+IndexOnlyScan(ti1 ti1_hash)*/
3968 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 = 1;
3969 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_hash)"
3970 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
3972 ----------------------------------
3973 Index Scan using ti1_uniq on ti1
3974 Index Cond: (c1 = 1)
3978 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 < 1;
3980 ----------------------------------
3981 Index Scan using ti1_uniq on ti1
3982 Index Cond: (c1 < 1)
3985 /*+IndexOnlyScan(ti1 ti1_gist)*/
3986 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 < 1;
3987 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_gist)"
3988 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
3990 ----------------------------------
3991 Index Scan using ti1_uniq on ti1
3992 Index Cond: (c1 < 1)
3996 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 = 1;
3998 ----------------------------------
3999 Index Scan using ti1_uniq on ti1
4000 Index Cond: (c1 = 1)
4003 /*+IndexOnlyScan(ti1 ti1_gin)*/
4004 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 = 1;
4005 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_gin)"
4006 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4008 ----------------------------------
4009 Index Scan using ti1_uniq on ti1
4010 Index Cond: (c1 = 1)
4014 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 < 100;
4016 ----------------------------------
4017 Index Scan using ti1_uniq on ti1
4018 Index Cond: (c1 < 100)
4021 /*+IndexOnlyScan(ti1 ti1_expr)*/
4022 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 < 100;
4023 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_expr)"
4024 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4026 ----------------------------------
4027 Index Scan using ti1_uniq on ti1
4028 Index Cond: (c1 < 100)
4032 EXPLAIN (COSTS false) SELECT c4 FROM s1.ti1 WHERE lower(c4) >= '1';
4034 ------------------------------------
4036 Filter: (lower(c4) >= '1'::text)
4039 /*+IndexOnlyScan(ti1 ti1_pred)*/
4040 EXPLAIN (COSTS false) SELECT c4 FROM s1.ti1 WHERE lower(c4) >= '1';
4041 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_pred)"
4042 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4044 ------------------------------------
4046 Filter: (lower(c4) >= '1'::text)
4050 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
4052 ---------------------
4057 /*+IndexOnlyScan(ti1 ti1_uniq)*/
4058 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
4059 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_uniq)"
4060 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4062 ---------------------
4068 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
4070 ---------------------
4075 /*+IndexOnlyScan(ti1 ti1_multi)*/
4076 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
4077 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_multi)"
4078 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4080 ---------------------
4086 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE to_tsvector('english', c4) @@ 'a & b';
4088 -----------------------------------------------------------------------------------------
4089 Bitmap Heap Scan on ti1
4090 Recheck Cond: (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery)
4091 -> Bitmap Index Scan on ti1_ts
4092 Index Cond: (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery)
4095 /*+IndexOnlyScan(ti1 ti1_ts)*/
4096 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE to_tsvector('english', c4) @@ 'a & b';
4097 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_ts)"
4098 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4100 -----------------------------------------------------------------------------------------
4101 Bitmap Heap Scan on ti1
4102 Recheck Cond: (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery)
4103 -> Bitmap Index Scan on ti1_ts
4104 Index Cond: (to_tsvector('english'::regconfig, c4) @@ '''a'' & ''b'''::tsquery)
4108 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
4110 ---------------------
4115 /*+IndexOnlyScan(ti1 ti1_pkey)*/
4116 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
4117 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_pkey)"
4118 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4120 ---------------------
4126 EXPLAIN (COSTS false) SELECT c2 FROM s1.ti1 WHERE c2 >= 1;
4128 ---------------------
4133 /*+IndexOnlyScan(ti1 ti1_c2_key)*/
4134 EXPLAIN (COSTS false) SELECT c2 FROM s1.ti1 WHERE c2 >= 1;
4135 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_c2_key)"
4136 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4138 ---------------------
4144 ---- No. S-3-5 not used index
4147 /*+IndexScan(ti1 ti1_pred)*/
4148 EXPLAIN (COSTS true) SELECT * FROM s1.ti1 WHERE c1 = 100;
4151 IndexScan(ti1 ti1_pred)
4157 ------------------------------------------------------------------------
4158 Seq Scan on ti1 (cost=10000000000.00..10000000018.50 rows=1 width=15)
4163 /*+BitmapScan(ti1 ti1_pred)*/
4164 EXPLAIN (COSTS true) SELECT * FROM s1.ti1 WHERE c1 = 100;
4167 BitmapScan(ti1 ti1_pred)
4173 ------------------------------------------------------------------------
4174 Seq Scan on ti1 (cost=10000000000.00..10000000018.50 rows=1 width=15)
4179 /*+IndexOnlyScan(ti1 ti1_pred)*/
4180 EXPLAIN (COSTS true) SELECT c1 FROM s1.ti1 WHERE c1 = 100;
4181 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_pred)"
4182 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4184 --------------------------------------------------------------------
4185 Index Scan using ti1_uniq on ti1 (cost=0.00..8.27 rows=1 width=4)
4186 Index Cond: (c1 = 100)
4190 ---- No. S-3-6 not exist index
4193 /*+IndexScan(ti1 not_exist)*/
4194 EXPLAIN (COSTS true) SELECT * FROM s1.ti1 WHERE c1 = 100;
4197 IndexScan(ti1 not_exist)
4203 ------------------------------------------------------------------------
4204 Seq Scan on ti1 (cost=10000000000.00..10000000018.50 rows=1 width=15)
4209 /*+BitmapScan(ti1 not_exist)*/
4210 EXPLAIN (COSTS true) SELECT * FROM s1.ti1 WHERE c1 = 100;
4213 BitmapScan(ti1 not_exist)
4219 ------------------------------------------------------------------------
4220 Seq Scan on ti1 (cost=10000000000.00..10000000018.50 rows=1 width=15)
4225 /*+IndexOnlyScan(ti1 not_exist)*/
4226 EXPLAIN (COSTS true) SELECT c1 FROM s1.ti1 WHERE c1 = 100;
4227 INFO: hint syntax error at or near "IndexOnlyScan(ti1 not_exist)"
4228 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
4230 --------------------------------------------------------------------
4231 Index Scan using ti1_uniq on ti1 (cost=0.00..8.27 rows=1 width=4)
4232 Index Cond: (c1 = 100)
4236 ---- No. S-3-7 query structure
4238 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.ctid = '(1,1)';
4240 -----------------------------------------------
4242 Hash Cond: (t2.c1 = t1.c1)
4246 TID Cond: (ctid = '(1,1)'::tid)
4251 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE c1 = 100;
4260 ----------------------
4266 /*+SeqScan(t1)BitmapScan(t2)*/
4267 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.ctid = '(1,1)';
4277 ----------------------------------------
4280 Filter: (ctid = '(1,1)'::tid)
4281 -> Bitmap Heap Scan on t2
4282 Recheck Cond: (c1 = t1.c1)
4283 -> Bitmap Index Scan on t2_i1
4284 Index Cond: (c1 = t1.c1)
4289 EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.ctid = '(1,1)';
4298 ---------------------------------------------
4300 Hash Cond: (t2.c1 = t1.c1)
4304 Filter: (ctid = '(1,1)'::tid)
4308 ---- No. S-3-8 query structure
4311 EXPLAIN (COSTS false)
4313 SELECT max(b1t1.c1) FROM s1.t1 b1t1 WHERE b1t1.c1 = 1)
4314 SELECT max(b3t1.c1), (
4315 SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
4316 ) FROM s1.t1 b3t1 WHERE b3t1.c1 = (
4317 SELECT max(b4t1.c1) FROM s1.t1 b4t1 WHERE b4t1.c1 = 1);
4319 ---------------------------------------------------------------------
4321 InitPlan 2 (returns $1)
4323 InitPlan 1 (returns $0)
4325 -> Index Scan using t1_i1 on t1 b2t1
4326 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
4327 InitPlan 4 (returns $3)
4329 InitPlan 3 (returns $2)
4331 -> Index Scan using t1_i1 on t1 b4t1
4332 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
4333 InitPlan 5 (returns $4)
4335 -> Index Scan using t1_i1 on t1 b3t1
4336 Index Cond: ((c1 IS NOT NULL) AND (c1 = $3))
4339 /*+SeqScan(b1t1)IndexScan(b2t1 t1_pkey)BitmapScan(b3t1 t1_pkey)TidScan(b4t1)
4341 EXPLAIN (COSTS false)
4343 SELECT max(b1t1.c1) FROM s1.t1 b1t1 WHERE b1t1.c1 = 1)
4344 SELECT max(b3t1.c1), (
4345 SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
4346 ) FROM s1.t1 b3t1 WHERE b3t1.c1 = (
4347 SELECT max(b4t1.c1) FROM s1.t1 b4t1 WHERE b4t1.c1 = 1);
4350 IndexScan(b2t1 t1_pkey)
4351 BitmapScan(b3t1 t1_pkey)
4359 ---------------------------------------------------------------------
4361 InitPlan 2 (returns $1)
4363 InitPlan 1 (returns $0)
4365 -> Index Scan using t1_pkey on t1 b2t1
4366 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
4367 InitPlan 4 (returns $3)
4369 InitPlan 3 (returns $2)
4371 -> Seq Scan on t1 b4t1
4372 Filter: ((c1 IS NOT NULL) AND (c1 = 1))
4373 InitPlan 5 (returns $4)
4375 -> Bitmap Heap Scan on t1 b3t1
4376 Recheck Cond: ((c1 IS NOT NULL) AND (c1 = $3))
4377 -> Bitmap Index Scan on t1_pkey
4378 Index Cond: ((c1 IS NOT NULL) AND (c1 = $3))
4382 EXPLAIN (COSTS false)
4384 SELECT max(b1t1.c1) FROM s1.t1 b1t1 JOIN s1.t2 b1t2 ON(b1t1.c1 = b1t2.c1) WHERE b1t1.c1 = 1)
4385 SELECT max(b3t1.c1), (
4386 SELECT max(b2t1.c1) FROM s1.t1 b2t1 JOIN s1.t2 b2t2 ON(b2t1.c1 = b2t2.c1) WHERE b2t1.c1 = 1
4387 ) FROM s1.t1 b3t1 JOIN s1.t2 b3t2 ON(b3t1.c1 = b3t2.c1) JOIN cte1 ON(b3t1.c1 = cte1.c1) WHERE b3t1.c1 = (
4388 SELECT max(b4t1.c1) FROM s1.t1 b4t1 JOIN s1.t2 b4t2 ON(b4t1.c1 = b4t2.c1) WHERE b4t1.c1 = 1);
4390 -------------------------------------------------------
4395 -> Index Scan using t1_i1 on t1 b1t1
4396 Index Cond: (c1 = 1)
4397 -> Seq Scan on t2 b1t2
4399 InitPlan 2 (returns $1)
4402 -> Index Scan using t1_i1 on t1 b2t1
4403 Index Cond: (c1 = 1)
4404 -> Seq Scan on t2 b2t2
4406 InitPlan 3 (returns $2)
4409 -> Index Scan using t1_i1 on t1 b4t1
4410 Index Cond: (c1 = 1)
4411 -> Seq Scan on t2 b4t2
4415 -> Index Scan using t1_i1 on t1 b3t1
4416 Index Cond: (c1 = $2)
4417 -> Seq Scan on t2 b3t2
4423 /*+SeqScan(b1t1)IndexScan(b2t1 t1_pkey)BitmapScan(b3t1 t1_pkey)TidScan(b4t1)
4424 TidScan(b1t2)SeqScan(b2t2)IndexScan(b3t2 t2_pkey)BitmapScan(b4t2 t2_pkey)
4426 EXPLAIN (COSTS false)
4428 SELECT max(b1t1.c1) FROM s1.t1 b1t1 JOIN s1.t2 b1t2 ON(b1t1.c1 = b1t2.c1) WHERE b1t1.c1 = 1)
4429 SELECT max(b3t1.c1), (
4430 SELECT max(b2t1.c1) FROM s1.t1 b2t1 JOIN s1.t2 b2t2 ON(b2t1.c1 = b2t2.c1) WHERE b2t1.c1 = 1
4431 ) FROM s1.t1 b3t1 JOIN s1.t2 b3t2 ON(b3t1.c1 = b3t2.c1) JOIN cte1 ON(b3t1.c1 = cte1.c1) WHERE b3t1.c1 = (
4432 SELECT max(b4t1.c1) FROM s1.t1 b4t1 JOIN s1.t2 b4t2 ON(b4t1.c1 = b4t2.c1) WHERE b4t1.c1 = 1);
4437 IndexScan(b2t1 t1_pkey)
4439 BitmapScan(b3t1 t1_pkey)
4440 IndexScan(b3t2 t2_pkey)
4442 BitmapScan(b4t2 t2_pkey)
4448 ---------------------------------------------------------
4453 -> Seq Scan on t1 b1t1
4455 -> Seq Scan on t2 b1t2
4457 InitPlan 2 (returns $1)
4460 -> Index Scan using t1_pkey on t1 b2t1
4461 Index Cond: (c1 = 1)
4462 -> Seq Scan on t2 b2t2
4464 InitPlan 3 (returns $2)
4467 -> Seq Scan on t1 b4t1
4469 -> Bitmap Heap Scan on t2 b4t2
4470 Recheck Cond: (c1 = 1)
4471 -> Bitmap Index Scan on t2_pkey
4472 Index Cond: (c1 = 1)
4475 -> Bitmap Heap Scan on t1 b3t1
4476 Recheck Cond: (c1 = $2)
4477 -> Bitmap Index Scan on t1_pkey
4478 Index Cond: (c1 = $2)
4481 -> Index Scan using t2_pkey on t2 b3t2
4482 Index Cond: (c1 = $2)
4486 EXPLAIN (COSTS false)
4488 SELECT max(b1t1.c1) FROM s1.t1 b1t1 JOIN s1.t2 b1t2 ON(b1t1.c1 = b1t2.c1) WHERE b1t1.c1 = 1)
4489 SELECT max(b3t1.c1), (
4490 SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
4491 ) FROM s1.t1 b3t1 JOIN s1.t2 b3t2 ON(b3t1.c1 = b3t2.c1) JOIN cte1 ON(b3t1.c1 = cte1.c1) WHERE b3t1.c1 = (
4492 SELECT max(b4t1.c1) FROM s1.t1 b4t1 WHERE b4t1.c1 = 1);
4494 ---------------------------------------------------------------------
4499 -> Index Scan using t1_i1 on t1 b1t1
4500 Index Cond: (c1 = 1)
4501 -> Seq Scan on t2 b1t2
4503 InitPlan 3 (returns $2)
4505 InitPlan 2 (returns $1)
4507 -> Index Scan using t1_i1 on t1 b2t1
4508 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
4509 InitPlan 5 (returns $4)
4511 InitPlan 4 (returns $3)
4513 -> Index Scan using t1_i1 on t1 b4t1
4514 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
4517 -> Index Scan using t1_i1 on t1 b3t1
4518 Index Cond: (c1 = $4)
4519 -> Seq Scan on t2 b3t2
4525 /*+SeqScan(b1t1)IndexScan(b2t1 t1_pkey)BitmapScan(b3t1 t1_pkey)TidScan(b4t1)
4526 TidScan(b1t2)IndexScan(b3t2 t2_pkey)
4528 EXPLAIN (COSTS false)
4530 SELECT max(b1t1.c1) FROM s1.t1 b1t1 JOIN s1.t2 b1t2 ON(b1t1.c1 = b1t2.c1) WHERE b1t1.c1 = 1)
4531 SELECT max(b3t1.c1), (
4532 SELECT max(b2t1.c1) FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
4533 ) FROM s1.t1 b3t1 JOIN s1.t2 b3t2 ON(b3t1.c1 = b3t2.c1) JOIN cte1 ON(b3t1.c1 = cte1.c1) WHERE b3t1.c1 = (
4534 SELECT max(b4t1.c1) FROM s1.t1 b4t1 WHERE b4t1.c1 = 1);
4539 IndexScan(b2t1 t1_pkey)
4540 BitmapScan(b3t1 t1_pkey)
4541 IndexScan(b3t2 t2_pkey)
4548 ---------------------------------------------------------------------
4553 -> Seq Scan on t1 b1t1
4555 -> Seq Scan on t2 b1t2
4557 InitPlan 3 (returns $2)
4559 InitPlan 2 (returns $1)
4561 -> Index Scan using t1_pkey on t1 b2t1
4562 Index Cond: ((c1 IS NOT NULL) AND (c1 = 1))
4563 InitPlan 5 (returns $4)
4565 InitPlan 4 (returns $3)
4567 -> Seq Scan on t1 b4t1
4568 Filter: ((c1 IS NOT NULL) AND (c1 = 1))
4571 -> Bitmap Heap Scan on t1 b3t1
4572 Recheck Cond: (c1 = $4)
4573 -> Bitmap Index Scan on t1_pkey
4574 Index Cond: (c1 = $4)
4577 -> Index Scan using t2_pkey on t2 b3t2
4578 Index Cond: (c1 = $4)
4582 ---- No. S-3-9 inheritance table select type
4585 EXPLAIN (COSTS false) SELECT * FROM ONLY s1.p1 WHERE c1 = 1;
4587 --------------------
4593 EXPLAIN (COSTS false) SELECT * FROM ONLY s1.p1 WHERE c1 = 1;
4602 -----------------------------
4603 Index Scan using p1_i on p1
4604 Index Cond: (c1 = 1)
4608 EXPLAIN (COSTS false) SELECT * FROM s1.p1 WHERE c1 = 1;
4610 ---------------------------------
4615 -> Seq Scan on p1c1 p1
4620 EXPLAIN (COSTS false) SELECT * FROM s1.p1 WHERE c1 = 1;
4629 ------------------------------------------------
4632 -> Index Scan using p1_i on p1
4633 Index Cond: (c1 = 1)
4634 -> Index Scan using p1c1_i on p1c1 p1
4635 Index Cond: (c1 = 1)
4639 ---- No. S-3-10 inheritance table number
4642 EXPLAIN (COSTS false) SELECT * FROM s1.p1 WHERE c1 = 1;
4644 ---------------------------------
4649 -> Seq Scan on p1c1 p1
4654 EXPLAIN (COSTS false) SELECT * FROM s1.p1 WHERE c1 = 1;
4663 ------------------------------------------------
4666 -> Index Scan using p1_i on p1
4667 Index Cond: (c1 = 1)
4668 -> Index Scan using p1c1_i on p1c1 p1
4669 Index Cond: (c1 = 1)
4673 EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1;
4675 -----------------------------------
4680 -> Seq Scan on p2c1 p2
4682 -> Seq Scan on p2c1c1 p2
4687 EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1;
4696 ----------------------------------------------------
4699 -> Index Scan using p2_i on p2
4700 Index Cond: (c1 = 1)
4701 -> Index Scan using p2c1_i on p2c1 p2
4702 Index Cond: (c1 = 1)
4703 -> Index Scan using p2c1c1_i on p2c1c1 p2
4704 Index Cond: (c1 = 1)
4708 ---- No. S-3-11 inheritance table specified table
4710 EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1;
4712 -----------------------------------
4717 -> Seq Scan on p2c1 p2
4719 -> Seq Scan on p2c1c1 p2
4725 EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1;
4734 ----------------------------------------------------
4737 -> Index Scan using p2_i on p2
4738 Index Cond: (c1 = 1)
4739 -> Index Scan using p2c1_i on p2c1 p2
4740 Index Cond: (c1 = 1)
4741 -> Index Scan using p2c1c1_i on p2c1c1 p2
4742 Index Cond: (c1 = 1)
4746 /*+IndexScan(p2c1)*/
4747 EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1;
4756 -----------------------------------
4761 -> Seq Scan on p2c1 p2
4763 -> Seq Scan on p2c1c1 p2
4768 /*+IndexScan(p2 p2_pkey p2c1_pkey p2c1c1_pkey)*/
4769 EXPLAIN (COSTS false) SELECT * FROM s1.p2 WHERE c1 = 1;
4772 IndexScan(p2 p2_pkey p2c1_pkey p2c1c1_pkey)
4778 -------------------------------------------------------
4781 -> Index Scan using p2_pkey on p2
4782 Index Cond: (c1 = 1)
4783 -> Index Scan using p2c1_pkey on p2c1 p2
4784 Index Cond: (c1 = 1)
4785 -> Index Scan using p2c1c1_pkey on p2c1c1 p2
4786 Index Cond: (c1 = 1)
4790 /*+IndexScan(p2 p2c1_pkey)*/
4791 EXPLAIN (COSTS true) SELECT * FROM s1.p2 WHERE c1 = 1;
4794 IndexScan(p2 p2c1_pkey)
4800 ------------------------------------------------------------------------------------------
4801 Result (cost=10000000000.00..20000000009.89 rows=3 width=34)
4802 -> Append (cost=10000000000.00..20000000009.89 rows=3 width=34)
4803 -> Seq Scan on p2 (cost=10000000000.00..10000000000.00 rows=1 width=44)
4805 -> Index Scan using p2c1_pkey on p2c1 p2 (cost=0.00..8.27 rows=1 width=44)
4806 Index Cond: (c1 = 1)
4807 -> Seq Scan on p2c1c1 p2 (cost=10000000000.00..10000000001.62 rows=1 width=14)
4812 ---- No. S-3-12 specified same table
4815 /*+IndexScan(ti1) BitmapScan(ti1)*/
4816 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4817 INFO: hint syntax error at or near "IndexScan(ti1) BitmapScan(ti1)"
4818 DETAIL: Conflict scan method hint.
4828 -------------------------------------
4829 Bitmap Heap Scan on ti1
4830 Recheck Cond: (c1 = 1)
4831 Filter: (ctid = '(1,1)'::tid)
4832 -> Bitmap Index Scan on ti1_uniq
4833 Index Cond: (c1 = 1)
4837 /*+IndexScan(ti1 ti1_pkey) BitmapScan(ti1 ti1_btree)*/
4838 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4839 INFO: hint syntax error at or near "IndexScan(ti1 ti1_pkey) BitmapScan(ti1 ti1_btree)"
4840 DETAIL: Conflict scan method hint.
4843 BitmapScan(ti1 ti1_btree)
4846 IndexScan(ti1 ti1_pkey)
4850 --------------------------------------
4851 Bitmap Heap Scan on ti1
4852 Recheck Cond: (c1 = 1)
4853 Filter: (ctid = '(1,1)'::tid)
4854 -> Bitmap Index Scan on ti1_btree
4855 Index Cond: (c1 = 1)
4859 /*+BitmapScan(ti1) IndexScan(ti1) BitmapScan(ti1)*/
4860 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4861 INFO: hint syntax error at or near "BitmapScan(ti1) IndexScan(ti1) BitmapScan(ti1)"
4862 DETAIL: Conflict scan method hint.
4863 INFO: hint syntax error at or near "IndexScan(ti1) BitmapScan(ti1)"
4864 DETAIL: Conflict scan method hint.
4875 -------------------------------------
4876 Bitmap Heap Scan on ti1
4877 Recheck Cond: (c1 = 1)
4878 Filter: (ctid = '(1,1)'::tid)
4879 -> Bitmap Index Scan on ti1_uniq
4880 Index Cond: (c1 = 1)
4884 /*+BitmapScan(ti1 ti1_hash) IndexScan(ti1 ti1_pkey) BitmapScan(ti1 ti1_btree)*/
4885 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4886 INFO: hint syntax error at or near "BitmapScan(ti1 ti1_hash) IndexScan(ti1 ti1_pkey) BitmapScan(ti1 ti1_btree)"
4887 DETAIL: Conflict scan method hint.
4888 INFO: hint syntax error at or near "IndexScan(ti1 ti1_pkey) BitmapScan(ti1 ti1_btree)"
4889 DETAIL: Conflict scan method hint.
4892 BitmapScan(ti1 ti1_btree)
4895 BitmapScan(ti1 ti1_hash)
4896 IndexScan(ti1 ti1_pkey)
4900 --------------------------------------
4901 Bitmap Heap Scan on ti1
4902 Recheck Cond: (c1 = 1)
4903 Filter: (ctid = '(1,1)'::tid)
4904 -> Bitmap Index Scan on ti1_btree
4905 Index Cond: (c1 = 1)
4909 ---- No. S-3-13 message output
4913 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4922 ------------------------------------------------
4924 Filter: ((c1 = 1) AND (ctid = '(1,1)'::tid))
4928 /*+SeqScan(ti1 ti1_pkey)*/
4929 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4930 INFO: hint syntax error at or near ""
4931 DETAIL: SeqScan hint requires only one relation.
4937 SeqScan(ti1 ti1_pkey)
4940 -----------------------------------
4942 TID Cond: (ctid = '(1,1)'::tid)
4947 /*+SeqScan(ti1 ti1_pkey ti1_btree)*/
4948 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4949 INFO: hint syntax error at or near ""
4950 DETAIL: SeqScan hint requires only one relation.
4956 SeqScan(ti1 ti1_pkey ti1_btree)
4959 -----------------------------------
4961 TID Cond: (ctid = '(1,1)'::tid)
4967 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4976 ----------------------------------
4977 Index Scan using ti1_uniq on ti1
4978 Index Cond: (c1 = 1)
4979 Filter: (ctid = '(1,1)'::tid)
4983 /*+IndexScan(ti1 ti1_pkey)*/
4984 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
4987 IndexScan(ti1 ti1_pkey)
4993 ----------------------------------
4994 Index Scan using ti1_pkey on ti1
4995 Index Cond: (c1 = 1)
4996 Filter: (ctid = '(1,1)'::tid)
5000 /*+IndexScan(ti1 ti1_pkey ti1_btree)*/
5001 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5004 IndexScan(ti1 ti1_pkey ti1_btree)
5010 -----------------------------------
5011 Index Scan using ti1_btree on ti1
5012 Index Cond: (c1 = 1)
5013 Filter: (ctid = '(1,1)'::tid)
5017 /*+BitmapScan(ti1)*/
5018 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5027 -------------------------------------
5028 Bitmap Heap Scan on ti1
5029 Recheck Cond: (c1 = 1)
5030 Filter: (ctid = '(1,1)'::tid)
5031 -> Bitmap Index Scan on ti1_uniq
5032 Index Cond: (c1 = 1)
5036 /*+BitmapScan(ti1 ti1_pkey)*/
5037 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5040 BitmapScan(ti1 ti1_pkey)
5046 -------------------------------------
5047 Bitmap Heap Scan on ti1
5048 Recheck Cond: (c1 = 1)
5049 Filter: (ctid = '(1,1)'::tid)
5050 -> Bitmap Index Scan on ti1_pkey
5051 Index Cond: (c1 = 1)
5055 /*+BitmapScan(ti1 ti1_pkey ti1_btree)*/
5056 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5059 BitmapScan(ti1 ti1_pkey ti1_btree)
5065 --------------------------------------
5066 Bitmap Heap Scan on ti1
5067 Recheck Cond: (c1 = 1)
5068 Filter: (ctid = '(1,1)'::tid)
5069 -> Bitmap Index Scan on ti1_btree
5070 Index Cond: (c1 = 1)
5075 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5084 -----------------------------------
5086 TID Cond: (ctid = '(1,1)'::tid)
5091 /*+TidScan(ti1 ti1_pkey)*/
5092 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5093 INFO: hint syntax error at or near ""
5094 DETAIL: TidScan hint requires only one relation.
5100 TidScan(ti1 ti1_pkey)
5103 -----------------------------------
5105 TID Cond: (ctid = '(1,1)'::tid)
5110 /*+TidScan(ti1 ti1_pkey ti1_btree)*/
5111 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5112 INFO: hint syntax error at or near ""
5113 DETAIL: TidScan hint requires only one relation.
5119 TidScan(ti1 ti1_pkey ti1_btree)
5122 -----------------------------------
5124 TID Cond: (ctid = '(1,1)'::tid)
5130 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5139 -----------------------------------
5141 TID Cond: (ctid = '(1,1)'::tid)
5146 /*+NoSeqScan(ti1 ti1_pkey)*/
5147 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5148 INFO: hint syntax error at or near ""
5149 DETAIL: NoSeqScan hint requires only one relation.
5155 NoSeqScan(ti1 ti1_pkey)
5158 -----------------------------------
5160 TID Cond: (ctid = '(1,1)'::tid)
5165 /*+NoSeqScan(ti1 ti1_pkey ti1_btree)*/
5166 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5167 INFO: hint syntax error at or near ""
5168 DETAIL: NoSeqScan hint requires only one relation.
5174 NoSeqScan(ti1 ti1_pkey ti1_btree)
5177 -----------------------------------
5179 TID Cond: (ctid = '(1,1)'::tid)
5184 /*+NoIndexScan(ti1)*/
5185 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5194 -----------------------------------
5196 TID Cond: (ctid = '(1,1)'::tid)
5201 /*+NoIndexScan(ti1 ti1_pkey)*/
5202 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5203 INFO: hint syntax error at or near ""
5204 DETAIL: NoIndexScan hint requires only one relation.
5210 NoIndexScan(ti1 ti1_pkey)
5213 -----------------------------------
5215 TID Cond: (ctid = '(1,1)'::tid)
5220 /*+NoIndexScan(ti1 ti1_pkey ti1_btree)*/
5221 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5222 INFO: hint syntax error at or near ""
5223 DETAIL: NoIndexScan hint requires only one relation.
5229 NoIndexScan(ti1 ti1_pkey ti1_btree)
5232 -----------------------------------
5234 TID Cond: (ctid = '(1,1)'::tid)
5239 /*+NoBitmapScan(ti1)*/
5240 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5249 -----------------------------------
5251 TID Cond: (ctid = '(1,1)'::tid)
5256 /*+NoBitmapScan(ti1 ti1_pkey)*/
5257 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5258 INFO: hint syntax error at or near ""
5259 DETAIL: NoBitmapScan hint requires only one relation.
5265 NoBitmapScan(ti1 ti1_pkey)
5268 -----------------------------------
5270 TID Cond: (ctid = '(1,1)'::tid)
5275 /*+NoBitmapScan(ti1 ti1_pkey ti1_btree)*/
5276 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5277 INFO: hint syntax error at or near ""
5278 DETAIL: NoBitmapScan hint requires only one relation.
5284 NoBitmapScan(ti1 ti1_pkey ti1_btree)
5287 -----------------------------------
5289 TID Cond: (ctid = '(1,1)'::tid)
5295 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5304 ----------------------------------
5305 Index Scan using ti1_uniq on ti1
5306 Index Cond: (c1 = 1)
5307 Filter: (ctid = '(1,1)'::tid)
5311 /*+NoTidScan(ti1 ti1_pkey)*/
5312 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5313 INFO: hint syntax error at or near ""
5314 DETAIL: NoTidScan hint requires only one relation.
5320 NoTidScan(ti1 ti1_pkey)
5323 -----------------------------------
5325 TID Cond: (ctid = '(1,1)'::tid)
5330 /*+NoTidScan(ti1 ti1_pkey ti1_btree)*/
5331 EXPLAIN (COSTS false) SELECT * FROM s1.ti1 WHERE c1 = 1 AND ctid = '(1,1)';
5332 INFO: hint syntax error at or near ""
5333 DETAIL: NoTidScan hint requires only one relation.
5339 NoTidScan(ti1 ti1_pkey ti1_btree)
5342 -----------------------------------
5344 TID Cond: (ctid = '(1,1)'::tid)
5349 /*+IndexOnlyScan(ti1)*/
5350 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
5351 INFO: hint syntax error at or near "IndexOnlyScan(ti1)"
5352 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
5354 ---------------------
5360 /*+IndexOnlyScan(ti1 ti1_pkey)*/
5361 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
5362 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_pkey)"
5363 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
5365 ---------------------
5371 /*+IndexOnlyScan(ti1 ti1_pkey ti1_btree)*/
5372 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 >= 1;
5373 INFO: hint syntax error at or near "IndexOnlyScan(ti1 ti1_pkey ti1_btree)"
5374 DETAIL: Unrecognized hint keyword "IndexOnlyScan".
5376 ---------------------
5382 /*+NoIndexOnlyScan(ti1)*/
5383 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 = 1;
5384 INFO: hint syntax error at or near "NoIndexOnlyScan(ti1)"
5385 DETAIL: Unrecognized hint keyword "NoIndexOnlyScan".
5387 ----------------------------------
5388 Index Scan using ti1_uniq on ti1
5389 Index Cond: (c1 = 1)
5393 /*+NoIndexOnlyScan(ti1 ti1_pkey)*/
5394 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 = 1;
5395 INFO: hint syntax error at or near "NoIndexOnlyScan(ti1 ti1_pkey)"
5396 DETAIL: Unrecognized hint keyword "NoIndexOnlyScan".
5398 ----------------------------------
5399 Index Scan using ti1_uniq on ti1
5400 Index Cond: (c1 = 1)
5404 /*+NoIndexOnlyScan(ti1 ti1_pkey ti1_btree)*/
5405 EXPLAIN (COSTS false) SELECT c1 FROM s1.ti1 WHERE c1 = 1;
5406 INFO: hint syntax error at or near "NoIndexOnlyScan(ti1 ti1_pkey ti1_btree)"
5407 DETAIL: Unrecognized hint keyword "NoIndexOnlyScan".
5409 ----------------------------------
5410 Index Scan using ti1_uniq on ti1
5411 Index Cond: (c1 = 1)