On Tue, Mar 5, 2013 at 4:07 PM, Joshua D. Drake <j...@commandprompt.com>wrote:
> > On 03/05/2013 03:51 PM, Niels Kristian Schjødt wrote: > > 3ms isn't slow >>> >>> Sorry, it's 3323ms! >> >> Can I do anything to optimize that query or maybe the index or something? >>>> >>> >>> your index is already used >>> >> >> Okay this leaves me with - "get better hardware" or? >> > > What does explain analyze say versus just explain. > Better yet, "explain (analyze, buffers)" with track_io_timing turned on. Cheers, Jeff