diff options
| author | Олег <[email protected]> | 2025-07-24 13:25:14 +0300 |
|---|---|---|
| committer | GitHub <[email protected]> | 2025-07-24 13:25:14 +0300 |
| commit | cd748bfd8a66f2dfce746dd98d68b5ea96cf7142 (patch) | |
| tree | 90966b7d699dbfca2c1f47e5dd93a493bb05f5ac /.github/scripts/analytics | |
| parent | 9fdc09a944ce70f680fe1be4f35416e9b9d44d55 (diff) | |
Add SumImportTime to perfomance_olap_suites_mart.sql (#21615)
Diffstat (limited to '.github/scripts/analytics')
| -rw-r--r-- | .github/scripts/analytics/data_mart_queries/perfomance_olap_suites_mart.sql | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/.github/scripts/analytics/data_mart_queries/perfomance_olap_suites_mart.sql b/.github/scripts/analytics/data_mart_queries/perfomance_olap_suites_mart.sql index dd6607d1c21..f12060904e9 100644 --- a/.github/scripts/analytics/data_mart_queries/perfomance_olap_suites_mart.sql +++ b/.github/scripts/analytics/data_mart_queries/perfomance_olap_suites_mart.sql @@ -54,10 +54,9 @@ $suites = SELECT RunId, MAX_BY(JSON_VALUE(Info, "$.cluster.version"), Success) AS Version, MAX_BY(JSON_VALUE(Info, "$.report_url"), Success) AS Report, - SUM_IF(MeanDuration, Success > 0 AND Test not in {"_Verification", "Sum"}) / 1000. AS YdbSumMeans, - SUM_IF(MaxDuration, Success > 0 AND Test not in {"_Verification", "Sum"}) / 1000. AS YdbSumMax, - SUM_IF(MinDuration, Success > 0 AND Test not in {"_Verification", "Sum"}) / 1000. AS YdbSumMin, + SUM_IF(MeanDuration, Success > 0 AND Test not in {"_Verification", "Sum"} AND JSON_VALUE(Stats, '$.import_time') IS NULL) / 1000. AS YdbSumMeans, SUM_IF(COALESCE(CAST(JSON_VALUE(Stats, '$.time_with_compaction') AS Float)), Test not in {"_Verification", "Sum"}) AS SumImportWithCompactionTime, + SUM_IF(COALESCE(CAST(JSON_VALUE(Stats, '$.import_time') AS Float)), Test not in {"_Verification", "Sum"}) AS SumImportTime, SUM_IF(COALESCE(CAST(JSON_VALUE(Stats, '$.compacted_bytes') AS Float)), Test not in {"_Verification", "Sum"}) AS SumCompactedBytes, SUM_IF(COALESCE(CAST(JSON_VALUE(Stats, '$.written_bytes') AS Float)), Test not in {"_Verification", "Sum"}) AS SumWrittenBytes, SUM_IF(COALESCE(CAST(JSON_VALUE(Stats, '$.GrossTime') AS float)), Test = 'Sum') AS GrossTime, @@ -79,8 +78,6 @@ SELECT s.Version AS Version, s.Report AS Report, s.YdbSumMeans AS YdbSumMeans, - s.YdbSumMax AS YdbSumMax, - s.YdbSumMin AS YdbSumMin, s.SumImportWithCompactionTime AS SumImportWithCompactionTime, s.SumCompactedBytes AS SumCompactedBytes, s.SumWrittenBytes AS SumWrittenBytes, |