explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dK2D

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Join (cost=3.02..5.39 rows=100 width=96) (actual rows= loops=)

  • Merge Cond: (sales.id = geolocations.id)
2. 0.000 0.000 ↓ 0.0

Index Scan using sales_pkey on sales (cost=0.06..80.74 rows=4,172 width=35) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=2.96..3.01 rows=100 width=61) (actual rows= loops=)

  • Sort Key: geolocations.id
4. 0.000 0.000 ↓ 0.0

Seq Scan on geolocations (cost=0.00..2.30 rows=100 width=61) (actual rows= loops=)