explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rG34

Settings
# exclusive inclusive rows x rows loops node
1. 966.921 2,183.874 ↓ 1.0 3,112,985 1

Hash Right Join (cost=149,461.65..170,532.47 rows=3,100,651 width=10) (actual time=1,214.421..2,183.874 rows=3,112,985 loops=1)

  • Hash Cond: (sr.sample_collection_id = sc.sample_collection_id)
  • Join Filter: (sc.sample_status = ANY ('{A,R,C}'::bpchar[]))
2. 2.700 2.700 ↑ 1.0 25,665 1

Seq Scan on sample_rejections sr (cost=0.00..395.65 rows=25,665 width=8) (actual time=0.004..2.700 rows=25,665 loops=1)

3. 473.374 1,214.253 ↑ 1.0 3,099,808 1

Hash (cost=98,591.51..98,591.51 rows=3,100,651 width=6) (actual time=1,214.253..1,214.253 rows=3,099,808 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 30331kB
4. 740.879 740.879 ↑ 1.0 3,099,808 1

Seq Scan on sample_collection sc (cost=0.00..98,591.51 rows=3,100,651 width=6) (actual time=0.006..740.879 rows=3,099,808 loops=1)