explain.depesz.com

PostgreSQL's explain analyze made readable

Result: asjx

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

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

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

CTE OrdersEntity

3. 0.033 0.033 ↑ 1.0 1 1

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

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

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

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

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

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

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

7. 0.009 851.451 ↑ 3.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.013 851.442 ↑ 3.0 1 1

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

9. 221.335 851.427 ↑ 3.0 1 1

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

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

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

11. 0.003 0.040 ↑ 1.0 1 1

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

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

CTE Scan on ""OrdersEntity"" (cost=0.00..0.02 rows=1 width=96) (actual time=0.035..0.037 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.004 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.015 0.015 ↑ 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.015 rows=27 loops=1)

16. 0.005 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.003 0.003 ↑ 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.003 rows=27 loops=1)

Planning time : 1.578 ms