UW Interactive Data Lab
IDL logo

Perfopticon: Visual Query Analysis for Distributed Databases

Dominik Moritz, Daniel Halperin, Bill Howe, Jeffrey Heer. Computer Graphics Forum (Proc. EuroVis), 2015
Figure for Perfopticon: Visual Query Analysis for Distributed Databases
Perfopticon visualizing a query that estimates species abundance in an oceanography dataset. The left panel displays the optimized query execution plan. The right panel includes (top) a divided bar chart showing the runtime contribution of individual query operators, and (bottom) a focus+context view of detailed per-worker execution traces.
Materials
Abstract
Distributed database performance is often unpredictable due to issues such as system complexity, network congestion, or imbalanced data distribution. These issues are difficult for users to assess in part due to the opaque mapping between declaratively-specified queries and actual physical execution plans. Database developers currently must expend significant time and effort scanning log files to isolate and debug the root causes of performance issues. In response, we present Perfopticon, an interactive query profiling tool that enables rapid insight into common problems such as performance bottlenecks and data skew. Perfopticon combines interactive visualizations of (1) query plans, (2) overall query execution, (3) data flow among servers, and (4) execution traces. These views coordinate multiple levels of abstraction to enable detection, isolation, and understanding of performance issues. We evaluate our design choices through engagements with system developers, scientists, and students. We demonstrate that Perfopticon enables performance debugging for real-world tasks.
BibTeX
@article{2015-perfopticon,
  title = {Perfopticon: Visual Query Analysis for Distributed Databases},
  author = {Moritz, Dominik AND Halperin, Daniel AND Howe, Bill AND Heer, Jeffrey},
  journal = {Computer Graphics Forum (Proc. EuroVis)},
  year = {2015},
  volume = {34},
  number = {3},
  url = {https://idl.uw.edu/papers/perfopticon},
  doi = {10.1111/cgf.12619}
}