Re: how do I get a log of SQL executed by server?

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Ken Guest <kguest(at)stockbyte(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: how do I get a log of SQL executed by server?
Date: 2003-02-06 19:02:56
Message-ID: 1044558176.22810.201.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2003-02-06 at 12:18, Ken Guest wrote:
> with mysql it's possible to get a log of all sql that the server executes.
> Is this possible with postgres and how do I turn this on?
>
> thanks ever so much
>
> Ken
>
>

You'll want to check out the DEBUG_PRINT_* settings in the
postgresql.conf file. See section 3.4 in the administrator's guide
-- http://www.gtsm.com/cgi/psearch?page=runtime-config.html

Robert Treat

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Fraser 2003-02-06 19:10:20 Re: 2D arrays in 7.3... actually, parser bug?
Previous Message Dennis Gearon 2003-02-06 18:59:53 Re: user column name