Postgres Pro
Downloads
Home   >   mailing lists

Query logging time, not values - Mailing list pgsql-performance

From Ludwik Dylag
Subject Query logging time, not values
Date
Msg-id 2fe468a20910080219r22a70474wbe11bdf8e15ad12f@mail.gmail.com
Whole thread Raw
Responses position in DDL of columns used in indexes
List pgsql-performance
Tree view
Hi
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 by date:

Previous
From: keshav upadhyaya
Date:
Subject: Regarding mulitple rows insert in one shot using ADO .net connected to postgres
Next
From: Matthew Wakeling
Date:
Subject: Re: Best suiting OS