By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
3 rows affected
3 rows affected
2 rows affected
7 rows affected
nice_user |
---|
(1,"game #10","Hi how are you doing?") |
(1,"game #20","Another game, hello") |
(1,"game #10","I am a nice user #1") |
(0,"game #20","I am a nice user #2") |
(1,"game #10","Are you there??") |
muted_user |
---|
(0,"game #20","Another game, hello") |
(0,"game #20","Another game, hello") |
(0,"game #10","Hi how are you doing?") |
(0,"game #20","I am a nice user #2") |
(0,"game #10","I am a nice user #1") |
(0,"game #20","I am a nice user #2") |
(1,"game #10","F*** ***!!") |
(1,"game #10","I am a bad user") |
(0,"game #10","Are you there??") |