Query Doctor
LightNews LightNews
banner
querydoctor.com
Query Doctor
@querydoctor.com
3 followers 2 following 6 posts
Posts Replies Media Videos
querydoctor.com
The conditions shown are also specific to the stage on the screen. A condition on games.genre is only shown when looking at the stage retrieving data from games and NOT for retrieving from the scores table. Bonus: conditions inherited from JOINs are there too!

app.querydoctor.com/ixr/share/Fb...
Diagram for an "Index Scan" on a games table showing the relevant conditions from the query: g.genre = 'Puzzle' AND g.release_date > '2018-12-31' Diagram for an "Index Scan" on a scores table showing the relevant conditions from the query: s.achieved_at < '2024-07-06'. Also shown is the JOIN condition of s.game_id = g.game_id along with its dynamically resolved value (8 in this iteration, 3 in another not shown) during processing as a nested loop join
February 7, 2025 at 5:48 PM
querydoctor.com
This is huge, congrats!
February 7, 2025 at 5:12 PM