search

project-koku / masu

This is a READ ONLY repo. See https://github.com/project-koku/koku for current masu implementation
GNU Affero General Public License v3.0
5 stars 6 forks source link

930 ocp infra performance improvement #482

Closed adberglund closed 5 years ago

adberglund commented 5 years ago

Summary

This should improve performance on the OCP on AWS check SQL. There's two things here. 1) Add the date match to the JOIN conditions to reduce the number of matches made. 2) Move the AWS tag breakout query to its own temp table so it can live on disk and smaller chunks can be worked with in memory.

codecov[bot] commented 5 years ago

Codecov Report

:exclamation: No coverage uploaded for pull request base (master@391520e). Click here to learn what that means. The diff coverage is n/a.

Impacted file tree graph

@@           Coverage Diff            @@
##             master    #482   +/-   ##
========================================
  Coverage          ?   97.6%           
========================================
  Files             ?      67           
  Lines             ?    3800           
  Branches          ?     405           
========================================
  Hits              ?    3708           
  Misses            ?      51           
  Partials          ?      41

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update 391520e...2a0abb4. Read the comment docs.