| 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: | Whole Thread | Raw Message | 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
| 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 |