Hi, I have some interesting question about PostgreSQL logging configuration. I want log all 'mod' statements with their execution times and all statements longer than 10ms (also with their execution times). Now I have 3 setting to play with: log_min_duration_statement log_duration log_statement But it seems that I could not have configuration which doing what I looking for. Because: log_min_duration_statement=10ms log_duration = off log_statement = mod will log almost everything what I need but db did not log execution times for mod statements in that case. Alternatively if I try: log_min_duration_statement=10ms log_duration = on log_statement = mod db will log execution times of every query (not only mod and ones longer 10ms) thus producing lot noise and exceptionally large log files. I could not keep log_min_duration_statement=0 on database with 20000+ requests per second. Is there any good solution for that task? -- Maxim Boguk Senior Postgresql DBA http://www.postgresql-consulting.ru/ Phone RU: +7 910 405 4718 Phone AU: +61 45 218 5678 Skype: maxim.boguk Jabber: maxim.boguk@xxxxxxxxx МойКруг: http://mboguk.moikrug.ru/ "People problems are solved with people. If people cannot solve the problem, try technology. People will then wish they'd listened at the first stage." -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
