Re: [PERFORM] Query plan with missing timespans

2015-04-22 Thread Andomar
ually implied 0 ms: actual time=0.040..0.040 But based on your reply this means, it took between 0.040 and 0.040 ms for each loop? Is there a way to tell postgres that a function will always return the same result for the same parameter, within the same transaction? Kind regards, Andoma

[PERFORM] Query plan with missing timespans

2015-04-22 Thread Andomar
This is a question about how to read "explain analyze". I've anonymized column names and table names. In the output of "explain analyze" below, what was the query doing between actual time 1.426 and 17.077? Kind regards, Andomar HashAggregate (cost=862.02