Plan-structured deep neural network models for query performance prediction

Ryan Marcus, Olga Papaemmanouil
2019 Proceedings of the VLDB Endowment  
Query performance prediction, the task of predicting a query's latency prior to execution, is a challenging problem in database management systems. Existing approaches rely on features and performance models engineered by human experts, but often fail to capture the complex interactions between query operators and input relations, and generally do not adapt naturally to workload characteristics and patterns in query execution plans. In this paper, we argue that deep learning can be applied to
more » ... e query performance prediction problem, and we introduce a novel neural network architecture for the task: a plan-structured neural network. Our neural network architecture matches the structure of any optimizer-selected query execution plan and predict its latency with high accuracy, while eliminating the need for human-crafted input features. A number of optimizations are also proposed to reduce training overhead without sacrificing effectiveness. We evaluated our techniques on various workloads and we demonstrate that our approach can outperform the state-of-the-art in query performance prediction. PVLDB Reference Format: Ryan Marcus, Olga Papaemmanouil. Plan-Structured Deep Neural Network Models for Query Performance Prediction.
doi:10.14778/3342263.3342646 fatcat:uragqsbyonhata4mrteugnfk3y