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?.
count |
---|
38559 |
rdbms_code | history_hour_at | distinct_ip |
---|---|---|
mariadb_10.2 | 2017-03-15 10:00:00+00 | 1 |
mariadb_10.2 | 2017-03-17 15:00:00+00 | 1 |
mariadb_10.2 | 2017-03-19 09:00:00+00 | 1 |
mariadb_10.2 | 2017-03-19 11:00:00+00 | 1 |
mariadb_10.2 | 2017-03-19 19:00:00+00 | 1 |
count |
---|
160495 |
rdbms_code | fiddle_hash | history_hour_at | distinct_ip |
---|---|---|---|
mariadb_10.2 | \x000054a9b11477f6a74e459e42f640d4 | 2017-06-16 22:00:00+01 | 1 |
mariadb_10.2 | \x0003a0224127474262142d6bb8f87092 | 2017-04-25 23:00:00+01 | 1 |
mariadb_10.2 | \x0003e572760edf05186d1b4b85f885bb | 2017-10-07 17:00:00+01 | 1 |
mariadb_10.2 | \x000571f754affebc06f392e3543b1a76 | 2018-03-29 06:00:00+01 | 1 |
mariadb_10.2 | \x00084988522c65f6c2472dab85835a21 | 2018-05-10 16:00:00+01 | 1 |