explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gfgx

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.654 ↑ 3.0 2 1

Nested Loop (cost=76.76..340.92 rows=6 width=425) (actual time=0.519..0.654 rows=2 loops=1)

2. 0.005 0.640 ↑ 3.0 2 1

Nested Loop (cost=76.48..291.09 rows=6 width=416) (actual time=0.507..0.640 rows=2 loops=1)

3. 0.006 0.631 ↓ 2.0 2 1

Nested Loop Left Join (cost=76.19..282.78 rows=1 width=346) (actual time=0.500..0.631 rows=2 loops=1)

4. 0.004 0.623 ↓ 2.0 2 1

Nested Loop Left Join (cost=75.91..274.48 rows=1 width=181) (actual time=0.494..0.623 rows=2 loops=1)

5. 0.004 0.615 ↓ 2.0 2 1

Nested Loop Left Join (cost=75.63..266.18 rows=1 width=184) (actual time=0.489..0.615 rows=2 loops=1)

6. 0.005 0.607 ↓ 2.0 2 1

Nested Loop (cost=75.35..257.87 rows=1 width=176) (actual time=0.482..0.607 rows=2 loops=1)

  • Join Filter: (subordertable.suborderid = subordertableforresellers.suborderid)
  • Rows Removed by Join Filter: 2
7. 0.522 0.522 ↓ 2.0 2 1

Seq Scan on subordertableforresellers (cost=0.00..149.02 rows=1 width=52) (actual time=0.408..0.522 rows=2 loops=1)

  • Filter: ((suborderid = ANY ('{15170,15171}'::bigint[])) AND (wholesellerid = 2251))
  • Rows Removed by Filter: 5666
8. 0.019 0.080 ↑ 3.0 2 2

Hash Join (cost=75.35..108.77 rows=6 width=140) (actual time=0.039..0.040 rows=2 loops=2)

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

HashAggregate (cost=51.31..64.02 rows=1,271 width=64) (actual time=0.009..0.017 rows=11 loops=2)

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

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

11. 0.004 0.009 ↑ 127.0 10 1

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

12. 0.005 0.005 ↑ 127.0 10 1

Seq Scan on convertortable (cost=0.00..22.70 rows=1,270 width=36) (actual time=0.003..0.005 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.027 ↓ 2.0 2 1

Hash (cost=24.03..24.03 rows=1 width=120) (actual time=0.027..0.027 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.005 0.022 ↓ 2.0 2 1

Nested Loop Left Join (cost=0.57..24.03 rows=1 width=120) (actual time=0.017..0.022 rows=2 loops=1)

16. 0.013 0.013 ↓ 2.0 2 1

Index Scan using subordertable_pkey on subordertable (cost=0.29..15.73 rows=1 width=116) (actual time=0.010..0.013 rows=2 loops=1)

  • Index Cond: (suborderid = ANY ('{15170,15171}'::bigint[]))
  • Filter: (parentstoreid = 2251)
17. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (subordertable.subordershipmentid = shipmentid)
18. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (subordertable.suborderid = suborderid)
19. 0.004 0.004 ↑ 1.0 1 2

Index Scan using productskudetails_productvariantid on productskudetails (cost=0.28..8.29 rows=1 width=13) (actual time=0.002..0.002 rows=1 loops=2)

  • Index Cond: (productvariantid = subordertableforresellers.productvariantid)
20. 0.002 0.002 ↑ 1.0 1 2

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

  • Index Cond: (subordertable.subordershipmentid = shipmentid)
21. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (productid = subordertableforresellers.productid)
22. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (storeid = subordertableforresellers.resellerid)
Planning time : 2.718 ms
Execution time : 0.763 ms