Re: Logging Parameter Values

[Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>]

Volkan YAZICI wrote:

> I don't want to interrupt your work, but as far as I see from logs --
> with the configurations I sent previously -- PostgreSQL doesn't log
> parameter values for queries dropped into query duration limit. (Using
> PostgreSQL 8.3.1.) Consider this test case:
> 
>   test# PREPARE foo (int) AS
>   ] SELECT S.i * T.i
>   ]   FROM generate_series(1, $1) AS S(i),
>   ]        generate_series(1, $1) AS T(i);
> 
>   test# EXECUTE foo (1000);
>   ...
> 
>   # tail -n 2 /srv/pg/pg_log/2008-06-19_141725.log
>   migration_test postgres 2008-06-19 17:58:05.185 EEST LOG:  duration: 2315.420 ms  statement: EXECUTE foo(1000);

The parameter is on the above line, isn't it?

>   migration_test postgres 2008-06-19 17:58:05.185 EEST DETAIL:  prepare: PREPARE foo (int) AS SELECT S.i * T.i FROM generate_series(1, $1) AS S(i), generate_series(1, $1) AS T(i);


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.