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 9.5.24 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 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
parent_name | child_name | toy_name |
---|---|---|
Fred | Jimmy | Barbie |
Fred | Jimmy | Monopoly |
Fred | Jimmy | Cluedo |
Fred | Jimmy | Hurley |
Fred | Gerry | Monopoly |
Fred | Gerry | Tennis raquet |
Fred | Billy | Action Man |
Fred | Billy | Barbie |
Mary | Mick | Soccer ball |
Mary | James | Rugby ball |
Mary | Larry | Tennis raquet |
Joe | Jim | Monopoly |
Joe | Jack | Cluedo |
Joe | Helen | Hurley |
Joe | Helen | Soccer ball |
Joe | Helen | Rugby ball |
parent_name | child_name | cnt |
---|---|---|
Fred | Jimmy | 4 |
Joe | Helen | 3 |
Fred | Gerry | 2 |
Fred | Billy | 2 |
Joe | Jack | 1 |
Mary | Larry | 1 |
Mary | Mick | 1 |
Mary | James | 1 |
Joe | Jim | 1 |
parent_name | child_name | cnt |
---|---|---|
Fred | Jimmy | 4 |