log_min_duration_statement

From: Eric Brown <eric(dot)brown(at)propel(dot)com>
To: Postgres help (E-mail) <pgsql-general(at)postgresql(dot)org>
Subject: log_min_duration_statement
Date: 2005-01-26 10:39:21
Message-ID: 8A0A4A18-6F86-11D9-B051-000A95C7176C@propel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I set this to 250 and the statements that take longer than this are
logged... but my driver is creating all kinds of cursors, so it isn't
logging anything useful. Yet, if I log all statement
(log_statment='mod'), I get way more logging than is useful. Is there a
happy medium?

This is what I'm getting now(for example):
Jan 26 02:26:15 abacagw postgres[28359]: [22-1] LOG: duration: 284.786
ms statement: FETCH 1 FROM "PgSQL_A8A3BE0C"
Jan 26 02:26:15 abacagw postgres[27992]: [19-1] LOG: duration: 254.549
ms statement: FETCH 1 FROM "PgSQL_A8A2884C"
Jan 26 02:26:15 abacagw postgres[28432]: [11-1] LOG: duration: 376.167
ms statement: FETCH 1 FROM "PgSQL_A8A49CAC"
Jan 26 02:26:16 abacagw postgres[28359]: [23-1] LOG: duration: 373.027
ms statement: FETCH 1 FROM "PgSQL_A8A166AC"
Jan 26 02:26:16 abacagw postgres[28539]: [10-1] LOG: duration: 278.023
ms statement: FETCH 1 FROM "PgSQL_A8A387EC"
Jan 26 02:26:16 abacagw postgres[28361]: [24-1] LOG: duration: 499.291
ms statement: FETCH 1 FROM "PgSQL_A8A68F0C"
Jan 26 02:26:17 abacagw postgres[28359]: [24-1] LOG: duration: 636.480
ms statement: FETCH 1 FROM "PgSQL_A8A166AC"
Jan 26 02:26:17 abacagw postgres[28399]: [9-1] LOG: duration: 369.708
ms statement: FETCH 1 FROM "PgSQL_A89CB0AC"
Jan 26 02:26:17 abacagw postgres[28432]: [12-1] LOG: duration: 304.065
ms statement: FETCH 1 FROM "PgSQL_A89E1CAC"
Jan 26 02:26:17 abacagw postgres[28361]: [25-1] LOG: duration: 252.809
ms statement: FETCH 1 FROM "PgSQL_A8A3694C"

Eric Brown
408-571-6341
www.propel.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michal Hlavac 2005-01-26 10:41:19 Re: Lower case
Previous Message Martijn van Oosterhout 2005-01-26 10:34:58 Re: Extended unit