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?.
14 rows affected
seriesbegin | cnt | min | max | delta |
---|---|---|---|---|
2021-11-16 11:45:00+00 | 3 | 2021-11-16 11:45:00+00 | 2021-11-16 11:48:00+00 | 00:03:00 |
2021-11-16 11:50:00+00 | 3 | 2021-11-16 11:50:00+00 | 2021-11-16 11:53:00+00 | 00:03:00 |
2021-11-16 12:35:00+00 | 1 | 2021-11-16 12:35:00+00 | 2021-11-16 12:36:00+00 | 00:01:00 |
2021-11-16 12:40:00+00 | 1 | 2021-11-16 12:40:00+00 | 2021-11-16 12:41:00+00 | 00:01:00 |
2021-11-16 12:44:00+00 | 1 | 2021-11-16 12:44:00+00 | 2021-11-16 12:45:00+00 | 00:01:00 |
2021-11-16 12:49:00+00 | 2 | 2021-11-16 12:49:00+00 | 2021-11-16 12:51:00+00 | 00:02:00 |
2021-11-16 12:59:00+00 | 2 | 2021-11-16 12:59:00+00 | 2021-11-16 13:01:00+00 | 00:02:00 |
2021-11-16 13:05:00+00 | 1 | 2021-11-16 13:05:00+00 | 2021-11-16 13:06:00+00 | 00:01:00 |