public inbox for [email protected]  

help / color / mirror / Atom feed

From: Vitale, Anthony, Sony Music <[email protected]>
To: [email protected] <[email protected]>
Subject: Question on what Duration in the log
Date: Wed, 9 Apr 2025 14:27:08 +0000
Message-ID: <AS8PR02MB100787E253E044418232962DC99B42@AS8PR02MB10078.eurprd02.prod.outlook.com> (raw)

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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Question on what Duration in the log
  In-Reply-To: <AS8PR02MB100787E253E044418232962DC99B42@AS8PR02MB10078.eurprd02.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox