explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kqhP : Optimization for: plan #06N

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 5.189 ↓ 0.0 0 1

GroupAggregate (cost=1,976.91..1,982.46 rows=171 width=641) (actual time=5.189..5.189 rows=0 loops=1)

  • Group Key: rfq.id, bid.origin_port_id
2. 0.004 5.188 ↓ 0.0 0 1

Sort (cost=1,976.91..1,977.33 rows=171 width=587) (actual time=5.187..5.188 rows=0 loops=1)

  • Sort Key: rfq.id, bid.origin_port_id
  • Sort Method: quicksort Memory: 25kB
3. 1.021 5.184 ↓ 0.0 0 1

Hash Join (cost=1,058.16..1,970.56 rows=171 width=587) (actual time=5.184..5.184 rows=0 loops=1)

  • Hash Cond: ((bid.rfq_id = rfq.id) AND (bid.is_active = rfq.is_active))
4. 0.567 0.567 ↑ 1.0 3,043 1

Seq Scan on bid (cost=0.00..896.43 rows=3,043 width=25) (actual time=0.004..0.567 rows=3,043 loops=1)

5. 1.655 3.596 ↓ 1.9 5,000 1

Hash (cost=1,017.96..1,017.96 rows=2,680 width=571) (actual time=3.596..3.596 rows=5,000 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1031kB
6. 1.736 1.941 ↓ 1.9 5,000 1

Bitmap Heap Scan on rfq (cost=174.46..1,017.96 rows=2,680 width=571) (actual time=0.222..1.941 rows=5,000 loops=1)

  • Recheck Cond: (rfq_plan_id = 81)
  • Filter: is_active
  • Heap Blocks: exact=124
7. 0.205 0.205 ↑ 1.0 5,000 1

Bitmap Index Scan on rfq_rfq_plan_id_idx (cost=0.00..173.79 rows=5,000 width=0) (actual time=0.205..0.205 rows=5,000 loops=1)

  • Index Cond: (rfq_plan_id = 81)