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?.
CREATE TABLE
CREATE INDEX
INSERT 0 10
| id | created_at | truncated_created_at | target | truncated_target | cond |
|---|---|---|---|---|---|
| e34d5557-43d7-4f81-802b-791c213ea5cb | 2024-03-14T07:23:56.474123UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | t |
| ea7e9cad-89f2-4610-898f-62a04e8b5331 | 2024-03-14T07:23:56.474123UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | t |
| 0cf727a8-5efc-454b-ba1b-ea301e2b1a82 | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | f |
| 10f1dd9b-2cd8-40bb-a199-2d9c922d07b1 | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | f |
| 3c00c38e-45b9-4c3c-9d05-fc1ca2177dbe | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | f |
| ac31e591-d4ea-4ef5-956a-c07bd043d9ea | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | f |
| b9b33ca5-2cd1-490b-a6be-d28784f75b2a | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | f |
| bc9763d0-6d24-4fbf-bc23-7eff1589280a | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | t |
| c442f6ea-61bf-42d4-aa85-4eab1d95f569 | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | t |
| ded826f7-65f0-4d23-9366-049823ba49ec | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | t |
SELECT 10
| id | to_char | target |
|---|---|---|
| e34d5557-43d7-4f81-802b-791c213ea5cb | 2024-03-14T07:23:56.474123UTC | 2024-03-14T07:23:56.474000UTC |
| ea7e9cad-89f2-4610-898f-62a04e8b5331 | 2024-03-14T07:23:56.474123UTC | 2024-03-14T07:23:56.474000UTC |
| 0cf727a8-5efc-454b-ba1b-ea301e2b1a82 | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC |
| 10f1dd9b-2cd8-40bb-a199-2d9c922d07b1 | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC |
| 3c00c38e-45b9-4c3c-9d05-fc1ca2177dbe | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC |
| ac31e591-d4ea-4ef5-956a-c07bd043d9ea | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC |
| b9b33ca5-2cd1-490b-a6be-d28784f75b2a | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC |
| bc9763d0-6d24-4fbf-bc23-7eff1589280a | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC |
| c442f6ea-61bf-42d4-aa85-4eab1d95f569 | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC |
| ded826f7-65f0-4d23-9366-049823ba49ec | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC |
SELECT 10
| id | created_at | truncated_created_at | target | truncated_target |
|---|---|---|---|---|
| ded826f7-65f0-4d23-9366-049823ba49ec | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| c442f6ea-61bf-42d4-aa85-4eab1d95f569 | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| bc9763d0-6d24-4fbf-bc23-7eff1589280a | 2024-03-14T07:23:56.474222UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| ea7e9cad-89f2-4610-898f-62a04e8b5331 | 2024-03-14T07:23:56.474123UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| e34d5557-43d7-4f81-802b-791c213ea5cb | 2024-03-14T07:23:56.474123UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
SELECT 5
BEGIN
ALTER TABLE
| id | to_char | target |
|---|---|---|
| bc9763d0-6d24-4fbf-bc23-7eff1589280a | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| c442f6ea-61bf-42d4-aa85-4eab1d95f569 | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| ded826f7-65f0-4d23-9366-049823ba49ec | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| e34d5557-43d7-4f81-802b-791c213ea5cb | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| ea7e9cad-89f2-4610-898f-62a04e8b5331 | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
SELECT 5
ROLLBACK
BEGIN
ALTER TABLE
ALTER TABLE
| id | to_char | target |
|---|---|---|
| bc9763d0-6d24-4fbf-bc23-7eff1589280a | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| c442f6ea-61bf-42d4-aa85-4eab1d95f569 | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| ded826f7-65f0-4d23-9366-049823ba49ec | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| e34d5557-43d7-4f81-802b-791c213ea5cb | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
| ea7e9cad-89f2-4610-898f-62a04e8b5331 | 2024-03-14T07:23:56.474000UTC | 2024-03-14T07:23:56.474000UTC |
SELECT 5
ROLLBACK