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?.
SELECT 898
| hour | transactons |
|---|---|
| 2020-12-01 00:00:00 | 2 |
| 2020-12-01 01:00:00 | 3 |
| 2020-12-01 02:00:00 | 2 |
| 2020-12-01 03:00:00 | 1 |
| 2020-12-01 04:00:00 | 1 |
| 2020-12-01 05:00:00 | 1 |
| 2020-12-01 06:00:00 | 3 |
| 2020-12-01 07:00:00 | 1 |
| 2020-12-01 08:00:00 | 2 |
| 2020-12-01 10:00:00 | 2 |
| 2020-12-01 11:00:00 | 1 |
| 2020-12-01 12:00:00 | 2 |
| 2020-12-01 13:00:00 | 1 |
| 2020-12-01 14:00:00 | 2 |
| 2020-12-01 15:00:00 | 2 |
| 2020-12-01 17:00:00 | 1 |
| 2020-12-01 19:00:00 | 1 |
| 2020-12-01 20:00:00 | 2 |
| 2020-12-01 21:00:00 | 2 |
| 2020-12-02 00:00:00 | 1 |
| 2020-12-02 01:00:00 | 2 |
| 2020-12-02 03:00:00 | 1 |
| 2020-12-02 04:00:00 | 1 |
| 2020-12-02 05:00:00 | 3 |
| 2020-12-02 06:00:00 | 1 |
| 2020-12-02 08:00:00 | 1 |
| 2020-12-02 10:00:00 | 2 |
| 2020-12-02 11:00:00 | 1 |
| 2020-12-02 12:00:00 | 3 |
| 2020-12-02 13:00:00 | 1 |
| 2020-12-02 14:00:00 | 1 |
| 2020-12-02 16:00:00 | 2 |
| 2020-12-02 18:00:00 | 1 |
| 2020-12-02 20:00:00 | 2 |
| 2020-12-02 21:00:00 | 3 |
| 2020-12-02 23:00:00 | 1 |
| 2020-12-03 00:00:00 | 1 |
| 2020-12-03 01:00:00 | 1 |
| 2020-12-03 03:00:00 | 1 |
| 2020-12-03 04:00:00 | 1 |
| 2020-12-03 07:00:00 | 1 |
| 2020-12-03 08:00:00 | 1 |
| 2020-12-03 10:00:00 | 2 |
| 2020-12-03 11:00:00 | 1 |
| 2020-12-03 12:00:00 | 1 |
| 2020-12-03 13:00:00 | 1 |
| 2020-12-03 15:00:00 | 4 |
| 2020-12-03 16:00:00 | 3 |
| 2020-12-03 18:00:00 | 2 |
| 2020-12-03 20:00:00 | 1 |
| 2020-12-03 21:00:00 | 2 |
| 2020-12-03 22:00:00 | 3 |
| 2020-12-03 23:00:00 | 2 |
| 2020-12-04 00:00:00 | 1 |
| 2020-12-04 01:00:00 | 2 |
| 2020-12-04 02:00:00 | 1 |
| 2020-12-04 04:00:00 | 1 |
| 2020-12-04 05:00:00 | 1 |
| 2020-12-04 06:00:00 | 1 |
| 2020-12-04 07:00:00 | 3 |
| 2020-12-04 09:00:00 | 2 |
| 2020-12-04 10:00:00 | 2 |
| 2020-12-04 12:00:00 | 3 |
| 2020-12-04 13:00:00 | 1 |
| 2020-12-04 14:00:00 | 2 |
| 2020-12-04 15:00:00 | 2 |
| 2020-12-04 16:00:00 | 2 |
| 2020-12-04 17:00:00 | 3 |
| 2020-12-04 18:00:00 | 1 |
| 2020-12-04 20:00:00 | 2 |
| 2020-12-04 21:00:00 | 3 |
| 2020-12-04 23:00:00 | 2 |
| 2020-12-05 00:00:00 | 2 |
| 2020-12-05 02:00:00 | 2 |
| 2020-12-05 03:00:00 | 2 |
| 2020-12-05 04:00:00 | 3 |
| 2020-12-05 05:00:00 | 1 |
| 2020-12-05 06:00:00 | 1 |
| 2020-12-05 07:00:00 | 2 |
| 2020-12-05 08:00:00 | 2 |
| 2020-12-05 09:00:00 | 2 |
| 2020-12-05 10:00:00 | 1 |
| 2020-12-05 11:00:00 | 1 |
| 2020-12-05 12:00:00 | 3 |
| 2020-12-05 13:00:00 | 1 |
| 2020-12-05 14:00:00 | 2 |
| 2020-12-05 16:00:00 | 2 |
| 2020-12-05 17:00:00 | 2 |
| 2020-12-05 18:00:00 | 4 |
| 2020-12-05 19:00:00 | 3 |
| 2020-12-05 21:00:00 | 2 |
| 2020-12-05 23:00:00 | 2 |
| 2020-12-06 00:00:00 | 1 |
| 2020-12-06 03:00:00 | 1 |
| 2020-12-06 05:00:00 | 2 |
| 2020-12-06 07:00:00 | 1 |
| 2020-12-06 08:00:00 | 4 |
| 2020-12-06 09:00:00 | 1 |
| 2020-12-06 10:00:00 | 1 |
| 2020-12-06 14:00:00 | 3 |
| 2020-12-06 15:00:00 | 3 |
| 2020-12-06 16:00:00 | 1 |
| 2020-12-06 17:00:00 | 1 |
| 2020-12-06 20:00:00 | 1 |
| 2020-12-06 21:00:00 | 1 |
| 2020-12-06 22:00:00 | 2 |
| 2020-12-07 00:00:00 | 3 |
| 2020-12-07 01:00:00 | 2 |
| 2020-12-07 02:00:00 | 1 |
| 2020-12-07 03:00:00 | 2 |
| 2020-12-07 05:00:00 | 1 |
| 2020-12-07 06:00:00 | 1 |
| 2020-12-07 07:00:00 | 2 |
| 2020-12-07 08:00:00 | 1 |
| 2020-12-07 09:00:00 | 4 |
| 2020-12-07 12:00:00 | 2 |
| 2020-12-07 13:00:00 | 2 |
| 2020-12-07 14:00:00 | 2 |
| 2020-12-07 15:00:00 | 2 |
| 2020-12-07 17:00:00 | 1 |
| 2020-12-07 18:00:00 | 2 |
| 2020-12-07 19:00:00 | 1 |
| 2020-12-07 20:00:00 | 2 |
| 2020-12-07 22:00:00 | 1 |
| 2020-12-08 00:00:00 | 2 |
| 2020-12-08 02:00:00 | 1 |
| 2020-12-08 03:00:00 | 2 |
| 2020-12-08 06:00:00 | 1 |
| 2020-12-08 07:00:00 | 1 |
| 2020-12-08 09:00:00 | 2 |
| 2020-12-08 10:00:00 | 1 |
| 2020-12-08 12:00:00 | 1 |
| 2020-12-08 14:00:00 | 2 |
| 2020-12-08 16:00:00 | 2 |
| 2020-12-08 17:00:00 | 1 |
| 2020-12-08 19:00:00 | 1 |
| 2020-12-08 20:00:00 | 1 |
| 2020-12-08 21:00:00 | 3 |
| 2020-12-08 22:00:00 | 1 |
| 2020-12-08 23:00:00 | 2 |
| 2020-12-09 01:00:00 | 3 |
| 2020-12-09 02:00:00 | 1 |
| 2020-12-09 03:00:00 | 1 |
| 2020-12-09 04:00:00 | 1 |
| 2020-12-09 05:00:00 | 2 |
| 2020-12-09 06:00:00 | 1 |
| 2020-12-09 08:00:00 | 1 |
| 2020-12-09 09:00:00 | 4 |
| 2020-12-09 10:00:00 | 2 |
| 2020-12-09 12:00:00 | 1 |
| 2020-12-09 13:00:00 | 2 |
| 2020-12-09 14:00:00 | 2 |
| 2020-12-09 15:00:00 | 2 |
| 2020-12-09 16:00:00 | 1 |
| 2020-12-09 17:00:00 | 2 |
| 2020-12-09 18:00:00 | 2 |
| 2020-12-09 19:00:00 | 3 |
| 2020-12-09 20:00:00 | 1 |
| 2020-12-09 21:00:00 | 2 |
| 2020-12-09 22:00:00 | 2 |
| 2020-12-09 23:00:00 | 2 |
| 2020-12-10 01:00:00 | 4 |
| 2020-12-10 02:00:00 | 1 |
| 2020-12-10 03:00:00 | 2 |
| 2020-12-10 04:00:00 | 3 |
| 2020-12-10 06:00:00 | 1 |
| 2020-12-10 08:00:00 | 1 |
| 2020-12-10 09:00:00 | 1 |
| 2020-12-10 10:00:00 | 1 |
| 2020-12-10 11:00:00 | 2 |
| 2020-12-10 13:00:00 | 3 |
| 2020-12-10 14:00:00 | 3 |
| 2020-12-10 15:00:00 | 1 |
| 2020-12-10 16:00:00 | 1 |
| 2020-12-10 18:00:00 | 2 |
| 2020-12-10 20:00:00 | 1 |
| 2020-12-10 21:00:00 | 1 |
| 2020-12-10 22:00:00 | 1 |
| 2020-12-10 23:00:00 | 1 |
| 2020-12-11 01:00:00 | 2 |
| 2020-12-11 02:00:00 | 2 |
| 2020-12-11 03:00:00 | 1 |
| 2020-12-11 04:00:00 | 1 |
| 2020-12-11 06:00:00 | 1 |
| 2020-12-11 07:00:00 | 1 |
| 2020-12-11 08:00:00 | 1 |
| 2020-12-11 09:00:00 | 1 |
| 2020-12-11 10:00:00 | 1 |
| 2020-12-11 12:00:00 | 1 |
| 2020-12-11 13:00:00 | 3 |
| 2020-12-11 17:00:00 | 2 |
| 2020-12-11 19:00:00 | 2 |
| 2020-12-11 22:00:00 | 2 |
| 2020-12-11 23:00:00 | 1 |
| 2020-12-12 00:00:00 | 1 |
| 2020-12-12 01:00:00 | 2 |
| 2020-12-12 02:00:00 | 2 |
| 2020-12-12 03:00:00 | 2 |
| 2020-12-12 04:00:00 | 1 |
| 2020-12-12 05:00:00 | 2 |
| 2020-12-12 06:00:00 | 2 |
| 2020-12-12 07:00:00 | 2 |
| 2020-12-12 08:00:00 | 3 |
| 2020-12-12 09:00:00 | 1 |
| 2020-12-12 11:00:00 | 2 |
| 2020-12-12 12:00:00 | 1 |
| 2020-12-12 13:00:00 | 1 |
| 2020-12-12 15:00:00 | 1 |
| 2020-12-12 16:00:00 | 3 |
| 2020-12-12 17:00:00 | 2 |
| 2020-12-12 18:00:00 | 3 |
| 2020-12-12 19:00:00 | 2 |
| 2020-12-12 20:00:00 | 1 |
| 2020-12-12 21:00:00 | 2 |
| 2020-12-12 22:00:00 | 2 |
| 2020-12-12 23:00:00 | 2 |
| 2020-12-13 01:00:00 | 2 |
| 2020-12-13 02:00:00 | 1 |
| 2020-12-13 04:00:00 | 1 |
| 2020-12-13 05:00:00 | 2 |
| 2020-12-13 06:00:00 | 3 |
| 2020-12-13 07:00:00 | 1 |
| 2020-12-13 08:00:00 | 1 |
| 2020-12-13 09:00:00 | 2 |
| 2020-12-13 10:00:00 | 3 |
| 2020-12-13 11:00:00 | 3 |
| 2020-12-13 12:00:00 | 3 |
| 2020-12-13 14:00:00 | 1 |
| 2020-12-13 15:00:00 | 1 |
| 2020-12-13 16:00:00 | 1 |
| 2020-12-13 17:00:00 | 2 |
| 2020-12-13 18:00:00 | 1 |
| 2020-12-13 19:00:00 | 3 |
| 2020-12-13 21:00:00 | 1 |
| 2020-12-13 22:00:00 | 1 |
| 2020-12-13 23:00:00 | 1 |
| 2020-12-14 01:00:00 | 2 |
| 2020-12-14 03:00:00 | 1 |
| 2020-12-14 04:00:00 | 2 |
| 2020-12-14 05:00:00 | 1 |
| 2020-12-14 06:00:00 | 3 |
| 2020-12-14 07:00:00 | 1 |
| 2020-12-14 09:00:00 | 1 |
| 2020-12-14 10:00:00 | 1 |
| 2020-12-14 11:00:00 | 3 |
| 2020-12-14 13:00:00 | 2 |
| 2020-12-14 14:00:00 | 1 |
| 2020-12-14 15:00:00 | 3 |
| 2020-12-14 16:00:00 | 2 |
| 2020-12-14 17:00:00 | 1 |
| 2020-12-14 19:00:00 | 2 |
| 2020-12-14 21:00:00 | 1 |
| 2020-12-14 22:00:00 | 1 |
| 2020-12-14 23:00:00 | 1 |
| 2020-12-15 02:00:00 | 4 |
| 2020-12-15 03:00:00 | 4 |
| 2020-12-15 04:00:00 | 2 |
| 2020-12-15 05:00:00 | 1 |
| 2020-12-15 06:00:00 | 1 |
| 2020-12-15 08:00:00 | 4 |
| 2020-12-15 09:00:00 | 1 |
| 2020-12-15 11:00:00 | 4 |
| 2020-12-15 12:00:00 | 1 |
| 2020-12-15 13:00:00 | 1 |
| 2020-12-15 14:00:00 | 2 |
| 2020-12-15 16:00:00 | 1 |
| 2020-12-15 17:00:00 | 1 |
| 2020-12-15 18:00:00 | 1 |
| 2020-12-15 19:00:00 | 1 |
| 2020-12-15 21:00:00 | 2 |
| 2020-12-15 22:00:00 | 5 |
| 2020-12-15 23:00:00 | 1 |
| 2020-12-16 01:00:00 | 1 |
| 2020-12-16 03:00:00 | 2 |
| 2020-12-16 04:00:00 | 1 |
| 2020-12-16 05:00:00 | 2 |
| 2020-12-16 10:00:00 | 1 |
| 2020-12-16 12:00:00 | 1 |
| 2020-12-16 14:00:00 | 1 |
| 2020-12-16 17:00:00 | 1 |
| 2020-12-16 19:00:00 | 1 |
| 2020-12-16 20:00:00 | 2 |
| 2020-12-16 22:00:00 | 1 |
| 2020-12-17 01:00:00 | 4 |
| 2020-12-17 02:00:00 | 2 |
| 2020-12-17 03:00:00 | 1 |
| 2020-12-17 04:00:00 | 2 |
| 2020-12-17 05:00:00 | 1 |
| 2020-12-17 07:00:00 | 2 |
| 2020-12-17 08:00:00 | 1 |
| 2020-12-17 09:00:00 | 2 |
| 2020-12-17 11:00:00 | 1 |
| 2020-12-17 12:00:00 | 1 |
| 2020-12-17 13:00:00 | 2 |
| 2020-12-17 14:00:00 | 1 |
| 2020-12-17 15:00:00 | 2 |
| 2020-12-17 16:00:00 | 4 |
| 2020-12-17 17:00:00 | 1 |
| 2020-12-17 18:00:00 | 1 |
| 2020-12-17 19:00:00 | 3 |
| 2020-12-17 20:00:00 | 1 |
| 2020-12-17 21:00:00 | 3 |
| 2020-12-17 22:00:00 | 1 |
| 2020-12-17 23:00:00 | 1 |
| 2020-12-18 00:00:00 | 3 |
| 2020-12-18 01:00:00 | 1 |
| 2020-12-18 02:00:00 | 1 |
| 2020-12-18 03:00:00 | 3 |
| 2020-12-18 04:00:00 | 2 |
| 2020-12-18 05:00:00 | 3 |
| 2020-12-18 06:00:00 | 2 |
| 2020-12-18 07:00:00 | 2 |
| 2020-12-18 10:00:00 | 1 |
| 2020-12-18 12:00:00 | 1 |
| 2020-12-18 13:00:00 | 3 |
| 2020-12-18 14:00:00 | 1 |
| 2020-12-18 15:00:00 | 2 |
| 2020-12-18 17:00:00 | 2 |
| 2020-12-18 18:00:00 | 1 |
| 2020-12-18 19:00:00 | 3 |
| 2020-12-18 20:00:00 | 2 |
| 2020-12-18 21:00:00 | 3 |
| 2020-12-18 22:00:00 | 2 |
| 2020-12-18 23:00:00 | 2 |
| 2020-12-19 00:00:00 | 1 |
| 2020-12-19 01:00:00 | 2 |
| 2020-12-19 02:00:00 | 4 |
| 2020-12-19 05:00:00 | 1 |
| 2020-12-19 07:00:00 | 2 |
| 2020-12-19 08:00:00 | 3 |
| 2020-12-19 09:00:00 | 1 |
| 2020-12-19 10:00:00 | 1 |
| 2020-12-19 12:00:00 | 1 |
| 2020-12-19 13:00:00 | 1 |
| 2020-12-19 14:00:00 | 3 |
| 2020-12-19 15:00:00 | 3 |
| 2020-12-19 16:00:00 | 2 |
| 2020-12-19 17:00:00 | 2 |
| 2020-12-19 18:00:00 | 2 |
| 2020-12-19 21:00:00 | 1 |
| 2020-12-19 22:00:00 | 1 |
| 2020-12-20 00:00:00 | 3 |
| 2020-12-20 02:00:00 | 1 |
| 2020-12-20 03:00:00 | 2 |
| 2020-12-20 04:00:00 | 2 |
| 2020-12-20 05:00:00 | 1 |
| 2020-12-20 06:00:00 | 1 |
| 2020-12-20 07:00:00 | 4 |
| 2020-12-20 09:00:00 | 1 |
| 2020-12-20 10:00:00 | 1 |
| 2020-12-20 11:00:00 | 2 |
| 2020-12-20 12:00:00 | 1 |
| 2020-12-20 13:00:00 | 1 |
| 2020-12-20 14:00:00 | 3 |
| 2020-12-20 15:00:00 | 1 |
| 2020-12-20 17:00:00 | 1 |
| 2020-12-20 18:00:00 | 2 |
| 2020-12-20 19:00:00 | 1 |
| 2020-12-20 20:00:00 | 3 |
| 2020-12-20 21:00:00 | 3 |
| 2020-12-20 22:00:00 | 1 |
| 2020-12-20 23:00:00 | 3 |
| 2020-12-21 00:00:00 | 2 |
| 2020-12-21 01:00:00 | 2 |
| 2020-12-21 02:00:00 | 1 |
| 2020-12-21 03:00:00 | 3 |
| 2020-12-21 04:00:00 | 4 |
| 2020-12-21 05:00:00 | 1 |
| 2020-12-21 06:00:00 | 1 |
| 2020-12-21 07:00:00 | 1 |
| 2020-12-21 08:00:00 | 2 |
| 2020-12-21 09:00:00 | 1 |
| 2020-12-21 10:00:00 | 2 |
| 2020-12-21 11:00:00 | 2 |
| 2020-12-21 12:00:00 | 2 |
| 2020-12-21 13:00:00 | 3 |
| 2020-12-21 15:00:00 | 3 |
| 2020-12-21 17:00:00 | 2 |
| 2020-12-21 18:00:00 | 1 |
| 2020-12-21 19:00:00 | 3 |
| 2020-12-21 20:00:00 | 1 |
| 2020-12-21 21:00:00 | 3 |
| 2020-12-21 22:00:00 | 2 |
| 2020-12-22 02:00:00 | 2 |
| 2020-12-22 03:00:00 | 2 |
| 2020-12-22 05:00:00 | 1 |
| 2020-12-22 06:00:00 | 1 |
| 2020-12-22 07:00:00 | 1 |
| 2020-12-22 08:00:00 | 3 |
| 2020-12-22 09:00:00 | 2 |
| 2020-12-22 10:00:00 | 2 |
| 2020-12-22 11:00:00 | 1 |
| 2020-12-22 12:00:00 | 2 |
| 2020-12-22 13:00:00 | 1 |
| 2020-12-22 14:00:00 | 2 |
| 2020-12-22 15:00:00 | 1 |
| 2020-12-22 16:00:00 | 1 |
| 2020-12-22 17:00:00 | 1 |
| 2020-12-22 19:00:00 | 1 |
| 2020-12-22 20:00:00 | 1 |
| 2020-12-22 21:00:00 | 1 |
| 2020-12-22 22:00:00 | 1 |
| 2020-12-22 23:00:00 | 1 |
| 2020-12-23 00:00:00 | 1 |
| 2020-12-23 01:00:00 | 2 |
| 2020-12-23 02:00:00 | 1 |
| 2020-12-23 04:00:00 | 1 |
| 2020-12-23 05:00:00 | 2 |
| 2020-12-23 06:00:00 | 2 |
| 2020-12-23 09:00:00 | 2 |
| 2020-12-23 11:00:00 | 2 |
| 2020-12-23 14:00:00 | 4 |
| 2020-12-23 15:00:00 | 1 |
| 2020-12-23 17:00:00 | 1 |
| 2020-12-23 18:00:00 | 3 |
| 2020-12-23 19:00:00 | 1 |
| 2020-12-23 20:00:00 | 1 |
| 2020-12-23 21:00:00 | 3 |
| 2020-12-23 22:00:00 | 2 |
| 2020-12-23 23:00:00 | 1 |
| 2020-12-24 00:00:00 | 1 |
| 2020-12-24 01:00:00 | 2 |
| 2020-12-24 03:00:00 | 2 |
| 2020-12-24 04:00:00 | 2 |
| 2020-12-24 05:00:00 | 1 |
| 2020-12-24 06:00:00 | 2 |
| 2020-12-24 07:00:00 | 2 |
| 2020-12-24 08:00:00 | 2 |
| 2020-12-24 09:00:00 | 2 |
| 2020-12-24 10:00:00 | 3 |
| 2020-12-24 11:00:00 | 1 |
| 2020-12-24 12:00:00 | 2 |
| 2020-12-24 15:00:00 | 2 |
| 2020-12-24 16:00:00 | 2 |
| 2020-12-24 17:00:00 | 2 |
| 2020-12-24 18:00:00 | 2 |
| 2020-12-24 20:00:00 | 2 |
| 2020-12-24 21:00:00 | 1 |
| 2020-12-24 22:00:00 | 2 |
| 2020-12-24 23:00:00 | 1 |
| 2020-12-25 00:00:00 | 1 |
| 2020-12-25 01:00:00 | 2 |
| 2020-12-25 03:00:00 | 3 |
| 2020-12-25 04:00:00 | 2 |
| 2020-12-25 06:00:00 | 1 |
| 2020-12-25 07:00:00 | 1 |
| 2020-12-25 08:00:00 | 1 |
| 2020-12-25 09:00:00 | 2 |
| 2020-12-25 11:00:00 | 1 |
| 2020-12-25 12:00:00 | 1 |
| 2020-12-25 13:00:00 | 2 |
| 2020-12-25 15:00:00 | 2 |
| 2020-12-25 16:00:00 | 1 |
| 2020-12-25 17:00:00 | 2 |
| 2020-12-25 18:00:00 | 1 |
| 2020-12-25 19:00:00 | 1 |
| 2020-12-25 20:00:00 | 1 |
| 2020-12-25 22:00:00 | 1 |
| 2020-12-25 23:00:00 | 3 |
| 2020-12-26 00:00:00 | 3 |
| 2020-12-26 01:00:00 | 2 |
| 2020-12-26 02:00:00 | 1 |
| 2020-12-26 03:00:00 | 2 |
| 2020-12-26 05:00:00 | 1 |
| 2020-12-26 06:00:00 | 2 |
| 2020-12-26 08:00:00 | 3 |
| 2020-12-26 09:00:00 | 1 |
| 2020-12-26 10:00:00 | 2 |
| 2020-12-26 11:00:00 | 1 |
| 2020-12-26 12:00:00 | 2 |
| 2020-12-26 13:00:00 | 2 |
| 2020-12-26 14:00:00 | 2 |
| 2020-12-26 15:00:00 | 2 |
| 2020-12-26 16:00:00 | 3 |
| 2020-12-26 17:00:00 | 1 |
| 2020-12-26 19:00:00 | 3 |
| 2020-12-26 20:00:00 | 2 |
| 2020-12-26 21:00:00 | 3 |
| 2020-12-26 22:00:00 | 2 |
| 2020-12-26 23:00:00 | 1 |
| 2020-12-27 00:00:00 | 1 |
| 2020-12-27 03:00:00 | 2 |
| 2020-12-27 04:00:00 | 1 |
| 2020-12-27 05:00:00 | 2 |
| 2020-12-27 06:00:00 | 1 |
| 2020-12-27 07:00:00 | 4 |
| 2020-12-27 10:00:00 | 1 |
| 2020-12-27 11:00:00 | 3 |
| 2020-12-27 12:00:00 | 2 |
| 2020-12-27 13:00:00 | 2 |
| 2020-12-27 14:00:00 | 2 |
| 2020-12-27 15:00:00 | 1 |
| 2020-12-27 16:00:00 | 1 |
| 2020-12-27 17:00:00 | 1 |
| 2020-12-27 18:00:00 | 2 |
| 2020-12-27 19:00:00 | 2 |
| 2020-12-27 20:00:00 | 1 |
| 2020-12-27 21:00:00 | 1 |
| 2020-12-27 22:00:00 | 1 |
| 2020-12-27 23:00:00 | 1 |
| 2020-12-28 00:00:00 | 1 |
| 2020-12-28 02:00:00 | 3 |
| 2020-12-28 03:00:00 | 2 |
| 2020-12-28 04:00:00 | 2 |
| 2020-12-28 05:00:00 | 1 |
| 2020-12-28 06:00:00 | 4 |
| 2020-12-28 07:00:00 | 3 |
| 2020-12-28 10:00:00 | 1 |
| 2020-12-28 11:00:00 | 1 |
| 2020-12-28 14:00:00 | 2 |
| 2020-12-28 15:00:00 | 3 |
| 2020-12-28 17:00:00 | 1 |
| 2020-12-28 18:00:00 | 1 |
| 2020-12-28 20:00:00 | 1 |
| 2020-12-28 21:00:00 | 1 |
| 2020-12-28 23:00:00 | 2 |
SELECT 516
| weekday_weekend | avg_transactions |
|---|---|
| 0 | 1.71 |
| 1 | 1.80 |
SELECT 2
| weekday_weekend | avg_transactions |
|---|---|
| 0 | 1.29 |
| 1 | 1.45 |
SELECT 2