Request a Demo
Home   >   mailing lists

interpret statement log duration information - Mailing list pgsql-performance

From Mark Rostron
Subject interpret statement log duration information
Date
Msg-id FD020D3E50E7FA479567872E5F5F31E3045A1865FE@ex01.corp.ql2.com
Whole thread Raw
Responses Re: interpret statement log duration information
List pgsql-performance
Tree view

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

 

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Next
From: Tom Lane
Date:
Subject: Re: interpret statement log duration information