Query logging time, not values
От
Ludwik Dylag
Тема
Query logging time, not values
Дата
Msg-id
2fe468a20910080219r22a70474wbe11bdf8e15ad12f@mail.gmail.com
Список
Дерево обсуждения
Query logging time, not values Ludwik Dylag <ldylag@gmail.com>
position in DDL of columns used in indexes Michael Gould <mgould@intermodalsoftwaresolutions.net>
Re: position in DDL of columns used in indexes Matthew Wakeling <matthew@flymine.org>
Re: position in DDL of columns used in indexes Tom Lane <tgl@sss.pgh.pa.us>
Hi
--
Ludwik Dyląg
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 по дате отправления
От: keshav upadhyaya
Дата:
