add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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