Re: [PERFORM] Surprising no use of indexes - low performance

2013-02-16 Thread Nicolas Charles
Le 15/02/2013 19:04, Jeff Janes a écrit : On Fri, Feb 15, 2013 at 1:00 AM, Nicolas Charles wrote: On 14/02/2013 20:27, Jeff Janes wrote: I'm surprised that the executiontimestamp index is not used, since it seems to be where most of the query time is spent. I do not draw that conclusion from

Re: [PERFORM] Surprising no use of indexes - low performance

2013-02-15 Thread Merlin Moncure
On Thu, Feb 14, 2013 at 9:35 AM, Nicolas Charles wrote: > Hello, > > I've been struggling to understand what's happening on my databases/query > for several days, and I'm turning to higher mind for a logical answer. > > I'm dealing with a fairly large database, containing logs informations, that >

Re: [PERFORM] Surprising no use of indexes - low performance

2013-02-15 Thread Jeff Janes
On Fri, Feb 15, 2013 at 1:00 AM, Nicolas Charles wrote: > On 14/02/2013 20:27, Jeff Janes wrote: >> >> On Thu, Feb 14, 2013 at 7:35 AM, Nicolas Charles >> wrote: >>> >>> It contains 11018592 entries, with the followinf patterns : >>> 108492 distinct executiontimestamp >>> 14 distinct nodeid >>>

Re: [PERFORM] Surprising no use of indexes - low performance

2013-02-15 Thread Nicolas Charles
On 14/02/2013 20:27, Jeff Janes wrote: On Thu, Feb 14, 2013 at 7:35 AM, Nicolas Charles wrote: It contains 11018592 entries, with the followinf patterns : 108492 distinct executiontimestamp 14 distinct nodeid 59 distinct directiveid 26 distinct ruleid 35 distinct serial How many entries fall

Re: [PERFORM] Surprising no use of indexes - low performance

2013-02-14 Thread Jeff Janes
On Thu, Feb 14, 2013 at 7:35 AM, Nicolas Charles wrote: > > It contains 11018592 entries, with the followinf patterns : > 108492 distinct executiontimestamp > 14 distinct nodeid > 59 distinct directiveid > 26 distinct ruleid > 35 distinct serial How many entries fall within a typical query interv

Re: [PERFORM] Surprising no use of indexes - low performance

2013-02-14 Thread Ireneusz Pluta
W dniu 2013-02-14 16:35, Nicolas Charles pisze: I'm crunching the data by looking for each nodeid/ruleid/directiveid/serial with an executiontimestamp in an interval: explain analyze select executiondate, nodeid, ruleid, directiveid, serial, component, keyValue, executionTimeStamp, eventtype,

[PERFORM] Surprising no use of indexes - low performance

2013-02-14 Thread Nicolas Charles
Hello, I've been struggling to understand what's happening on my databases/query for several days, and I'm turning to higher mind for a logical answer. I'm dealing with a fairly large database, containing logs informations, that I crunch to get data out of it, with several indexes on them th