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 |
 |
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 <rich...@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 |
 |
|
