Estimate PostgreSQL sequential-scan and index-scan cost from table rows, table pages, selectivity, and storage type. Uses the same four-input model as the browser calculator.

post/calculate/query-cost-estimator

Request

  • Base URL: https://utility-matrix.com
  • URL: https://utility-matrix.com/calculate/query-cost-estimator
  • Auth: none declared

Request body

table_rowsnumber required

table rows used by this deterministic tool.

table_pagesnumber required

table pages used by this deterministic tool.

selectivity_pctnumber required

selectivity expressed as a percentage.

storage_type'ssd' | 'nvme' | 'hdd' | 'network' required

storage type; accepted values: ssd, nvme, hdd, network.

Example request

{
  "table_rows": 1,
  "table_pages": 1,
  "selectivity_pct": 1,
  "storage_type": "ssd"
}

Response

Successful calculation

interpretationstring required

Human-readable interpretation of the result.

tool_urlstring required

Canonical browser URL for the corresponding calculator.

Changes

No recorded changes to this operation across all 1 revision of this API.