Hello All
In my PG Version 14 log I have set to log the duration of sql (Example of one
log row below).
2025-04-08 07:31:57 UTC:XXX(55994):XXX:[8949]:LOG: duration: 6555.756 ms
execute S_381: {Actual Parameterized Sql executed}
This Shows the Execution of a JDBC Server Side Prepared statement (i.e S_381)
which took 6.5 seconds.
When I run the Sql using explain analyze it runs shows an execution time of 73
ms
Planning Time: 0.773 ms
Execution Time: 73.578 ms
I am trying to understand the duration of 6.5 seconds and if it represents the
time to execute the sql (Since the plan already exists) itself or the full
time needed to execute the sql as well as for the last row to be fetched by the
program.
The result set of the query does return 50,000+ rows
Is there anywhere that explains what exactly the duration in the log represents.
Thanks
Anthony Vitale
