Why does my query cost so much?
Almost always because it read data it did not need.
Tag
performance
24 pieces tagged “performance”, newest first.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
Search is a JSON file
Site search is a static JSON index fetched on first use and scored in the page. No search service, no API key, no query leaving your browser.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
Reading 3 columns instead of 12
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
The build takes under two seconds
Full rebuild: generate fourteen datasets from scratch, render every page, write the feeds, verify every internal link. Under two seconds on a laptop.
Reading 3 columns instead of 8
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
Reading 3 columns instead of 10
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
Reading 3 columns instead of 11
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
Reading 3 columns instead of 7
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
The arithmetic behind a cheap query
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
Fifteen minutes a month on the warehouse bill
A recurring review that has never once found nothing.
Reading 3 columns instead of 10
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
Reading 3 columns instead of 10
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
Reading 3 columns instead of 8
Column pruning times partition pruning on a real schema, and the function call that quietly defeats both.
A backfill that cost $400 in ninety seconds
Four hundred days, unbounded concurrency, and a very short conversation with the platform team.
DuckDB replaced a Spark cluster for one of our jobs
40 minutes to 90 seconds, and a lesson about what "big data" actually means.
We saved $2,100 a month by typing more
A columnar storage lesson learned from a bill, not a book.