From 1a289e8de3464055d23c38c58bed8fc737c56485 Mon Sep 17 00:00:00 2001 From: Mitsuru Hasegawa Date: Tue, 17 Jul 2012 17:23:44 +0900 Subject: [PATCH] =?utf8?q?=E7=92=B0=E5=A2=83=EF=BC=88=E3=83=AA=E3=82=B0?= =?utf8?q?=E3=83=AC=E3=83=83=E3=82=B7=E3=83=A7=E3=83=B3=E3=82=92=E5=AE=9F?= =?utf8?q?=E8=A1=8C=E3=81=97=E3=81=9F=E3=83=91=E3=82=B9=E3=81=AE=E9=95=B7?= =?utf8?q?=E3=81=95=EF=BC=89=E3=81=AB=E3=82=88=E3=81=A3=E3=81=A6=E8=A9=A6?= =?utf8?q?=E9=A8=93=E7=B5=90=E6=9E=9C=E3=81=8C=20=E5=A4=89=E3=82=8F?= =?utf8?q?=E3=82=8B=E5=95=8F=E9=A1=8C=E3=81=AB=E5=AF=BE=E5=87=A6=E3=81=97?= =?utf8?q?=E3=81=9F=E3=80=82?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- input/fdw.source | 1 + output/fdw.source | 7 +------ 2 files changed, 2 insertions(+), 6 deletions(-) diff --git a/input/fdw.source b/input/fdw.source index 95f7895..b14ff8b 100644 --- a/input/fdw.source +++ b/input/fdw.source @@ -10,6 +10,7 @@ CREATE FOREIGN TABLE ft1 (id int, val int) SERVER file_server OPTIONS (format 'c -- foreign table test SELECT * FROM ft1; +\t EXPLAIN (COSTS false) SELECT * FROM t1, ft1 WHERE t1.id = ft1.id; /*+SeqScan(t1)SeqScan(ft1)*/ EXPLAIN (COSTS false) SELECT * FROM t1, ft1 WHERE t1.id = ft1.id; diff --git a/output/fdw.source b/output/fdw.source index 71464cf..b6cb029 100644 --- a/output/fdw.source +++ b/output/fdw.source @@ -22,15 +22,13 @@ SELECT * FROM ft1; 10 | 10 (10 rows) +\t EXPLAIN (COSTS false) SELECT * FROM t1, ft1 WHERE t1.id = ft1.id; - QUERY PLAN ------------------------------------------------------------------------------------------------ Nested Loop -> Foreign Scan on ft1 Foreign File: @abs_srcdir@/data/data.csv -> Index Scan using t1_pkey on t1 Index Cond: (id = ft1.id) -(5 rows) /*+SeqScan(t1)SeqScan(ft1)*/ EXPLAIN (COSTS false) SELECT * FROM t1, ft1 WHERE t1.id = ft1.id; @@ -42,13 +40,10 @@ SeqScan(ft1) duplication hint: error hint: - QUERY PLAN ------------------------------------------------------------------------------------------------------ Hash Join Hash Cond: (t1.id = ft1.id) -> Seq Scan on t1 -> Hash -> Foreign Scan on ft1 Foreign File: @abs_srcdir@/data/data.csv -(6 rows) -- 2.11.0