Skip to main content

Module job

dsfb_database::adapters

Module job 

Source
Expand description

JOB adapter (Join Order Benchmark, Leis et al., VLDB 2015).

Real subset CSV columns (after running JOB through DuckDB / PostgreSQL with EXPLAIN ANALYZE and exporting via scripts/fetch_ceb.sh-style tooling — JOB itself is just the 113 SQL files; you generate the trace):

  • query_id (e.g. 1a, 33c)
  • iteration (replay number)
  • est_rows, actual_rows per top-level result
  • latency_ms
  • plan_hash (SHA-1 of the EXPLAIN tree, for plan-change detection)

What we extract:

  • Cardinality — log10(actual / est) per query (top-level).
  • PlanRegression — latency residual per query class + plan-hash transition events.

What we cannot extract:

  • Contention, CacheIo, WorkloadPhase (single-tenant replay; no phase changes in a 113-query benchmark).

Structs§

Job