explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BpNx

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 441.419 ↑ 1.0 1 1

Limit (cost=156,693.50..156,693.50 rows=1 width=641) (actual time=441.418..441.419 rows=1 loops=1)

2. 0.022 441.417 ↑ 1.0 1 1

Sort (cost=156,693.50..156,693.50 rows=1 width=641) (actual time=441.417..441.417 rows=1 loops=1)

  • Sort Key: ordertable.orderid DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.006 441.395 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,000.86..156,693.49 rows=1 width=641) (actual time=283.116..441.395 rows=1 loops=1)

  • Filter: ((subordertable.subordermodeofpayment <> 'onlinepayment'::text) OR (doo.paymentgatewaystatus = 'success'::text))
4. 0.000 441.377 ↑ 1.0 1 1

Nested Loop (cost=1,000.43..156,691.93 rows=1 width=641) (actual time=283.099..441.377 rows=1 loops=1)

  • Join Filter: (subordertable.suborderstatusvalue = convertortable.suborderstatusvalue)
  • Rows Removed by Join Filter: 8
5. 4.581 442.538 ↑ 1.0 1 1

Gather (cost=1,000.43..156,690.73 rows=1 width=609) (actual time=283.084..442.538 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.006 437.957 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.43..155,690.63 rows=1 width=609) (actual time=385.200..437.957 rows=0 loops=3)

7. 437.920 437.920 ↑ 7.0 1 3 / 3

Parallel Seq Scan on ordertable (cost=0.00..155,622.70 rows=7 width=131) (actual time=275.185..437.920 rows=1 loops=3)

  • Filter: (ordercustomerphone = '6201745328'::text)
  • Rows Removed by Filter: 1,485,517
8. 0.031 0.031 ↓ 0.0 0 3 / 3

Index Scan using idx_orderid_subordertable on subordertable (cost=0.43..9.69 rows=1 width=486) (actual time=0.031..0.031 rows=0 loops=3)

  • Index Cond: (orderid = ordertable.orderid)
  • Filter: ((storeid = 20,106) OR (parentstoreid = 20,106))
  • Rows Removed by Filter: 1
9. 0.011 0.011 ↑ 1.0 9 1

Seq Scan on convertortable (cost=0.00..1.09 rows=9 width=36) (actual time=0.010..0.011 rows=9 loops=1)

10. 0.012 0.012 ↓ 0.0 0 1

Index Scan using paymenttable_pkey on paymenttable doo (cost=0.42..1.54 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (subordertable.suborderpaymentid = paymentid)
Planning time : 1.746 ms
Execution time : 442.760 ms