Query logging time, not values

Поиск

Список

Период

Сортировка

От	Ludwik Dylag
Тема	Query logging time, not values
Дата	8 октября 2009 г. 06:19:41
Msg-id	2fe468a20910080219r22a70474wbe11bdf8e15ad12f@mail.gmail.com обсуждение
Ответы	position in DDL of columns used in indexes
Список	pgsql-performance

I have a database and ~150 clients non-stop writing to this database quite big pieces of text.

I have a performacne problem so I tried to increase log level, so I could see which queries take most time.

My postgresql.conf (Log section) is:

log_destination = 'stderr'

logging_collector = on

log_rotation_size = 1GB

log_connections = on

log_line_prefix = '%m %p %u %d %r '

log_lock_waits = on

log_statement = 'ddl'

log_temp_files = 4096

And I got the query times + query parameters values, which makes my log extremly big.

How can I set the logging parameters to write query + duration time but without parameter values?

Thanks

Ludwik

--
Ludwik Dyląg

В списке pgsql-performance по дате отправления: