Skip to content

Instantly share code, notes, and snippets.

#!/bin/bash
set -e
rm -rf {cumulative,histograms,stats,metric-names}.{tsv,png} histogram-*.png ||:
clickhouse-local --query "
-- leave only statistically significant changes of metrics of sufficient magnitude
create view metric_stats_filtered as
select *
from file('report/query-metric-stats.tsv', TSVWithNamesAndTypes,
#!/bin/bash
set -ex
set -o pipefail
trap "exit" INT TERM
trap "kill $(jobs -pr) ||:" EXIT
stage=${stage:-}
script_dir="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"
rm -rf data {affected-queries,shm-traces,trace-filtered,flamegraph-query-runs}.tsv {interesting-addrs-,stacks.}{left,right}.{tsv,rep} ||:
2019-11-07 15:00:01,089 ( 0.002s) INFO (root) Query 'SELECT count() FROM system.numbers WHERE NOT ignore(visitParamExtractRaw(materialize('{"myparam":"test_string"}'), 'myparam'))' - /usr/share/clickhouse-test/performance/visit_param_extract_raw.xml failed, got value 18310128, prev 21285669
2019-11-07 15:00:01,089 ( 0.000s) INFO (root) Query 'SELECT count() FROM system.numbers WHERE NOT ignore(visitParamExtractRaw(materialize('{"myparam":{"nested_1":"test_string","nested_2":"test_2"}}'), 'myparam'))' - /usr/share/clickhouse-test/performance/visit_param_extract_raw.xml ok, got value 7830467, prev 7946978
2019-11-07 15:00:01,090 ( 0.000s) INFO (root) Query 'SELECT count() FROM system.numbers WHERE NOT ignore(visitParamExtractRaw(materialize('{"myparam":{"nested_1":"test_string","nested_2":"test_2","nested_1":"test_string","nested_2":"test_2","nested_1":"test_string","nested_2":"test_2"}}'), 'myparam'))' - /usr/share/clickhouse-test/performance/visit_param_extract_raw.xml ok, got value 2601970,