Re: Logging affected rows

On Sat, Jan 19, 2013 at 12:53 PM, Raghavendra <
raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:

> On Thu, Jan 17, 2013 at 9:18 AM, classical_89 <luongnx512(at)gmail(dot)com>wrote:
>
>> When i run a query , i just only want to the affected rows are logged to
>> log
>> file,What can i do ? .Is there a parameter in postgresql.conf to do that ?
>> .Thanks in advance
>>
>>
> AFAIK, I don't think we can log only affected rows of the query. But you
> can log the EXPLAIN ANALYZE output of the query which includes affected
> rows using AUTO_EXPLAIN contrib module.
>
> *Eg:-*
>
> postgres=# set auto_explain.log_analyze TO on;
> SET
> postgres=# load 'auto_explain';
> LOAD
> postgres=# select count(*) from cities ;
> count
> -------
> 2
> (1 row)
> *
> *
> *In logs:*
>
> 2012-12-06 03:27:57.104 IST [17410]: [78-1] db=postgres,user=postgres LOG:
> statement: select count(*) from cities ;
> 2012-12-06 03:27:57.105 IST [17410]: [79-1] db=postgres,user=postgres LOG:
> duration: 0.024 ms plan:
> Query Text: select count(*) from cities ;
> Aggregate (cost=1.02..1.03 rows=1 width=0) (actual
> time=0.015..0.015 rows=1 loops=1)
> Output: count(*)
> -> Seq Scan on public.cities (cost=0.00..1.02 rows=2 width=0)
> (actual time=0.009..0.010 *rows=2* loops=1)
> Output: city, location
>
>
Correction to my previous email, first you need to LOAD module and then
enable log_analyze. Copy/Paste mistake :)

--Raghav