explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3NoR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on order_orderinfo ooi (cost=65.99..66.72 rows=1 width=62) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=65.99..66.72 rows=1 width=62) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=65.56..65.57 rows=1 width=16) (actual rows= loops=)

  • Group Key: oo.id
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.98..65.56 rows=1 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using user_user_username_key on user_user uu (cost=0.56..16.87 rows=2 width=10) (actual rows= loops=)

  • Index Cond: ((username)::text = ANY ('{26827132,28195662}'::text[]))
6. 0.000 0.000 ↓ 0.0

Index Scan using order_order_user_id_7cf9bc2b on order_order oo (cost=0.43..24.27 rows=7 width=14) (actual rows= loops=)

  • Index Cond: (user_id = uu.id)
7. 0.000 0.000 ↓ 0.0

Index Scan using order_orderinfo_order_id_key on order_orderinfo ooi (cost=0.43..1.16 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (order_id = oo.id)
  • Filter: ((((http_request)::json -> 'GET'::text) ->> 'deviceType'::text) IS NULL)