Re: [PERFORM] interpret statement log duration information

2010-10-25 Thread Tom Lane
Mark Rostron 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

[PERFORM] interpret statement log duration information

2010-10-25 Thread Mark Rostron
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 tim