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?.
22 rows affected
| colony | date_check | protection |
|---|---|---|
| 2 | 2019-10-26 | N |
| 2 | 2019-10-27 | N |
| 2 | 2019-11-01 | Y |
| 2 | 2019-11-03 | Y |
| 2 | 2019-11-05 | N |
| 7 | 2019-10-12 | Y |
| 7 | 2019-10-13 | Y |
| 7 | 2019-10-14 | Y |
| 7 | 2019-10-15 | Y |
| 7 | 2019-10-16 | Y |
| 7 | 2019-10-17 | Y |
| 7 | 2019-10-20 | N |
| 7 | 2019-10-21 | N |
| 7 | 2019-10-22 | N |
| 7 | 2019-10-23 | Y |
| 7 | 2019-10-24 | Y |
| 7 | 2019-10-25 | Y |
| 7 | 2019-10-26 | Y |
| 7 | 2019-10-27 | N |
| 7 | 2019-11-01 | Y |
| 7 | 2019-11-04 | Y |
| 7 | 2019-11-05 | N |
4 rows affected
| colony | date_in | date_out |
|---|---|---|
| 2 | 2019-11-01 | 2019-11-03 |
| 7 | 2019-10-12 | 2019-10-17 |
| 7 | 2019-10-23 | 2019-10-26 |
| 7 | 2019-11-01 | 2019-11-04 |