Thread: interpret statement log duration information

interpret statement log duration information

From
Mark Rostron
Date:

Hey

 

Turned on log_min_duration_statement today and started getting timings on sql statements (version 8.3.10).

Can anyone please tell me how to interpret the (S_nn/C_nn) information in the log line.

 

LOG:  duration: 19817.211 ms  execute S_73/C_74: ….(statement text) …..

 

Thanks for your time

Mr

 

Re: interpret statement log duration information

From
Tom Lane
Date:
Mark Rostron <mrostron@ql2.com> writes:
> Can anyone please tell me how to interpret the (S_nn/C_nn) information in the log line.

> LOG:  duration: 19817.211 ms  execute S_73/C_74: ....(statement text) .....

It's prepared statement name slash portal name.  You'd have to look at
your client-side code to find out what the names refer to.

            regards, tom lane