Re: Postgres using the wrong index index

2021-08-12 Thread Justin Pryzby
On Thu, Aug 12, 2021 at 09:38:45AM -0400, Matt Dupree wrote: > > The rowcount estimate for the time column is bad for all these plans - do > > you > > know why ? You're using inheritence - have you analyzed the parent tables > > recently ? > > Yes. I used ANALYZE before posting, as it's one of

Re: Postgres using the wrong index index

2021-08-12 Thread Matt Dupree
Justin, The rowcount estimate for the time column is bad for all these plans - do > you > know why ? You're using inheritence - have you analyzed the parent tables > recently ? > Yes. I used ANALYZE before posting, as it's one of the "things to try" listed in the slow queries wiki. I even ran th