Your question is Optimizing Slow Cost Reporting Queries. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are asked how to optimize a PostgreSQL query used in an Apptio cost reporting workflow when it becomes too slow as data grows. Explain how you would diagnose the bottleneck, what SQL anti-patterns you would check first, and how you would decide between rewriting the query, adding indexes, or changing the underlying data model.