explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SUDv

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2,047.666 ↑ 16.0 1 1

Hash Left Join (cost=89,252.13..343,685.10 rows=16 width=664) (actual time=2,047.664..2,047.666 rows=1 loops=1)

  • Hash Cond: ((""OrdersEntity__assignedFundings__funding"".""paymentModeId"")::text = (""OrdersEntity__assignedFundings__funding__paymentMode"".id)::text)
2.          

CTE OrdersEntity

3. 0.019 0.019 ↑ 1.0 1 1

Index Scan using ""IDX_basketId"" on ""Orders"" (cost=0.43..4.45 rows=1 width=25) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (""basketId"" = '100010754'::text)
4. 0.025 2,047.650 ↑ 16.0 1 1

Hash Left Join (cost=89,246.07..343,678.83 rows=16 width=645) (actual time=2,047.649..2,047.650 rows=1 loops=1)

  • Hash Cond: ((""OrdersEntity__payments"".""paymentModeId"")::text = (""OrdersEntity__payments__paymentMode"".id)::text)
5. 784.253 2,047.606 ↑ 16.0 1 1

Hash Right Join (cost=89,244.46..343,677.00 rows=16 width=626) (actual time=2,047.605..2,047.606 rows=1 loops=1)

  • Hash Cond: (""OrdersEntity__payments"".""orderId"" = ""OrdersEntity"".id)
6. 443.473 443.473 ↑ 1.0 4,925,885 1

Seq Scan on ""Payments"" ""OrdersEntity__payments"" (cost=0.00..222,435.29 rows=5,119,529 width=129) (actual time=0.007..443.473 rows=4,925,885 loops=1)

7. 0.006 819.880 ↑ 3.0 1 1

Hash (cost=89,244.43..89,244.43 rows=3 width=497) (actual time=819.880..819.880 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.009 819.874 ↑ 3.0 1 1

Nested Loop Left Join (cost=0.46..89,244.43 rows=3 width=497) (actual time=819.872..819.874 rows=1 loops=1)

9. 216.010 819.863 ↑ 3.0 1 1

Hash Right Join (cost=0.03..89,242.88 rows=3 width=213) (actual time=819.861..819.863 rows=1 loops=1)

  • Hash Cond: (""OrdersEntity__assignedFundings"".""orderId"" = ""OrdersEntity"".id)
10. 603.830 603.830 ↓ 1.0 3,269,153 1

Seq Scan on ""AssignedFundings"" ""OrdersEntity__assignedFundings"" (cost=0.00..77,084.96 rows=3,242,096 width=117) (actual time=0.005..603.830 rows=3,269,153 loops=1)

11. 0.001 0.023 ↑ 1.0 1 1

Hash (cost=0.02..0.02 rows=1 width=96) (actual time=0.023..0.023 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.022 0.022 ↑ 1.0 1 1

CTE Scan on ""OrdersEntity"" (cost=0.00..0.02 rows=1 width=96) (actual time=0.021..0.022 rows=1 loops=1)

13. 0.002 0.002 ↓ 0.0 0 1

Index Scan using ""PK_b31a7a9f6cd5660ce7b85ada52e"" on ""Fundings"" ""OrdersEntity__assignedFundings__funding"" (cost=0.43..0.50 rows=1 width=284) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id = ""OrdersEntity__assignedFundings"".""fundingId"")
14. 0.007 0.019 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=19) (actual time=0.019..0.019 rows=27 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
15. 0.012 0.012 ↑ 1.0 27 1

Seq Scan on ""PaymentModes"" ""OrdersEntity__payments__paymentMode"" (cost=0.00..1.27 rows=27 width=19) (actual time=0.010..0.012 rows=27 loops=1)

16. 0.003 0.008 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=19) (actual time=0.008..0.008 rows=27 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
17. 0.005 0.005 ↑ 1.0 27 1

Seq Scan on ""PaymentModes"" ""OrdersEntity__assignedFundings__funding__paymentMode"" (cost=0.00..1.27 rows=27 width=19) (actual time=0.001..0.005 rows=27 loops=1)

Planning time : 0.614 ms