Re: Get time for each operation in "Explain..."

Perfect!

As I did suspect, I need more education :-)

Regards,

*Edson Carlos Ericksson Richter*
/SimKorp Informática Ltda/
Fone: (51) 3366-7964
Celular: (51)9318-9766/(51) 8585-0796
Embedded Image

Em 17/09/2012 11:53, Pavel Stehule escreveu:
> Hello
>
> use EXPLAIN ANALYZE
>
> chef=# explain ANALYZE select count(*) from
> d_items_itmaum_aan2ii80lhab3x0 ;
> QUERY PLAN
> ---------------------------------------------------------------------------------------------------------------------
> Aggregate (cost=1.06..1.07 rows=1 width=0) (actual time=0.008..0.008
> rows=1 loops=1)
> -> Seq Scan on d_items_itmaum_aan2ii80lhab3x0 (cost=0.00..1.05
> rows=5 width=0) (actual time=0.004..0.006 rows=5
> Total runtime: 0.030 ms
> (3 rows)
>
>
>
>
> 2012/9/17 Edson Richter <richter(at)simkorp(dot)com(dot)br
> <mailto:richter(at)simkorp(dot)com(dot)br>>
>
> Is there any flag I can set in PostgreSQL to get the real time
> spent in each step on "Explain"?
> Is like "Explain Execute" that will get time for each step after
> real execution.
> I know there is the "cost" attribute, but seems to me that the
> "projected cost" is not always the same as "time spent" (may be I
> just need more education on this topic).
>
> Thanks,
> --
>
> *Edson Carlos Ericksson Richter*
> /SimKorp Informática Ltda/
> Fone: (51) 3366-7964 <tel:%2851%29%203366-7964>
> Celular: (51)9318-9766/(51) 8585-0796
> Embedded Image
>
>
>