The Crystal programming language | http://crystal-lang.org | Fund Crystal's development: http://is.gd/X7PRtI | Docs: http://crystal-lang.org/docs/ | API: http://crystal-lang.org/api/
other_shard (*) required by shard.yml
and other_shard (1.0 at ../other_shard) required by shard.lock
SELECT
time_bucket('86400.0s',"time") AS "time",
qname AS "domain",
client_ip AS "IP",
sum(count) AS "count"
FROM bind_rpz_log
WHERE
"time" BETWEEN '2022-04-15T06:07:27.34Z' AND '2022-04-15T07:07:27.34Z' AND
rpz_zone ~* 'feeder.csm.rpzdb.com'
GROUP BY 1, qname, client_ip
ORDER BY 1, qname
DB::Database
instance
(x / y).round.to_i
is different than x // y
, right?
#round
, right?
RoundingMode::TO_ZERO
?