Database Query Cost Estimate
Calculator
Results
- Query cost
- 0.925
- Cost per row
- 3.7e-7
Computing results
| Query cost | 0.925 |
| Cost per row | 3.7e-7 |
formula-map diagram
- Query cost
- 0.925
- Cost per row
- 3.7e-7
Computing relationship
Formula
cost = rows_scanned × (cost_factor_per_million_rows ÷ 1,000,000)= 0.925
Note
This is a simplified model: it applies the standard computing formula to the numbers you entered and ignores protocol overhead, compression variability, retries, contention and other real-world effects. Size your systems with measured data.
Example: with the default inputs, calculator.technology.query_cost is 0.925.
More in Technology and computing
See all →Frequently asked questions
How is the query cost estimated?+
Cost = rows scanned × (cost per million rows ÷ 1,000,000). With the defaults of 2,500,000 rows and 0.37 per million rows, you get the cost of that scan.
What is the cost per row?+
It is the price per million rows divided by 1,000,000, shown as a separate result. It is the unit price applied to each scanned row.
Where do I find the cost per million rows?+
The calculator does not supply it. Take it from your database provider's pricing or your own estimate, and enter it in your currency.
Is this the real bill for my query?+
No. It is a simplified estimate based only on rows scanned and one per-row rate. It ignores compute time, I/O, indexes, caching, minimum charges and anything else your provider bills.
Which currency does it use?+
None in particular. The result is in the same currency as the cost per million rows that you enter.