birdsql/Effi-SQL

1---2license: apache-2.03language:4- en5task_categories:6- text-generation7tags:8- sql9- postgresql10- sql-optimization11- benchmark12pretty_name: Effi-SQL13---14 15# Effi-SQL16 17## Update 2026-06-1218 19We release **Effi-SQL**, a dataset suite for SQL efficiency optimization.20 21This collection includes:22 23- **Effi-SQL Benchmark**: a benchmark for evaluating SQL efficiency optimization methods.24- **Diff-SQL Training Dataset**: training data used by Diff-SQL, including data for the Patch Generator and Constraint Aligner.25 26## Dataset Fields27 28### Effi-SQL Benchmark29 30- **id**: A unique identifier for each benchmark instance.31- **db**: The database name.32- **base_sql**: The original slow SQL query.33- **optimized_sql**: The human-verified optimized SQL query.34- **base_time**: Execution time of the original SQL query.35- **fast_time**: Execution time of the optimized SQL query.36- **base_explain_analyze**: Query execution plan (QEP) output for the original SQL query.37- **optimized_explain_analyze**: Query execution plan (QEP) output for the optimized SQL query.38- **difficulty**: The difficulty label of the benchmark instance.39 40### Diff-SQL Training Dataset41 42- **instance_id**: A unique identifier for each training instance.43- **prompt**: The model input prompt, including the slow SQL query, relevant database information, and the query execution plan of the slow SQL query.44- **response**: The target response, including optimization or refinement reasoning and the target patch.45- **db**: The database name of the slow SQL query.46- **base_sql**: The original slow SQL query.47- **optimized_sql**: The optimized SQL query used as the reference target.48 49## Related Resources50 51- **Code**: [L-nshpp/Diff-SQL](https://github.com/L-nshpp/Diff-SQL)52