Database Query Cost Estimate
Calculator

Inputs

Query cost
0.925

Results

Query cost
0.925
Cost per row
3.7e-7

Computing results

Query cost0.925
Cost per row3.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.