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?.
version |
---|
PostgreSQL 10.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20190507 (Red Hat 8.3.1-4), 64-bit |
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
user_id | name | position | cost | sum |
---|---|---|---|---|
2 | Charles | 1 | 214.11 | 454.13 |
2 | Charles | 2 | 240.02 | 454.13 |
3 | Eva | 1 | 214.11 | 360.96 |
3 | Eva | 2 | 146.85 | 360.96 |
5 | Helene | 1 | 168.18 | 308.2 |
5 | Helene | 2 | 140.02 | 308.2 |
4 | John | 1 | 181.03 | 343.16 |
4 | John | 2 | 162.13 | 343.16 |
1 | Peter | 1 | 100.34 | 520.38 |
1 | Peter | 2 | 180.02 | 520.38 |
1 | Peter | 3 | 240.02 | 520.38 |