explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Dnd : Optimization for: plan #Asx7

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.045 2,221.587 ↑ 83.3 12 1

Hash Left Join (cost=91.83..184.33 rows=1,000 width=1,996) (actual time=2,221.557..2,221.587 rows=12 loops=1)

  • Hash Cond: ((v.cart_id)::bpchar = (o.cart_id)::bpchar)
2. 0.044 1,094.246 ↑ 83.3 12 1

WindowAgg (cost=60.08..85.08 rows=1,000 width=1,732) (actual time=1,094.229..1,094.246 rows=12 loops=1)

3. 0.035 1,094.202 ↑ 83.3 12 1

Sort (cost=60.08..62.58 rows=1,000 width=1,732) (actual time=1,094.200..1,094.202 rows=12 loops=1)

  • Sort Key: v.cart_id
  • Sort Method: quicksort Memory: 31kB
4. 1,094.167 1,094.167 ↑ 83.3 12 1

Function Scan on priv_order_established_price_breakdown2 v (cost=0.25..10.25 rows=1,000 width=1,732) (actual time=1,094.161..1,094.167 rows=12 loops=1)

5. 0.004 1,127.296 ↑ 200.0 1 1

Hash (cost=29.25..29.25 rows=200 width=168) (actual time=1,127.296..1,127.296 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
6. 0.001 1,127.292 ↑ 200.0 1 1

Subquery Scan on o (cost=25.25..29.25 rows=200 width=168) (actual time=1,127.290..1,127.292 rows=1 loops=1)

7. 0.026 1,127.291 ↑ 200.0 1 1

HashAggregate (cost=25.25..27.25 rows=200 width=164) (actual time=1,127.290..1,127.291 rows=1 loops=1)

8. 1,127.265 1,127.265 ↑ 83.3 12 1

Function Scan on priv_order_allocated_net_funds w (cost=0.25..10.25 rows=1,000 width=164) (actual time=1,127.265..1,127.265 rows=12 loops=1)