benchmark

command

v0.6.0 Latest Latest Go to latest Published: Jun 23, 2026 License: MIT Imports: 21 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/specterops/dawgs

Links

Open Source Insights

README ¶

Benchmark

Runs query scenarios against a real database and outputs a markdown timing table with warm-up row counts. Path-heavy scenarios can also report distinct returned path rows and duplicate returned path rows. PostgreSQL explain capture includes translated SQL, plan text, and optimizer rule/lowering metadata in JSON output.

Usage

# Default datasets (base and adcs_fanout)
go run ./cmd/benchmark -connection "postgresql://dawgs:dawgs@localhost:5432/dawgs"

# Local dataset (not committed to repo)
go run ./cmd/benchmark -connection "..." -dataset local/phantom

# Default + local dataset
go run ./cmd/benchmark -connection "..." -local-dataset local/phantom

# Neo4j
go run ./cmd/benchmark -driver neo4j -connection "neo4j://neo4j:password@localhost:7687"

# Save to file
go run ./cmd/benchmark -connection "..." -output report.md

# Save markdown and JSON for quality baseline comparison
go run ./cmd/benchmark -connection "..." -output report.md -json-output report.json

# Capture PostgreSQL EXPLAIN (ANALYZE, BUFFERS), translated SQL, and optimizer metadata in JSON output
go run ./cmd/benchmark -connection "..." -dataset adcs_fanout -json-output report.json -explain

Flags

Flag	Default	Description
`-driver`	`pg`	Database driver (`pg`, `neo4j`)
`-connection`		Connection string (or `CONNECTION_STRING` env)
`-iterations`	`10`	Timed iterations per scenario
`-explain`	`false`	Capture PostgreSQL `EXPLAIN (ANALYZE, BUFFERS)` and translated SQL for Cypher scenarios in JSON output
`-dataset`		Run only this dataset
`-local-dataset`		Add a local dataset to the default set
`-dataset-dir`	`integration/testdata`	Path to testdata directory
`-output`	stdout	Markdown output file
`-json-output`		JSON output file for baseline comparison

Example: Neo4j on local/phantom

$ go run ./cmd/benchmark -driver neo4j -connection "neo4j://neo4j:testpassword@localhost:7687" -dataset local/phantom

Query	Dataset	Rows	Distinct Rows	Duplicate Rows	Median	P95	Max	Explain
Match Nodes	local/phantom	1000	-	-	1.4ms	2.3ms	2.3ms	-
Match Edges	local/phantom	2000	-	-	1.6ms	1.9ms	1.9ms	-

Example: PG on local/phantom

$ export CONNECTION_STRING="postgresql://dawgs:dawgs@localhost:5432/dawgs"
$ go run ./cmd/benchmark -dataset local/phantom

Query	Dataset	Rows	Distinct Rows	Duplicate Rows	Median	P95	Max	Explain
Match Nodes	local/phantom	1000	-	-	2.0ms	6.5ms	6.5ms	-
Match Edges	local/phantom	2000	-	-	464ms	604ms	604ms	-

Documentation ¶

There is no documentation for this package.

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL