possible minor EXPLAIN bug? - Mailing list pgsql-hackers

From Pavel Stehule
Subject possible minor EXPLAIN bug?
Date
Msg-id 162867790808190045o5053e4d4tbb910797c702fbda@mail.gmail.com
Whole thread Raw
Responses Re: possible minor EXPLAIN bug?  (Simon Riggs <simon@2ndQuadrant.com>)
Re: possible minor EXPLAIN bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello

I thing so Agg node doesn't set width well:

postgres=# explain select a,b from twocol;                       QUERY PLAN
----------------------------------------------------------Seq Scan on twocol  (cost=0.00..31.40 rows=2140 width=8)
(1 row)

postgres=# explain select sum(a) from twocol group by b;                          QUERY PLAN
----------------------------------------------------------------HashAggregate  (cost=42.10..44.60 rows=200 width=8) --<
wrongshould be 4  ->  Seq Scan on twocol  (cost=0.00..31.40 rows=2140 width=8)
 
(2 rows)

Agg get width directly from outer plan, what could be wrong.

Regards
Pavel Stehule


pgsql-hackers by date:

Previous
From: Jeremy Drake
Date:
Subject: Re: Extending varlena
Next
From: Tatsuo Ishii
Date:
Subject: Re: WITH RECURSIVE patches 0818