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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
