Re: log_statement at postgres.conf - Mailing list pgsql-performance

From Pomarede Nicolas
Subject Re: log_statement at postgres.conf
Date
Msg-id Pine.LNX.4.64.0807211023260.11758@localhost
Whole thread Raw
In response to Re: log_statement at postgres.conf  ("System/IJS - Joko" <system@ijs.co.id>)
List pgsql-performance
On Mon, 21 Jul 2008, System/IJS - Joko wrote:

> Thx a lot Nicolas,
>
> I finaly success to log query statement because of your simple explanation.
> I have other question:
> 1. Is there posibility to automatically logging that statement to table?

I don't know, never tried that.

> 2. All of that statement is come from every database on my server,
> could I know from which database that statement come?
> or at least I can filter to log only from database X ?

You can modify 'log_line_prefix' to add the database name :
use '%d %t %p %r ' instead of the default '%t %p %r ' for example.

> 3. If I need to log only changed made on my database, then the value of
> 'log_statement' is 'mod' ?

yes


Nicolas


pgsql-performance by date:

Previous
From: "System/IJS - Joko"
Date:
Subject: Re: log_statement at postgres.conf
Next
From: Stephane Bailliez
Date:
Subject: Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)