DH{}DataHunter

Dataset from Zenodo · Bergmann, Rico

Stats Benchmark

Open on Zenodo
License
CC BY-SA 4.0commercial use allowedLicense text
This license allows commercial use. Usually you must credit the author; read the license for the exact terms.
Formats
DUCKDB, SQL, ZIP, PG
Size
865 MB
Updated
Apr 21, 2026

Description

General This is a re-distribution of the Stats dataset and workload, adapted for different database systems. The original dataset was uploaded by Stack Exchange, Inc. to archive.org and licensed under CC-BY-SA 4.0 terms. Our dump is based on the distribution from the CTU Relational Dataset Repository , but re-packaged for PostgreSQL and DuckDB. The benchmark queries were first presented by Han et al. in their paper "Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation" (Proc. VLDB, Vol. 15, Issue 4) (DOI 10.14778/3503585.3503586 ). We extracted the queries from the official Github Repo of the publication and provide the as individual SQL files. Import for PostgreSQL The PostgreSQL dump was created using PostgreSQL 16, so it should work on all Postgres version starting from PG 16. To load the dump, first create a new Postgres database. Afterwards, run pg restore on the dump: $ createdb stats $ pg restore -n public -O -d stats stats dump.pg If you do not have the pg hint plan extension available on your server, you might see a couple of warnings during the import. These are safe to ignore. For reference, we also provide the raw schema for Postgres. Similarly, a…

Description from Zenodo, shortened.

Files (6)

  • DUCKDBstats.duckdb618 MB
  • SQLschema-duckdb.sql5.2 kB
  • ZIPqueries.zip57 kB
  • ZIPcsv.zip123 MB
  • PGstats_dump.pg124 MB
  • SQLschema-postgres.sql5.8 kB

DataHunter does not store or host these files: every link leads to the original source. Check the license there before using the data.

Search other datasets