The Picasso Database Query Optimizer Visualizer

Summary: Picasso visualizes and profiles database query optimizers, generating plan diagrams and optimality regions over a parameterized selectivity space. It supports IBM DB2, SQL Server, Oracle, Sybase ASE, and PostgreSQL for optimizer analysis, debugging, benchmarking, and teaching, highlighting robust plans under estimation errors. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9987
Venue: VLDB
Year: 2010
Pagerank: 0.00012732768
Overall Rank: 1,297 | 90.99%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Jayant R. Haritsa

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059446482
2,244	Query Optimization in Microsoft SQL Server PDW	2012	SIGMOD	9.2095696e-05
5,344	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB	5.5579641e-05
5,790	MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education	2022	VLDB	5.3247208e-05
5,994	Steering Query Optimizers: A Practical Take on Big Data Workloads	2021	SIGMOD	5.2367998e-05
8,115	Databases will Visualize Queries too*	2011	VLDB	4.5800219e-05
8,623	Adaptive Code Generation for Data-Intensive Analytics	2021	VLDB	4.4786182e-05
9,160	ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA	2020	SIGMOD	4.380727e-05
9,191	POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance	2024	VLDB	4.3738237e-05
9,709	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.2951473e-05
9,959	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD	4.2254157e-05
10,577	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
181	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036970794
221	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00033182072
1,064	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00014348262
1,234	Least Expected Cost Query Optimization: An Exercise in Utility	1999	PODS	0.00013115865
1,644	Parametric Query Optimization for Linear and Piecewise Linear Cost Functions	2002	VLDB	0.0001102889
1,990	AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions	2003	VLDB	9.8491124e-05
2,187	Least Expected Cost Query Optimization: What Can We Expect?	2002	PODS	9.3429142e-05
4,342	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	6.2680535e-05
5,476	On the Production of Anorexic Plan Diagrams	2007	VLDB	5.4866057e-05
6,561	On the Stability of Plan Costs and the Costs of Plan Stability	2010	VLDB	5.0055336e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
13,551	Extreme Visualisation of Query Optimizer Search Spaces	2009	SIGMOD	-
1,536	Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions	2011	VLDB	0.00011458359
7,010	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	4.8589148e-05
9,709	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.2951473e-05
7,438	Interactive Plan Hints for Query Optimization	2009	SIGMOD	4.7256896e-05
10,577	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1905499e-05
1,064	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00014348262
5,263	SeeDB: Visualizing Database Queries Efficiently	2014	VLDB	5.5959099e-05
4,342	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	6.2680535e-05
5,344	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB	5.5579641e-05