explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Od4q

Settings
# exclusive inclusive rows x rows loops node
1. 440.362 1,718.002 ↓ 0.0 0 1

Hash Anti Join (cost=120,625.65..150,286.51 rows=5,967 width=120) (actual time=1,718.002..1,718.002 rows=0 loops=1)

  • Hash Cond: ((offer_images.image_hash)::text = (store_offers.image_hash)::text)
2. 2.447 2.447 ↑ 1.0 10,235 1

Seq Scan on offer_images (cost=0.00..237.62 rows=10,262 width=59) (actual time=0.014..2.447 rows=10,235 loops=1)

3. 847.870 1,275.193 ↑ 1.0 2,703,276 1

Hash (cost=57,794.18..57,794.18 rows=2,703,318 width=61) (actual time=1,275.193..1,275.193 rows=2,703,276 loops=1)

  • Buckets: 65536 Batches: 128 Memory Usage: 3314kB
4. 427.323 427.323 ↑ 1.0 2,703,276 1

Seq Scan on store_offers (cost=0.00..57,794.18 rows=2,703,318 width=61) (actual time=0.009..427.323 rows=2,703,276 loops=1)