I assume you are using log_duration. Yes, that does produce quite a bit
of output. In fact, you need log_statement and log_pid at the same time
so you can figure out the query that had that duration, and that can
really fill the logs.
We could change log_duration to take a time in milliseconds rather than
just be a boolean, and print the duration _only_ if it was longer than
the specified number of milliseconds. Not sure what value we would use
to have it always print the duration, assuming 0 means off, or if we use
0 for always print, that values would we use for off, -1?
Another feature would be to print the query if log_statement was not
already true. How does that sound?
---------------------------------------------------------------------------
Peter Childs wrote:
> After listening to a long talk on the glories of MySql (Its no
> better than Postgres, Postgres can do things MySql can't do and MySql can
> do things Postgres can't do... So I'm not going to change camp) but it is
> a good idea to know what the other camp thinks.
> One nice feature that was meationed was the ability to log queries
> by how long they took, I'm already loggin all my queries but this produces
> alot of junk. Is it possible to just log all the queries that take longer
> than say 30secs so I can then work on those that really take ages to speed
> my program up.
>
> Thanks in advance.
>
> Peter Childs
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073