Im adding this to the knowledgebase. From what version up exactly is query time being lgged?
ernst > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Namens Michiel Meeuwissen > Verzonden: maandag 6 september 2004 18:51 > Aan: [EMAIL PROTECTED] > Onderwerp: Re: CPU usuage Postgresql > > > Nico Klasens <[EMAIL PROTECTED]> wrote: > > <category name="org.mmbase.module.database.MultiConnection" > > class="&logger;"> > > <priority class="&priority;" value="info" /> > > </category> > > > > Or > > > > <category name="org.mmbase.module.database" class="&logger;"> > > <priority class="&priority;" value="info" /> > > </category> > > > > Leaving the priority on 'info' makes no sense though, because > the default is already 'service'. Set those to 'debug', to > actually get more logging. > > I'm not sure if in 1.5 the duration of queries was logged > already, but it can be tried. If not, you may try to > configure query-logging in postgresql itself (possible, but I > don't know the details by heart, nor if it logs durations). > > > Michiel > > PS 'category' and 'priority' tags were deprecated by log4j. > Nowadays we use 'logger' and 'level' tags, but perhaps not > yet in the log4j of MMBase 1.5. > > -- > Michiel Meeuwissen mihxil' > Mediacentrum 140 H'sum [] () > +31 (0)35 6772979 nl_NL eo_XX en_US > > > > > >
