explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DtWk

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.231 ↓ 2.0 4 1

Nested Loop Left Join (cost=10.07..141.96 rows=2 width=624) (actual time=0.134..0.231 rows=4 loops=1)

2. 0.004 0.223 ↓ 2.0 4 1

Nested Loop Left Join (cost=9.65..140.99 rows=2 width=213) (actual time=0.129..0.223 rows=4 loops=1)

3. 0.002 0.215 ↓ 2.0 4 1

Nested Loop Left Join (cost=9.23..140.07 rows=2 width=207) (actual time=0.124..0.215 rows=4 loops=1)

4. 0.002 0.209 ↓ 2.0 4 1

Nested Loop Left Join (cost=8.80..123.72 rows=2 width=207) (actual time=0.119..0.209 rows=4 loops=1)

5. 0.001 0.203 ↓ 2.0 4 1

Nested Loop Left Join (cost=8.38..107.37 rows=2 width=207) (actual time=0.115..0.203 rows=4 loops=1)

6. 0.000 0.190 ↓ 2.0 4 1

Nested Loop Left Join (cost=8.09..106.70 rows=2 width=195) (actual time=0.108..0.190 rows=4 loops=1)

7. 0.002 0.182 ↓ 2.0 4 1

Nested Loop Left Join (cost=7.67..105.78 rows=2 width=189) (actual time=0.102..0.182 rows=4 loops=1)

8. 0.002 0.176 ↓ 2.0 4 1

Nested Loop Left Join (cost=7.25..104.87 rows=2 width=183) (actual time=0.097..0.176 rows=4 loops=1)

9. 0.003 0.166 ↓ 2.0 4 1

Nested Loop Left Join (cost=6.82..88.52 rows=2 width=183) (actual time=0.090..0.166 rows=4 loops=1)

10. 0.003 0.159 ↓ 2.0 4 1

Nested Loop Left Join (cost=6.40..72.17 rows=2 width=183) (actual time=0.084..0.159 rows=4 loops=1)

11. 0.001 0.144 ↓ 2.0 4 1

Nested Loop Left Join (cost=6.11..71.50 rows=2 width=171) (actual time=0.077..0.144 rows=4 loops=1)

12. 0.003 0.139 ↓ 2.0 4 1

Nested Loop Left Join (cost=5.69..70.61 rows=2 width=159) (actual time=0.073..0.139 rows=4 loops=1)

13. 0.001 0.136 ↓ 2.0 4 1

Nested Loop Left Join (cost=5.26..69.51 rows=2 width=147) (actual time=0.072..0.136 rows=4 loops=1)

14. 0.003 0.131 ↓ 2.0 4 1

Nested Loop Left Join (cost=4.83..68.56 rows=2 width=143) (actual time=0.069..0.131 rows=4 loops=1)

15. 0.004 0.128 ↓ 2.0 4 1

Nested Loop Left Join (cost=4.42..66.94 rows=2 width=131) (actual time=0.068..0.128 rows=4 loops=1)

16. 0.001 0.124 ↓ 2.0 4 1

Nested Loop Left Join (cost=4.13..66.31 rows=2 width=127) (actual time=0.066..0.124 rows=4 loops=1)

  • Join Filter: tx.isreversetx
17. 0.002 0.095 ↓ 2.0 4 1

Nested Loop Left Join (cost=3.69..60.44 rows=2 width=132) (actual time=0.053..0.095 rows=4 loops=1)

18. 0.004 0.085 ↓ 2.0 4 1

Nested Loop Left Join (cost=3.28..59.46 rows=2 width=116) (actual time=0.049..0.085 rows=4 loops=1)

19. 0.002 0.073 ↓ 2.0 4 1

Nested Loop Left Join (cost=2.85..58.36 rows=2 width=104) (actual time=0.042..0.073 rows=4 loops=1)

20. 0.001 0.055 ↓ 2.0 4 1

Nested Loop Left Join (cost=2.42..56.76 rows=2 width=100) (actual time=0.035..0.055 rows=4 loops=1)

21. 0.001 0.050 ↓ 2.0 4 1

Nested Loop Left Join (cost=2.00..55.14 rows=2 width=88) (actual time=0.032..0.050 rows=4 loops=1)

22. 0.002 0.041 ↓ 2.0 4 1

Nested Loop (cost=1.71..54.49 rows=2 width=84) (actual time=0.029..0.041 rows=4 loops=1)

23. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (pkey = 272827)
  • Heap Fetches: 1
24. 0.002 0.030 ↓ 2.0 4 1

Nested Loop (cost=1.29..46.03 rows=2 width=84) (actual time=0.019..0.030 rows=4 loops=1)

25. 0.003 0.014 ↑ 1.0 2 1

Nested Loop (cost=0.86..41.86 rows=2 width=44) (actual time=0.012..0.014 rows=2 loops=1)

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.006 0.006 ↓ 2.0 2 1

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

  • Index Cond: ((creditfk = c.pkey) AND (txstatuscd = 3))
28. 0.014 0.014 ↑ 1.0 2 2

Index Scan using ix_txel_ix_txel_txfk on txel te (cost=0.43..2.07 rows=2 width=44) (actual time=0.006..0.007 rows=2 loops=2)

  • Index Cond: (txfk = tx.pkey)
29. 0.008 0.008 ↓ 0.0 0 4

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=4)

  • Index Cond: (txfk = tx.pkey)
30. 0.004 0.004 ↓ 0.0 0 4

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

  • Index Cond: (pkey = c2p.paymentoutfk)
31. 0.016 0.016 ↓ 0.0 0 4

Index Scan using ix_credit2paymentin_ix_credit2paymentin_txfk_gl on credit2paymentin c2pi (cost=0.43..0.79 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=4)

  • Index Cond: (txfk = tx.pkey)
32. 0.008 0.008 ↓ 0.0 0 4

Index Scan using pk__paymenti__5e190d18db30bbc7 on paymentin pai (cost=0.43..0.55 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (pkey = c2pi.paymentinfk)
33. 0.008 0.008 ↓ 0.0 0 4

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

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

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

  • Index Cond: (creditfk = tx.creditfk)
  • Filter: (tx.reversedtx = txseqnr)
  • Rows Removed by Filter: 6
35. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=4)

  • Index Cond: (txfk = tx2.pkey)
36. 0.000 0.000 ↓ 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.000..0.000 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.47 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=4)

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

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

  • Index Cond: (pkey = c2pi2.paymentinfk)
39. 0.004 0.004 ↓ 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.001..0.001 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.33 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..8.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=4)

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

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

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

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

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

Index Scan using pk_creditdossier_1906105831 on creditdossier btincd2 (cost=0.42..0.46 rows=1 width=14) (actual time=0.002..0.002 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.33 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.004 0.004 ↓ 0.0 0 4

Index Scan using pk__credit__5e190d1888000db6 on credit btoutc (cost=0.42..8.18 rows=1 width=8) (actual time=0.001..0.001 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..8.18 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.46 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.46 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (pkey = btoutc2.creditdossierfk)