explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hNFo : Optimization for: plan #KJJn

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2.316 16.976 ↑ 1.0 2,813 1

GroupAggregate (cost=2,445.10..2,536.72 rows=2,819 width=641) (actual time=14.507..16.976 rows=2,813 loops=1)

  • Group Key: rfq.id, bid.origin_port_id
2. 2.281 14.660 ↑ 1.0 2,814 1

Sort (cost=2,445.10..2,452.15 rows=2,819 width=586) (actual time=14.494..14.660 rows=2,814 loops=1)

  • Sort Key: rfq.id, bid.origin_port_id
  • Sort Method: quicksort Memory: 1167kB
3. 2.797 12.379 ↑ 1.0 2,814 1

Hash Join (cost=931.67..2,283.56 rows=2,819 width=586) (actual time=1.778..12.379 rows=2,814 loops=1)

  • Hash Cond: (rfq.id = bid.rfq_id)
4. 7.819 7.819 ↓ 1.0 25,588 1

Seq Scan on rfq (cost=0.00..1,036.39 rows=25,539 width=571) (actual time=0.006..7.819 rows=25,588 loops=1)

5. 0.385 1.763 ↑ 1.0 2,814 1

Hash (cost=896.43..896.43 rows=2,819 width=23) (actual time=1.763..1.763 rows=2,814 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 208kB
6. 1.378 1.378 ↑ 1.0 2,814 1

Seq Scan on bid (cost=0.00..896.43 rows=2,819 width=23) (actual time=0.018..1.378 rows=2,814 loops=1)

  • Filter: (is_active AND (NOT is_finalised))
  • Rows Removed by Filter: 229