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?.
12 rows affected
| conv_id | user_id | content | sent_time |
|---|---|---|---|
| 1 | 1 | 1st_msg | 1990-01-01 00:01:01 |
| 1 | 2 | 2nd_msg | 1990-01-01 00:01:02 |
| 2 | 1 | 1st_msg | 1990-01-02 00:02:01 |
| 2 | 2 | 2nd_msg | 1990-01-02 00:02:02 |
| 3 | 2 | 2nd_msg | 1990-01-02 00:03:02 |
| 3 | 3 | 1st_msg | 1990-01-02 00:03:01 |