Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group