UmbraPerf - Profiling Results Tailored for DBMS Developers

Download PDF

Abstract

Developing a code-generating Database Management System requires tight profiling and performance-tuning iterations. However, existing profilers report results at instruction or function level, making it challenging to correlate them with constructs like query plan operators to derive actionable insights. In this demonstration, we show how to solve this issue, building on our previous work, Tailored Profiling. We introduce UmbraPerf, a novel profiling tool that combines profiling samples with metadata to map profiling results to a DBMS’s internal abstractions, from query plan components down to generated code. Its interactive frontend visualizes data across multiple abstraction levels, enabling developers to narrow performance bottlenecks from operators down to individual instructions. We demonstrate its utility through two scenarios using our publicly available frontend.