On Mon, May 23, 2016 at 8:33 PM, Lucas Possamai <drum.lu...@gmail.com> wrote:
> > > On 24 May 2016 at 12:18, Jeff Janes <jeff.ja...@gmail.com> wrote: > >> On Mon, May 23, 2016 at 4:23 PM, Lucas Possamai <drum.lu...@gmail.com> >> wrote: >> > >> > That index has been added just 3 hours ago, and you can see that the >> > times_used goes over 41000.... How is that possible?? >> >> Well, that is what it is there for, right , to be used? My ancient >> laptop can use an index that many times in less than 20 seconds, >> running flat out. >> >> > Yeah! > But I mean... over 70.000 times in 4 hours? that's a lot of usage! ahhahaha > > >> > >> > Don't think the query is right. >> > >> > Can you please check ? >> >> The query seems right to me. >> >> Cheers, >> >> Jeff >> > > I think the query is ok.. just wanna understand if that value is correct :O > > If it is.. I'm happy with that. Just shows the work of finding and > creating the index worthed it. > > I don't have the answer off hand but what is it counting? If it counts, say, each lookup into the index during a nested loop evaluation the difference in perception could be easily explained. David J.