DBG-PT: A Large Language Model Assisted Query Performance Regression Debugger

Summary: DBG-PT uses LLMs to detect query-performance regressions, compare current and historical EXPLAIN plans, and recommend tuning knobs. Its distinctive text-only design integrates with any EXPLAIN-supporting DBMS with near-zero implementation effort. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 13839
Venue: VLDB
Year: 2024
Pagerank: 5.2839552e-05
Overall Rank: 9,351 | 35.85%
DOI: 10.14778/3685800.3685869

Incoming Non-self Citations Over Time

Authors

1. Victor Giannakouris (Cornell University)
2. Immanuel Trummer (Cornell University)

BibTeX Citation

@article{giannakouris_vldb24,
        title = {{DBG-PT: A Large Language Model Assisted Query Performance Regression Debugger}},
        author = {Giannakouris, Victor and Trummer, Immanuel},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {12},
        pages = {4337--4340},
        doi = {10.14778/3685800.3685869},
        url = {https://doi.org/10.14778/3685800.3685869},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,139	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR	5.093636e-05
10,384	MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration	2026	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
1,279	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00011361878
1,337	DB-BERT: A Database Tuning Tool that "Reads the Manual"	2022	SIGMOD	0.00011117488
2,298	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	8.7886538e-05
3,757	Panda: Performance Debugging for Databases using LLM Agents	2024	CIDR	7.1483644e-05
4,449	From BERT to GPT-3 Codex: Harnessing the Potential of Very Large Language Models for Data Management	2022	VLDB	6.697553e-05
5,573	Eraser: Eliminating Performance Regression on Learned Query Optimizer	2024	VLDB	6.1682747e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	10,139	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR
2	10,713	D-Bot: An LLM-Powered DBA Copilot	2025	SIGMOD
3	10,506	This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch!	2026	SIGMOD
4	1,920	D-Bot: Database Diagnosis System using Large Language Models	2024	VLDB
5	8,482	A Demonstration of DLBD: Database Logic Bug Detection System	2023	VLDB
6	10,705	Andromeda: Debugging Database Performance Issues with Retrieval-Augmented Large Language Models	2025	SIGMOD
7	9,391	Demonstration of DB-GPT: Next Generation Data Interaction System Empowered by Large Language Models	2024	VLDB
8	2,298	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB
9	7,809	Can Large Language Models Be Query Optimizer for Relational Databases?	2026	SIGMOD
10	3,757	Panda: Performance Debugging for Databases using LLM Agents	2024	CIDR