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: 9986
Venue: VLDB
Year: 2010
Pagerank: 0.00012733214
Overall Rank: 1,300 | 90.96%
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.00059038975
2,241	Query Optimization in Microsoft SQL Server PDW	2012	SIGMOD	9.2191212e-05
5,340	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB	5.5623066e-05
5,780	MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education	2022	VLDB	5.3298375e-05
6,040	Steering Query Optimizers: A Practical Take on Big Data Workloads	2021	SIGMOD	5.2412035e-05
8,111	Databases will Visualize Queries too*	2011	VLDB	4.5842786e-05
8,626	Adaptive Code Generation for Data-Intensive Analytics	2021	VLDB	4.4829152e-05
9,160	ProcAnalyzer: Effective Code Analyzer for Tuning Imperative Programs in SAP HANA	2020	SIGMOD	4.3849295e-05
9,187	POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance	2024	VLDB	4.3780059e-05
9,710	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.299267e-05
9,960	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD	4.2294678e-05
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-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
182	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036962631
220	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00033194808
1,070	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00014316791
1,236	Least Expected Cost Query Optimization: An Exercise in Utility	1999	PODS	0.00013117798
1,647	Parametric Query Optimization for Linear and Piecewise Linear Cost Functions	2002	VLDB	0.00011033757
1,986	AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions	2003	VLDB	9.8536784e-05
2,180	Least Expected Cost Query Optimization: What Can We Expect?	2002	PODS	9.3481968e-05
4,348	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	6.2660237e-05
5,466	On the Production of Anorexic Plan Diagrams	2007	VLDB	5.4909203e-05
6,561	On the Stability of Plan Costs and the Costs of Plan Stability	2010	VLDB	5.0099895e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
13,538	Extreme Visualisation of Query Optimizer Search Spaces	2009	SIGMOD	-
1,547	Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions	2011	VLDB	0.00011442359
7,010	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	4.8634875e-05
9,710	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.299267e-05
7,440	Interactive Plan Hints for Query Optimization	2009	SIGMOD	4.7302233e-05
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-05
1,070	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00014316791
5,264	SeeDB: Visualizing Database Queries Efficiently	2014	VLDB	5.597302e-05
4,348	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	6.2660237e-05
5,340	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB	5.5623066e-05