powa-team / powa-web

PoWA user interface
http://powa.readthedocs.io/
73 stars 31 forks source link

many index suggestions, only one tested with hypopg #147

Closed yhuelf closed 2 years ago

yhuelf commented 2 years ago

Screenshot from 2021-09-14 16-43-43

rjuju commented 2 years ago

I'm assuming that the other queries couldn't be denormalized, and as such couldn't be tested. It's hard to be certain without access to the data. Maybe there's some additional info in the javascript console?

yhuelf commented 2 years ago

It is probably the case, indeed: with a larger time window comes more index suggestions. Sorry for the noise!