diff options
Diffstat (limited to 'db/click_house/main/20230719101806_create_ci_finished_builds_aggregated_queueing_delay_percentiles.sql')
-rw-r--r-- | db/click_house/main/20230719101806_create_ci_finished_builds_aggregated_queueing_delay_percentiles.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/db/click_house/main/20230719101806_create_ci_finished_builds_aggregated_queueing_delay_percentiles.sql b/db/click_house/main/20230719101806_create_ci_finished_builds_aggregated_queueing_delay_percentiles.sql new file mode 100644 index 00000000000..56889ffc0d4 --- /dev/null +++ b/db/click_house/main/20230719101806_create_ci_finished_builds_aggregated_queueing_delay_percentiles.sql @@ -0,0 +1,11 @@ +CREATE TABLE ci_finished_builds_aggregated_queueing_delay_percentiles +( + status LowCardinality(String) DEFAULT '', + runner_type UInt8 DEFAULT 0, + started_at_bucket DateTime64(6, 'UTC') DEFAULT now(), + + count_builds AggregateFunction(count), + queueing_duration_quantile AggregateFunction(quantile, Int64) +) +ENGINE = AggregatingMergeTree() +ORDER BY (started_at_bucket, status, runner_type) |