Re: [HACKERS] T_CustomScan on ExplainTargetRel
Kouhei Kaigai kai...@ak.jp.nec.com writes: The attached obvious patch adds T_CustomScan on case-switch of ExplainTargetRel() that was oversight. Applied, thanks. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] T_CustomScan on ExplainTargetRel
Hello, The attached obvious patch adds T_CustomScan on case-switch of ExplainTargetRel() that was oversight. It looked like working, but what it did was just printing referenced name, instead of table name. postgres=# explain select ctid, * from t0 hoge where ctid '(50,0)'::tid; QUERY PLAN Custom Scan (ctidscan) on hoge (cost=0.00..100.00 rows= width=43) Filter: (ctid '(50,0)'::tid) ctid quals: (ctid '(50,0)'::tid) (3 rows) This patch fixes up this behavior, as like other *Scan nodes are doing. postgres=# explain select ctid, * from t0 hoge where ctid '(50,0)'::tid; QUERY PLAN - Seq Scan on t0 hoge (cost=0.00..209.00 rows= width=43) Filter: (ctid '(50,0)'::tid) (2 rows) Thanks, -- NEC OSS Promotion Center / PG-Strom Project KaiGai Kohei kai...@ak.jp.nec.com pgsql-v9.5-fixup-customscan-on-explain-targetrel.patch Description: pgsql-v9.5-fixup-customscan-on-explain-targetrel.patch -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] T_CustomScan on ExplainTargetRel
BTW, I published the 'ctidscan' module below as an example of custom-scan. https://github.com/kaigai/ctidscan -- NEC OSS Promotion Center / PG-Strom Project KaiGai Kohei kai...@ak.jp.nec.com -Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Kouhei Kaigai Sent: Thursday, November 20, 2014 3:42 PM To: pgsql-hackers@postgresql.org Subject: [HACKERS] T_CustomScan on ExplainTargetRel Hello, The attached obvious patch adds T_CustomScan on case-switch of ExplainTargetRel() that was oversight. It looked like working, but what it did was just printing referenced name, instead of table name. postgres=# explain select ctid, * from t0 hoge where ctid '(50,0)'::tid; QUERY PLAN -- -- Custom Scan (ctidscan) on hoge (cost=0.00..100.00 rows= width=43) Filter: (ctid '(50,0)'::tid) ctid quals: (ctid '(50,0)'::tid) (3 rows) This patch fixes up this behavior, as like other *Scan nodes are doing. postgres=# explain select ctid, * from t0 hoge where ctid '(50,0)'::tid; QUERY PLAN - Seq Scan on t0 hoge (cost=0.00..209.00 rows= width=43) Filter: (ctid '(50,0)'::tid) (2 rows) Thanks, -- NEC OSS Promotion Center / PG-Strom Project KaiGai Kohei kai...@ak.jp.nec.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers