If you want more precise timings then turn on log_duration_statement.
The logs will carry timings down to the microsecond.
Also note that this is not the correct list for such questions - this
list is about development of PostgreSQL, not use.
cheers
andrew
Kenneth Marshall wrote:
Mickael
Mickael,
Not knowing your query, it sounds like your method is working
correctly. It is quite normal to have the initial query take
longer than subsequent queries. This is a cache effect and is
what databases, in general, strive for performance-wise. I
suspect that the second time you run the quer
