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?.
7 rows affected
| id | amount | is_stop | created_at |
|---|---|---|---|
| 1 | 10 | f | 2021-08-30 13:41:27.656459+01 |
| 23 | 15 | f | 2021-08-30 13:41:27.656459+01 |
| 31 | 9 | f | 2021-08-30 13:41:27.656459+01 |
| 54 | 10 | t | 2021-08-30 13:41:27.656459+01 |
| 565 | 4123 | f | 2021-08-30 13:41:27.656459+01 |
| 6565 | 323 | f | 2021-08-30 13:41:27.656459+01 |
| 54545 | 3434 | f | 2021-08-30 13:41:27.656459+01 |
| sum |
|---|
| 44 |