Re: 9.0 EXPLAIN Buffers: written=nnnn - Mailing list pgsql-general

From Rodrigo Gonzalez
Subject Re: 9.0 EXPLAIN Buffers: written=nnnn
Date
Msg-id 20120202153734.47a3c21c@estrads.com.ar
Whole thread Raw
In response to 9.0 EXPLAIN Buffers: written=nnnn  (<david.sahagian@emc.com>)
List pgsql-general
El Thu, 2 Feb 2012 12:03:20 -0500
<david.sahagian@emc.com> escribió:
> Do EXPLAIN ANALYZE:
>
>   written=2325   !!!!!
>
> "Total runtime: 375542.347 ms"
>
>
> Then Do EXPLAIN ANALYZE again:

> In general, can you tell me why [written=2325] is displayed by the
> first EXPLAIN, but not the second EXPLAIN ? The query is a SELECT, so
> what is getting "written" ?
>
> Note that both EXPLAINs have the exact same plan. Bottom up is: Seq
> Scan on YYYY, Hash, Seq Scan on XXXX, Hash Join, HashAggregate
>
> I am wondering if it is a clue as to why the "actual time" is so
> different from one run to the next.
>

I can be completely wrong, but maybe it is about hint bits.

Read http://wiki.postgresql.org/wiki/Hint_Bits

Thanks

Rodrigo

pgsql-general by date:

Previous
From:
Date:
Subject: 9.0 EXPLAIN Buffers: written=nnnn
Next
From: Christophe Pettus
Date:
Subject: xlog min recovery request ... is past current point ...