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

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>

> 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 Celular: (51)9318-9766/(51)
> 8585-0796 [image: Embedded Image]
>