explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nh8T : Optimization for: plan #Nj6s

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.042 0.112 ↑ 1.0 1 1

Nested Loop (cost=0.99..10.64 rows=1 width=37) (actual time=0.111..0.112 rows=1 loops=1)

2. 0.045 0.045 ↑ 1.0 1 1

Index Scan using udx_orders_number on orders o (cost=0.56..5.38 rows=1 width=18) (actual time=0.044..0.045 rows=1 loops=1)

  • Index Cond: (number = '1104290452'::text)
3. 0.001 0.025 ↑ 1.0 1 1

Custom Scan (RuntimeAppend) (cost=0.43..5.24 rows=1 width=27) (actual time=0.025..0.025 rows=1 loops=1)

  • Prune by: (o.paid_online_on_delivery_id = v.id)
4. 0.024 0.024 ↑ 1.0 1 1

Index Scan using valuation_3762_pkey on valuation_3762 v_1 (cost=0.57..5.38 rows=1 width=27) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: (id = o.paid_online_on_delivery_id)