egat | E-g Automated Testing | Testing library

Your code is estimated to return 345,­789 rows out of 1,000,000.

Based on this estimate, Postgres will need to read records on all the data pages. I think Postgres always refers to the data pages, even when using a covering index, because it has to check for various types of locks and dirty data.

Because it needs to read all the pages, Postgres makes the reasonable assumption that it is faster to sequentially scan them rather than going through the index.

Indexes are useful for filtering when they reduce the number of data pages that need to be read. This query does not appear to be doing that.

EDIT:

There is no real solution to this problem. You could create a summary table which is maintained by triggers. That would add load to insert/update/delete, which might be undesirable.

Remove the p.stars from your GROUP BY clause

It is tripping things up because it is establishing another unnecessary subdivision of your groupings. It only appears inside an aggregate (SUM) function so it does not have to be present in the group by, and your sum case when p.stars is doing the correct job of counting where a player is star or not

If you want better visibility of why this caused a problem, put p.stars back in the group by and also as a column in the select - you'll see the grouping keys (columns that aren't an aggregate function) and it should become obvious why it caused the split rows to appear

If stars is an integer count of the number of stars a player has earned, you might want to make it a >= 10 check - this is more robust than an equals check, just in case it ever goes higher (unless 11+ stars means the player is no longer a star player..). Also if a column is an int is should be compared with a constant int rather than a constant string (10 rather than '10')

The reason of the error is the missing do catch block wrapping the decode line

I could kind of resolve this issue. I am not 100% happy but I can make this work by calling SonarQube.Scanner.MSBuild.exe and MSBuild.exe with the full absolute path:

Try it