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
id_type | grp_begin | grp_end |
---|---|---|
3 | 2017-01-10 07:19:21 | 2017-01-10 07:19:25 |
5 | 2017-01-10 07:19:26 | 2017-01-10 07:19:26 |
3 | 2017-01-10 07:19:27.1 | 2017-01-10 07:19:27.1 |
5 | 2017-01-10 07:19:28 | 2017-01-10 07:19:29 |
3 | 2017-01-10 07:19:30.1 | 2017-01-10 07:19:30.1 |
5 | 2017-01-10 07:19:31 | 2017-01-10 07:19:31 |
3 | 2017-01-10 07:19:32 | 2017-01-10 07:19:32 |
5 | 2017-01-10 07:19:33.1 | 2017-01-10 07:19:37.1 |