explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qin7 : analyze buffers

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

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

  • Buffers: shared hit=96
2. 0.002 0.232 ↑ 1.5 4 1

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

  • Buffers: shared hit=96
3. 0.003 0.226 ↑ 1.5 4 1

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

  • Buffers: shared hit=96
4. 0.001 0.219 ↑ 1.5 4 1

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

  • Buffers: shared hit=96
5. 0.004 0.210 ↑ 1.5 4 1

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

  • Buffers: shared hit=96
6. 0.002 0.198 ↑ 1.5 4 1

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

  • Buffers: shared hit=88
7. 0.002 0.192 ↑ 1.5 4 1

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

  • Buffers: shared hit=88
8. 0.002 0.186 ↑ 1.5 4 1

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

  • Buffers: shared hit=88
9. 0.004 0.180 ↑ 1.5 4 1

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

  • Buffers: shared hit=88
10. 0.001 0.172 ↑ 1.5 4 1

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

  • Buffers: shared hit=88
11. 0.002 0.159 ↑ 1.5 4 1

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

  • Buffers: shared hit=80
12. 0.001 0.149 ↑ 1.5 4 1

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

  • Buffers: shared hit=80
13. 0.003 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)

  • Buffers: shared hit=80
14. 0.002 0.133 ↑ 1.5 4 1

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

  • Buffers: shared hit=80
15. 0.003 0.127 ↑ 1.5 4 1

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

  • Buffers: shared hit=80
16. 0.002 0.120 ↑ 1.5 4 1

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

  • Join Filter: tx.isreversetx
  • Buffers: shared hit=80
17. 0.001 0.086 ↑ 1.5 4 1

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

  • Buffers: shared hit=48
18. 0.003 0.073 ↑ 1.5 4 1

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

  • Buffers: shared hit=36
19. 0.000 0.052 ↑ 2.5 2 1

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

  • Buffers: shared hit=28
20. 0.001 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)

  • Buffers: shared hit=24
21. 0.002 0.031 ↑ 2.5 2 1

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

  • Buffers: shared hit=17
22. 0.002 0.029 ↑ 2.5 2 1

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

  • Buffers: shared hit=17
23. 0.002 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)

  • Buffers: shared hit=13
24. 0.002 0.016 ↑ 3.0 1 1

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

  • Buffers: shared hit=8
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
  • Buffers: shared hit=4
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)
  • Buffers: shared hit=4
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.005..0.005 rows=2 loops=1)

  • Index Cond: ((creditfk = c.pkey) AND (txstatuscd = 3))
  • Buffers: shared hit=5
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)
  • Buffers: shared hit=4
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.004..0.005 rows=0 loops=2)

  • Index Cond: (txfk = tx.pkey)
  • Buffers: shared hit=7
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)
  • Buffers: shared hit=4
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)
  • Buffers: shared hit=8
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)
  • Buffers: shared hit=12
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
  • Buffers: shared hit=32
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.008 0.008 ↓ 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.002..0.002 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))
  • Buffers: shared hit=8
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.004 0.004 ↓ 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.001..0.001 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.008 0.008 ↓ 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.002..0.002 rows=0 loops=4)

  • Index Cond: (txinfk = tx.pkey)
  • Filter: (lower((classname)::text) = 'bonustransfer'::text)
  • Buffers: shared hit=8
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.001..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)
Planning time : 9.042 ms
Execution time : 0.724 ms