explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aHNB

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2,142.261 ↑ 1.0 1 1

Nested Loop Left Join (cost=89,248.01..330,881.68 rows=1 width=593) (actual time=2,142.259..2,142.261 rows=1 loops=1)

2. 0.003 2,142.255 ↑ 1.0 1 1

Nested Loop Left Join (cost=89,247.87..330,881.52 rows=1 width=574) (actual time=2,142.254..2,142.255 rows=1 loops=1)

3. 0.010 2,142.251 ↑ 1.0 1 1

Nested Loop Left Join (cost=89,247.44..330,881.00 rows=1 width=290) (actual time=2,142.250..2,142.251 rows=1 loops=1)

4. 830.699 2,142.239 ↑ 1.0 1 1

Hash Right Join (cost=89,247.30..330,880.84 rows=1 width=271) (actual time=2,142.238..2,142.239 rows=1 loops=1)

  • Hash Cond: (""OrdersEntity__payments"".""orderId"" = ""OrdersEntity"".id)
5. 458.422 458.422 ↑ 1.0 4,926,019 1

Seq Scan on ""Payments"" ""OrdersEntity__payments"" (cost=0.00..222,435.29 rows=5,119,529 width=129) (actual time=0.013..458.422 rows=4,926,019 loops=1)

6. 0.009 853.118 ↑ 1.0 1 1

Hash (cost=89,247.29..89,247.29 rows=1 width=142) (actual time=853.118..853.118 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 221.813 853.109 ↑ 1.0 1 1

Hash Right Join (cost=4.46..89,247.29 rows=1 width=142) (actual time=853.108..853.109 rows=1 loops=1)

  • Hash Cond: (""OrdersEntity__assignedFundings"".""orderId"" = ""OrdersEntity"".id)
8. 631.266 631.266 ↓ 1.0 3,269,221 1

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

9. 0.002 0.030 ↑ 1.0 1 1

Hash (cost=4.45..4.45 rows=1 width=25) (actual time=0.030..0.030 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
10. 0.028 0.028 ↑ 1.0 1 1

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

  • Index Cond: (""basketId"" = '100010754'::text)
11. 0.002 0.002 ↓ 0.0 0 1

Index Scan using ""PK_a9e75b141122d8788eb92c08d14"" on ""PaymentModes"" ""OrdersEntity__payments__paymentMode"" (cost=0.14..0.16 rows=1 width=19) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((id)::text = (""OrdersEntity__payments"".""paymentModeId"")::text)
12. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Index Cond: (id = ""OrdersEntity__assignedFundings"".""fundingId"")
13. 0.000 0.000 ↓ 0.0 0 1

Index Scan using ""PK_a9e75b141122d8788eb92c08d14"" on ""PaymentModes"" ""OrdersEntity__assignedFundings__funding__paymentMode"" (cost=0.14..0.16 rows=1 width=19) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: ((id)::text = (""OrdersEntity__assignedFundings__funding"".""paymentModeId"")::text)
Planning time : 0.848 ms