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?.
SELECT 8
SELECT 1
quote_literal | activity_date | department_id | isopen |
---|---|---|---|
'Wednesday' | 2024-04-24 | 1 | true |
'Tuesday ' | 2024-04-23 | 1 | null |
'Monday ' | 2024-04-22 | 1 | null |
'Sunday ' | 2024-04-21 | 1 | null |
'Saturday ' | 2024-04-20 | 1 | null |
'Friday ' | 2024-04-19 | 1 | null |
'Thursday ' | 2024-04-18 | 1 | null |
'Wednesday' | 2024-04-17 | 1 | true |
SELECT 8
quote_literal | activity_date | department_id | isopen |
---|---|---|---|
'Wednesday' | 2024-04-24 | 1 | true |
'Tuesday' | 2024-04-23 | 1 | true |
'Monday' | 2024-04-22 | 1 | false |
'Sunday' | 2024-04-21 | 1 | false |
'Saturday' | 2024-04-20 | 1 | false |
'Friday' | 2024-04-19 | 1 | true |
'Thursday' | 2024-04-18 | 1 | true |
'Wednesday' | 2024-04-17 | 1 | true |
SELECT 8