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?.
| now | statement_timestamp | clock_timestamp |
|---|---|---|
| 2025-01-18 12:49:54.647139+00 | 2025-01-18 12:49:54.647139+00 | 2025-01-18 12:49:54.648992+00 |
SELECT 1
| pg_sleep |
|---|
SELECT 1
| now | statement_timestamp | clock_timestamp |
|---|---|---|
| 2025-01-18 12:49:54.752428+00 | 2025-01-18 12:49:54.752428+00 | 2025-01-18 12:49:54.752531+00 |
SELECT 1
BEGIN
| now | statement_timestamp | clock_timestamp |
|---|---|---|
| 2025-01-18 12:49:54.752597+00 | 2025-01-18 12:49:54.752597+00 | 2025-01-18 12:49:54.752653+00 |
SELECT 1
| pg_sleep |
|---|
SELECT 1
| now | statement_timestamp | clock_timestamp |
|---|---|---|
| 2025-01-18 12:49:54.752597+00 | 2025-01-18 12:49:54.752597+00 | 2025-01-18 12:49:54.853925+00 |
SELECT 1
COMMIT
DROP TABLE
CREATE TABLE
DO
| now | statement_timestamp | clock_timestamp | id |
|---|---|---|---|
| 2025-01-18 12:49:54.854183+00 | 2025-01-18 12:49:54.854183+00 | 2025-01-18 12:49:54.867843+00 | 1 |
| 2025-01-18 12:49:54.854183+00 | 2025-01-18 12:49:54.854183+00 | 2025-01-18 12:49:54.968707+00 | 2 |
| 2025-01-18 12:49:54.854183+00 | 2025-01-18 12:49:54.854183+00 | 2025-01-18 12:49:55.070274+00 | 3 |
SELECT 3
DROP TABLE
CREATE TABLE
DO
| now | statement_timestamp | clock_timestamp | id |
|---|---|---|---|
| 2025-01-18 12:49:55.075149+00 | 2025-01-18 12:49:55.075149+00 | 2025-01-18 12:49:55.075404+00 | 1 |
| 2025-01-18 12:49:55.176869+00 | 2025-01-18 12:49:55.075149+00 | 2025-01-18 12:49:55.177075+00 | 2 |
| 2025-01-18 12:49:55.277518+00 | 2025-01-18 12:49:55.075149+00 | 2025-01-18 12:49:55.27782+00 | 3 |
SELECT 3