Get time for each operation in "Explain..." - Mailing list pgsql-general

From Edson Richter
Subject Get time for each operation in "Explain..."
Date
Msg-id 5057385A.9020302@simkorp.com.br
Whole thread Raw
Responses Re: Get time for each operation in "Explain..."
List 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

Attachment

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Can a view use a schema search_path?
Next
From: Pavel Stehule
Date:
Subject: Re: Get time for each operation in "Explain..."