explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ugTg

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.047 ↑ 1.5 10 1

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

2. 0.016 0.016 ↑ 1.0 2 1

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

  • Index Cond: (id = ANY ('{26236857,27923671}'::integer[]))
3. 0.022 0.022 ↑ 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.011 rows=5 loops=2)

  • Index Cond: (order_id = orders.id)