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

From: Edson Richter <richter(at)simkorp(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Get time for each operation in "Explain..."
Date: 2012-09-17 14:48:58
Message-ID: 5057385A.9020302@simkorp.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
Embedded Image

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2012-09-17 14:53:58 Re: Get time for each operation in "Explain..."
Previous Message Alban Hertroys 2012-09-17 14:46:37 Re: Can a view use a schema search_path?