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?.
5 rows affected
8 rows affected
| postcodefootprint |
|---|
| 2529,2530,2533,2534,2535,2536,2537,2538,2539,2540,2541,2575,2576,2577,2580 |
| 2640 |
| 3844 |
| 2063, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2080, 2081, 2082, 2083, 2119, 2120, 2126, 2158, 2159 |
| 2848, 2849, 2850, 2852 |
| poa_code |
|---|
| 2090 |
| 2092 |
| 2093 |
| 829 |
| 830 |
| 836 |
| 2080 |
| 2081 |
| poa_code | postcodefootprint |
|---|---|
| 2080 | 2063, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2080, 2081, 2082, 2083, 2119, 2120, 2126, 2158, 2159 |
| 2081 | 2063, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2079, 2080, 2081, 2082, 2083, 2119, 2120, 2126, 2158, 2159 |