explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Asx7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.044 2,375.169 ↑ 83.3 12 1

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

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

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

3. 0.028 1,231.171 ↑ 83.3 12 1

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

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

Function Scan on priv_order_established_price_breakdown v (cost=0.25..10.25 rows=1,000 width=1,732) (actual time=1,231.138..1,231.143 rows=12 loops=1)

5. 0.004 1,143.909 ↑ 200.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
6. 0.002 1,143.905 ↑ 200.0 1 1

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

7. 0.023 1,143.903 ↑ 200.0 1 1

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

8. 1,143.880 1,143.880 ↑ 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,143.878..1,143.880 rows=12 loops=1)