explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eb3l : index isreversetx = true

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.239 ↑ 1.5 4 1

Nested Loop Left Join (cost=10.05..313.07 rows=6 width=624) (actual time=0.154..0.239 rows=4 loops=1)

2. 0.003 0.231 ↑ 1.5 4 1

Nested Loop Left Join (cost=9.63..310.06 rows=6 width=213) (actual time=0.148..0.231 rows=4 loops=1)

3. 0.002 0.224 ↑ 1.5 4 1

Nested Loop Left Join (cost=9.21..307.23 rows=6 width=207) (actual time=0.144..0.224 rows=4 loops=1)

4. 0.000 0.218 ↑ 1.5 4 1

Nested Loop Left Join (cost=8.79..259.49 rows=6 width=207) (actual time=0.139..0.218 rows=4 loops=1)

5. 0.001 0.210 ↑ 1.5 4 1

Nested Loop Left Join (cost=8.37..211.75 rows=6 width=207) (actual time=0.132..0.210 rows=4 loops=1)

6. 0.002 0.197 ↑ 1.5 4 1

Nested Loop Left Join (cost=8.08..209.77 rows=6 width=195) (actual time=0.125..0.197 rows=4 loops=1)

7. 0.001 0.191 ↑ 1.5 4 1

Nested Loop Left Join (cost=7.66..206.94 rows=6 width=189) (actual time=0.121..0.191 rows=4 loops=1)

8. 0.002 0.182 ↑ 1.5 4 1

Nested Loop Left Join (cost=7.24..204.10 rows=6 width=183) (actual time=0.114..0.182 rows=4 loops=1)

9. 0.002 0.176 ↑ 1.5 4 1

Nested Loop Left Join (cost=6.82..156.38 rows=6 width=183) (actual time=0.109..0.176 rows=4 loops=1)

10. 0.001 0.170 ↑ 1.5 4 1

Nested Loop Left Join (cost=6.39..108.66 rows=6 width=183) (actual time=0.105..0.170 rows=4 loops=1)

11. 0.003 0.157 ↑ 1.5 4 1

Nested Loop Left Join (cost=6.10..106.68 rows=6 width=171) (actual time=0.097..0.157 rows=4 loops=1)

12. 0.002 0.146 ↑ 1.5 4 1

Nested Loop Left Join (cost=5.69..104.00 rows=6 width=159) (actual time=0.088..0.146 rows=4 loops=1)

13. 0.002 0.140 ↑ 1.5 4 1

Nested Loop Left Join (cost=5.26..100.61 rows=6 width=147) (actual time=0.084..0.140 rows=4 loops=1)

14. 0.003 0.134 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.83..97.77 rows=6 width=143) (actual time=0.079..0.134 rows=4 loops=1)

15. 0.002 0.127 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.41..92.93 rows=6 width=131) (actual time=0.075..0.127 rows=4 loops=1)

16. 0.002 0.121 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.12..91.02 rows=6 width=127) (actual time=0.070..0.121 rows=4 loops=1)

  • Join Filter: tx.isreversetx
17. 0.001 0.087 ↑ 1.5 4 1

Nested Loop Left Join (cost=3.69..79.25 rows=6 width=132) (actual time=0.054..0.087 rows=4 loops=1)

18. 0.003 0.074 ↑ 1.5 4 1

Nested Loop (cost=3.27..76.43 rows=6 width=116) (actual time=0.048..0.074 rows=4 loops=1)

19. 0.001 0.053 ↑ 2.5 2 1

Nested Loop Left Join (cost=2.84..69.38 rows=5 width=76) (actual time=0.035..0.053 rows=2 loops=1)

20. 0.002 0.042 ↑ 2.5 2 1

Nested Loop Left Join (cost=2.41..66.56 rows=5 width=64) (actual time=0.030..0.042 rows=2 loops=1)

21. 0.002 0.030 ↑ 2.5 2 1

Nested Loop Left Join (cost=1.98..63.35 rows=5 width=60) (actual time=0.025..0.030 rows=2 loops=1)

22. 0.001 0.028 ↑ 2.5 2 1

Nested Loop Left Join (cost=1.56..59.32 rows=5 width=48) (actual time=0.023..0.028 rows=2 loops=1)

23. 0.003 0.023 ↑ 2.5 2 1

Nested Loop (cost=1.27..57.71 rows=5 width=44) (actual time=0.020..0.023 rows=2 loops=1)

24. 0.001 0.015 ↑ 3.0 1 1

Nested Loop (cost=0.84..20.94 rows=3 width=19) (actual time=0.014..0.015 rows=1 loops=1)

25. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using pk_creditdossier_1906105831 on creditdossier crd (cost=0.42..4.44 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (pkey = 272827)
  • Heap Fetches: 0
26. 0.005 0.005 ↑ 3.0 1 1

Index Scan using ix_credit_ix_credit_creditdossierfk_gl on credit c (cost=0.42..16.47 rows=3 width=19) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (creditdossierfk = 272827)
27. 0.005 0.005 ↑ 1.0 2 1

Index Scan using ix_tx_creditfk_txstatuscd on tx (cost=0.43..12.24 rows=2 width=25) (actual time=0.004..0.005 rows=2 loops=1)

  • Index Cond: ((creditfk = c.pkey) AND (txstatuscd = 3))
28. 0.004 0.004 ↓ 0.0 0 2

Index Scan using ix_credit2paymentout_ix_credit2paymentout_txfk on credit2paymentout c2p (cost=0.29..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)

  • Index Cond: (txfk = tx.pkey)
29. 0.000 0.000 ↓ 0.0 0 2

Index Scan using pk_payment_338816269 on payment po (cost=0.42..0.81 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=2)

  • Index Cond: (pkey = c2p.paymentoutfk)
30. 0.010 0.010 ↓ 0.0 0 2

Index Scan using ix_credit2paymentin_ix_credit2paymentin_txfk_gl on credit2paymentin c2pi (cost=0.43..0.63 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: (txfk = tx.pkey)
31. 0.010 0.010 ↓ 0.0 0 2

Index Scan using pk__paymenti__5e190d18db30bbc7 on paymentin pai (cost=0.43..0.56 rows=1 width=20) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: (pkey = c2pi.paymentinfk)
32. 0.018 0.018 ↑ 1.5 2 2

Index Scan using ix_txel_ix_txel_txfk on txel te (cost=0.43..1.38 rows=3 width=44) (actual time=0.008..0.009 rows=2 loops=2)

  • Index Cond: (txfk = tx.pkey)
33. 0.012 0.012 ↓ 0.0 0 4

Index Scan using ix_payment_ix_payment_txfk_gl on payment po2 (cost=0.42..0.46 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: (txfk = tx.pkey)
34. 0.032 0.032 ↓ 0.0 0 4

Index Scan using ix_tx_ix_tx_creditfk on tx tx2 (cost=0.43..1.95 rows=1 width=12) (actual time=0.008..0.008 rows=0 loops=4)

  • Index Cond: (creditfk = tx.creditfk)
  • Filter: (tx.reversedtx = txseqnr)
  • Rows Removed by Filter: 6
35. 0.004 0.004 ↓ 0.0 0 4

Index Scan using ix_credit2paymentout_ix_credit2paymentout_txfk on credit2paymentout c2p2 (cost=0.29..0.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (txfk = tx2.pkey)
36. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk_payment_338816269 on payment po3 (cost=0.42..0.81 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = c2p2.paymentoutfk)
37. 0.004 0.004 ↓ 0.0 0 4

Index Scan using ix_credit2paymentin_ix_credit2paymentin_txfk_gl on credit2paymentin c2pi2 (cost=0.43..0.46 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (txfk = tx2.pkey)
38. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk__paymenti__5e190d18db30bbc7 on paymentin pai2 (cost=0.43..0.56 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = c2pi2.paymentinfk)
39. 0.008 0.008 ↓ 0.0 0 4

Index Scan using ix_payment_ix_payment_txfk_gl on payment po4 (cost=0.42..0.44 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (txfk = tx2.pkey)
40. 0.012 0.012 ↓ 0.0 0 4

Index Scan using ix_internaltransfer_ix_internaltransfer_txoutfk on internaltransfer bt (cost=0.29..0.32 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: (txoutfk = tx.pkey)
  • Filter: ((transfereecreditfk IS NOT NULL) AND (lower((classname)::text) = 'bonustransfer'::text))
41. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk__credit__5e190d1888000db6 on credit btinc (cost=0.42..7.95 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = bt.transferringcreditfk)
42. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk__credit__5e190d1888000db6 on credit btinc2 (cost=0.42..7.95 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = bt.transfereecreditfk)
43. 0.008 0.008 ↓ 0.0 0 4

Index Scan using pk_creditdossier_1906105831 on creditdossier btincd (cost=0.42..0.47 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (pkey = btinc.creditdossierfk)
44. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk_creditdossier_1906105831 on creditdossier btincd2 (cost=0.42..0.47 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = btinc2.creditdossierfk)
45. 0.012 0.012 ↓ 0.0 0 4

Index Scan using ix_internaltransfer_ix_internaltransfer_txinfk on internaltransfer btout (cost=0.29..0.32 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: (txinfk = tx.pkey)
  • Filter: (lower((classname)::text) = 'bonustransfer'::text)
46. 0.008 0.008 ↓ 0.0 0 4

Index Scan using pk__credit__5e190d1888000db6 on credit btoutc (cost=0.42..7.96 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (pkey = btout.transferringcreditfk)
47. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk__credit__5e190d1888000db6 on credit btoutc2 (cost=0.42..7.96 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = btout.transfereecreditfk)
48. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk_creditdossier_1906105831 on creditdossier btoutcd (cost=0.42..0.47 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = btoutc.creditdossierfk)
49. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk_creditdossier_1906105831 on creditdossier btoutcd2 (cost=0.42..0.47 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = btoutc2.creditdossierfk)