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.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit |
14 rows affected
id | user_id | title | data | d1 | d2 | d3 |
---|---|---|---|---|---|---|
1 | 1 | DATE | 01-01-2021 | 2021-01-01 | 2021-01-01 | 2021-01-01 |
3 | 2 | DATE | null | null | null | null |
5 | 3 | DATE | 03-03-2023 | 2023-03-03 | 2023-03-03 | 2023-03-03 |
5 | 4 | DATE | 04-04-2024 | 2024-04-04 | 2024-04-04 | 2024-04-04 |
7 | 5 | DATE | 05-05-2025 | 2025-05-05 | 2025-05-05 | 2025-05-05 |
7 | 6 | DATE | 06-06-2026 | 2026-06-06 | 2026-06-06 | 2026-06-06 |
3 | 7 | DATE | 07-07-2027 | 2027-07-07 | 2027-07-07 | 2027-07-07 |