explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ETPX

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.471 ↑ 6.0 1 1

Nested Loop Left Join (cost=77.09..283.79 rows=6 width=452) (actual time=0.379..0.471 rows=1 loops=1)

  • Join Filter: (subordertable.suborderid = orderstatustimestamps.suborderid)
2. 0.004 0.456 ↑ 6.0 1 1

Nested Loop (cost=76.80..275.35 rows=6 width=423) (actual time=0.365..0.456 rows=1 loops=1)

3. 0.002 0.380 ↑ 1.0 1 1

Nested Loop (cost=0.57..165.63 rows=1 width=134) (actual time=0.290..0.380 rows=1 loops=1)

4. 0.004 0.373 ↑ 1.0 1 1

Nested Loop (cost=0.29..157.33 rows=1 width=114) (actual time=0.282..0.373 rows=1 loops=1)

5. 0.362 0.362 ↑ 1.0 1 1

Seq Scan on subordertableforresellers (cost=0.00..149.02 rows=1 width=44) (actual time=0.271..0.362 rows=1 loops=1)

  • Filter: ((suborderid = 15170) AND (wholesellerid = 2251))
  • Rows Removed by Filter: 5667
6. 0.007 0.007 ↑ 1.0 1 1

Index Scan using producttable_pkey on producttable (cost=0.29..8.31 rows=1 width=78) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (productid = subordertableforresellers.productid)
7. 0.005 0.005 ↑ 1.0 1 1

Index Scan using storetable_pkey on storetable (cost=0.28..8.30 rows=1 width=28) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (storeid = subordertableforresellers.resellerid)
8. 0.020 0.072 ↑ 6.0 1 1

Hash Join (cost=76.23..109.66 rows=6 width=305) (actual time=0.072..0.072 rows=1 loops=1)

  • Hash Cond: ((("*SELECT* 1".suborderstatusvalue)::numeric) = CASE WHEN ((shipmenttable_1.pickupdate IS NOT NULL) AND (subordertable.suborderstatusvalue = 2)) THEN 2.5 ELSE (subordertable.sub
9. 0.014 0.028 ↑ 115.5 11 1

HashAggregate (cost=51.31..64.02 rows=1,271 width=64) (actual time=0.021..0.028 rows=11 loops=1)

  • Group Key: (("*SELECT* 1".suborderstatusvalue)::numeric), "*SELECT* 1".suborderstatus
10. 0.002 0.014 ↑ 115.5 11 1

Append (cost=0.00..44.95 rows=1,271 width=64) (actual time=0.008..0.014 rows=11 loops=1)

11. 0.007 0.011 ↑ 127.0 10 1

Subquery Scan on *SELECT* 1 (cost=0.00..38.58 rows=1,270 width=64) (actual time=0.007..0.011 rows=10 loops=1)

12. 0.004 0.004 ↑ 127.0 10 1

Seq Scan on convertortable (cost=0.00..22.70 rows=1,270 width=36) (actual time=0.003..0.004 rows=10 loops=1)

13. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=64) (actual time=0.001..0.001 rows=1 loops=1)

14. 0.005 0.024 ↑ 1.0 1 1

Hash (cost=24.92..24.92 rows=1 width=285) (actual time=0.024..0.024 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.004 0.019 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..24.92 rows=1 width=285) (actual time=0.017..0.019 rows=1 loops=1)

16. 0.003 0.013 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.61 rows=1 width=120) (actual time=0.012..0.013 rows=1 loops=1)

17. 0.007 0.007 ↑ 1.0 1 1

Index Scan using subordertable_pkey on subordertable (cost=0.29..8.31 rows=1 width=116) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (suborderid = 15170)
  • Filter: (parentstoreid = 2251)
18. 0.003 0.003 ↑ 1.0 1 1

Index Scan using shipmenttable_pkey on shipmenttable shipmenttable_1 (cost=0.28..8.30 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (subordertable.subordershipmentid = shipmentid)
19. 0.002 0.002 ↑ 1.0 1 1

Index Scan using shipmenttable_pkey on shipmenttable (cost=0.28..8.30 rows=1 width=165) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (subordertable.subordershipmentid = shipmentid)
20. 0.001 0.006 ↑ 1.0 1 1

Materialize (cost=0.29..8.31 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=1)

21. 0.005 0.005 ↑ 1.0 1 1

Index Scan using orderstatustimestamps_pkey on orderstatustimestamps (cost=0.29..8.30 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (suborderid = 15170)
Planning time : 2.853 ms
Execution time : 0.694 ms