explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nj6s

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.009 0.846 ↑ 1.0 100 1

Limit (cost=0.43..51.50 rows=100 width=37) (actual time=0.069..0.846 rows=100 loops=1)

2. 0.306 0.837 ↑ 338,877.1 100 1

Nested Loop (cost=0.43..17,306,993.13 rows=33,887,707 width=37) (actual time=0.068..0.837 rows=100 loops=1)

3. 0.031 0.031 ↑ 338,956.2 100 1

Seq Scan on orders o (cost=0.00..1,880,750.16 rows=33,895,616 width=18) (actual time=0.014..0.031 rows=100 loops=1)

4. 0.068 0.500 ↑ 1.0 1 100

Custom Scan (RuntimeAppend) (cost=0.43..0.45 rows=1 width=27) (actual time=0.005..0.005 rows=1 loops=100)

  • Prune by: (o.paid_online_on_delivery_id = v.id)
5. 0.102 0.102 ↑ 1.0 1 34

Index Scan using valuation_3761_pkey on valuation_3761 v_2 (cost=0.42..0.44 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=34)

  • Index Cond: (id = o.paid_online_on_delivery_id)
6. 0.330 0.330 ↑ 1.0 1 66

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

  • Index Cond: (id = o.paid_online_on_delivery_id)