explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hnK

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

Nested Loop Left Join (cost=4.99..95.40 rows=6 width=80) (actual time=0.095..0.146 rows=4 loops=1)

  • Buffers: shared hit=92
2. 0.004 0.138 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.70..93.42 rows=6 width=68) (actual time=0.092..0.138 rows=4 loops=1)

  • Buffers: shared hit=84
3. 0.003 0.130 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.41..91.44 rows=6 width=64) (actual time=0.088..0.130 rows=4 loops=1)

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

Nested Loop Left Join (cost=4.00..88.77 rows=6 width=68) (actual time=0.087..0.127 rows=4 loops=1)

  • Buffers: shared hit=76
5. 0.004 0.124 ↑ 1.5 4 1

Nested Loop Left Join (cost=3.57..85.93 rows=6 width=68) (actual time=0.086..0.124 rows=4 loops=1)

  • Buffers: shared hit=76
6. 0.003 0.120 ↑ 1.5 4 1

Nested Loop Left Join (cost=3.28..84.02 rows=6 width=68) (actual time=0.083..0.120 rows=4 loops=1)

  • Join Filter: tx.isreversetx
  • Buffers: shared hit=76
7. 0.002 0.093 ↑ 1.5 4 1

Nested Loop Left Join (cost=2.84..72.25 rows=6 width=73) (actual time=0.070..0.093 rows=4 loops=1)

  • Buffers: shared hit=44
8. 0.003 0.083 ↑ 1.5 4 1

Nested Loop (cost=2.43..69.57 rows=6 width=73) (actual time=0.065..0.083 rows=4 loops=1)

  • Buffers: shared hit=32
9. 0.000 0.066 ↑ 2.5 2 1

Nested Loop Left Join (cost=1.99..62.52 rows=5 width=33) (actual time=0.057..0.066 rows=2 loops=1)

  • Buffers: shared hit=24
10. 0.001 0.054 ↑ 2.5 2 1

Nested Loop Left Join (cost=1.56..59.32 rows=5 width=33) (actual time=0.050..0.054 rows=2 loops=1)

  • Buffers: shared hit=17
11. 0.003 0.047 ↑ 2.5 2 1

Nested Loop (cost=1.27..57.71 rows=5 width=33) (actual time=0.044..0.047 rows=2 loops=1)

  • Buffers: shared hit=13
12. 0.002 0.019 ↑ 3.0 1 1

Nested Loop (cost=0.84..20.94 rows=3 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Buffers: shared hit=8
13. 0.008 0.008 ↑ 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.008 rows=1 loops=1)

  • Index Cond: (pkey = 272827)
  • Heap Fetches: 0
  • Buffers: shared hit=4
14. 0.009 0.009 ↑ 3.0 1 1

Index Scan using ix_credit_ix_credit_creditdossierfk_gl on credit c (cost=0.42..16.47 rows=3 width=8) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (creditdossierfk = 272827)
  • Buffers: shared hit=4
15. 0.025 0.025 ↑ 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.025..0.025 rows=2 loops=1)

  • Index Cond: ((creditfk = c.pkey) AND (txstatuscd = 3))
  • Buffers: shared hit=5
16. 0.006 0.006 ↓ 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.003..0.003 rows=0 loops=2)

  • Index Cond: (txfk = tx.pkey)
  • Buffers: shared hit=4
17. 0.012 0.012 ↓ 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.006..0.006 rows=0 loops=2)

  • Index Cond: (txfk = tx.pkey)
  • Buffers: shared hit=7
18. 0.014 0.014 ↑ 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.006..0.007 rows=2 loops=2)

  • Index Cond: (txfk = tx.pkey)
  • Buffers: shared hit=8
19. 0.008 0.008 ↓ 0.0 0 4

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

  • Index Cond: (txfk = tx.pkey)
  • Heap Fetches: 0
  • Buffers: shared hit=12
20. 0.024 0.024 ↓ 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.006..0.006 rows=0 loops=4)

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

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

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

  • Index Cond: (txfk = tx2.pkey)
  • Heap Fetches: 0
24. 0.004 0.004 ↓ 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.001..0.001 rows=0 loops=4)

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

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

  • Index Cond: (txinfk = tx.pkey)
  • Filter: (lower((classname)::text) = 'bonustransfer'::text)
  • Buffers: shared hit=8