| From: | Ludwik Dylag <ldylag(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Query logging time, not values |
| Date: | 2009-10-08 09:19:26 |
| Message-ID: | 2fe468a20910080219r22a70474wbe11bdf8e15ad12f@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
HiI 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Wakeling | 2009-10-08 13:40:53 | Re: Best suiting OS |
| Previous Message | keshav upadhyaya | 2009-10-08 07:29:46 | Re: Regarding mulitple rows insert in one shot using ADO .net connected to postgres |