Postgres Pro
Downloads
Home   >   mailing lists

Re: interpret statement log duration information - Mailing list pgsql-performance

From Tom Lane
Subject Re: interpret statement log duration information
Date
Msg-id 8227.1288047283@sss.pgh.pa.us
Whole thread Raw
In response to interpret statement log duration information  (Mark Rostron <mrostron@ql2.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Mark Rostron
Date:
Subject: interpret statement log duration information
Next
From: Scott Carey
Date:
Subject: Re: BBU Cache vs. spindles