explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 35qK

Settings
# exclusive inclusive rows x rows loops node
1. 13.892 291.265 ↓ 178.0 178 1

Gather (cost=9,438.51..32,905.67 rows=1 width=26) (actual time=114.484..291.265 rows=178 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 85.170 277.373 ↓ 59.0 59 3

Hash Anti Join (cost=8,438.51..31,905.57 rows=1 width=26) (actual time=148.945..277.373 rows=59 loops=3)

  • Hash Cond: ((collectionsettle.loan_id)::text = (collectionauth.loan_id)::text)
3. 50.548 50.548 ↑ 1.3 97,221 3

Parallel Seq Scan on collectionsettle (cost=0.00..7,568.27 rows=121,527 width=17) (actual time=0.026..50.548 rows=97,221 loops=3)

4. 60.070 141.655 ↑ 1.0 163,934 3

Hash (cost=5,588.34..5,588.34 rows=163,934 width=9) (actual time=141.655..141.655 rows=163,934 loops=3)

  • Buckets: 131072 Batches: 4 Memory Usage: 2718kB
5. 81.585 81.585 ↑ 1.0 163,934 3

Seq Scan on collectionauth (cost=0.00..5,588.34 rows=163,934 width=9) (actual time=0.043..81.585 rows=163,934 loops=3)