Query Cost: Sequential vs Index Scan Calculator

Model relative I/O cost of sequential table scan vs index scan for a given table size, result fraction, and random vs sequential page cost ratio. Mirrors PostgreSQL planner cost model.

Networking
Algorithms
Binary & Number
Systems
Dev Metrics

IP Subnet Calculator

IP Address
CIDR Prefix
/
Network
192.168.1.0
Broadcast
192.168.1.255
Subnet Mask
255.255.255.0
First Host
192.168.1.1
Last Host
192.168.1.254
Usable Hosts
254
Binary breakdown:
IP: 11000000.10101000.00000001.00000000
Mask: 11111111.11111111.11111111.00000000
Net: 11000000.10101000.00000001.00000000
Advertisement

How to Use

Enter the values for the patient or scenario you are assessing. Model relative I/O cost of sequential table scan vs index scan for a given table size, result fraction, and random vs sequential page cost ratio. Mirrors PostgreSQL planner cost model. Use the seq scan vs index scan cost result to inform your clinical assessment.

Frequently Asked Questions