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?.
16 rows affected
begin | end | id_type |
---|---|---|
2017-01-10 07:19:21 | 2017-01-10 07:19:25 | 3 |
2017-01-10 07:19:26 | 2017-01-10 07:19:26 | 5 |
2017-01-10 07:19:27.1 | 2017-01-10 07:19:27.1 | 3 |
2017-01-10 07:19:28 | 2017-01-10 07:19:29 | 5 |
2017-01-10 07:19:30.1 | 2017-01-10 07:19:30.1 | 3 |
2017-01-10 07:19:31 | 2017-01-10 07:19:31 | 5 |
2017-01-10 07:19:32 | 2017-01-10 07:19:32 | 3 |
2017-01-10 07:19:33.1 | 2017-01-10 07:19:37.1 | 5 |