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)
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 LtdaFone: (51) 3366-7964 Celular: (51)9318-9766/(51) 8585-0796
Вложения
В списке pgsql-general по дате отправления: