---

SELECT
    toStartOfMinute(event_time) AS minute,
    count() AS inserts,
    sum(written_rows) AS rows,
    formatReadableSize(sum(written_bytes)) AS bytes,
    round(avg(written_bytes)) AS avg_insert_bytes,
    formatReadableSize(quantile(0.50)(written_bytes)) AS p50,
    formatReadableSize(quantile(0.95)(written_bytes)) AS p95,
    formatReadableSize(quantile(0.99)(written_bytes)) AS p99
FROM system.query_log
WHERE
    type = 'QueryFinish'
    AND query_kind = 'Insert'
    AND event_time >= now() - INTERVAL 1 HOUR
GROUP BY minute
ORDER BY minute DESC;