explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ogTo

Settings
# exclusive inclusive rows x rows loops node
1. 13.058 43.547 ↓ 1,022.0 1,022 1

Nested Loop (cost=1.41..1,007.46 rows=1 width=1,342) (actual time=0.098..43.547 rows=1,022 loops=1)

2. 7.521 17.575 ↓ 48.9 1,174 1

Nested Loop (cost=0.98..979.67 rows=24 width=4) (actual time=0.065..17.575 rows=1,174 loops=1)

3. 0.990 2.854 ↑ 1.0 100 1

Nested Loop (cost=0.56..858.75 rows=100 width=4) (actual time=0.040..2.854 rows=100 loops=1)

4. 0.464 0.464 ↑ 1.0 100 1

Values Scan on "*VALUES*" (cost=0.00..1.25 rows=100 width=32) (actual time=0.005..0.464 rows=100 loops=1)

5. 1.400 1.400 ↑ 1.0 1 100

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

  • Index Cond: ((username)::text = "*VALUES*".column1)
6. 7.200 7.200 ↓ 1.7 12 100

Index Scan using order_order_user_id_7cf9bc2b on order_order oo (cost=0.43..1.14 rows=7 width=8) (actual time=0.008..0.072 rows=12 loops=100)

  • Index Cond: (user_id = uu.id)
7. 12.914 12.914 ↑ 1.0 1 1,174

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.011..0.011 rows=1 loops=1,174)

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