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

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,

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)

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@simkorp.com.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