explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sE7uw

Settings
# exclusive inclusive rows x rows loops node
1. 0.221 1.368 ↓ 26.0 26 1

Nested Loop (cost=20.02..20.76 rows=1 width=1,338) (actual time=0.682..1.368 rows=26 loops=1)

2. 0.332 0.867 ↓ 28.0 28 1

HashAggregate (cost=19.59..19.60 rows=1 width=4) (actual time=0.646..0.867 rows=28 loops=1)

  • Group Key: oo.id
3. 0.186 0.535 ↓ 28.0 28 1

Nested Loop (cost=0.98..19.59 rows=1 width=4) (actual time=0.068..0.535 rows=28 loops=1)

4. 0.024 0.079 ↑ 1.0 2 1

Nested Loop (cost=0.56..17.18 rows=2 width=4) (actual time=0.042..0.079 rows=2 loops=1)

5. 0.015 0.015 ↑ 1.0 2 1

Values Scan on "*VALUES*" (cost=0.00..0.03 rows=2 width=32) (actual time=0.006..0.015 rows=2 loops=1)

6. 0.040 0.040 ↑ 1.0 1 2

Index Scan using user_user_username_e2bdfe0c_like on user_user uu (cost=0.56..8.57 rows=1 width=21) (actual time=0.018..0.020 rows=1 loops=2)

  • Index Cond: ((username)::text = "*VALUES*".column1)
7. 0.270 0.270 ↓ 2.0 14 2

Index Scan using order_order_user_id_7cf9bc2b on order_order oo (cost=0.43..1.14 rows=7 width=8) (actual time=0.047..0.135 rows=14 loops=2)

  • Index Cond: (user_id = uu.id)
8. 0.280 0.280 ↑ 1.0 1 28

Index Scan using order_orderinfo_order_id_key on order_orderinfo ooi (cost=0.43..1.16 rows=1 width=1,338) (actual time=0.010..0.010 rows=1 loops=28)

  • Index Cond: (order_id = oo.id)
  • Filter: ((((http_request)::json -> 'GET'::text) ->> 'deviceType'::text) IS NULL)
  • Filter: ((((http_request)::json -> 'GET'::text) ->> 'deviceType'::text) IS NULL)
  • Rows Removed by Filter: 0
Planning time : 1.462 ms
Execution time : 57.676 ms