On 2010-12-08 10:19 AM +0200, David Fetter wrote:
> On Sun, Dec 05, 2010 at 01:33:39PM -0500, Greg Smith wrote:
>> So this patch was marked "Ready for Committer", but a) no committer
>> has picked it up yet and b) Marko has made changes here that nobody
>> else has tested out yet that I've seen on the last. Accordingly,
>> that classification may have been optimistic. It seems to me that
>> another testing run-through from someone like David might be
>> appropriate to build some confidence this latest patch should be a
>> commit candidate. If there is a committer intending to work on this
>> as-is, they haven't identified themselves.
>
> I've tested this one and not managed to break it. One thing it could
> use is support for EXPLAIN ANALYZE.
What's wrong with EXPLAIN ANALYZE? Here's what I see:
=# explain analyze with t as (insert into foo values(0) returning *)
select * from t; QUERY PLAN
-------------------------------------------------------------------------------------------------- CTE Scan on t
(cost=0.01..0.03rows=1 width=4) (actual
time=0.017..0.017 rows=1 loops=2) CTE t -> Insert (cost=0.00..0.01 rows=1 width=0) (actual
time=0.029..0.030 rows=1 loops=1) -> Result (cost=0.00..0.01 rows=1 width=0) (actual
time=0.002..0.002 rows=1 loops=1) Total runtime: 0.104 ms
(5 rows)
Regards,
Marko Tiikkaja