Question on what Duration in the log

Поиск
Список
Период
Сортировка
От Vitale, Anthony, Sony Music
Тема Question on what Duration in the log
Дата
Msg-id AS8PR02MB100787E253E044418232962DC99B42@AS8PR02MB10078.eurprd02.prod.outlook.com
обсуждение исходный текст
Ответы Re: Question on what Duration in the log
Список pgsql-performance

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

 

В списке pgsql-performance по дате отправления: