Hi guys,
Looking at the log_duration postgresql.conf option. How about adding an
option log_duration_min which is a value in milliseconds that is the minimum
time a query must run for before being logged. Basically, what I'd be
interested in is "please log the SQL query and duration of all queries that
last longer than 500ms".
That way I can quickly find badly formed queries, index them, etc...
Idea?
Chris