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?.
| row |
|---|
| (11,"2018-12-06 22:00:00",2,0,41,0) |
| (11,"2018-12-06 22:30:00",2,0,43,0) |
| (11,"2018-12-06 23:00:00",2,0,94,0) |
| (11,"2018-12-06 23:30:00",2,0,83,0) |
| (11,"2018-12-07 00:00:00",2,0,21,0) |
| (11,"2018-12-07 00:30:00",2,0,33,0) |
| (11,"2018-12-07 01:00:00",2,0,20,0) |
| (11,"2018-12-07 01:30:00",2,0,70,0) |
| (11,"2018-12-07 02:00:00",2,0,18,0) |
| (11,"2018-12-07 02:30:00",2,0,46,0) |
| (11,"2018-12-07 03:00:00",2,0,58,0) |
| (11,"2018-12-07 03:30:00",2,0,38,0) |
| (11,"2018-12-07 04:00:00",2,0,46,0) |
| (11,"2018-12-07 04:30:00",2,0,90,0) |
| (11,"2018-12-07 05:00:00",2,0,51,0) |
| (11,"2018-12-07 05:30:00",2,0,36,0) |
| (11,"2018-12-07 06:00:00",2,0,82,0) |
| (11,"2018-12-07 06:30:00",2,0,85,0) |
| (11,"2018-12-07 07:00:00",2,0,30,0) |
| (11,"2018-12-07 07:30:00",2,0,75,0) |
| (11,"2018-12-07 08:00:00",2,0,95,0) |
| (11,"2018-12-07 08:30:00",2,0,66,0) |
| (11,"2018-12-07 09:00:00",2,0,86,0) |
| (11,"2018-12-07 09:30:00",2,0,80,0) |
| (11,"2018-12-07 10:00:00",2,0,58,0) |
| (11,"2018-12-07 10:30:00",2,0,57,0) |
| (11,"2018-12-07 11:00:00",2,0,85,0) |
| (11,"2018-12-07 11:30:00",2,0,80,0) |
| (11,"2018-12-07 12:00:00",2,0,46,0) |
| (11,"2018-12-07 12:30:00",2,0,39,0) |
| (11,"2018-12-07 13:00:00",2,0,2,0) |
| (11,"2018-12-07 13:30:00",2,0,87,0) |
| (11,"2018-12-07 14:00:00",2,0,82,0) |
| (11,"2018-12-07 14:30:00",2,0,97,0) |
| (11,"2018-12-07 15:00:00",2,0,70,0) |
| (11,"2018-12-07 15:30:00",2,0,3,0) |
| (11,"2018-12-07 16:00:00",2,0,29,0) |
| (11,"2018-12-07 16:30:00",2,0,90,0) |
| (11,"2018-12-07 17:00:00",2,0,74,0) |
| (11,"2018-12-07 17:30:00",2,0,48,0) |
| (11,"2018-12-07 18:00:00",2,0,36,0) |
| (11,"2018-12-07 18:30:00",2,0,31,0) |
| (11,"2018-12-07 19:00:00",2,0,87,0) |
| (11,"2018-12-07 19:30:00",2,0,83,0) |
| (11,"2018-12-07 20:00:00",2,0,21,0) |
| (11,"2018-12-07 20:30:00",2,0,37,0) |
| (11,"2018-12-07 21:00:00",2,0,18,0) |
| (11,"2018-12-07 21:30:00",2,0,2,0) |
| (11,"2018-12-07 22:00:00",2,0,21,0) |
| (11,"2018-12-07 22:30:00",2,0,49,0) |
| (11,"2018-12-07 23:00:00",2,0,77,0) |
| (11,"2018-12-07 23:30:00",2,0,16,0) |
| (11,"2018-12-08 00:00:00",2,0,14,0) |
| (11,"2018-12-08 00:30:00",2,0,62,0) |
| (11,"2018-12-08 01:00:00",2,0,97,0) |
| (11,"2018-12-08 01:30:00",2,0,73,0) |
| (11,"2018-12-08 02:00:00",2,0,18,0) |
| (11,"2018-12-08 02:30:00",2,0,82,0) |
| (11,"2018-12-08 03:00:00",2,0,52,0) |
| (11,"2018-12-08 03:30:00",2,0,65,0) |
| (11,"2018-12-08 04:00:00",2,0,21,0) |
| (11,"2018-12-08 04:30:00",2,0,55,0) |
| (11,"2018-12-08 05:00:00",2,0,52,0) |
| (11,"2018-12-08 05:30:00",2,0,3,0) |
| (11,"2018-12-08 06:00:00",2,0,52,0) |
| (11,"2018-12-08 06:30:00",2,0,22,0) |
| (11,"2018-12-08 07:00:00",2,0,6,0) |
| (11,"2018-12-08 07:30:00",2,0,81,0) |
| (11,"2018-12-08 08:00:00",2,0,11,0) |
| (11,"2018-12-08 08:30:00",2,0,81,0) |
| (11,"2018-12-08 09:00:00",2,0,29,0) |
| (11,"2018-12-08 09:30:00",2,0,48,0) |
| (11,"2018-12-08 10:00:00",2,0,12,0) |
| (11,"2018-12-08 10:30:00",2,0,15,0) |
| (11,"2018-12-08 11:00:00",2,0,30,0) |
| (11,"2018-12-08 11:30:00",2,0,33,0) |
| (11,"2018-12-08 12:00:00",2,0,52,0) |
| (11,"2018-12-08 12:30:00",2,0,49,0) |
| (11,"2018-12-08 13:00:00",2,0,35,0) |
| (11,"2018-12-08 13:30:00",2,0,74,0) |
| (11,"2018-12-08 14:00:00",2,0,98,0) |
| (11,"2018-12-08 14:30:00",2,0,12,0) |
| (11,"2018-12-08 15:00:00",2,0,91,0) |
| (11,"2018-12-08 15:30:00",2,0,12,0) |
| (11,"2018-12-08 16:00:00",2,0,74,0) |
| (11,"2018-12-08 16:30:00",2,0,87,0) |
| (11,"2018-12-08 17:00:00",2,0,85,0) |
| (11,"2018-12-08 17:30:00",2,0,93,0) |
| (11,"2018-12-08 18:00:00",2,0,68,0) |
| (11,"2018-12-08 18:30:00",2,0,37,0) |
| (11,"2018-12-08 19:00:00",2,0,58,0) |
| (11,"2018-12-08 19:30:00",2,0,89,0) |
| (11,"2018-12-08 20:00:00",2,0,93,0) |
| (11,"2018-12-08 20:30:00",2,0,10,0) |
| (11,"2018-12-08 21:00:00",2,0,93,0) |
| (11,"2018-12-08 21:30:00",2,0,44,0) |
| (11,"2018-12-08 22:00:00",2,0,32,0) |
| (11,"2018-12-08 22:30:00",2,0,100,0) |
| (11,"2018-12-08 23:00:00",2,0,25,0) |
| (11,"2018-12-08 23:30:00",2,0,44,0) |
| (11,"2018-12-09 00:00:00",2,0,80,0) |
| (11,"2018-12-09 00:30:00",2,0,54,0) |
| (11,"2018-12-09 01:00:00",2,0,92,0) |
| (11,"2018-12-09 01:30:00",2,0,92,0) |
| (11,"2018-12-09 02:00:00",2,0,69,0) |
| (11,"2018-12-09 02:30:00",2,0,21,0) |
| (11,"2018-12-09 03:00:00",2,0,25,0) |
| (11,"2018-12-09 03:30:00",2,0,21,0) |
| (11,"2018-12-09 04:00:00",2,0,71,0) |
| (11,"2018-12-09 04:30:00",2,0,61,0) |
| (11,"2018-12-09 05:00:00",2,0,96,0) |
| (11,"2018-12-09 05:30:00",2,0,68,0) |
| (11,"2018-12-09 06:00:00",2,0,73,0) |
| (11,"2018-12-09 06:30:00",2,0,86,0) |
| (11,"2018-12-09 07:00:00",2,0,80,0) |
| (11,"2018-12-09 07:30:00",2,0,47,0) |
| (11,"2018-12-09 08:00:00",2,0,72,0) |
| (11,"2018-12-09 08:30:00",2,0,65,0) |
| (11,"2018-12-09 09:00:00",2,0,40,0) |
| (11,"2018-12-09 09:30:00",2,0,40,0) |
| (11,"2018-12-09 10:00:00",2,0,2,0) |
| (11,"2018-12-09 10:30:00",2,0,98,0) |
| (11,"2018-12-09 11:00:00",2,0,29,0) |
| (11,"2018-12-09 11:30:00",2,0,95,0) |
| (11,"2018-12-09 12:00:00",2,0,8,0) |
| (11,"2018-12-09 12:30:00",2,0,21,0) |
| (11,"2018-12-09 13:00:00",2,0,38,0) |
| (11,"2018-12-09 13:30:00",2,0,40,0) |
| (11,"2018-12-09 14:00:00",2,0,20,0) |
| (11,"2018-12-09 14:30:00",2,0,64,0) |
| (11,"2018-12-09 15:00:00",2,0,85,0) |
| (11,"2018-12-09 15:30:00",2,0,0,0) |
| (11,"2018-12-09 16:00:00",2,0,17,0) |
| (11,"2018-12-09 16:30:00",2,0,76,0) |
| (11,"2018-12-09 17:00:00",2,0,93,0) |
| (11,"2018-12-09 17:30:00",2,0,87,0) |
| (11,"2018-12-09 18:00:00",2,0,98,0) |
| (11,"2018-12-09 18:30:00",2,0,17,0) |
| (11,"2018-12-09 19:00:00",2,0,7,0) |
| (11,"2018-12-09 19:30:00",2,0,68,0) |
| (11,"2018-12-09 20:00:00",2,0,78,0) |
| (11,"2018-12-09 20:30:00",2,0,3,0) |
| (11,"2018-12-09 21:00:00",2,0,35,0) |
| (11,"2018-12-09 21:30:00",2,0,50,0) |
| (11,"2018-12-09 22:00:00",2,0,89,0) |
| (11,"2018-12-09 22:30:00",2,0,15,0) |
| (11,"2018-12-09 23:00:00",2,0,98,0) |
| (11,"2018-12-09 23:30:00",2,0,60,0) |
| (11,"2018-12-10 00:00:00",2,0,81,0) |