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 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit |
SELECT 1
CREATE TABLE
INSERT 0 5
| product_name | created_at | modified_at | amount | units | requires_cold_storage | promoted |
|---|---|---|---|---|---|---|
| Bottled Mineral Water 1,5l | 2025-01-02 06:53:11+00 | 2025-01-02 06:53:11+00 | 1.5 | l | null | f |
| Frozen Vegetable Mix | 2025-01-02 06:55:40+00 | 2025-01-02 06:55:40+00 | 450 | g | t | t |
| Toothbrush | 2025-01-02 07:12:55+00 | 2025-01-02 07:12:55+00 | 1 | pcs | f | f |
| Bottled Mineral Water 1,5l | 2025-01-02 06:53:11+00 | 2025-01-03 15:01:32+00 | 1.5 | l | f | t |
| Frozen Vegetable Mix | 2025-01-02 06:55:40+00 | 2025-01-04 00:00:00+00 | 450 | g | t | f |
SELECT 5
| product_name | created_at | modified_at | amount | units | requires_cold_storage | promoted |
|---|---|---|---|---|---|---|
| Bottled Mineral Water 1,5l | 2025-01-02 06:53:11+00 | 2025-01-02 06:53:11+00 | 1.5 | l | null | f |
| Frozen Vegetable Mix | 2025-01-02 06:55:40+00 | 2025-01-02 06:55:40+00 | 450 | g | t | t |
| Bottled Mineral Water 1,5l | 2025-01-02 06:53:11+00 | 2025-01-03 15:01:32+00 | 1.5 | l | f | t |
| Frozen Vegetable Mix | 2025-01-02 06:55:40+00 | 2025-01-04 00:00:00+00 | 450 | g | t | f |
SELECT 4