Thread: about statement execution times in the logs

Hello community,

I have a simple question about the duration of statements, which appear in the logs when using :

log_min_duration_statement = 0

or

log_duration = on

Does this include client-time ? (i.e the time spent to send the data to the client). Or is it server-side only ?

According to different tests I made, it seems not to be, but I'd like to have your confirmation.
Note : I run pg 12

Thanks !

On 1/24/24 02:48, Mickaël SALMON wrote:
> Hello community,
> 
> 
> I have a simple question about the duration of statements, which appear 
> in the logs when using :
> 
> 
>     log_min_duration_statement = 0
> 
> 
> or
> 
> 
>     log_duration = on
> 
> 
> Does this include client-time ? (i.e the time spent to send the data to 
> the client). Or is it server-side only ?
> 
> 
> According to different tests I made, it seems not to be, but I'd like to 
> have your confirmation.
> Note : I run pg 12
> 


Asked and answered:

https://stackoverflow.com/questions/77872627/does-postgresql-log-statement-duration-includes-client-time

> 
> Thanks !
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com