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 12.0 (Debian 12.0-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit |
4 rows affected
party_id | party_name |
---|---|
1 | Bill |
2 | Fred |
3 | Mary |
4 | Jim |
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
t_id | party_id | party_name | action | party_name | a | item | t_amount |
---|---|---|---|---|---|---|---|
1 | 1 | Bill | sold to | Fred | a | Car | 45 |
2 | 2 | Fred | sold to | Mary | a | Car | 50 |
3 | 2 | Fred | sold to | Jim | a | Ship | 450 |
4 | 4 | Jim | sold to | Bill | a | Ship | 500 |
5 | 3 | Mary | sold to | Fred | a | Book | 5 |
6 | 2 | Fred | sold to | Jim | a | Book | 7 |
7 | 3 | Mary | sold to | Bill | a | TV | 60 |
8 | 1 | Bill | sold to | Fred | a | TV | 70 |