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?.
4 rows affected
id | level_title | quiz_desc | overall_quest |
---|---|---|---|
1 | Sets | The purpose of... | Suppose we have... |
2 | Seqs | sequences desc... | overall question... |
3 | Prop Logic | logic desc ... | overall quest... |
4 | Pred Logic | pred desc 1 ... | predicase quest... |
10 rows affected
id | level_title | quiz_desc | overall_quest | student_no | level_id | points | ts |
---|---|---|---|---|---|---|---|
1 | Sets | The purpose of... | Suppose we have... | 40204123 | 1 | 80 | 2021-01-12 15:37:11 |
2 | Seqs | sequences desc... | overall question... | 40204123 | 2 | 75 | 2021-01-12 15:38:06 |
3 | Prop Logic | logic desc ... | overall quest... | 40204123 | 3 | 30 | 2021-01-13 22:13:13 |