Re: Slow join

AM, Laurenz Albe wrote: > > Roman Kushnir wrote: >> The following basic inner join is taking too much time for me. (I’m using >> count(videos.id) >> instead of count(*) because my actual query looks different, but I >> simplified it here to the essence). >> I’ve trie

Re: Slow join

actually used! So I created a covering index on videos (channel_id, id) and the query now completes in 190ms! Thanks, you helped me a lot. > On Jun 25, 2018, at 6:45 PM, Justin Pryzby wrote: > > Hi, > > Thanks for providing all this info :) > > On Mon, Jun 25, 2018 at 05

Slow join

Hello, The following basic inner join is taking too much time for me. (I’m using count(videos.id ) instead of count(*) because my actual query looks different, but I simplified it here to the essence). I’ve tried following random people's suggestions and adjusting the random_