explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1TSa

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.075 ↑ 1.5 10 1

Nested Loop (cost=1.13..19.09 rows=15 width=545) (actual time=0.021..0.075 rows=10 loops=1)

2. 0.021 0.021 ↑ 1.0 2 1

Index Scan using orders_pkey on orders (cost=0.56..4.67 rows=2 width=325) (actual time=0.011..0.021 rows=2 loops=1)

  • Index Cond: (id = ANY ('{26236857,27923671}'::integer[]))
3. 0.028 0.028 ↑ 4.8 5 2

Index Scan using order_modifications_order_id_index on order_modifications (cost=0.57..6.97 rows=24 width=220) (actual time=0.007..0.014 rows=5 loops=2)

  • Index Cond: (order_id = orders.id)