explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aBO9

Settings
# exclusive inclusive rows x rows loops node
1. 11.503 54.404 ↓ 1,022.0 1,022 1

Nested Loop (cost=3,254.32..3,281.90 rows=1 width=1,338) (actual time=23.331..54.404 rows=1,022 loops=1)

2. 8.434 27.639 ↓ 48.9 1,174 1

HashAggregate (cost=3,253.89..3,254.13 rows=24 width=4) (actual time=23.283..27.639 rows=1,174 loops=1)

  • Group Key: oo.id
3. 7.561 19.205 ↓ 48.9 1,174 1

Nested Loop (cost=0.98..3,253.83 rows=24 width=4) (actual time=0.250..19.205 rows=1,174 loops=1)

4. 1.844 1.844 ↑ 1.0 100 1

Index Scan using user_user_username_key on user_user uu (cost=0.56..830.15 rows=100 width=4) (actual time=0.193..1.844 rows=100 loops=1)

  • Index Cond: ((username)::text = ANY ('{23632882,31320822,25854666,19715888,13209868,7623688,10751338,11933047,19601350,31335418,1241601,25922322,12411425,23619320,23955052,25807186,10391556,30204544,23695606,20793408,17830312,20770782,5818718,11827723,25206960,18843514,15099822,30304854,31220064,31152988,30210960,12142799,20066454,31154230,31176424,11032301,27809268,25939336,24002340,20453358,4561609,22918350,9884602,27814754,9648992,27371128,30215872,31156258,13764736,27821038,10848356,513410,5940747,12515846,468524,521082,4198936,24701654,27677020,20863314,24146782,30221140,366128,5369382,11549665,20651058,31160532,27838874,5669012,23803178,25956716,439802,11429549,4226766,23222306,22923656,31160848,20882516,8901366,27851446,9894112,12218439,7415110,25821844,18237278,3886066,8714694,1917918,23087346,5603596,5556122,4394783,29956976,5950247,23842694,23584482,4562531,6602517,14575718,9828092}'::text[]))
5. 9.800 9.800 ↓ 1.7 12 100

Index Scan using order_order_user_id_7cf9bc2b on order_order oo (cost=0.43..24.17 rows=7 width=8) (actual time=0.016..0.098 rows=12 loops=100)

  • Index Cond: (user_id = uu.id)
6. 15.262 15.262 ↑ 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.013..0.013 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 : 1.462 ms
Execution time : 57.676 ms