interpret statement log duration information

From: Mark Rostron <mrostron(at)ql2(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: interpret statement log duration information
Date: 2010-10-25 22:33:47
Message-ID: FD020D3E50E7FA479567872E5F5F31E3045A1865FE@ex01.corp.ql2.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-10-25 22:54:43 Re: interpret statement log duration information
Previous Message Merlin Moncure 2010-10-25 20:51:02 Re: Postgres insert performance and storage requirement compared to Oracle