1 SET search_path TO public;
2 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
4 --------------------------------------
6 Merge Cond: (t1.id = t2.id)
7 -> Index Scan using t1_pkey on t1
8 -> Index Scan using t2_pkey on t2
11 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.val = t2.val;
13 -------------------------------------------
15 Merge Cond: (t2.val = t1.val)
16 -> Index Scan using t2_val on t2
18 -> Index Scan using t1_val on t1
22 SET pg_hint_plan.debug_print TO on;
23 SET client_min_messages TO LOG;
24 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
26 --------------------------------------
28 Merge Cond: (t1.id = t2.id)
29 -> Index Scan using t1_pkey on t1
30 -> Index Scan using t2_pkey on t2
33 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.val = t2.val;
35 -------------------------------------------
37 Merge Cond: (t2.val = t1.val)
38 -> Index Scan using t2_val on t2
40 -> Index Scan using t1_val on t1
44 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
45 INFO: hint syntax error at or near "Test (t1 t2) "
46 DETAIL: Keyword "Test" does not exist.
48 --------------------------------------
50 Merge Cond: (t1.id = t2.id)
51 -> Index Scan using t1_pkey on t1
52 -> Index Scan using t2_pkey on t2
55 SET pg_hint_plan.enable TO off;
57 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
59 --------------------------------------
61 Merge Cond: (t1.id = t2.id)
62 -> Index Scan using t1_pkey on t1
63 -> Index Scan using t2_pkey on t2
66 SET pg_hint_plan.enable TO on;
67 /*+Set(enable_indexscan off)*/
68 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
71 Set(enable_indexscan off)
77 ------------------------------
79 Hash Cond: (t1.id = t2.id)
85 /*+ Set(enable_indexscan off) Set(enable_hashjoin off) */
86 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
89 Set(enable_hashjoin off)
90 Set(enable_indexscan off)
96 -------------------------------
98 Merge Cond: (t1.id = t2.id)
107 /*+ Set ( enable_indexscan off ) */
108 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
111 Set(enable_indexscan off)
117 ------------------------------
119 Hash Cond: (t1.id = t2.id)
132 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
135 Set(enable_indexscan off)
141 ------------------------------
143 Hash Cond: (t1.id = t2.id)
149 /*+ Set(enable_indexscan off)Set(enable_nestloop off)Set(enable_mergejoin off)
150 Set(enable_seqscan off)
152 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
155 Set(enable_indexscan off)
156 Set(enable_mergejoin off)
157 Set(enable_nestloop off)
158 Set(enable_seqscan off)
164 --------------------------------------------
166 Hash Cond: (t1.id = t2.id)
167 -> Index Scan using t1_pkey on t1
169 -> Index Scan using t2_pkey on t2
172 /*+Set(work_mem "1M")*/
173 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
174 INFO: invalid value for parameter "work_mem": "1M"
175 HINT: Valid units for this parameter are "kB", "MB", and "GB".
184 --------------------------------------
186 Merge Cond: (t1.id = t2.id)
187 -> Index Scan using t1_pkey on t1
188 -> Index Scan using t2_pkey on t2
191 /*+Set(work_mem "1MB")*/
192 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
201 --------------------------------------
203 Merge Cond: (t1.id = t2.id)
204 -> Index Scan using t1_pkey on t1
205 -> Index Scan using t2_pkey on t2
208 /*+Set(work_mem TO "1MB")*/
209 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
210 INFO: hint syntax error at or near ""1MB")"
211 DETAIL: Closed parenthesis is necessary.
213 --------------------------------------
215 Merge Cond: (t1.id = t2.id)
216 -> Index Scan using t1_pkey on t1
217 -> Index Scan using t2_pkey on t2
221 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
222 INFO: hint syntax error at or near "t2)"
223 DETAIL: Closed parenthesis is necessary.
225 --------------------------------------
227 Merge Cond: (t1.id = t2.id)
228 -> Index Scan using t1_pkey on t1
229 -> Index Scan using t2_pkey on t2
233 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
242 ------------------------------
244 Hash Cond: (t1.id = t2.id)
250 /*+SeqScan(t1)IndexScan(t2)*/
251 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
261 --------------------------------------------
263 Hash Cond: (t1.id = t2.id)
266 -> Index Scan using t2_pkey on t2
270 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
279 ------------------------------------------
282 -> Bitmap Heap Scan on t2
283 Recheck Cond: (id = t1.id)
284 -> Bitmap Index Scan on t2_pkey
285 Index Cond: (id = t1.id)
288 /*+BitmapScan(t2)NoSeqScan(t1)*/
289 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
299 ------------------------------------------
301 -> Index Scan using t1_pkey on t1
302 -> Bitmap Heap Scan on t2
303 Recheck Cond: (id = t1.id)
304 -> Bitmap Index Scan on t2_pkey
305 Index Cond: (id = t1.id)
309 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
318 ------------------------------
320 Hash Cond: (t1.id = t2.id)
326 /*+NoBitmapScan(t1)*/
327 EXPLAIN (COSTS false) SELECT * FROM t1, t4 WHERE t1.val < 10;
336 ----------------------------
345 EXPLAIN (COSTS false) SELECT * FROM t3, t4 WHERE t3.id = t4.id AND t4.ctid = '(1,1)';
354 -----------------------------------------------
356 Merge Cond: (t3.id = t4.id)
357 -> Index Scan using t3_pkey on t3
361 TID Cond: (ctid = '(1,1)'::tid)
365 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)';
374 ---------------------------------------
377 Filter: (ctid = '(1,1)'::tid)
378 -> Index Scan using t2_pkey on t2
379 Index Cond: (id = t1.id)
383 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
392 ------------------------------
394 Hash Cond: (t1.id = t2.id)
401 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
410 --------------------------------------
413 -> Index Scan using t1_pkey on t1
414 Index Cond: (id = t2.id)
417 /*+NoMergeJoin(t1 t2)*/
418 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
427 ------------------------------
429 Hash Cond: (t1.id = t2.id)
435 /*+MergeJoin(t1 t3)*/
436 EXPLAIN (COSTS false) SELECT * FROM t1, t3 WHERE t1.val = t3.val;
445 -------------------------------------
447 Merge Cond: (t1.val = t3.val)
448 -> Index Scan using t1_val on t1
455 EXPLAIN (COSTS false) SELECT * FROM t1, t3 WHERE t1.val = t3.val;
464 -------------------------------------
467 -> Index Scan using t1_val on t1
468 Index Cond: (val = t3.val)
471 /*+NoHashJoin(t1 t3)*/
472 EXPLAIN (COSTS false) SELECT * FROM t1, t3 WHERE t1.val = t3.val;
481 -------------------------------------
484 -> Index Scan using t1_val on t1
485 Index Cond: (val = t3.val)
488 /*+MergeJoin(t4 t1 t2 t3)*/
489 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
492 MergeJoin(t1 t2 t3 t4)
498 --------------------------------------------------
500 Merge Cond: (t1.id = t4.id)
502 Merge Cond: (t1.id = t3.id)
504 Merge Cond: (t1.id = t2.id)
505 -> Index Scan using t1_pkey on t1
506 -> Index Scan using t2_pkey on t2
507 -> Index Scan using t3_pkey on t3
513 /*+HashJoin(t3 t4 t1 t2)*/
514 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
517 HashJoin(t1 t2 t3 t4)
523 --------------------------------------------------------
525 Hash Cond: (t3.id = t1.id)
529 Merge Cond: (t1.id = t4.id)
531 Merge Cond: (t1.id = t2.id)
532 -> Index Scan using t1_pkey on t1
533 -> Index Scan using t2_pkey on t2
539 /*+NestLoop(t2 t3 t4 t1) IndexScan(t3)*/
540 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
544 NestLoop(t1 t2 t3 t4)
550 --------------------------------------------------
553 Merge Cond: (t1.id = t4.id)
555 Merge Cond: (t1.id = t2.id)
556 -> Index Scan using t1_pkey on t1
557 -> Index Scan using t2_pkey on t2
561 -> Index Scan using t3_pkey on t3
562 Index Cond: (id = t1.id)
565 /*+NoNestLoop(t4 t1 t3 t2)*/
566 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
569 NoNestLoop(t1 t2 t3 t4)
575 --------------------------------------------------
577 Merge Cond: (t1.id = t4.id)
579 Merge Cond: (t1.id = t3.id)
581 Merge Cond: (t1.id = t2.id)
582 -> Index Scan using t1_pkey on t1
583 -> Index Scan using t2_pkey on t2
584 -> Index Scan using t3_pkey on t3
591 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
592 INFO: hint syntax error at or near ""
593 DETAIL: relation name is necessary.
595 --------------------------------------------------
597 Merge Cond: (t1.id = t4.id)
599 Merge Cond: (t1.id = t3.id)
601 Merge Cond: (t1.id = t2.id)
602 -> Index Scan using t1_pkey on t1
603 -> Index Scan using t2_pkey on t2
604 -> Index Scan using t3_pkey on t3
611 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
612 INFO: hint syntax error at or near "Leading( )"
613 DETAIL: In Leading hint, specified relation name 2 or more.
622 --------------------------------------------------
624 Merge Cond: (t1.id = t4.id)
626 Merge Cond: (t1.id = t3.id)
628 Merge Cond: (t1.id = t2.id)
629 -> Index Scan using t1_pkey on t1
630 -> Index Scan using t2_pkey on t2
631 -> Index Scan using t3_pkey on t3
638 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
639 INFO: hint syntax error at or near "Leading( t3 )"
640 DETAIL: In Leading hint, specified relation name 2 or more.
649 --------------------------------------------------
651 Merge Cond: (t1.id = t4.id)
653 Merge Cond: (t1.id = t3.id)
655 Merge Cond: (t1.id = t2.id)
656 -> Index Scan using t1_pkey on t1
657 -> Index Scan using t2_pkey on t2
658 -> Index Scan using t3_pkey on t3
664 /*+Leading( t3 t4 )*/
665 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
674 --------------------------------------------------
678 Merge Cond: (t3.id = t4.id)
679 -> Index Scan using t3_pkey on t3
683 -> Index Scan using t2_pkey on t2
684 Index Cond: (id = t3.id)
685 -> Index Scan using t1_pkey on t1
686 Index Cond: (id = t2.id)
689 /*+Leading(t3 t4 t1)*/
690 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
699 --------------------------------------------------
702 Merge Cond: (t3.id = t1.id)
704 Merge Cond: (t3.id = t4.id)
705 -> Index Scan using t3_pkey on t3
709 -> Index Scan using t1_pkey on t1
710 -> Index Scan using t2_pkey on t2
711 Index Cond: (id = t1.id)
714 /*+Leading(t3 t4 t1 t2)*/
715 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
724 --------------------------------------------------
727 Merge Cond: (t3.id = t1.id)
729 Merge Cond: (t3.id = t4.id)
730 -> Index Scan using t3_pkey on t3
734 -> Index Scan using t1_pkey on t1
735 -> Index Scan using t2_pkey on t2
736 Index Cond: (id = t1.id)
739 /*+Leading(t3 t4 t1 t2 t1)*/
740 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
743 Leading(t3 t4 t1 t2 t1)
749 --------------------------------------------------
752 Merge Cond: (t3.id = t1.id)
754 Merge Cond: (t3.id = t4.id)
755 -> Index Scan using t3_pkey on t3
759 -> Index Scan using t1_pkey on t1
760 -> Index Scan using t2_pkey on t2
761 Index Cond: (id = t1.id)
764 /*+Leading(t3 t4 t4)*/
765 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
766 INFO: hint syntax error at or near "Leading(t3 t4 t4)"
767 DETAIL: Relation name "t4" is duplicate.
776 --------------------------------------------------
778 Merge Cond: (t1.id = t4.id)
780 Merge Cond: (t1.id = t3.id)
782 Merge Cond: (t1.id = t2.id)
783 -> Index Scan using t1_pkey on t1
784 -> Index Scan using t2_pkey on t2
785 -> Index Scan using t3_pkey on t3
791 EXPLAIN (COSTS false) SELECT * FROM t1, (VALUES(1,1),(2,2),(3,3)) AS t2(id,val) WHERE t1.id = t2.id;
793 -----------------------------------------------
795 -> Values Scan on "*VALUES*"
796 -> Index Scan using t1_pkey on t1
797 Index Cond: (id = "*VALUES*".column1)
801 EXPLAIN (COSTS false) SELECT * FROM t1, (VALUES(1,1),(2,2),(3,3)) AS t2(id,val) WHERE t1.id = t2.id;
810 -----------------------------------------------
812 -> Values Scan on "*VALUES*"
813 -> Index Scan using t1_pkey on t1
814 Index Cond: (id = "*VALUES*".column1)
817 /*+HashJoin(t1 *VALUES*)*/
818 EXPLAIN (COSTS false) SELECT * FROM t1, (VALUES(1,1),(2,2),(3,3)) AS t2(id,val) WHERE t1.id = t2.id;
821 HashJoin(*VALUES* t1)
827 -------------------------------------------
829 Hash Cond: (t1.id = "*VALUES*".column1)
832 -> Values Scan on "*VALUES*"
835 /*+HashJoin(t1 *VALUES*) IndexScan(t1) IndexScan(*VALUES*)*/
836 EXPLAIN (COSTS false) SELECT * FROM t1, (VALUES(1,1),(2,2),(3,3)) AS t2(id,val) WHERE t1.id = t2.id;
840 HashJoin(*VALUES* t1)
847 -------------------------------------------
849 Hash Cond: (t1.id = "*VALUES*".column1)
850 -> Index Scan using t1_pkey on t1
852 -> Values Scan on "*VALUES*"
855 -- single table scan hint test
856 EXPLAIN SELECT (SELECT max(id) FROM t1 v_1 WHERE id < 10), id FROM v1 WHERE v1.id = (SELECT max(id) FROM t1 v_2 WHERE id < 10);
858 -----------------------------------------------------------------------------------------------------
859 Index Scan using t1_pkey on t1 (cost=1.89..10.16 rows=1 width=4)
860 Index Cond: (id = $3)
861 InitPlan 2 (returns $1)
862 -> Result (cost=0.94..0.95 rows=1 width=0)
863 InitPlan 1 (returns $0)
864 -> Limit (cost=0.00..0.94 rows=1 width=4)
865 -> Index Scan Backward using t1_pkey on t1 v_1 (cost=0.00..8.43 rows=9 width=4)
866 Index Cond: ((id IS NOT NULL) AND (id < 10))
867 InitPlan 4 (returns $3)
868 -> Result (cost=0.94..0.95 rows=1 width=0)
869 InitPlan 3 (returns $2)
870 -> Limit (cost=0.00..0.94 rows=1 width=4)
871 -> Index Scan Backward using t1_pkey on t1 v_2 (cost=0.00..8.43 rows=9 width=4)
872 Index Cond: ((id IS NOT NULL) AND (id < 10))
876 EXPLAIN SELECT (SELECT max(id) FROM t1 v_1 WHERE id < 10), id FROM v1 WHERE v1.id = (SELECT max(id) FROM t1 v_2 WHERE id < 10);
885 -----------------------------------------------------------------------------------------------------
886 Index Scan using t1_pkey on t1 (cost=29.34..37.61 rows=1 width=4)
887 Index Cond: (id = $2)
888 InitPlan 1 (returns $0)
889 -> Aggregate (cost=28.38..28.39 rows=1 width=4)
890 -> Bitmap Heap Scan on t1 v_1 (cost=4.32..28.36 rows=9 width=4)
891 Recheck Cond: (id < 10)
892 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.32 rows=9 width=0)
893 Index Cond: (id < 10)
894 InitPlan 3 (returns $2)
895 -> Result (cost=0.94..0.95 rows=1 width=0)
896 InitPlan 2 (returns $1)
897 -> Limit (cost=0.00..0.94 rows=1 width=4)
898 -> Index Scan Backward using t1_pkey on t1 v_2 (cost=0.00..8.43 rows=9 width=4)
899 Index Cond: ((id IS NOT NULL) AND (id < 10))
903 EXPLAIN SELECT (SELECT max(id) FROM t1 v_1 WHERE id < 10), id FROM v1 WHERE v1.id = (SELECT max(id) FROM t1 v_2 WHERE id < 10);
912 -----------------------------------------------------------------------------------------------------
913 Index Scan using t1_pkey on t1 (cost=29.34..37.61 rows=1 width=4)
914 Index Cond: (id = $2)
915 InitPlan 2 (returns $1)
916 -> Result (cost=0.94..0.95 rows=1 width=0)
917 InitPlan 1 (returns $0)
918 -> Limit (cost=0.00..0.94 rows=1 width=4)
919 -> Index Scan Backward using t1_pkey on t1 v_1 (cost=0.00..8.43 rows=9 width=4)
920 Index Cond: ((id IS NOT NULL) AND (id < 10))
921 InitPlan 3 (returns $2)
922 -> Aggregate (cost=28.38..28.39 rows=1 width=4)
923 -> Bitmap Heap Scan on t1 v_2 (cost=4.32..28.36 rows=9 width=4)
924 Recheck Cond: (id < 10)
925 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.32 rows=9 width=0)
926 Index Cond: (id < 10)
930 EXPLAIN SELECT (SELECT max(id) FROM t1 v_1 WHERE id < 10), id FROM v1 WHERE v1.id = (SELECT max(id) FROM t1 v_2 WHERE id < 10);
939 -----------------------------------------------------------------------------------------------------
940 Bitmap Heap Scan on t1 (cost=6.15..10.17 rows=1 width=4)
941 Recheck Cond: (id = $3)
942 InitPlan 2 (returns $1)
943 -> Result (cost=0.94..0.95 rows=1 width=0)
944 InitPlan 1 (returns $0)
945 -> Limit (cost=0.00..0.94 rows=1 width=4)
946 -> Index Scan Backward using t1_pkey on t1 v_1 (cost=0.00..8.43 rows=9 width=4)
947 Index Cond: ((id IS NOT NULL) AND (id < 10))
948 InitPlan 4 (returns $3)
949 -> Result (cost=0.94..0.95 rows=1 width=0)
950 InitPlan 3 (returns $2)
951 -> Limit (cost=0.00..0.94 rows=1 width=4)
952 -> Index Scan Backward using t1_pkey on t1 v_2 (cost=0.00..8.43 rows=9 width=4)
953 Index Cond: ((id IS NOT NULL) AND (id < 10))
954 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.26 rows=1 width=0)
955 Index Cond: (id = $3)
958 /*+BitmapScan(v_1)BitmapScan(v_2)*/
959 EXPLAIN SELECT (SELECT max(id) FROM t1 v_1 WHERE id < 10), id FROM v1 WHERE v1.id = (SELECT max(id) FROM t1 v_2 WHERE id < 10);
969 ------------------------------------------------------------------------------------
970 Index Scan using t1_pkey on t1 (cost=56.78..65.05 rows=1 width=4)
971 Index Cond: (id = $1)
972 InitPlan 1 (returns $0)
973 -> Aggregate (cost=28.38..28.39 rows=1 width=4)
974 -> Bitmap Heap Scan on t1 v_1 (cost=4.32..28.36 rows=9 width=4)
975 Recheck Cond: (id < 10)
976 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.32 rows=9 width=0)
977 Index Cond: (id < 10)
978 InitPlan 2 (returns $1)
979 -> Aggregate (cost=28.38..28.39 rows=1 width=4)
980 -> Bitmap Heap Scan on t1 v_2 (cost=4.32..28.36 rows=9 width=4)
981 Recheck Cond: (id < 10)
982 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.32 rows=9 width=0)
983 Index Cond: (id < 10)
986 /*+BitmapScan(v_1)BitmapScan(t1)*/
987 EXPLAIN SELECT (SELECT max(id) FROM t1 v_1 WHERE id < 10), id FROM v1 WHERE v1.id = (SELECT max(id) FROM t1 v_2 WHERE id < 10);
997 -----------------------------------------------------------------------------------------------------
998 Bitmap Heap Scan on t1 (cost=33.60..37.61 rows=1 width=4)
999 Recheck Cond: (id = $2)
1000 InitPlan 1 (returns $0)
1001 -> Aggregate (cost=28.38..28.39 rows=1 width=4)
1002 -> Bitmap Heap Scan on t1 v_1 (cost=4.32..28.36 rows=9 width=4)
1003 Recheck Cond: (id < 10)
1004 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.32 rows=9 width=0)
1005 Index Cond: (id < 10)
1006 InitPlan 3 (returns $2)
1007 -> Result (cost=0.94..0.95 rows=1 width=0)
1008 InitPlan 2 (returns $1)
1009 -> Limit (cost=0.00..0.94 rows=1 width=4)
1010 -> Index Scan Backward using t1_pkey on t1 v_2 (cost=0.00..8.43 rows=9 width=4)
1011 Index Cond: ((id IS NOT NULL) AND (id < 10))
1012 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.26 rows=1 width=0)
1013 Index Cond: (id = $2)
1016 /*+BitmapScan(v_2)BitmapScan(t1)*/
1017 EXPLAIN SELECT (SELECT max(id) FROM t1 v_1 WHERE id < 10), id FROM v1 WHERE v1.id = (SELECT max(id) FROM t1 v_2 WHERE id < 10);
1027 -----------------------------------------------------------------------------------------------------
1028 Bitmap Heap Scan on t1 (cost=33.60..37.61 rows=1 width=4)
1029 Recheck Cond: (id = $2)
1030 InitPlan 2 (returns $1)
1031 -> Result (cost=0.94..0.95 rows=1 width=0)
1032 InitPlan 1 (returns $0)
1033 -> Limit (cost=0.00..0.94 rows=1 width=4)
1034 -> Index Scan Backward using t1_pkey on t1 v_1 (cost=0.00..8.43 rows=9 width=4)
1035 Index Cond: ((id IS NOT NULL) AND (id < 10))
1036 InitPlan 3 (returns $2)
1037 -> Aggregate (cost=28.38..28.39 rows=1 width=4)
1038 -> Bitmap Heap Scan on t1 v_2 (cost=4.32..28.36 rows=9 width=4)
1039 Recheck Cond: (id < 10)
1040 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.32 rows=9 width=0)
1041 Index Cond: (id < 10)
1042 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.26 rows=1 width=0)
1043 Index Cond: (id = $2)
1046 /*+BitmapScan(v_1)BitmapScan(v_2)BitmapScan(t1)*/
1047 EXPLAIN SELECT (SELECT max(id) FROM t1 v_1 WHERE id < 10), id FROM v1 WHERE v1.id = (SELECT max(id) FROM t1 v_2 WHERE id < 10);
1058 ------------------------------------------------------------------------------------
1059 Bitmap Heap Scan on t1 (cost=61.04..65.05 rows=1 width=4)
1060 Recheck Cond: (id = $1)
1061 InitPlan 1 (returns $0)
1062 -> Aggregate (cost=28.38..28.39 rows=1 width=4)
1063 -> Bitmap Heap Scan on t1 v_1 (cost=4.32..28.36 rows=9 width=4)
1064 Recheck Cond: (id < 10)
1065 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.32 rows=9 width=0)
1066 Index Cond: (id < 10)
1067 InitPlan 2 (returns $1)
1068 -> Aggregate (cost=28.38..28.39 rows=1 width=4)
1069 -> Bitmap Heap Scan on t1 v_2 (cost=4.32..28.36 rows=9 width=4)
1070 Recheck Cond: (id < 10)
1071 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.32 rows=9 width=0)
1072 Index Cond: (id < 10)
1073 -> Bitmap Index Scan on t1_pkey (cost=0.00..4.26 rows=1 width=0)
1074 Index Cond: (id = $1)
1077 -- full scan hint pattern test
1078 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1080 -----------------------------------
1082 TID Cond: (ctid = '(1,1)'::tid)
1087 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1096 -------------------------------------------------
1098 Filter: ((id < 10) AND (ctid = '(1,1)'::tid))
1102 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1111 ---------------------------------
1112 Index Scan using t1_pkey on t1
1113 Index Cond: (id < 10)
1114 Filter: (ctid = '(1,1)'::tid)
1118 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1127 ------------------------------------
1128 Bitmap Heap Scan on t1
1129 Recheck Cond: (id < 10)
1130 Filter: (ctid = '(1,1)'::tid)
1131 -> Bitmap Index Scan on t1_pkey
1132 Index Cond: (id < 10)
1136 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1145 -----------------------------------
1147 TID Cond: (ctid = '(1,1)'::tid)
1152 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1161 -----------------------------------
1163 TID Cond: (ctid = '(1,1)'::tid)
1167 /*+NoIndexScan(t1)*/
1168 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1177 -----------------------------------
1179 TID Cond: (ctid = '(1,1)'::tid)
1183 /*+NoBitmapScan(t1)*/
1184 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1193 -----------------------------------
1195 TID Cond: (ctid = '(1,1)'::tid)
1200 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE id < 10 AND ctid = '(1,1)';
1209 ---------------------------------
1210 Index Scan using t1_pkey on t1
1211 Index Cond: (id < 10)
1212 Filter: (ctid = '(1,1)'::tid)
1215 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1217 -----------------------------------------
1219 Join Filter: (t1.id = t2.id)
1221 TID Cond: (ctid = '(1,1)'::tid)
1223 TID Cond: (ctid = '(1,1)'::tid)
1227 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1236 -----------------------------------------
1238 Join Filter: (t1.id = t2.id)
1240 Filter: (ctid = '(1,1)'::tid)
1242 TID Cond: (ctid = '(1,1)'::tid)
1246 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1255 -----------------------------------------
1257 Join Filter: (t1.id = t2.id)
1259 TID Cond: (ctid = '(1,1)'::tid)
1261 Filter: (ctid = '(1,1)'::tid)
1264 /*+SeqScan(t1) SeqScan(t2)*/
1265 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1275 ---------------------------------------
1277 Join Filter: (t1.id = t2.id)
1279 Filter: (ctid = '(1,1)'::tid)
1281 Filter: (ctid = '(1,1)'::tid)
1284 /*+SeqScan(t1) IndexScan(t2)*/
1285 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1295 ---------------------------------------
1298 Filter: (ctid = '(1,1)'::tid)
1299 -> Index Scan using t2_pkey on t2
1300 Index Cond: (id = t1.id)
1301 Filter: (ctid = '(1,1)'::tid)
1304 /*+SeqScan(t1) BitmapScan(t2)*/
1305 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1315 ------------------------------------------
1318 Filter: (ctid = '(1,1)'::tid)
1319 -> Bitmap Heap Scan on t2
1320 Recheck Cond: (id = t1.id)
1321 Filter: (ctid = '(1,1)'::tid)
1322 -> Bitmap Index Scan on t2_pkey
1323 Index Cond: (id = t1.id)
1326 /*+SeqScan(t1) TidScan(t2)*/
1327 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1337 -----------------------------------------
1339 Join Filter: (t1.id = t2.id)
1341 Filter: (ctid = '(1,1)'::tid)
1343 TID Cond: (ctid = '(1,1)'::tid)
1346 /*+SeqScan(t1) NoSeqScan(t2)*/
1347 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1357 -----------------------------------------
1359 Join Filter: (t1.id = t2.id)
1361 Filter: (ctid = '(1,1)'::tid)
1363 TID Cond: (ctid = '(1,1)'::tid)
1366 /*+SeqScan(t1) NoIndexScan(t2)*/
1367 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1377 -----------------------------------------
1379 Join Filter: (t1.id = t2.id)
1381 Filter: (ctid = '(1,1)'::tid)
1383 TID Cond: (ctid = '(1,1)'::tid)
1386 /*+SeqScan(t1) NoBitmapScan(t2)*/
1387 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1397 -----------------------------------------
1399 Join Filter: (t1.id = t2.id)
1401 Filter: (ctid = '(1,1)'::tid)
1403 TID Cond: (ctid = '(1,1)'::tid)
1406 /*+SeqScan(t1) NoTidScan(t2)*/
1407 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1417 ---------------------------------------
1420 Filter: (ctid = '(1,1)'::tid)
1421 -> Index Scan using t2_pkey on t2
1422 Index Cond: (id = t1.id)
1423 Filter: (ctid = '(1,1)'::tid)
1427 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1436 -----------------------------------------
1439 TID Cond: (ctid = '(1,1)'::tid)
1440 -> Index Scan using t1_pkey on t1
1441 Index Cond: (id = t2.id)
1442 Filter: (ctid = '(1,1)'::tid)
1446 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1455 -----------------------------------------
1458 TID Cond: (ctid = '(1,1)'::tid)
1459 -> Index Scan using t2_pkey on t2
1460 Index Cond: (id = t1.id)
1461 Filter: (ctid = '(1,1)'::tid)
1464 /*+IndexScan(t1) SeqScan(t2)*/
1465 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1475 ---------------------------------------
1478 Filter: (ctid = '(1,1)'::tid)
1479 -> Index Scan using t1_pkey on t1
1480 Index Cond: (id = t2.id)
1481 Filter: (ctid = '(1,1)'::tid)
1484 /*+IndexScan(t1) IndexScan(t2)*/
1485 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1495 ---------------------------------------
1497 -> Index Scan using t2_pkey on t2
1498 Filter: (ctid = '(1,1)'::tid)
1499 -> Index Scan using t1_pkey on t1
1500 Index Cond: (id = t2.id)
1501 Filter: (ctid = '(1,1)'::tid)
1504 /*+IndexScan(t1) BitmapScan(t2)*/
1505 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1515 ------------------------------------------
1517 -> Index Scan using t1_pkey on t1
1518 Filter: (ctid = '(1,1)'::tid)
1519 -> Bitmap Heap Scan on t2
1520 Recheck Cond: (id = t1.id)
1521 Filter: (ctid = '(1,1)'::tid)
1522 -> Bitmap Index Scan on t2_pkey
1523 Index Cond: (id = t1.id)
1526 /*+IndexScan(t1) TidScan(t2)*/
1527 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1537 -----------------------------------------
1540 TID Cond: (ctid = '(1,1)'::tid)
1541 -> Index Scan using t1_pkey on t1
1542 Index Cond: (id = t2.id)
1543 Filter: (ctid = '(1,1)'::tid)
1546 /*+IndexScan(t1) NoSeqScan(t2)*/
1547 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1557 -----------------------------------------
1560 TID Cond: (ctid = '(1,1)'::tid)
1561 -> Index Scan using t1_pkey on t1
1562 Index Cond: (id = t2.id)
1563 Filter: (ctid = '(1,1)'::tid)
1566 /*+IndexScan(t1) NoIndexScan(t2)*/
1567 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1577 -----------------------------------------
1580 TID Cond: (ctid = '(1,1)'::tid)
1581 -> Index Scan using t1_pkey on t1
1582 Index Cond: (id = t2.id)
1583 Filter: (ctid = '(1,1)'::tid)
1586 /*+IndexScan(t1) NoBitmapScan(t2)*/
1587 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1597 -----------------------------------------
1600 TID Cond: (ctid = '(1,1)'::tid)
1601 -> Index Scan using t1_pkey on t1
1602 Index Cond: (id = t2.id)
1603 Filter: (ctid = '(1,1)'::tid)
1606 /*+IndexScan(t1) NoTidScan(t2)*/
1607 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1617 ---------------------------------------
1620 Filter: (ctid = '(1,1)'::tid)
1621 -> Index Scan using t1_pkey on t1
1622 Index Cond: (id = t2.id)
1623 Filter: (ctid = '(1,1)'::tid)
1627 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1636 ------------------------------------------
1639 TID Cond: (ctid = '(1,1)'::tid)
1640 -> Bitmap Heap Scan on t1
1641 Recheck Cond: (id = t2.id)
1642 Filter: (ctid = '(1,1)'::tid)
1643 -> Bitmap Index Scan on t1_pkey
1644 Index Cond: (id = t2.id)
1648 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1657 ------------------------------------------
1660 TID Cond: (ctid = '(1,1)'::tid)
1661 -> Bitmap Heap Scan on t2
1662 Recheck Cond: (id = t1.id)
1663 Filter: (ctid = '(1,1)'::tid)
1664 -> Bitmap Index Scan on t2_pkey
1665 Index Cond: (id = t1.id)
1669 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1678 ------------------------------------------
1681 TID Cond: (ctid = '(1,1)'::tid)
1682 -> Bitmap Heap Scan on t2
1683 Recheck Cond: (id = t1.id)
1684 Filter: (ctid = '(1,1)'::tid)
1685 -> Bitmap Index Scan on t2_pkey
1686 Index Cond: (id = t1.id)
1689 /*+BitmapScan(t1) SeqScan(t2)*/
1690 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1700 ------------------------------------------
1703 Filter: (ctid = '(1,1)'::tid)
1704 -> Bitmap Heap Scan on t1
1705 Recheck Cond: (id = t2.id)
1706 Filter: (ctid = '(1,1)'::tid)
1707 -> Bitmap Index Scan on t1_pkey
1708 Index Cond: (id = t2.id)
1711 /*+BitmapScan(t1) IndexScan(t2)*/
1712 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1722 ------------------------------------------
1724 -> Index Scan using t2_pkey on t2
1725 Filter: (ctid = '(1,1)'::tid)
1726 -> Bitmap Heap Scan on t1
1727 Recheck Cond: (id = t2.id)
1728 Filter: (ctid = '(1,1)'::tid)
1729 -> Bitmap Index Scan on t1_pkey
1730 Index Cond: (id = t2.id)
1733 /*+BitmapScan(t1) BitmapScan(t2)*/
1734 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1744 ------------------------------------------
1746 -> Index Scan using t2_pkey on t2
1747 Filter: (ctid = '(1,1)'::tid)
1748 -> Bitmap Heap Scan on t1
1749 Recheck Cond: (id = t2.id)
1750 Filter: (ctid = '(1,1)'::tid)
1751 -> Bitmap Index Scan on t1_pkey
1752 Index Cond: (id = t2.id)
1755 /*+BitmapScan(t1) TidScan(t2)*/
1756 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1766 ------------------------------------------
1769 TID Cond: (ctid = '(1,1)'::tid)
1770 -> Bitmap Heap Scan on t1
1771 Recheck Cond: (id = t2.id)
1772 Filter: (ctid = '(1,1)'::tid)
1773 -> Bitmap Index Scan on t1_pkey
1774 Index Cond: (id = t2.id)
1777 /*+BitmapScan(t1) NoSeqScan(t2)*/
1778 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1788 ------------------------------------------
1791 TID Cond: (ctid = '(1,1)'::tid)
1792 -> Bitmap Heap Scan on t1
1793 Recheck Cond: (id = t2.id)
1794 Filter: (ctid = '(1,1)'::tid)
1795 -> Bitmap Index Scan on t1_pkey
1796 Index Cond: (id = t2.id)
1799 /*+BitmapScan(t1) NoIndexScan(t2)*/
1800 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1810 ------------------------------------------
1813 TID Cond: (ctid = '(1,1)'::tid)
1814 -> Bitmap Heap Scan on t1
1815 Recheck Cond: (id = t2.id)
1816 Filter: (ctid = '(1,1)'::tid)
1817 -> Bitmap Index Scan on t1_pkey
1818 Index Cond: (id = t2.id)
1821 /*+BitmapScan(t1) NoBitmapScan(t2)*/
1822 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1832 ------------------------------------------
1835 TID Cond: (ctid = '(1,1)'::tid)
1836 -> Bitmap Heap Scan on t1
1837 Recheck Cond: (id = t2.id)
1838 Filter: (ctid = '(1,1)'::tid)
1839 -> Bitmap Index Scan on t1_pkey
1840 Index Cond: (id = t2.id)
1843 /*+BitmapScan(t1) NoTidScan(t2)*/
1844 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1854 ------------------------------------------
1857 Filter: (ctid = '(1,1)'::tid)
1858 -> Bitmap Heap Scan on t1
1859 Recheck Cond: (id = t2.id)
1860 Filter: (ctid = '(1,1)'::tid)
1861 -> Bitmap Index Scan on t1_pkey
1862 Index Cond: (id = t2.id)
1866 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1875 -----------------------------------------
1877 Join Filter: (t1.id = t2.id)
1879 TID Cond: (ctid = '(1,1)'::tid)
1881 TID Cond: (ctid = '(1,1)'::tid)
1885 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1894 -----------------------------------------
1896 Join Filter: (t1.id = t2.id)
1898 TID Cond: (ctid = '(1,1)'::tid)
1900 TID Cond: (ctid = '(1,1)'::tid)
1903 /*+TidScan(t1) SeqScan(t2)*/
1904 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1914 -----------------------------------------
1916 Join Filter: (t1.id = t2.id)
1918 TID Cond: (ctid = '(1,1)'::tid)
1920 Filter: (ctid = '(1,1)'::tid)
1923 /*+TidScan(t1) IndexScan(t2)*/
1924 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1934 -----------------------------------------
1937 TID Cond: (ctid = '(1,1)'::tid)
1938 -> Index Scan using t2_pkey on t2
1939 Index Cond: (id = t1.id)
1940 Filter: (ctid = '(1,1)'::tid)
1943 /*+TidScan(t1) BitmapScan(t2)*/
1944 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1954 ------------------------------------------
1957 TID Cond: (ctid = '(1,1)'::tid)
1958 -> Bitmap Heap Scan on t2
1959 Recheck Cond: (id = t1.id)
1960 Filter: (ctid = '(1,1)'::tid)
1961 -> Bitmap Index Scan on t2_pkey
1962 Index Cond: (id = t1.id)
1965 /*+TidScan(t1) TidScan(t2)*/
1966 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1976 -----------------------------------------
1978 Join Filter: (t1.id = t2.id)
1980 TID Cond: (ctid = '(1,1)'::tid)
1982 TID Cond: (ctid = '(1,1)'::tid)
1985 /*+TidScan(t1) NoSeqScan(t2)*/
1986 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
1996 -----------------------------------------
1998 Join Filter: (t1.id = t2.id)
2000 TID Cond: (ctid = '(1,1)'::tid)
2002 TID Cond: (ctid = '(1,1)'::tid)
2005 /*+TidScan(t1) NoIndexScan(t2)*/
2006 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2016 -----------------------------------------
2018 Join Filter: (t1.id = t2.id)
2020 TID Cond: (ctid = '(1,1)'::tid)
2022 TID Cond: (ctid = '(1,1)'::tid)
2025 /*+TidScan(t1) NoBitmapScan(t2)*/
2026 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2036 -----------------------------------------
2038 Join Filter: (t1.id = t2.id)
2040 TID Cond: (ctid = '(1,1)'::tid)
2042 TID Cond: (ctid = '(1,1)'::tid)
2045 /*+TidScan(t1) NoTidScan(t2)*/
2046 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2056 -----------------------------------------
2059 TID Cond: (ctid = '(1,1)'::tid)
2060 -> Index Scan using t2_pkey on t2
2061 Index Cond: (id = t1.id)
2062 Filter: (ctid = '(1,1)'::tid)
2066 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2075 -----------------------------------------
2077 Join Filter: (t1.id = t2.id)
2079 TID Cond: (ctid = '(1,1)'::tid)
2081 TID Cond: (ctid = '(1,1)'::tid)
2085 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2094 -----------------------------------------
2096 Join Filter: (t1.id = t2.id)
2098 TID Cond: (ctid = '(1,1)'::tid)
2100 TID Cond: (ctid = '(1,1)'::tid)
2103 /*+NoSeqScan(t1) SeqScan(t2)*/
2104 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2114 -----------------------------------------
2116 Join Filter: (t1.id = t2.id)
2118 TID Cond: (ctid = '(1,1)'::tid)
2120 Filter: (ctid = '(1,1)'::tid)
2123 /*+NoSeqScan(t1) IndexScan(t2)*/
2124 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2134 -----------------------------------------
2137 TID Cond: (ctid = '(1,1)'::tid)
2138 -> Index Scan using t2_pkey on t2
2139 Index Cond: (id = t1.id)
2140 Filter: (ctid = '(1,1)'::tid)
2143 /*+NoSeqScan(t1) BitmapScan(t2)*/
2144 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2154 ------------------------------------------
2157 TID Cond: (ctid = '(1,1)'::tid)
2158 -> Bitmap Heap Scan on t2
2159 Recheck Cond: (id = t1.id)
2160 Filter: (ctid = '(1,1)'::tid)
2161 -> Bitmap Index Scan on t2_pkey
2162 Index Cond: (id = t1.id)
2165 /*+NoSeqScan(t1) TidScan(t2)*/
2166 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2176 -----------------------------------------
2178 Join Filter: (t1.id = t2.id)
2180 TID Cond: (ctid = '(1,1)'::tid)
2182 TID Cond: (ctid = '(1,1)'::tid)
2185 /*+NoSeqScan(t1) NoSeqScan(t2)*/
2186 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2196 -----------------------------------------
2198 Join Filter: (t1.id = t2.id)
2200 TID Cond: (ctid = '(1,1)'::tid)
2202 TID Cond: (ctid = '(1,1)'::tid)
2205 /*+NoSeqScan(t1) NoIndexScan(t2)*/
2206 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2216 -----------------------------------------
2218 Join Filter: (t1.id = t2.id)
2220 TID Cond: (ctid = '(1,1)'::tid)
2222 TID Cond: (ctid = '(1,1)'::tid)
2225 /*+NoSeqScan(t1) NoBitmapScan(t2)*/
2226 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2236 -----------------------------------------
2238 Join Filter: (t1.id = t2.id)
2240 TID Cond: (ctid = '(1,1)'::tid)
2242 TID Cond: (ctid = '(1,1)'::tid)
2245 /*+NoSeqScan(t1) NoTidScan(t2)*/
2246 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2256 -----------------------------------------
2259 TID Cond: (ctid = '(1,1)'::tid)
2260 -> Index Scan using t2_pkey on t2
2261 Index Cond: (id = t1.id)
2262 Filter: (ctid = '(1,1)'::tid)
2265 /*+NoIndexScan(t1)*/
2266 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2275 -----------------------------------------
2277 Join Filter: (t1.id = t2.id)
2279 TID Cond: (ctid = '(1,1)'::tid)
2281 TID Cond: (ctid = '(1,1)'::tid)
2284 /*+NoIndexScan(t2)*/
2285 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2294 -----------------------------------------
2296 Join Filter: (t1.id = t2.id)
2298 TID Cond: (ctid = '(1,1)'::tid)
2300 TID Cond: (ctid = '(1,1)'::tid)
2303 /*+NoIndexScan(t1) SeqScan(t2)*/
2304 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2314 -----------------------------------------
2316 Join Filter: (t1.id = t2.id)
2318 TID Cond: (ctid = '(1,1)'::tid)
2320 Filter: (ctid = '(1,1)'::tid)
2323 /*+NoIndexScan(t1) IndexScan(t2)*/
2324 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2334 -----------------------------------------
2337 TID Cond: (ctid = '(1,1)'::tid)
2338 -> Index Scan using t2_pkey on t2
2339 Index Cond: (id = t1.id)
2340 Filter: (ctid = '(1,1)'::tid)
2343 /*+NoIndexScan(t1) BitmapScan(t2)*/
2344 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2354 ------------------------------------------
2357 TID Cond: (ctid = '(1,1)'::tid)
2358 -> Bitmap Heap Scan on t2
2359 Recheck Cond: (id = t1.id)
2360 Filter: (ctid = '(1,1)'::tid)
2361 -> Bitmap Index Scan on t2_pkey
2362 Index Cond: (id = t1.id)
2365 /*+NoIndexScan(t1) TidScan(t2)*/
2366 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2376 -----------------------------------------
2378 Join Filter: (t1.id = t2.id)
2380 TID Cond: (ctid = '(1,1)'::tid)
2382 TID Cond: (ctid = '(1,1)'::tid)
2385 /*+NoIndexScan(t1) NoSeqScan(t2)*/
2386 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2396 -----------------------------------------
2398 Join Filter: (t1.id = t2.id)
2400 TID Cond: (ctid = '(1,1)'::tid)
2402 TID Cond: (ctid = '(1,1)'::tid)
2405 /*+NoIndexScan(t1) NoIndexScan(t2)*/
2406 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2416 -----------------------------------------
2418 Join Filter: (t1.id = t2.id)
2420 TID Cond: (ctid = '(1,1)'::tid)
2422 TID Cond: (ctid = '(1,1)'::tid)
2425 /*+NoIndexScan(t1) NoBitmapScan(t2)*/
2426 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2436 -----------------------------------------
2438 Join Filter: (t1.id = t2.id)
2440 TID Cond: (ctid = '(1,1)'::tid)
2442 TID Cond: (ctid = '(1,1)'::tid)
2445 /*+NoIndexScan(t1) NoTidScan(t2)*/
2446 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2456 -----------------------------------------
2459 TID Cond: (ctid = '(1,1)'::tid)
2460 -> Index Scan using t2_pkey on t2
2461 Index Cond: (id = t1.id)
2462 Filter: (ctid = '(1,1)'::tid)
2465 /*+NoBitmapScan(t1)*/
2466 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2475 -----------------------------------------
2477 Join Filter: (t1.id = t2.id)
2479 TID Cond: (ctid = '(1,1)'::tid)
2481 TID Cond: (ctid = '(1,1)'::tid)
2484 /*+NoBitmapScan(t2)*/
2485 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2494 -----------------------------------------
2496 Join Filter: (t1.id = t2.id)
2498 TID Cond: (ctid = '(1,1)'::tid)
2500 TID Cond: (ctid = '(1,1)'::tid)
2503 /*+NoBitmapScan(t1) SeqScan(t2)*/
2504 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2514 -----------------------------------------
2516 Join Filter: (t1.id = t2.id)
2518 TID Cond: (ctid = '(1,1)'::tid)
2520 Filter: (ctid = '(1,1)'::tid)
2523 /*+NoBitmapScan(t1) IndexScan(t2)*/
2524 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2534 -----------------------------------------
2537 TID Cond: (ctid = '(1,1)'::tid)
2538 -> Index Scan using t2_pkey on t2
2539 Index Cond: (id = t1.id)
2540 Filter: (ctid = '(1,1)'::tid)
2543 /*+NoBitmapScan(t1) BitmapScan(t2)*/
2544 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2554 ------------------------------------------
2557 TID Cond: (ctid = '(1,1)'::tid)
2558 -> Bitmap Heap Scan on t2
2559 Recheck Cond: (id = t1.id)
2560 Filter: (ctid = '(1,1)'::tid)
2561 -> Bitmap Index Scan on t2_pkey
2562 Index Cond: (id = t1.id)
2565 /*+NoBitmapScan(t1) TidScan(t2)*/
2566 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2576 -----------------------------------------
2578 Join Filter: (t1.id = t2.id)
2580 TID Cond: (ctid = '(1,1)'::tid)
2582 TID Cond: (ctid = '(1,1)'::tid)
2585 /*+NoBitmapScan(t1) NoSeqScan(t2)*/
2586 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2596 -----------------------------------------
2598 Join Filter: (t1.id = t2.id)
2600 TID Cond: (ctid = '(1,1)'::tid)
2602 TID Cond: (ctid = '(1,1)'::tid)
2605 /*+NoBitmapScan(t1) NoIndexScan(t2)*/
2606 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2616 -----------------------------------------
2618 Join Filter: (t1.id = t2.id)
2620 TID Cond: (ctid = '(1,1)'::tid)
2622 TID Cond: (ctid = '(1,1)'::tid)
2625 /*+NoBitmapScan(t1) NoBitmapScan(t2)*/
2626 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2636 -----------------------------------------
2638 Join Filter: (t1.id = t2.id)
2640 TID Cond: (ctid = '(1,1)'::tid)
2642 TID Cond: (ctid = '(1,1)'::tid)
2645 /*+NoBitmapScan(t1) NoTidScan(t2)*/
2646 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2656 -----------------------------------------
2659 TID Cond: (ctid = '(1,1)'::tid)
2660 -> Index Scan using t2_pkey on t2
2661 Index Cond: (id = t1.id)
2662 Filter: (ctid = '(1,1)'::tid)
2666 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2675 -----------------------------------------
2678 TID Cond: (ctid = '(1,1)'::tid)
2679 -> Index Scan using t1_pkey on t1
2680 Index Cond: (id = t2.id)
2681 Filter: (ctid = '(1,1)'::tid)
2685 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2694 -----------------------------------------
2697 TID Cond: (ctid = '(1,1)'::tid)
2698 -> Index Scan using t2_pkey on t2
2699 Index Cond: (id = t1.id)
2700 Filter: (ctid = '(1,1)'::tid)
2703 /*+NoTidScan(t1) SeqScan(t2)*/
2704 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2714 ---------------------------------------
2717 Filter: (ctid = '(1,1)'::tid)
2718 -> Index Scan using t1_pkey on t1
2719 Index Cond: (id = t2.id)
2720 Filter: (ctid = '(1,1)'::tid)
2723 /*+NoTidScan(t1) IndexScan(t2)*/
2724 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2734 ---------------------------------------
2736 -> Index Scan using t2_pkey on t2
2737 Filter: (ctid = '(1,1)'::tid)
2738 -> Index Scan using t1_pkey on t1
2739 Index Cond: (id = t2.id)
2740 Filter: (ctid = '(1,1)'::tid)
2743 /*+NoTidScan(t1) BitmapScan(t2)*/
2744 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2754 ------------------------------------------
2757 Filter: (ctid = '(1,1)'::tid)
2758 -> Bitmap Heap Scan on t2
2759 Recheck Cond: (id = t1.id)
2760 Filter: (ctid = '(1,1)'::tid)
2761 -> Bitmap Index Scan on t2_pkey
2762 Index Cond: (id = t1.id)
2765 /*+NoTidScan(t1) TidScan(t2)*/
2766 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2776 -----------------------------------------
2779 TID Cond: (ctid = '(1,1)'::tid)
2780 -> Index Scan using t1_pkey on t1
2781 Index Cond: (id = t2.id)
2782 Filter: (ctid = '(1,1)'::tid)
2785 /*+NoTidScan(t1) NoSeqScan(t2)*/
2786 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2796 -----------------------------------------
2799 TID Cond: (ctid = '(1,1)'::tid)
2800 -> Index Scan using t1_pkey on t1
2801 Index Cond: (id = t2.id)
2802 Filter: (ctid = '(1,1)'::tid)
2805 /*+NoTidScan(t1) NoIndexScan(t2)*/
2806 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2816 -----------------------------------------
2819 TID Cond: (ctid = '(1,1)'::tid)
2820 -> Index Scan using t1_pkey on t1
2821 Index Cond: (id = t2.id)
2822 Filter: (ctid = '(1,1)'::tid)
2825 /*+NoTidScan(t1) NoBitmapScan(t2)*/
2826 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2836 -----------------------------------------
2839 TID Cond: (ctid = '(1,1)'::tid)
2840 -> Index Scan using t1_pkey on t1
2841 Index Cond: (id = t2.id)
2842 Filter: (ctid = '(1,1)'::tid)
2845 /*+NoTidScan(t1) NoTidScan(t2)*/
2846 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
2856 ---------------------------------------
2859 Filter: (ctid = '(1,1)'::tid)
2860 -> Index Scan using t1_pkey on t1
2861 Index Cond: (id = t2.id)
2862 Filter: (ctid = '(1,1)'::tid)
2866 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)' AND t1.id < 10 AND t2.id < 10;
2868 -----------------------------------------
2870 Join Filter: (t1.id = t2.id)
2872 TID Cond: (ctid = '(1,1)'::tid)
2875 TID Cond: (ctid = '(1,1)'::tid)
2879 /*+BitmapScan(t1) BitmapScan(t2)*/
2880 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)' AND t1.id < 10 AND t2.id < 10;
2890 --------------------------------------------------------
2892 -> Bitmap Heap Scan on t2
2893 Recheck Cond: (id < 10)
2894 Filter: (ctid = '(1,1)'::tid)
2895 -> Bitmap Index Scan on t2_pkey
2896 Index Cond: (id < 10)
2897 -> Bitmap Heap Scan on t1
2898 Recheck Cond: ((id < 10) AND (id = t2.id))
2899 Filter: (ctid = '(1,1)'::tid)
2900 -> Bitmap Index Scan on t1_pkey
2901 Index Cond: ((id < 10) AND (id = t2.id))
2905 EXPLAIN (COSTS false) SELECT * FROM t1 FULL OUTER JOIN t2 ON (t1.id = t2.id);
2907 ------------------------------
2909 Hash Cond: (t1.id = t2.id)
2915 /*+MergeJoin(t1 t2)*/
2916 EXPLAIN (COSTS false) SELECT * FROM t1 FULL OUTER JOIN t2 ON (t1.id = t2.id);
2925 --------------------------------------
2927 Merge Cond: (t1.id = t2.id)
2928 -> Index Scan using t1_pkey on t1
2929 -> Index Scan using t2_pkey on t2
2932 /*+NestLoop(t1 t2)*/
2933 EXPLAIN (COSTS false) SELECT * FROM t1 FULL OUTER JOIN t2 ON (t1.id = t2.id);
2942 ------------------------------
2944 Hash Cond: (t1.id = t2.id)
2950 -- inherite table test
2951 SET constraint_exclusion TO off;
2952 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
2954 -----------------------------------------------------------------------------
2958 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
2959 -> Seq Scan on p1_c1 p1
2960 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
2961 -> Seq Scan on p1_c2 p1
2962 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
2963 -> Seq Scan on p1_c3 p1
2964 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
2965 -> Tid Scan on p1_c4 p1
2966 TID Cond: (ctid = '(1,1)'::tid)
2967 Filter: ((id >= 50) AND (id <= 51))
2968 -> Tid Scan on p1_c1_c1 p1
2969 TID Cond: (ctid = '(1,1)'::tid)
2970 Filter: ((id >= 50) AND (id <= 51))
2971 -> Tid Scan on p1_c1_c2 p1
2972 TID Cond: (ctid = '(1,1)'::tid)
2973 Filter: ((id >= 50) AND (id <= 51))
2974 -> Tid Scan on p1_c3_c1 p1
2975 TID Cond: (ctid = '(1,1)'::tid)
2976 Filter: ((id >= 50) AND (id <= 51))
2977 -> Tid Scan on p1_c3_c2 p1
2978 TID Cond: (ctid = '(1,1)'::tid)
2979 Filter: ((id >= 50) AND (id <= 51))
2982 SET constraint_exclusion TO on;
2983 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
2985 -----------------------------------------------------------------------------
2989 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
2990 -> Seq Scan on p1_c1 p1
2991 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
2992 -> Tid Scan on p1_c1_c1 p1
2993 TID Cond: (ctid = '(1,1)'::tid)
2994 Filter: ((id >= 50) AND (id <= 51))
2995 -> Tid Scan on p1_c1_c2 p1
2996 TID Cond: (ctid = '(1,1)'::tid)
2997 Filter: ((id >= 50) AND (id <= 51))
3000 SET constraint_exclusion TO off;
3002 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3011 -----------------------------------------------------------------------------
3015 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3016 -> Seq Scan on p1_c1 p1
3017 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3018 -> Seq Scan on p1_c2 p1
3019 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3020 -> Seq Scan on p1_c3 p1
3021 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3022 -> Seq Scan on p1_c4 p1
3023 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3024 -> Seq Scan on p1_c1_c1 p1
3025 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3026 -> Seq Scan on p1_c1_c2 p1
3027 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3028 -> Seq Scan on p1_c3_c1 p1
3029 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3030 -> Seq Scan on p1_c3_c2 p1
3031 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3035 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3044 -----------------------------------------------------------
3047 -> Index Scan using p1_pkey on p1
3048 Index Cond: ((id >= 50) AND (id <= 51))
3049 Filter: (ctid = '(1,1)'::tid)
3050 -> Index Scan using p1_c1_pkey on p1_c1 p1
3051 Index Cond: ((id >= 50) AND (id <= 51))
3052 Filter: (ctid = '(1,1)'::tid)
3053 -> Index Scan using p1_c2_pkey on p1_c2 p1
3054 Index Cond: ((id >= 50) AND (id <= 51))
3055 Filter: (ctid = '(1,1)'::tid)
3056 -> Index Scan using p1_c3_pkey on p1_c3 p1
3057 Index Cond: ((id >= 50) AND (id <= 51))
3058 Filter: (ctid = '(1,1)'::tid)
3059 -> Index Scan using p1_c4_pkey on p1_c4 p1
3060 Index Cond: ((id >= 50) AND (id <= 51))
3061 Filter: (ctid = '(1,1)'::tid)
3062 -> Index Scan using p1_c1_c1_pkey on p1_c1_c1 p1
3063 Index Cond: ((id >= 50) AND (id <= 51))
3064 Filter: (ctid = '(1,1)'::tid)
3065 -> Index Scan using p1_c1_c2_pkey on p1_c1_c2 p1
3066 Index Cond: ((id >= 50) AND (id <= 51))
3067 Filter: (ctid = '(1,1)'::tid)
3068 -> Index Scan using p1_c3_c1_pkey on p1_c3_c1 p1
3069 Index Cond: ((id >= 50) AND (id <= 51))
3070 Filter: (ctid = '(1,1)'::tid)
3071 -> Index Scan using p1_c3_c2_pkey on p1_c3_c2 p1
3072 Index Cond: ((id >= 50) AND (id <= 51))
3073 Filter: (ctid = '(1,1)'::tid)
3077 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3086 -------------------------------------------------------------
3089 -> Bitmap Heap Scan on p1
3090 Recheck Cond: ((id >= 50) AND (id <= 51))
3091 Filter: (ctid = '(1,1)'::tid)
3092 -> Bitmap Index Scan on p1_pkey
3093 Index Cond: ((id >= 50) AND (id <= 51))
3094 -> Bitmap Heap Scan on p1_c1 p1
3095 Recheck Cond: ((id >= 50) AND (id <= 51))
3096 Filter: (ctid = '(1,1)'::tid)
3097 -> Bitmap Index Scan on p1_c1_pkey
3098 Index Cond: ((id >= 50) AND (id <= 51))
3099 -> Bitmap Heap Scan on p1_c2 p1
3100 Recheck Cond: ((id >= 50) AND (id <= 51))
3101 Filter: (ctid = '(1,1)'::tid)
3102 -> Bitmap Index Scan on p1_c2_pkey
3103 Index Cond: ((id >= 50) AND (id <= 51))
3104 -> Bitmap Heap Scan on p1_c3 p1
3105 Recheck Cond: ((id >= 50) AND (id <= 51))
3106 Filter: (ctid = '(1,1)'::tid)
3107 -> Bitmap Index Scan on p1_c3_pkey
3108 Index Cond: ((id >= 50) AND (id <= 51))
3109 -> Bitmap Heap Scan on p1_c4 p1
3110 Recheck Cond: ((id >= 50) AND (id <= 51))
3111 Filter: (ctid = '(1,1)'::tid)
3112 -> Bitmap Index Scan on p1_c4_pkey
3113 Index Cond: ((id >= 50) AND (id <= 51))
3114 -> Bitmap Heap Scan on p1_c1_c1 p1
3115 Recheck Cond: ((id >= 50) AND (id <= 51))
3116 Filter: (ctid = '(1,1)'::tid)
3117 -> Bitmap Index Scan on p1_c1_c1_pkey
3118 Index Cond: ((id >= 50) AND (id <= 51))
3119 -> Bitmap Heap Scan on p1_c1_c2 p1
3120 Recheck Cond: ((id >= 50) AND (id <= 51))
3121 Filter: (ctid = '(1,1)'::tid)
3122 -> Bitmap Index Scan on p1_c1_c2_pkey
3123 Index Cond: ((id >= 50) AND (id <= 51))
3124 -> Bitmap Heap Scan on p1_c3_c1 p1
3125 Recheck Cond: ((id >= 50) AND (id <= 51))
3126 Filter: (ctid = '(1,1)'::tid)
3127 -> Bitmap Index Scan on p1_c3_c1_pkey
3128 Index Cond: ((id >= 50) AND (id <= 51))
3129 -> Bitmap Heap Scan on p1_c3_c2 p1
3130 Recheck Cond: ((id >= 50) AND (id <= 51))
3131 Filter: (ctid = '(1,1)'::tid)
3132 -> Bitmap Index Scan on p1_c3_c2_pkey
3133 Index Cond: ((id >= 50) AND (id <= 51))
3137 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3146 ---------------------------------------------------
3150 TID Cond: (ctid = '(1,1)'::tid)
3151 Filter: ((id >= 50) AND (id <= 51))
3152 -> Tid Scan on p1_c1 p1
3153 TID Cond: (ctid = '(1,1)'::tid)
3154 Filter: ((id >= 50) AND (id <= 51))
3155 -> Tid Scan on p1_c2 p1
3156 TID Cond: (ctid = '(1,1)'::tid)
3157 Filter: ((id >= 50) AND (id <= 51))
3158 -> Tid Scan on p1_c3 p1
3159 TID Cond: (ctid = '(1,1)'::tid)
3160 Filter: ((id >= 50) AND (id <= 51))
3161 -> Tid Scan on p1_c4 p1
3162 TID Cond: (ctid = '(1,1)'::tid)
3163 Filter: ((id >= 50) AND (id <= 51))
3164 -> Tid Scan on p1_c1_c1 p1
3165 TID Cond: (ctid = '(1,1)'::tid)
3166 Filter: ((id >= 50) AND (id <= 51))
3167 -> Tid Scan on p1_c1_c2 p1
3168 TID Cond: (ctid = '(1,1)'::tid)
3169 Filter: ((id >= 50) AND (id <= 51))
3170 -> Tid Scan on p1_c3_c1 p1
3171 TID Cond: (ctid = '(1,1)'::tid)
3172 Filter: ((id >= 50) AND (id <= 51))
3173 -> Tid Scan on p1_c3_c2 p1
3174 TID Cond: (ctid = '(1,1)'::tid)
3175 Filter: ((id >= 50) AND (id <= 51))
3178 SET constraint_exclusion TO on;
3180 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3189 -----------------------------------------------------------------------------
3193 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3194 -> Seq Scan on p1_c1 p1
3195 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3196 -> Seq Scan on p1_c1_c1 p1
3197 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3198 -> Seq Scan on p1_c1_c2 p1
3199 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3203 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3212 -----------------------------------------------------------
3215 -> Index Scan using p1_pkey on p1
3216 Index Cond: ((id >= 50) AND (id <= 51))
3217 Filter: (ctid = '(1,1)'::tid)
3218 -> Index Scan using p1_c1_pkey on p1_c1 p1
3219 Index Cond: ((id >= 50) AND (id <= 51))
3220 Filter: (ctid = '(1,1)'::tid)
3221 -> Index Scan using p1_c1_c1_pkey on p1_c1_c1 p1
3222 Index Cond: ((id >= 50) AND (id <= 51))
3223 Filter: (ctid = '(1,1)'::tid)
3224 -> Index Scan using p1_c1_c2_pkey on p1_c1_c2 p1
3225 Index Cond: ((id >= 50) AND (id <= 51))
3226 Filter: (ctid = '(1,1)'::tid)
3230 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3239 -------------------------------------------------------------
3242 -> Bitmap Heap Scan on p1
3243 Recheck Cond: ((id >= 50) AND (id <= 51))
3244 Filter: (ctid = '(1,1)'::tid)
3245 -> Bitmap Index Scan on p1_pkey
3246 Index Cond: ((id >= 50) AND (id <= 51))
3247 -> Bitmap Heap Scan on p1_c1 p1
3248 Recheck Cond: ((id >= 50) AND (id <= 51))
3249 Filter: (ctid = '(1,1)'::tid)
3250 -> Bitmap Index Scan on p1_c1_pkey
3251 Index Cond: ((id >= 50) AND (id <= 51))
3252 -> Bitmap Heap Scan on p1_c1_c1 p1
3253 Recheck Cond: ((id >= 50) AND (id <= 51))
3254 Filter: (ctid = '(1,1)'::tid)
3255 -> Bitmap Index Scan on p1_c1_c1_pkey
3256 Index Cond: ((id >= 50) AND (id <= 51))
3257 -> Bitmap Heap Scan on p1_c1_c2 p1
3258 Recheck Cond: ((id >= 50) AND (id <= 51))
3259 Filter: (ctid = '(1,1)'::tid)
3260 -> Bitmap Index Scan on p1_c1_c2_pkey
3261 Index Cond: ((id >= 50) AND (id <= 51))
3265 EXPLAIN (COSTS false) SELECT * FROM p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3274 ---------------------------------------------------
3278 TID Cond: (ctid = '(1,1)'::tid)
3279 Filter: ((id >= 50) AND (id <= 51))
3280 -> Tid Scan on p1_c1 p1
3281 TID Cond: (ctid = '(1,1)'::tid)
3282 Filter: ((id >= 50) AND (id <= 51))
3283 -> Tid Scan on p1_c1_c1 p1
3284 TID Cond: (ctid = '(1,1)'::tid)
3285 Filter: ((id >= 50) AND (id <= 51))
3286 -> Tid Scan on p1_c1_c2 p1
3287 TID Cond: (ctid = '(1,1)'::tid)
3288 Filter: ((id >= 50) AND (id <= 51))
3291 SET constraint_exclusion TO off;
3292 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3294 -----------------------------------------------------------------------------------
3296 Merge Cond: (public.p1.id = t1.id)
3298 Sort Key: public.p1.id
3301 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3302 -> Seq Scan on p1_c1 p1
3303 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3304 -> Seq Scan on p1_c2 p1
3305 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3306 -> Seq Scan on p1_c3 p1
3307 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3308 -> Tid Scan on p1_c4 p1
3309 TID Cond: (ctid = '(1,1)'::tid)
3310 Filter: ((id >= 50) AND (id <= 51))
3311 -> Tid Scan on p1_c1_c1 p1
3312 TID Cond: (ctid = '(1,1)'::tid)
3313 Filter: ((id >= 50) AND (id <= 51))
3314 -> Tid Scan on p1_c1_c2 p1
3315 TID Cond: (ctid = '(1,1)'::tid)
3316 Filter: ((id >= 50) AND (id <= 51))
3317 -> Tid Scan on p1_c3_c1 p1
3318 TID Cond: (ctid = '(1,1)'::tid)
3319 Filter: ((id >= 50) AND (id <= 51))
3320 -> Tid Scan on p1_c3_c2 p1
3321 TID Cond: (ctid = '(1,1)'::tid)
3322 Filter: ((id >= 50) AND (id <= 51))
3323 -> Index Scan using t1_pkey on t1
3324 Index Cond: (id < 10)
3327 SET constraint_exclusion TO on;
3328 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3330 -----------------------------------------------------------------------------------
3332 Merge Cond: (public.p1.id = t1.id)
3334 Sort Key: public.p1.id
3337 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3338 -> Seq Scan on p1_c1 p1
3339 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3340 -> Tid Scan on p1_c1_c1 p1
3341 TID Cond: (ctid = '(1,1)'::tid)
3342 Filter: ((id >= 50) AND (id <= 51))
3343 -> Tid Scan on p1_c1_c2 p1
3344 TID Cond: (ctid = '(1,1)'::tid)
3345 Filter: ((id >= 50) AND (id <= 51))
3346 -> Index Scan using t1_pkey on t1
3347 Index Cond: (id < 10)
3350 SET constraint_exclusion TO off;
3352 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3361 -----------------------------------------------------------------------------------
3363 Merge Cond: (public.p1.id = t1.id)
3365 Sort Key: public.p1.id
3368 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3369 -> Seq Scan on p1_c1 p1
3370 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3371 -> Seq Scan on p1_c2 p1
3372 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3373 -> Seq Scan on p1_c3 p1
3374 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3375 -> Seq Scan on p1_c4 p1
3376 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3377 -> Seq Scan on p1_c1_c1 p1
3378 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3379 -> Seq Scan on p1_c1_c2 p1
3380 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3381 -> Seq Scan on p1_c3_c1 p1
3382 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3383 -> Seq Scan on p1_c3_c2 p1
3384 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3385 -> Index Scan using t1_pkey on t1
3386 Index Cond: (id < 10)
3390 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3399 -----------------------------------------------------------
3401 Merge Cond: (public.p1.id = t1.id)
3403 Sort Key: public.p1.id
3404 -> Index Scan using p1_pkey on p1
3405 Index Cond: ((id >= 50) AND (id <= 51))
3406 Filter: (ctid = '(1,1)'::tid)
3407 -> Index Scan using p1_c1_pkey on p1_c1 p1
3408 Index Cond: ((id >= 50) AND (id <= 51))
3409 Filter: (ctid = '(1,1)'::tid)
3410 -> Index Scan using p1_c2_pkey on p1_c2 p1
3411 Index Cond: ((id >= 50) AND (id <= 51))
3412 Filter: (ctid = '(1,1)'::tid)
3413 -> Index Scan using p1_c3_pkey on p1_c3 p1
3414 Index Cond: ((id >= 50) AND (id <= 51))
3415 Filter: (ctid = '(1,1)'::tid)
3416 -> Index Scan using p1_c4_pkey on p1_c4 p1
3417 Index Cond: ((id >= 50) AND (id <= 51))
3418 Filter: (ctid = '(1,1)'::tid)
3419 -> Index Scan using p1_c1_c1_pkey on p1_c1_c1 p1
3420 Index Cond: ((id >= 50) AND (id <= 51))
3421 Filter: (ctid = '(1,1)'::tid)
3422 -> Index Scan using p1_c1_c2_pkey on p1_c1_c2 p1
3423 Index Cond: ((id >= 50) AND (id <= 51))
3424 Filter: (ctid = '(1,1)'::tid)
3425 -> Index Scan using p1_c3_c1_pkey on p1_c3_c1 p1
3426 Index Cond: ((id >= 50) AND (id <= 51))
3427 Filter: (ctid = '(1,1)'::tid)
3428 -> Index Scan using p1_c3_c2_pkey on p1_c3_c2 p1
3429 Index Cond: ((id >= 50) AND (id <= 51))
3430 Filter: (ctid = '(1,1)'::tid)
3431 -> Index Scan using t1_pkey on t1
3432 Index Cond: (id < 10)
3436 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3445 -------------------------------------------------------------------
3447 Merge Cond: (public.p1.id = t1.id)
3449 Sort Key: public.p1.id
3451 -> Bitmap Heap Scan on p1
3452 Recheck Cond: ((id >= 50) AND (id <= 51))
3453 Filter: (ctid = '(1,1)'::tid)
3454 -> Bitmap Index Scan on p1_pkey
3455 Index Cond: ((id >= 50) AND (id <= 51))
3456 -> Bitmap Heap Scan on p1_c1 p1
3457 Recheck Cond: ((id >= 50) AND (id <= 51))
3458 Filter: (ctid = '(1,1)'::tid)
3459 -> Bitmap Index Scan on p1_c1_pkey
3460 Index Cond: ((id >= 50) AND (id <= 51))
3461 -> Bitmap Heap Scan on p1_c2 p1
3462 Recheck Cond: ((id >= 50) AND (id <= 51))
3463 Filter: (ctid = '(1,1)'::tid)
3464 -> Bitmap Index Scan on p1_c2_pkey
3465 Index Cond: ((id >= 50) AND (id <= 51))
3466 -> Bitmap Heap Scan on p1_c3 p1
3467 Recheck Cond: ((id >= 50) AND (id <= 51))
3468 Filter: (ctid = '(1,1)'::tid)
3469 -> Bitmap Index Scan on p1_c3_pkey
3470 Index Cond: ((id >= 50) AND (id <= 51))
3471 -> Bitmap Heap Scan on p1_c4 p1
3472 Recheck Cond: ((id >= 50) AND (id <= 51))
3473 Filter: (ctid = '(1,1)'::tid)
3474 -> Bitmap Index Scan on p1_c4_pkey
3475 Index Cond: ((id >= 50) AND (id <= 51))
3476 -> Bitmap Heap Scan on p1_c1_c1 p1
3477 Recheck Cond: ((id >= 50) AND (id <= 51))
3478 Filter: (ctid = '(1,1)'::tid)
3479 -> Bitmap Index Scan on p1_c1_c1_pkey
3480 Index Cond: ((id >= 50) AND (id <= 51))
3481 -> Bitmap Heap Scan on p1_c1_c2 p1
3482 Recheck Cond: ((id >= 50) AND (id <= 51))
3483 Filter: (ctid = '(1,1)'::tid)
3484 -> Bitmap Index Scan on p1_c1_c2_pkey
3485 Index Cond: ((id >= 50) AND (id <= 51))
3486 -> Bitmap Heap Scan on p1_c3_c1 p1
3487 Recheck Cond: ((id >= 50) AND (id <= 51))
3488 Filter: (ctid = '(1,1)'::tid)
3489 -> Bitmap Index Scan on p1_c3_c1_pkey
3490 Index Cond: ((id >= 50) AND (id <= 51))
3491 -> Bitmap Heap Scan on p1_c3_c2 p1
3492 Recheck Cond: ((id >= 50) AND (id <= 51))
3493 Filter: (ctid = '(1,1)'::tid)
3494 -> Bitmap Index Scan on p1_c3_c2_pkey
3495 Index Cond: ((id >= 50) AND (id <= 51))
3496 -> Index Scan using t1_pkey on t1
3497 Index Cond: (id < 10)
3501 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3510 ---------------------------------------------------------
3512 Merge Cond: (public.p1.id = t1.id)
3514 Sort Key: public.p1.id
3517 TID Cond: (ctid = '(1,1)'::tid)
3518 Filter: ((id >= 50) AND (id <= 51))
3519 -> Tid Scan on p1_c1 p1
3520 TID Cond: (ctid = '(1,1)'::tid)
3521 Filter: ((id >= 50) AND (id <= 51))
3522 -> Tid Scan on p1_c2 p1
3523 TID Cond: (ctid = '(1,1)'::tid)
3524 Filter: ((id >= 50) AND (id <= 51))
3525 -> Tid Scan on p1_c3 p1
3526 TID Cond: (ctid = '(1,1)'::tid)
3527 Filter: ((id >= 50) AND (id <= 51))
3528 -> Tid Scan on p1_c4 p1
3529 TID Cond: (ctid = '(1,1)'::tid)
3530 Filter: ((id >= 50) AND (id <= 51))
3531 -> Tid Scan on p1_c1_c1 p1
3532 TID Cond: (ctid = '(1,1)'::tid)
3533 Filter: ((id >= 50) AND (id <= 51))
3534 -> Tid Scan on p1_c1_c2 p1
3535 TID Cond: (ctid = '(1,1)'::tid)
3536 Filter: ((id >= 50) AND (id <= 51))
3537 -> Tid Scan on p1_c3_c1 p1
3538 TID Cond: (ctid = '(1,1)'::tid)
3539 Filter: ((id >= 50) AND (id <= 51))
3540 -> Tid Scan on p1_c3_c2 p1
3541 TID Cond: (ctid = '(1,1)'::tid)
3542 Filter: ((id >= 50) AND (id <= 51))
3543 -> Index Scan using t1_pkey on t1
3544 Index Cond: (id < 10)
3547 /*+NestLoop(p1 t1)*/
3548 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3557 -----------------------------------------------------------------------------
3559 Join Filter: (public.p1.id = t1.id)
3562 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3563 -> Seq Scan on p1_c1 p1
3564 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3565 -> Seq Scan on p1_c2 p1
3566 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3567 -> Seq Scan on p1_c3 p1
3568 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3569 -> Tid Scan on p1_c4 p1
3570 TID Cond: (ctid = '(1,1)'::tid)
3571 Filter: ((id >= 50) AND (id <= 51))
3572 -> Tid Scan on p1_c1_c1 p1
3573 TID Cond: (ctid = '(1,1)'::tid)
3574 Filter: ((id >= 50) AND (id <= 51))
3575 -> Tid Scan on p1_c1_c2 p1
3576 TID Cond: (ctid = '(1,1)'::tid)
3577 Filter: ((id >= 50) AND (id <= 51))
3578 -> Tid Scan on p1_c3_c1 p1
3579 TID Cond: (ctid = '(1,1)'::tid)
3580 Filter: ((id >= 50) AND (id <= 51))
3581 -> Tid Scan on p1_c3_c2 p1
3582 TID Cond: (ctid = '(1,1)'::tid)
3583 Filter: ((id >= 50) AND (id <= 51))
3585 -> Index Scan using t1_pkey on t1
3586 Index Cond: (id < 10)
3589 /*+MergeJoin(p1 t1)*/
3590 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3599 -----------------------------------------------------------------------------------
3601 Merge Cond: (public.p1.id = t1.id)
3603 Sort Key: public.p1.id
3606 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3607 -> Seq Scan on p1_c1 p1
3608 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3609 -> Seq Scan on p1_c2 p1
3610 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3611 -> Seq Scan on p1_c3 p1
3612 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3613 -> Tid Scan on p1_c4 p1
3614 TID Cond: (ctid = '(1,1)'::tid)
3615 Filter: ((id >= 50) AND (id <= 51))
3616 -> Tid Scan on p1_c1_c1 p1
3617 TID Cond: (ctid = '(1,1)'::tid)
3618 Filter: ((id >= 50) AND (id <= 51))
3619 -> Tid Scan on p1_c1_c2 p1
3620 TID Cond: (ctid = '(1,1)'::tid)
3621 Filter: ((id >= 50) AND (id <= 51))
3622 -> Tid Scan on p1_c3_c1 p1
3623 TID Cond: (ctid = '(1,1)'::tid)
3624 Filter: ((id >= 50) AND (id <= 51))
3625 -> Tid Scan on p1_c3_c2 p1
3626 TID Cond: (ctid = '(1,1)'::tid)
3627 Filter: ((id >= 50) AND (id <= 51))
3628 -> Index Scan using t1_pkey on t1
3629 Index Cond: (id < 10)
3632 /*+HashJoin(p1 t1)*/
3633 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3642 -----------------------------------------------------------------------------
3644 Hash Cond: (public.p1.id = t1.id)
3647 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3648 -> Seq Scan on p1_c1 p1
3649 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3650 -> Seq Scan on p1_c2 p1
3651 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3652 -> Seq Scan on p1_c3 p1
3653 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3654 -> Tid Scan on p1_c4 p1
3655 TID Cond: (ctid = '(1,1)'::tid)
3656 Filter: ((id >= 50) AND (id <= 51))
3657 -> Tid Scan on p1_c1_c1 p1
3658 TID Cond: (ctid = '(1,1)'::tid)
3659 Filter: ((id >= 50) AND (id <= 51))
3660 -> Tid Scan on p1_c1_c2 p1
3661 TID Cond: (ctid = '(1,1)'::tid)
3662 Filter: ((id >= 50) AND (id <= 51))
3663 -> Tid Scan on p1_c3_c1 p1
3664 TID Cond: (ctid = '(1,1)'::tid)
3665 Filter: ((id >= 50) AND (id <= 51))
3666 -> Tid Scan on p1_c3_c2 p1
3667 TID Cond: (ctid = '(1,1)'::tid)
3668 Filter: ((id >= 50) AND (id <= 51))
3670 -> Index Scan using t1_pkey on t1
3671 Index Cond: (id < 10)
3674 SET constraint_exclusion TO on;
3676 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3685 -----------------------------------------------------------------------------------
3687 Merge Cond: (public.p1.id = t1.id)
3689 Sort Key: public.p1.id
3692 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3693 -> Seq Scan on p1_c1 p1
3694 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3695 -> Seq Scan on p1_c1_c1 p1
3696 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3697 -> Seq Scan on p1_c1_c2 p1
3698 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3699 -> Index Scan using t1_pkey on t1
3700 Index Cond: (id < 10)
3704 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3713 -----------------------------------------------------------
3715 Merge Cond: (public.p1.id = t1.id)
3717 Sort Key: public.p1.id
3718 -> Index Scan using p1_pkey on p1
3719 Index Cond: ((id >= 50) AND (id <= 51))
3720 Filter: (ctid = '(1,1)'::tid)
3721 -> Index Scan using p1_c1_pkey on p1_c1 p1
3722 Index Cond: ((id >= 50) AND (id <= 51))
3723 Filter: (ctid = '(1,1)'::tid)
3724 -> Index Scan using p1_c1_c1_pkey on p1_c1_c1 p1
3725 Index Cond: ((id >= 50) AND (id <= 51))
3726 Filter: (ctid = '(1,1)'::tid)
3727 -> Index Scan using p1_c1_c2_pkey on p1_c1_c2 p1
3728 Index Cond: ((id >= 50) AND (id <= 51))
3729 Filter: (ctid = '(1,1)'::tid)
3730 -> Index Scan using t1_pkey on t1
3731 Index Cond: (id < 10)
3735 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3744 -------------------------------------------------------------------
3746 Merge Cond: (public.p1.id = t1.id)
3748 Sort Key: public.p1.id
3750 -> Bitmap Heap Scan on p1
3751 Recheck Cond: ((id >= 50) AND (id <= 51))
3752 Filter: (ctid = '(1,1)'::tid)
3753 -> Bitmap Index Scan on p1_pkey
3754 Index Cond: ((id >= 50) AND (id <= 51))
3755 -> Bitmap Heap Scan on p1_c1 p1
3756 Recheck Cond: ((id >= 50) AND (id <= 51))
3757 Filter: (ctid = '(1,1)'::tid)
3758 -> Bitmap Index Scan on p1_c1_pkey
3759 Index Cond: ((id >= 50) AND (id <= 51))
3760 -> Bitmap Heap Scan on p1_c1_c1 p1
3761 Recheck Cond: ((id >= 50) AND (id <= 51))
3762 Filter: (ctid = '(1,1)'::tid)
3763 -> Bitmap Index Scan on p1_c1_c1_pkey
3764 Index Cond: ((id >= 50) AND (id <= 51))
3765 -> Bitmap Heap Scan on p1_c1_c2 p1
3766 Recheck Cond: ((id >= 50) AND (id <= 51))
3767 Filter: (ctid = '(1,1)'::tid)
3768 -> Bitmap Index Scan on p1_c1_c2_pkey
3769 Index Cond: ((id >= 50) AND (id <= 51))
3770 -> Index Scan using t1_pkey on t1
3771 Index Cond: (id < 10)
3775 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3784 ---------------------------------------------------------
3786 Merge Cond: (public.p1.id = t1.id)
3788 Sort Key: public.p1.id
3791 TID Cond: (ctid = '(1,1)'::tid)
3792 Filter: ((id >= 50) AND (id <= 51))
3793 -> Tid Scan on p1_c1 p1
3794 TID Cond: (ctid = '(1,1)'::tid)
3795 Filter: ((id >= 50) AND (id <= 51))
3796 -> Tid Scan on p1_c1_c1 p1
3797 TID Cond: (ctid = '(1,1)'::tid)
3798 Filter: ((id >= 50) AND (id <= 51))
3799 -> Tid Scan on p1_c1_c2 p1
3800 TID Cond: (ctid = '(1,1)'::tid)
3801 Filter: ((id >= 50) AND (id <= 51))
3802 -> Index Scan using t1_pkey on t1
3803 Index Cond: (id < 10)
3806 /*+NestLoop(p1 t1)*/
3807 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3816 -----------------------------------------------------------------------------------
3818 Join Filter: (public.p1.id = t1.id)
3819 -> Index Scan using t1_pkey on t1
3820 Index Cond: (id < 10)
3824 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3825 -> Seq Scan on p1_c1 p1
3826 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3827 -> Tid Scan on p1_c1_c1 p1
3828 TID Cond: (ctid = '(1,1)'::tid)
3829 Filter: ((id >= 50) AND (id <= 51))
3830 -> Tid Scan on p1_c1_c2 p1
3831 TID Cond: (ctid = '(1,1)'::tid)
3832 Filter: ((id >= 50) AND (id <= 51))
3835 /*+MergeJoin(p1 t1)*/
3836 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3845 -----------------------------------------------------------------------------------
3847 Merge Cond: (public.p1.id = t1.id)
3849 Sort Key: public.p1.id
3852 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3853 -> Seq Scan on p1_c1 p1
3854 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3855 -> Tid Scan on p1_c1_c1 p1
3856 TID Cond: (ctid = '(1,1)'::tid)
3857 Filter: ((id >= 50) AND (id <= 51))
3858 -> Tid Scan on p1_c1_c2 p1
3859 TID Cond: (ctid = '(1,1)'::tid)
3860 Filter: ((id >= 50) AND (id <= 51))
3861 -> Index Scan using t1_pkey on t1
3862 Index Cond: (id < 10)
3865 /*+HashJoin(p1 t1)*/
3866 EXPLAIN (COSTS false) SELECT * FROM p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3875 -----------------------------------------------------------------------------------
3877 Hash Cond: (t1.id = public.p1.id)
3878 -> Index Scan using t1_pkey on t1
3879 Index Cond: (id < 10)
3883 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3884 -> Seq Scan on p1_c1 p1
3885 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3886 -> Tid Scan on p1_c1_c1 p1
3887 TID Cond: (ctid = '(1,1)'::tid)
3888 Filter: ((id >= 50) AND (id <= 51))
3889 -> Tid Scan on p1_c1_c2 p1
3890 TID Cond: (ctid = '(1,1)'::tid)
3891 Filter: ((id >= 50) AND (id <= 51))
3894 SET constraint_exclusion TO off;
3895 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3897 -----------------------------------------------------------------
3899 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3902 SET constraint_exclusion TO on;
3903 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3905 -----------------------------------------------------------------
3907 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3910 SET constraint_exclusion TO off;
3912 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3921 -----------------------------------------------------------------
3923 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3927 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3936 -------------------------------------------
3937 Index Scan using p1_pkey on p1
3938 Index Cond: ((id >= 50) AND (id <= 51))
3939 Filter: (ctid = '(1,1)'::tid)
3943 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3952 -------------------------------------------------
3953 Bitmap Heap Scan on p1
3954 Recheck Cond: ((id >= 50) AND (id <= 51))
3955 Filter: (ctid = '(1,1)'::tid)
3956 -> Bitmap Index Scan on p1_pkey
3957 Index Cond: ((id >= 50) AND (id <= 51))
3961 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
3970 ---------------------------------------
3972 TID Cond: (ctid = '(1,1)'::tid)
3973 Filter: ((id >= 50) AND (id <= 51))
3976 /*+NestLoop(p1 t1)*/
3977 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
3986 -----------------------------------------------------------------------
3989 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
3990 -> Index Scan using t1_pkey on t1
3991 Index Cond: ((id < 10) AND (id = p1.id))
3994 /*+MergeJoin(p1 t1)*/
3995 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4004 -----------------------------------------------------------------------------
4006 Merge Cond: (p1.id = t1.id)
4010 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4011 -> Index Scan using t1_pkey on t1
4012 Index Cond: (id < 10)
4015 /*+HashJoin(p1 t1)*/
4016 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4025 -----------------------------------------------------------------------------
4027 Hash Cond: (t1.id = p1.id)
4028 -> Index Scan using t1_pkey on t1
4029 Index Cond: (id < 10)
4032 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4035 SET constraint_exclusion TO on;
4037 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
4046 -----------------------------------------------------------------
4048 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4052 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
4061 -------------------------------------------
4062 Index Scan using p1_pkey on p1
4063 Index Cond: ((id >= 50) AND (id <= 51))
4064 Filter: (ctid = '(1,1)'::tid)
4068 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
4077 -------------------------------------------------
4078 Bitmap Heap Scan on p1
4079 Recheck Cond: ((id >= 50) AND (id <= 51))
4080 Filter: (ctid = '(1,1)'::tid)
4081 -> Bitmap Index Scan on p1_pkey
4082 Index Cond: ((id >= 50) AND (id <= 51))
4086 EXPLAIN (COSTS false) SELECT * FROM ONLY p1 WHERE id >= 50 AND id <= 51 AND p1.ctid = '(1,1)';
4095 ---------------------------------------
4097 TID Cond: (ctid = '(1,1)'::tid)
4098 Filter: ((id >= 50) AND (id <= 51))
4101 /*+NestLoop(p1 t1)*/
4102 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4111 -----------------------------------------------------------------------
4114 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4115 -> Index Scan using t1_pkey on t1
4116 Index Cond: ((id < 10) AND (id = p1.id))
4119 /*+MergeJoin(p1 t1)*/
4120 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4129 -----------------------------------------------------------------------------
4131 Merge Cond: (p1.id = t1.id)
4135 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4136 -> Index Scan using t1_pkey on t1
4137 Index Cond: (id < 10)
4140 /*+HashJoin(p1 t1)*/
4141 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4150 -----------------------------------------------------------------------------
4152 Hash Cond: (t1.id = p1.id)
4153 -> Index Scan using t1_pkey on t1
4154 Index Cond: (id < 10)
4157 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4160 SET constraint_exclusion TO off;
4161 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4163 -----------------------------------------------------------------------
4166 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4167 -> Index Scan using t1_pkey on t1
4168 Index Cond: ((id < 10) AND (id = p1.id))
4171 SET constraint_exclusion TO on;
4172 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4174 -----------------------------------------------------------------------
4177 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4178 -> Index Scan using t1_pkey on t1
4179 Index Cond: ((id < 10) AND (id = p1.id))
4182 SET constraint_exclusion TO off;
4184 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4193 -----------------------------------------------------------------------
4196 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4197 -> Index Scan using t1_pkey on t1
4198 Index Cond: ((id < 10) AND (id = p1.id))
4202 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4211 --------------------------------------------------
4213 -> Index Scan using p1_pkey on p1
4214 Index Cond: ((id >= 50) AND (id <= 51))
4215 Filter: (ctid = '(1,1)'::tid)
4216 -> Index Scan using t1_pkey on t1
4217 Index Cond: ((id < 10) AND (id = p1.id))
4221 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4230 -------------------------------------------------------
4232 -> Bitmap Heap Scan on p1
4233 Recheck Cond: ((id >= 50) AND (id <= 51))
4234 Filter: (ctid = '(1,1)'::tid)
4235 -> Bitmap Index Scan on p1_pkey
4236 Index Cond: ((id >= 50) AND (id <= 51))
4237 -> Index Scan using t1_pkey on t1
4238 Index Cond: ((id < 10) AND (id = p1.id))
4242 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4251 --------------------------------------------------
4254 TID Cond: (ctid = '(1,1)'::tid)
4255 Filter: ((id >= 50) AND (id <= 51))
4256 -> Index Scan using t1_pkey on t1
4257 Index Cond: ((id < 10) AND (id = p1.id))
4260 SET constraint_exclusion TO on;
4262 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4271 -----------------------------------------------------------------------
4274 Filter: ((id >= 50) AND (id <= 51) AND (ctid = '(1,1)'::tid))
4275 -> Index Scan using t1_pkey on t1
4276 Index Cond: ((id < 10) AND (id = p1.id))
4280 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4289 --------------------------------------------------
4291 -> Index Scan using p1_pkey on p1
4292 Index Cond: ((id >= 50) AND (id <= 51))
4293 Filter: (ctid = '(1,1)'::tid)
4294 -> Index Scan using t1_pkey on t1
4295 Index Cond: ((id < 10) AND (id = p1.id))
4299 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4308 -------------------------------------------------------
4310 -> Bitmap Heap Scan on p1
4311 Recheck Cond: ((id >= 50) AND (id <= 51))
4312 Filter: (ctid = '(1,1)'::tid)
4313 -> Bitmap Index Scan on p1_pkey
4314 Index Cond: ((id >= 50) AND (id <= 51))
4315 -> Index Scan using t1_pkey on t1
4316 Index Cond: ((id < 10) AND (id = p1.id))
4320 EXPLAIN (COSTS false) SELECT * FROM ONLY p1, t1 WHERE p1.id >= 50 AND p1.id <= 51 AND p1.ctid = '(1,1)' AND p1.id = t1.id AND t1.id < 10;
4329 --------------------------------------------------
4332 TID Cond: (ctid = '(1,1)'::tid)
4333 Filter: ((id >= 50) AND (id <= 51))
4334 -> Index Scan using t1_pkey on t1
4335 Index Cond: ((id < 10) AND (id = p1.id))
4339 /*+SeqScan("""t1 ) ")IndexScan("t 2 """)HashJoin("""t1 ) "T3"t 2 """)Leading("""t1 ) "T3"t 2 """)Set(application_name"a a a"" a A")*/
4340 EXPLAIN (COSTS false) SELECT * FROM t1 """t1 ) ", t2 "t 2 """, t3 "T3" WHERE """t1 ) ".id = "t 2 """.id AND """t1 ) ".id = "T3".id;
4345 HashJoin("""t1 ) " T3 "t 2 """)
4346 Leading("""t1 ) " T3 "t 2 """)
4347 Set(application_name "a a a"" a A")
4353 ---------------------------------------------------------
4355 Hash Cond: ("t 2 """.id = """t1 ) ".id)
4356 -> Index Scan using t2_pkey on t2 "t 2 """
4359 Hash Cond: ("""t1 ) ".id = "T3".id)
4360 -> Seq Scan on t1 """t1 ) "
4362 -> Seq Scan on t3 "T3"
4365 -- duplicate hint test
4366 /*+SeqScan(t1)SeqScan(t2)IndexScan(t1)IndexScan(t2)BitmapScan(t1)BitmapScan(t2)TidScan(t1)TidScan(t2)HashJoin(t1 t2)NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)*/
4367 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)' AND t2.ctid = '(1,1)';
4368 INFO: hint syntax error at or near "SeqScan(t1)SeqScan(t2)IndexScan(t1)IndexScan(t2)BitmapScan(t1)BitmapScan(t2)TidScan(t1)TidScan(t2)HashJoin(t1 t2)NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4369 DETAIL: Conflict scan method hint.
4370 INFO: hint syntax error at or near "IndexScan(t1)IndexScan(t2)BitmapScan(t1)BitmapScan(t2)TidScan(t1)TidScan(t2)HashJoin(t1 t2)NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4371 DETAIL: Conflict scan method hint.
4372 INFO: hint syntax error at or near "BitmapScan(t1)BitmapScan(t2)TidScan(t1)TidScan(t2)HashJoin(t1 t2)NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4373 DETAIL: Conflict scan method hint.
4374 INFO: hint syntax error at or near "SeqScan(t2)IndexScan(t1)IndexScan(t2)BitmapScan(t1)BitmapScan(t2)TidScan(t1)TidScan(t2)HashJoin(t1 t2)NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4375 DETAIL: Conflict scan method hint.
4376 INFO: hint syntax error at or near "IndexScan(t2)BitmapScan(t1)BitmapScan(t2)TidScan(t1)TidScan(t2)HashJoin(t1 t2)NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4377 DETAIL: Conflict scan method hint.
4378 INFO: hint syntax error at or near "BitmapScan(t2)TidScan(t1)TidScan(t2)HashJoin(t1 t2)NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4379 DETAIL: Conflict scan method hint.
4380 INFO: hint syntax error at or near "HashJoin(t1 t2)NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4381 DETAIL: Conflict join method hint.
4382 INFO: hint syntax error at or near "NestLoop(t2 t1)MergeJoin(t1 t2)Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4383 DETAIL: Conflict join method hint.
4384 INFO: hint syntax error at or near "Leading(t1 t2)Leading(t2 t1)Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4385 DETAIL: Conflict leading hint.
4386 INFO: hint syntax error at or near "Set(enable_seqscan off)Set(enable_mergejoin on)Set(enable_seqscan on)"
4387 DETAIL: Conflict set hint.
4394 Set(enable_mergejoin on)
4395 Set(enable_seqscan on)
4407 Set(enable_seqscan off)
4411 -----------------------------------------------
4413 Merge Cond: (t1.id = t2.id)
4417 TID Cond: (ctid = '(1,1)'::tid)
4421 TID Cond: (ctid = '(1,1)'::tid)
4424 -- sub query Leading hint test
4425 SET from_collapse_limit TO 100;
4426 SET geqo_threshold TO 100;
4427 EXPLAIN (COSTS false)
4429 SELECT max(t1_5.id) FROM t1 t1_5, t2 t2_5, t3 t3_5 WHERE t1_5.id = t2_5.id AND t2_5.id = t3_5.id
4432 SELECT max(t1_2.id) FROM t1 t1_2, t2 t2_2, t3 t3_2 WHERE t1_2.id = t2_2.id AND t2_2.id = t3_2.id
4433 ) FROM t1 t1_1, t2 t2_1, t3 t3_1, (
4434 SELECT t1_3.id FROM t1 t1_3, t2 t2_3, t3 t3_3 WHERE t1_3.id = t2_3.id AND t2_3.id = t3_3.id
4435 ) v1_1(id), c1_1 WHERE t1_1.id = t2_1.id AND t2_1.id = t3_1.id AND t2_1.id = v1_1.id AND v1_1.id = c1_1.id AND t1_1.id = (
4436 SELECT max(t1_4.id) FROM t1 t1_4, t2 t2_4, t3 t3_4 WHERE t1_4.id = t2_4.id AND t2_4.id = t3_4.id
4439 -------------------------------------------------------------------------
4444 Merge Cond: (t1_5.id = t3_5.id)
4446 Merge Cond: (t1_5.id = t2_5.id)
4447 -> Index Scan using t1_pkey on t1 t1_5
4448 -> Index Scan using t2_pkey on t2 t2_5
4451 -> Seq Scan on t3 t3_5
4452 InitPlan 2 (returns $1)
4455 Merge Cond: (t1_2.id = t3_2.id)
4457 Merge Cond: (t1_2.id = t2_2.id)
4458 -> Index Scan using t1_pkey on t1 t1_2
4459 -> Index Scan using t2_pkey on t2 t2_2
4462 -> Seq Scan on t3 t3_2
4463 InitPlan 3 (returns $2)
4466 Merge Cond: (t1_4.id = t3_4.id)
4468 Merge Cond: (t1_4.id = t2_4.id)
4469 -> Index Scan using t1_pkey on t1 t1_4
4470 -> Index Scan using t2_pkey on t2 t2_4
4473 -> Seq Scan on t3 t3_4
4479 -> Index Scan using t1_pkey on t1 t1_1
4480 Index Cond: (id = $2)
4481 -> Seq Scan on t3 t3_1
4483 -> Index Scan using t2_pkey on t2 t2_1
4484 Index Cond: (id = $2)
4485 -> Index Scan using t1_pkey on t1 t1_3
4486 Index Cond: (id = $2)
4487 -> Index Scan using t2_pkey on t2 t2_3
4488 Index Cond: (id = $2)
4489 -> Seq Scan on t3 t3_3
4495 /*+HashJoin(t1_1 t3_1)MergeJoin(t1_3 t3_3)NestLoop(t1_2 t2_2)NestLoop(t1_4 t2_4)NestLoop(t1_5 t2_5)*/
4496 EXPLAIN (COSTS false)
4498 SELECT max(t1_5.id) FROM t1 t1_5, t2 t2_5, t3 t3_5 WHERE t1_5.id = t2_5.id AND t2_5.id = t3_5.id
4501 SELECT max(t1_2.id) FROM t1 t1_2, t2 t2_2, t3 t3_2 WHERE t1_2.id = t2_2.id AND t2_2.id = t3_2.id
4502 ) FROM t1 t1_1, t2 t2_1, t3 t3_1, (
4503 SELECT t1_3.id FROM t1 t1_3, t2 t2_3, t3 t3_3 WHERE t1_3.id = t2_3.id AND t2_3.id = t3_3.id
4504 ) v1_1(id), c1_1 WHERE t1_1.id = t2_1.id AND t2_1.id = t3_1.id AND t2_1.id = v1_1.id AND v1_1.id = c1_1.id AND t1_1.id = (
4505 SELECT max(t1_4.id) FROM t1 t1_4, t2 t2_4, t3 t3_4 WHERE t1_4.id = t2_4.id AND t2_4.id = t3_4.id
4511 MergeJoin(t1_3 t3_3)
4519 -------------------------------------------------------------------------
4524 Merge Cond: (t1_5.id = t3_5.id)
4526 -> Index Scan using t2_pkey on t2 t2_5
4527 -> Index Scan using t1_pkey on t1 t1_5
4528 Index Cond: (id = t2_5.id)
4531 -> Seq Scan on t3 t3_5
4532 InitPlan 2 (returns $2)
4535 Merge Cond: (t1_2.id = t3_2.id)
4537 -> Index Scan using t2_pkey on t2 t2_2
4538 -> Index Scan using t1_pkey on t1 t1_2
4539 Index Cond: (id = t2_2.id)
4542 -> Seq Scan on t3 t3_2
4543 InitPlan 3 (returns $3)
4546 Merge Cond: (t1_4.id = t3_4.id)
4548 -> Index Scan using t2_pkey on t2 t2_4
4549 -> Index Scan using t1_pkey on t1 t1_4
4550 Index Cond: (id = t2_4.id)
4553 -> Seq Scan on t3 t3_4
4559 -> Index Scan using t2_pkey on t2 t2_1
4560 Index Cond: (id = $3)
4561 -> Seq Scan on t3 t3_1
4563 -> Index Scan using t1_pkey on t1 t1_1
4564 Index Cond: (id = $3)
4565 -> Index Scan using t1_pkey on t1 t1_3
4566 Index Cond: (id = $3)
4567 -> Index Scan using t2_pkey on t2 t2_3
4568 Index Cond: (id = $3)
4569 -> Seq Scan on t3 t3_3
4575 /*+HashJoin(t1_1 t3_1)MergeJoin(t1_3 t3_3)NestLoop(t1_2 t2_2)NestLoop(t1_4 t2_4)NestLoop(t1_5 t2_5)Leading(a t1_1 t1_2 t1_4 t1_5)*/
4576 EXPLAIN (COSTS false)
4578 SELECT max(t1_5.id) FROM t1 t1_5, t2 t2_5, t3 t3_5 WHERE t1_5.id = t2_5.id AND t2_5.id = t3_5.id
4581 SELECT max(t1_2.id) FROM t1 t1_2, t2 t2_2, t3 t3_2 WHERE t1_2.id = t2_2.id AND t2_2.id = t3_2.id
4582 ) FROM t1 t1_1, t2 t2_1, t3 t3_1, (
4583 SELECT t1_3.id FROM t1 t1_3, t2 t2_3, t3 t3_3 WHERE t1_3.id = t2_3.id AND t2_3.id = t3_3.id
4584 ) v1_1(id), c1_1 WHERE t1_1.id = t2_1.id AND t2_1.id = t3_1.id AND t2_1.id = v1_1.id AND v1_1.id = c1_1.id AND t1_1.id = (
4585 SELECT max(t1_4.id) FROM t1 t1_4, t2 t2_4, t3 t3_4 WHERE t1_4.id = t2_4.id AND t2_4.id = t3_4.id
4591 MergeJoin(t1_3 t3_3)
4595 Leading(a t1_1 t1_2 t1_4 t1_5)
4600 -------------------------------------------------------------------------
4605 Merge Cond: (t1_5.id = t3_5.id)
4607 -> Index Scan using t2_pkey on t2 t2_5
4608 -> Index Scan using t1_pkey on t1 t1_5
4609 Index Cond: (id = t2_5.id)
4612 -> Seq Scan on t3 t3_5
4613 InitPlan 2 (returns $2)
4616 Merge Cond: (t1_2.id = t3_2.id)
4618 -> Index Scan using t2_pkey on t2 t2_2
4619 -> Index Scan using t1_pkey on t1 t1_2
4620 Index Cond: (id = t2_2.id)
4623 -> Seq Scan on t3 t3_2
4624 InitPlan 3 (returns $3)
4627 Merge Cond: (t1_4.id = t3_4.id)
4629 -> Index Scan using t2_pkey on t2 t2_4
4630 -> Index Scan using t1_pkey on t1 t1_4
4631 Index Cond: (id = t2_4.id)
4634 -> Seq Scan on t3 t3_4
4640 -> Index Scan using t2_pkey on t2 t2_1
4641 Index Cond: (id = $3)
4642 -> Seq Scan on t3 t3_1
4644 -> Index Scan using t1_pkey on t1 t1_1
4645 Index Cond: (id = $3)
4646 -> Index Scan using t1_pkey on t1 t1_3
4647 Index Cond: (id = $3)
4648 -> Index Scan using t2_pkey on t2 t2_3
4649 Index Cond: (id = $3)
4650 -> Seq Scan on t3 t3_3
4656 /*+HashJoin(t1_1 t3_1)MergeJoin(t1_3 t3_3)NestLoop(t1_2 t2_2)NestLoop(t1_4 t2_4)NestLoop(t1_5 t2_5)Leading(a t3_2 t3_5 t2_2 c1_1 t3_4 t3_3 t2_3 t2_4 t1_3 t2_5 t1_2 t3_1 t1_4 t2_1 t1_5 t1_1)*/
4657 EXPLAIN (COSTS false)
4659 SELECT max(t1_5.id) FROM t1 t1_5, t2 t2_5, t3 t3_5 WHERE t1_5.id = t2_5.id AND t2_5.id = t3_5.id
4662 SELECT max(t1_2.id) FROM t1 t1_2, t2 t2_2, t3 t3_2 WHERE t1_2.id = t2_2.id AND t2_2.id = t3_2.id
4663 ) FROM t1 t1_1, t2 t2_1, t3 t3_1, (
4664 SELECT t1_3.id FROM t1 t1_3, t2 t2_3, t3 t3_3 WHERE t1_3.id = t2_3.id AND t2_3.id = t3_3.id
4665 ) v1_1(id), c1_1 WHERE t1_1.id = t2_1.id AND t2_1.id = t3_1.id AND t2_1.id = v1_1.id AND v1_1.id = c1_1.id AND t1_1.id = (
4666 SELECT max(t1_4.id) FROM t1 t1_4, t2 t2_4, t3 t3_4 WHERE t1_4.id = t2_4.id AND t2_4.id = t3_4.id
4670 Leading(a t3_2 t3_5 t2_2 c1_1 t3_4 t3_3 t2_3 t2_4 t1_3 t2_5 t1_2 t3_1 t1_4 t2_1 t1_5 t1_1)
4674 MergeJoin(t1_3 t3_3)
4681 -------------------------------------------------------------------
4686 Merge Cond: (t2_5.id = t1_5.id)
4688 Merge Cond: (t2_5.id = t3_5.id)
4689 -> Index Scan using t2_pkey on t2 t2_5
4692 -> Seq Scan on t3 t3_5
4693 -> Index Scan using t1_pkey on t1 t1_5
4694 InitPlan 2 (returns $1)
4697 Merge Cond: (t2_2.id = t1_2.id)
4699 Merge Cond: (t2_2.id = t3_2.id)
4700 -> Index Scan using t2_pkey on t2 t2_2
4703 -> Seq Scan on t3 t3_2
4704 -> Index Scan using t1_pkey on t1 t1_2
4705 InitPlan 3 (returns $2)
4708 Merge Cond: (t2_4.id = t1_4.id)
4710 Merge Cond: (t2_4.id = t3_4.id)
4711 -> Index Scan using t2_pkey on t2 t2_4
4714 -> Seq Scan on t3 t3_4
4715 -> Index Scan using t1_pkey on t1 t1_4
4721 -> Seq Scan on t3 t3_3
4725 -> Index Scan using t2_pkey on t2 t2_3
4726 Index Cond: (id = $2)
4727 -> Index Scan using t1_pkey on t1 t1_3
4728 Index Cond: (id = $2)
4729 -> Seq Scan on t3 t3_1
4731 -> Index Scan using t2_pkey on t2 t2_1
4732 Index Cond: (id = $2)
4733 -> Index Scan using t1_pkey on t1 t1_1
4734 Index Cond: (id = $2)
4737 SET from_collapse_limit TO 1;
4738 EXPLAIN (COSTS false)
4740 SELECT max(t1_5.id) FROM t1 t1_5, t2 t2_5, t3 t3_5 WHERE t1_5.id = t2_5.id AND t2_5.id = t3_5.id
4743 SELECT max(t1_2.id) FROM t1 t1_2, t2 t2_2, t3 t3_2 WHERE t1_2.id = t2_2.id AND t2_2.id = t3_2.id
4744 ) FROM t1 t1_1, t2 t2_1, t3 t3_1, (
4745 SELECT t1_3.id FROM t1 t1_3, t2 t2_3, t3 t3_3 WHERE t1_3.id = t2_3.id AND t2_3.id = t3_3.id
4746 ) v1_1(id), c1_1 WHERE t1_1.id = t2_1.id AND t2_1.id = t3_1.id AND t2_1.id = v1_1.id AND v1_1.id = c1_1.id AND t1_1.id = (
4747 SELECT max(t1_4.id) FROM t1 t1_4, t2 t2_4, t3 t3_4 WHERE t1_4.id = t2_4.id AND t2_4.id = t3_4.id
4750 ---------------------------------------------------------------
4755 Merge Cond: (t1_5.id = t3_5.id)
4757 Merge Cond: (t1_5.id = t2_5.id)
4758 -> Index Scan using t1_pkey on t1 t1_5
4759 -> Index Scan using t2_pkey on t2 t2_5
4762 -> Seq Scan on t3 t3_5
4763 InitPlan 2 (returns $1)
4766 Merge Cond: (t1_2.id = t3_2.id)
4768 Merge Cond: (t1_2.id = t2_2.id)
4769 -> Index Scan using t1_pkey on t1 t1_2
4770 -> Index Scan using t2_pkey on t2 t2_2
4773 -> Seq Scan on t3 t3_2
4774 InitPlan 3 (returns $2)
4777 Merge Cond: (t1_4.id = t3_4.id)
4779 Merge Cond: (t1_4.id = t2_4.id)
4780 -> Index Scan using t1_pkey on t1 t1_4
4781 -> Index Scan using t2_pkey on t2 t2_4
4784 -> Seq Scan on t3 t3_4
4788 -> Index Scan using t1_pkey on t1 t1_1
4789 Index Cond: (id = $2)
4790 -> Seq Scan on t3 t3_1
4792 -> Index Scan using t2_pkey on t2 t2_1
4793 Index Cond: (id = $2)
4796 -> Index Scan using t1_pkey on t1 t1_3
4797 Index Cond: (id = $2)
4798 -> Seq Scan on t3 t3_3
4800 -> Index Scan using t2_pkey on t2 t2_3
4801 Index Cond: (id = $2)
4806 /*+HashJoin(t1_1 t3_1)MergeJoin(t1_3 t3_3)NestLoop(t1_2 t2_2)NestLoop(t1_4 t2_4)NestLoop(t1_5 t2_5)*/
4807 EXPLAIN (COSTS false)
4809 SELECT max(t1_5.id) FROM t1 t1_5, t2 t2_5, t3 t3_5 WHERE t1_5.id = t2_5.id AND t2_5.id = t3_5.id
4812 SELECT max(t1_2.id) FROM t1 t1_2, t2 t2_2, t3 t3_2 WHERE t1_2.id = t2_2.id AND t2_2.id = t3_2.id
4813 ) FROM t1 t1_1, t2 t2_1, t3 t3_1, (
4814 SELECT t1_3.id FROM t1 t1_3, t2 t2_3, t3 t3_3 WHERE t1_3.id = t2_3.id AND t2_3.id = t3_3.id
4815 ) v1_1(id), c1_1 WHERE t1_1.id = t2_1.id AND t2_1.id = t3_1.id AND t2_1.id = v1_1.id AND v1_1.id = c1_1.id AND t1_1.id = (
4816 SELECT max(t1_4.id) FROM t1 t1_4, t2 t2_4, t3 t3_4 WHERE t1_4.id = t2_4.id AND t2_4.id = t3_4.id
4822 MergeJoin(t1_3 t3_3)
4830 ---------------------------------------------------------------
4835 Merge Cond: (t1_5.id = t3_5.id)
4837 -> Index Scan using t2_pkey on t2 t2_5
4838 -> Index Scan using t1_pkey on t1 t1_5
4839 Index Cond: (id = t2_5.id)
4842 -> Seq Scan on t3 t3_5
4843 InitPlan 2 (returns $2)
4846 Merge Cond: (t1_2.id = t3_2.id)
4848 -> Index Scan using t2_pkey on t2 t2_2
4849 -> Index Scan using t1_pkey on t1 t1_2
4850 Index Cond: (id = t2_2.id)
4853 -> Seq Scan on t3 t3_2
4854 InitPlan 3 (returns $3)
4857 Merge Cond: (t1_4.id = t3_4.id)
4859 -> Index Scan using t2_pkey on t2 t2_4
4860 -> Index Scan using t1_pkey on t1 t1_4
4861 Index Cond: (id = t2_4.id)
4864 -> Seq Scan on t3 t3_4
4868 -> Index Scan using t2_pkey on t2 t2_1
4869 Index Cond: (id = $3)
4870 -> Seq Scan on t3 t3_1
4872 -> Index Scan using t1_pkey on t1 t1_1
4873 Index Cond: (id = $3)
4876 -> Index Scan using t2_pkey on t2 t2_3
4877 Index Cond: (id = $3)
4878 -> Seq Scan on t3 t3_3
4880 -> Index Scan using t1_pkey on t1 t1_3
4881 Index Cond: (id = $3)
4886 /*+HashJoin(t1_1 t3_1)MergeJoin(t1_3 t3_3)NestLoop(t1_2 t2_2)NestLoop(t1_4 t2_4)NestLoop(t1_5 t2_5)Leading(a t1_1 t1_2 t1_4 t1_5)*/
4887 EXPLAIN (COSTS false)
4889 SELECT max(t1_5.id) FROM t1 t1_5, t2 t2_5, t3 t3_5 WHERE t1_5.id = t2_5.id AND t2_5.id = t3_5.id
4892 SELECT max(t1_2.id) FROM t1 t1_2, t2 t2_2, t3 t3_2 WHERE t1_2.id = t2_2.id AND t2_2.id = t3_2.id
4893 ) FROM t1 t1_1, t2 t2_1, t3 t3_1, (
4894 SELECT t1_3.id FROM t1 t1_3, t2 t2_3, t3 t3_3 WHERE t1_3.id = t2_3.id AND t2_3.id = t3_3.id
4895 ) v1_1(id), c1_1 WHERE t1_1.id = t2_1.id AND t2_1.id = t3_1.id AND t2_1.id = v1_1.id AND v1_1.id = c1_1.id AND t1_1.id = (
4896 SELECT max(t1_4.id) FROM t1 t1_4, t2 t2_4, t3 t3_4 WHERE t1_4.id = t2_4.id AND t2_4.id = t3_4.id
4902 MergeJoin(t1_3 t3_3)
4906 Leading(a t1_1 t1_2 t1_4 t1_5)
4911 ---------------------------------------------------------------
4916 Merge Cond: (t1_5.id = t3_5.id)
4918 -> Index Scan using t2_pkey on t2 t2_5
4919 -> Index Scan using t1_pkey on t1 t1_5
4920 Index Cond: (id = t2_5.id)
4923 -> Seq Scan on t3 t3_5
4924 InitPlan 2 (returns $2)
4927 Merge Cond: (t1_2.id = t3_2.id)
4929 -> Index Scan using t2_pkey on t2 t2_2
4930 -> Index Scan using t1_pkey on t1 t1_2
4931 Index Cond: (id = t2_2.id)
4934 -> Seq Scan on t3 t3_2
4935 InitPlan 3 (returns $3)
4938 Merge Cond: (t1_4.id = t3_4.id)
4940 -> Index Scan using t2_pkey on t2 t2_4
4941 -> Index Scan using t1_pkey on t1 t1_4
4942 Index Cond: (id = t2_4.id)
4945 -> Seq Scan on t3 t3_4
4949 -> Index Scan using t2_pkey on t2 t2_1
4950 Index Cond: (id = $3)
4951 -> Seq Scan on t3 t3_1
4953 -> Index Scan using t1_pkey on t1 t1_1
4954 Index Cond: (id = $3)
4957 -> Index Scan using t2_pkey on t2 t2_3
4958 Index Cond: (id = $3)
4959 -> Seq Scan on t3 t3_3
4961 -> Index Scan using t1_pkey on t1 t1_3
4962 Index Cond: (id = $3)
4967 /*+HashJoin(t1_1 t3_1)MergeJoin(t1_3 t3_3)NestLoop(t1_2 t2_2)NestLoop(t1_4 t2_4)NestLoop(t1_5 t2_5)Leading(a t3_2 t3_5 t2_2 c1_1 t3_4 t3_3 t2_3 t2_4 t1_3 t2_5 t1_2 t3_1 t1_4 t2_1 t1_5 t1_1)*/
4968 EXPLAIN (COSTS false)
4970 SELECT max(t1_5.id) FROM t1 t1_5, t2 t2_5, t3 t3_5 WHERE t1_5.id = t2_5.id AND t2_5.id = t3_5.id
4973 SELECT max(t1_2.id) FROM t1 t1_2, t2 t2_2, t3 t3_2 WHERE t1_2.id = t2_2.id AND t2_2.id = t3_2.id
4974 ) FROM t1 t1_1, t2 t2_1, t3 t3_1, (
4975 SELECT t1_3.id FROM t1 t1_3, t2 t2_3, t3 t3_3 WHERE t1_3.id = t2_3.id AND t2_3.id = t3_3.id
4976 ) v1_1(id), c1_1 WHERE t1_1.id = t2_1.id AND t2_1.id = t3_1.id AND t2_1.id = v1_1.id AND v1_1.id = c1_1.id AND t1_1.id = (
4977 SELECT max(t1_4.id) FROM t1 t1_4, t2 t2_4, t3 t3_4 WHERE t1_4.id = t2_4.id AND t2_4.id = t3_4.id
4981 Leading(a t3_2 t3_5 t2_2 c1_1 t3_4 t3_3 t2_3 t2_4 t1_3 t2_5 t1_2 t3_1 t1_4 t2_1 t1_5 t1_1)
4985 MergeJoin(t1_3 t3_3)
4992 -------------------------------------------------------------------------
4997 Merge Cond: (t2_5.id = t1_5.id)
4999 Merge Cond: (t2_5.id = t3_5.id)
5000 -> Index Scan using t2_pkey on t2 t2_5
5003 -> Seq Scan on t3 t3_5
5004 -> Index Scan using t1_pkey on t1 t1_5
5005 InitPlan 2 (returns $1)
5008 Merge Cond: (t2_2.id = t1_2.id)
5010 Merge Cond: (t2_2.id = t3_2.id)
5011 -> Index Scan using t2_pkey on t2 t2_2
5014 -> Seq Scan on t3 t3_2
5015 -> Index Scan using t1_pkey on t1 t1_2
5016 InitPlan 3 (returns $2)
5019 Merge Cond: (t2_4.id = t1_4.id)
5021 Merge Cond: (t2_4.id = t3_4.id)
5022 -> Index Scan using t2_pkey on t2 t2_4
5025 -> Seq Scan on t3 t3_4
5026 -> Index Scan using t1_pkey on t1 t1_4
5032 -> Index Scan using t2_pkey on t2 t2_3
5033 Index Cond: (id = $2)
5034 -> Seq Scan on t3 t3_3
5036 -> Index Scan using t1_pkey on t1 t1_3
5037 Index Cond: (id = $2)
5040 -> Seq Scan on t3 t3_1
5042 -> Index Scan using t2_pkey on t2 t2_1
5043 Index Cond: (id = $2)
5044 -> Index Scan using t1_pkey on t1 t1_1
5045 Index Cond: (id = $2)
5048 EXPLAIN (COSTS false) SELECT * FROM t1, s1.t1, t2 WHERE public.t1.id = s1.t1.id AND public.t1.id = t2.id;
5050 -----------------------------------------------
5052 Merge Cond: (public.t1.id = t2.id)
5054 Merge Cond: (public.t1.id = s1.t1.id)
5055 -> Index Scan using t1_pkey on t1
5056 -> Index Scan using t1_pkey on t1
5057 -> Index Scan using t2_pkey on t2
5060 /*+NestLoop(t1 t2)*/
5061 EXPLAIN (COSTS false) SELECT * FROM t1, s1.t1, t2 WHERE public.t1.id = s1.t1.id AND public.t1.id = t2.id;
5062 INFO: hint syntax error at or near "NestLoop(t1 t2)"
5063 DETAIL: Relation name "t1" is ambiguous.
5064 ERROR: negative bitmapset member not allowed