explain.depesz.com

PostgreSQL's explain analyze made readable

Result: svop

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

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

  • Hash Cond: (sr.sample_collection_id = sc.sample_collection_id)
2. 2.586 2.586 ↑ 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.586 rows=25,665 loops=1)

3. 465.748 1,174.242 ↑ 1.0 3,099,808 1

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

  • Buckets: 131072 Batches: 4 Memory Usage: 30331kB
4. 708.494 708.494 ↑ 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.011..708.494 rows=3,099,808 loops=1)