possible minor EXPLAIN bug?

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "PostgreSQL-development Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: possible minor EXPLAIN bug?
Date: 2008-08-19 07:45:54
Message-ID: 162867790808190045o5053e4d4tbb910797c702fbda@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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) --< wrong should 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2008-08-19 07:49:55 Re: [HACKERS] WITH RECURSIVE patches 0818
Previous Message Jeremy Drake 2008-08-19 07:33:38 Re: Extending varlena