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


Reply via email to