explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4y5W

Settings
# exclusive inclusive rows x rows loops node
1. 8,167.088 180,343.670 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=5,707,018.08..44,086,572.50 rows=986,192 width=1,394) (actual time=33,150.008..180,343.670 rows=986,192 loops=1)

2. 1,006.416 154,425.126 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=5,707,016.94..38,226,515.92 rows=986,192 width=221) (actual time=33,149.921..154,425.126 rows=986,192 loops=1)

3. 1,208.445 144,542.982 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=5,707,016.37..35,541,196.82 rows=986,192 width=213) (actual time=33,149.903..144,542.982 rows=986,192 loops=1)

4. 617.812 136,431.193 ↑ 1.0 986,192 1

Nested Loop (cost=5,707,015.80..32,858,586.30 rows=986,192 width=210) (actual time=33,149.881..136,431.193 rows=986,192 loops=1)

5. 1,006.807 130,882.421 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=5,707,015.23..30,174,001.48 rows=986,192 width=218) (actual time=33,149.870..130,882.421 rows=986,192 loops=1)

6. 1,306.467 120,013.694 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=5,707,014.66..27,488,427.18 rows=986,192 width=207) (actual time=33,149.840..120,013.694 rows=986,192 loops=1)

7. 771.053 110,817.691 ↑ 1.0 986,192 1

Hash Left Join (cost=5,707,013.53..22,099,942.20 rows=986,192 width=186) (actual time=33,149.802..110,817.691 rows=986,192 loops=1)

  • Hash Cond: (o_account_ptpgroup_1.ptpgroup = o_ptpgroup_name_1.ptpgroup)
8. 880.920 110,046.620 ↑ 1.0 986,192 1

Hash Left Join (cost=5,707,011.99..22,087,621.16 rows=986,192 width=180) (actual time=33,149.769..110,046.620 rows=986,192 loops=1)

  • Hash Cond: (o_bvurequest_createdby.createdby = o_account_name_1.account)
9. 1,045.571 109,165.469 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=5,706,967.34..22,075,146.24 rows=986,192 width=173) (actual time=33,149.528..109,165.469 rows=986,192 loops=1)

10. 1,363.654 98,257.978 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=5,706,966.20..16,702,734.67 rows=986,192 width=148) (actual time=33,149.461..98,257.978 rows=986,192 loops=1)

11. 1,023.324 88,018.596 ↑ 1.0 986,192 1

Nested Loop (cost=5,706,965.20..11,448,211.66 rows=986,192 width=127) (actual time=33,149.440..88,018.596 rows=986,192 loops=1)

12. 961.739 82,064.312 ↑ 1.0 986,192 1

Hash Left Join (cost=5,706,964.63..9,816,226.59 rows=986,192 width=119) (actual time=33,148.844..82,064.312 rows=986,192 loops=1)

  • Hash Cond: (o_bvurequest_createdby.createdby = o_account_ptpgroup.account)
13. 1,003.802 81,102.452 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=5,706,956.19..9,802,658.01 rows=986,192 width=105) (actual time=33,148.707..81,102.452 rows=986,192 loops=1)

14. 3,401.409 72,209.114 ↑ 1.0 986,192 1

Hash Left Join (cost=5,706,955.62..7,117,398.31 rows=986,192 width=97) (actual time=33,148.666..72,209.114 rows=986,192 loops=1)

  • Hash Cond: (o_bvurequest_contract.contract = o_contract_sasclientdwhid.contract)
15. 414.550 67,531.067 ↑ 1.0 986,192 1

Hash Left Join (cost=5,633,952.39..6,992,076.41 rows=986,192 width=86) (actual time=31,841.463..67,531.067 rows=986,192 loops=1)

  • Hash Cond: (o_contract_bvurequestsentby.bvurequestsentby = o_account_name.account)
16. 22,654.869 67,116.253 ↑ 1.0 986,192 1

Hash Right Join (cost=5,633,907.74..6,979,601.49 rows=986,192 width=79) (actual time=31,841.184..67,116.253 rows=986,192 loops=1)

  • Hash Cond: (o_bvurequest_actual.bvurequest = b.bvurequest)
17. 12,630.378 12,630.378 ↑ 1.0 42,459,372 1

Seq Scan on o_bvurequest_actual (cost=0.00..748,912.24 rows=42,498,824 width=12) (actual time=8.549..12,630.378 rows=42,459,372 loops=1)

18. 723.423 31,831.006 ↑ 1.0 986,192 1

Hash (cost=5,609,059.34..5,609,059.34 rows=986,192 width=75) (actual time=31,831.006..31,831.006 rows=986,192 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 14234kB
19. 473.566 31,107.583 ↑ 1.0 986,192 1

Hash Left Join (cost=139,754.17..5,609,059.34 rows=986,192 width=75) (actual time=2,528.432..31,107.583 rows=986,192 loops=1)

  • Hash Cond: (o_contract_bvurequestsentby.bvurequestsentby = o_account_ptpgroup_1.account)
20. 313.513 30,633.096 ↑ 1.0 986,192 1

Nested Loop Left Join (cost=139,749.02..5,596,666.03 rows=986,192 width=67) (actual time=2,527.489..30,633.096 rows=986,192 loops=1)

21. 1,456.614 11,581.935 ↑ 1.0 986,192 1

Hash Left Join (cost=139,748.45..2,911,051.03 rows=986,192 width=50) (actual time=2,497.464..11,581.935 rows=986,192 loops=1)

  • Hash Cond: (o_bvurequest_contract.contract = o_contract_contractdwhid.contract)
22. 1,402.217 8,850.417 ↑ 1.0 986,192 1

Hash Left Join (cost=66,815.86..2,799,293.77 rows=986,192 width=32) (actual time=1,221.924..8,850.417 rows=986,192 loops=1)

  • Hash Cond: (o_bvurequest_contract.contract = o_contract_bvurequestsentby.contract)
23. 159.490 6,301.525 ↑ 1.0 986,192 1

Nested Loop (cost=0.57..2,699,586.82 rows=986,192 width=24) (actual time=36.456..6,301.525 rows=986,192 loops=1)

24. 224.883 224.883 ↑ 1.0 986,192 1

Seq Scan on out_accnumberreq_to_update b (cost=0.00..14,225.92 rows=986,192 width=8) (actual time=0.023..224.883 rows=986,192 loops=1)

25. 5,917.152 5,917.152 ↑ 1.0 1 986,192

Index Scan using o_bvurequest_contract_pkey on o_bvurequest_contract (cost=0.57..2.72 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=986,192)

  • Index Cond: (bvurequest = b.bvurequest)
26. 506.666 1,146.675 ↑ 1.0 1,819,035 1

Hash (cost=35,194.35..35,194.35 rows=1,819,035 width=16) (actual time=1,146.675..1,146.675 rows=1,819,035 loops=1)

  • Buckets: 524288 Batches: 8 Memory Usage: 14768kB
27. 640.009 640.009 ↑ 1.0 1,819,035 1

Seq Scan on o_contract_bvurequestsentby (cost=0.00..35,194.35 rows=1,819,035 width=16) (actual time=10.235..640.009 rows=1,819,035 loops=1)

28. 619.007 1,274.904 ↓ 1.0 1,886,572 1

Hash (cost=36,472.82..36,472.82 rows=1,885,582 width=26) (actual time=1,274.904..1,274.904 rows=1,886,572 loops=1)

  • Buckets: 262144 Batches: 16 Memory Usage: 9415kB
29. 655.897 655.897 ↓ 1.0 1,886,572 1

Seq Scan on o_contract_contractdwhid (cost=0.00..36,472.82 rows=1,885,582 width=26) (actual time=8.958..655.897 rows=1,886,572 loops=1)

30. 18,737.648 18,737.648 ↑ 1.0 1 986,192

Index Scan using o_bvurequest_result_pkey on o_bvurequest_result (cost=0.57..2.72 rows=1 width=25) (actual time=0.019..0.019 rows=1 loops=986,192)

  • Index Cond: (bvurequest = b.bvurequest)
31. 0.028 0.921 ↑ 1.0 140 1

Hash (cost=3.40..3.40 rows=140 width=16) (actual time=0.921..0.921 rows=140 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
32. 0.893 0.893 ↑ 1.0 140 1

Seq Scan on o_account_ptpgroup o_account_ptpgroup_1 (cost=0.00..3.40 rows=140 width=16) (actual time=0.012..0.893 rows=140 loops=1)

33. 0.083 0.264 ↑ 1.0 429 1

Hash (cost=39.29..39.29 rows=429 width=23) (actual time=0.264..0.264 rows=429 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
34. 0.181 0.181 ↑ 1.0 429 1

Seq Scan on o_account_name (cost=0.00..39.29 rows=429 width=23) (actual time=0.009..0.181 rows=429 loops=1)

35. 594.182 1,276.638 ↓ 1.0 1,887,001 1

Hash (cost=36,515.88..36,515.88 rows=1,886,988 width=27) (actual time=1,276.638..1,276.638 rows=1,887,001 loops=1)

  • Buckets: 262144 Batches: 16 Memory Usage: 9423kB
36. 682.456 682.456 ↓ 1.0 1,887,001 1

Seq Scan on o_contract_sasclientdwhid (cost=0.00..36,515.88 rows=1,886,988 width=27) (actual time=6.895..682.456 rows=1,887,001 loops=1)

37. 7,889.536 7,889.536 ↑ 1.0 1 986,192

Index Scan using o_bvurequest_createdby_pkey on o_bvurequest_createdby (cost=0.57..2.72 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=986,192)

  • Index Cond: (bvurequest = b.bvurequest)
38. 0.025 0.121 ↑ 1.0 140 1

Hash (cost=6.69..6.69 rows=140 width=22) (actual time=0.121..0.121 rows=140 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
39. 0.043 0.096 ↑ 1.0 140 1

Hash Left Join (cost=1.54..6.69 rows=140 width=22) (actual time=0.046..0.096 rows=140 loops=1)

  • Hash Cond: (o_account_ptpgroup.ptpgroup = o_ptpgroup_name.ptpgroup)
40. 0.026 0.026 ↑ 1.0 140 1

Seq Scan on o_account_ptpgroup (cost=0.00..3.40 rows=140 width=16) (actual time=0.012..0.026 rows=140 loops=1)

41. 0.014 0.027 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=22) (actual time=0.027..0.027 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
42. 0.013 0.013 ↑ 1.0 24 1

Seq Scan on o_ptpgroup_name (cost=0.00..1.24 rows=24 width=22) (actual time=0.007..0.013 rows=24 loops=1)

43. 4,930.960 4,930.960 ↑ 1.0 1 986,192

Index Only Scan using m_bvurequest_pkey on m_bvurequest q0 (cost=0.57..1.65 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=986,192)

  • Index Cond: (bvurequest = o_bvurequest_contract.bvurequest)
  • Heap Fetches: 0
44. 553.564 8,875.728 ↓ 0.0 0 986,192

Nested Loop (cost=1.00..5.32 rows=1 width=37) (actual time=0.009..0.009 rows=0 loops=986,192)

  • Join Filter: ((q_2.doc_ref)::text = (q1_2.refrd2)::text)
  • Rows Removed by Join Filter: 0
45. 6,903.344 6,903.344 ↓ 0.0 0 986,192

Index Scan using esb_dbz_bvu_doc_ref on esb_dbz q_2 (cost=0.57..2.72 rows=1 width=29) (actual time=0.006..0.007 rows=0 loops=986,192)

  • Index Cond: ((bvu_request_id = q0.bvurequest) AND (bvu_request_id = q0.bvurequest))
46. 1,418.820 1,418.820 ↓ 0.0 0 472,940

Index Scan using gg_o_bvurequest_refrd2_bvureq on o_bvurequest_refrd2 q1_2 (cost=0.43..2.58 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=472,940)

  • Index Cond: (bvurequest = q0.bvurequest)
47. 771.052 9,861.920 ↓ 0.0 0 986,192

Nested Loop (cost=1.13..5.44 rows=1 width=33) (actual time=0.010..0.010 rows=0 loops=986,192)

48. 5,917.152 5,917.152 ↓ 0.0 0 986,192

Index Scan using o_bvurequest_ref_pkey on o_bvurequest_ref r (cost=0.56..2.72 rows=1 width=25) (actual time=0.005..0.006 rows=0 loops=986,192)

  • Index Cond: ((bvurequest = q0.bvurequest) AND (bvurequest = q0.bvurequest))
49. 3,173.716 3,173.716 ↑ 1.0 1 453,388

Index Scan using o_bvurequest_sentdate_pkey on o_bvurequest_sentdate r1 (cost=0.57..2.72 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=453,388)

  • Index Cond: (bvurequest = r.bvurequest)
50. 0.081 0.231 ↑ 1.0 429 1

Hash (cost=39.29..39.29 rows=429 width=23) (actual time=0.231..0.231 rows=429 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
51. 0.150 0.150 ↑ 1.0 429 1

Seq Scan on o_account_name o_account_name_1 (cost=0.00..39.29 rows=429 width=23) (actual time=0.010..0.150 rows=429 loops=1)

52. 0.006 0.018 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=22) (actual time=0.018..0.018 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
53. 0.012 0.012 ↑ 1.0 24 1

Seq Scan on o_ptpgroup_name o_ptpgroup_name_1 (cost=0.00..1.24 rows=24 width=22) (actual time=0.009..0.012 rows=24 loops=1)

54. 1,566.825 7,889.536 ↓ 0.0 0 986,192

Nested Loop (cost=1.14..5.45 rows=1 width=37) (actual time=0.008..0.008 rows=0 loops=986,192)

  • Join Filter: ((q1_1.refrd1)::text = (q_1.doc_ref)::text)
  • Rows Removed by Join Filter: 0
55. 4,930.960 4,930.960 ↓ 0.0 0 986,192

Index Scan using o_bvurequest_refrd1_pkey on o_bvurequest_refrd1 q1_1 (cost=0.57..2.72 rows=1 width=25) (actual time=0.005..0.005 rows=0 loops=986,192)

  • Index Cond: (bvurequest = q0.bvurequest)
56. 1,391.751 1,391.751 ↑ 1.0 1 463,917

Index Scan using esb_dbz_bvu_doc_ref on esb_dbz q_1 (cost=0.57..2.72 rows=1 width=29) (actual time=0.003..0.003 rows=1 loops=463,917)

  • Index Cond: ((bvu_request_id = q0.bvurequest) AND (bvu_request_id = q0.bvurequest))
57. 9,861.920 9,861.920 ↑ 1.0 1 986,192

Index Scan using o_bvurequest_state_pkey on o_bvurequest_state (cost=0.57..2.72 rows=1 width=19) (actual time=0.010..0.010 rows=1 loops=986,192)

  • Index Cond: (bvurequest = b.bvurequest)
58. 4,930.960 4,930.960 ↑ 1.0 1 986,192

Index Scan using m_bvurequest_pkey on m_bvurequest b3 (cost=0.57..2.72 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=986,192)

  • Index Cond: (bvurequest = q0.bvurequest)
59. 6,903.344 6,903.344 ↑ 1.0 1 986,192

Index Scan using o_bvurequest_resultcode_pkey on o_bvurequest_resultcode (cost=0.57..2.72 rows=1 width=11) (actual time=0.007..0.007 rows=1 loops=986,192)

  • Index Cond: (bvurequest = b.bvurequest)
60. 8,875.728 8,875.728 ↑ 1.0 1 986,192

Index Scan using gg_o_bvurequest_respdate_unique on o_bvurequest_respdate (cost=0.57..2.72 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=986,192)

  • Index Cond: (bvurequest = b.bvurequest)
61. 1,972.384 17,751.456 ↑ 1.0 1 986,192

Nested Loop Left Join (cost=1.14..5.68 rows=1 width=226) (actual time=0.016..0.018 rows=1 loops=986,192)

62. 986.192 13,806.688 ↑ 1.0 1 986,192

Nested Loop Left Join (cost=1.00..4.93 rows=1 width=25) (actual time=0.013..0.014 rows=1 loops=986,192)

63. 5,917.152 5,917.152 ↑ 1.0 1 986,192

Index Scan using o_bvurequest_bankreq_pkey on o_bvurequest_bankreq q (cost=0.57..2.73 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=986,192)

  • Index Cond: ((bvurequest = b.bvurequest) AND (bvurequest = b.bvurequest))
64. 986.192 6,903.344 ↑ 1.0 1 986,192

Nested Loop Left Join (cost=0.43..2.20 rows=1 width=17) (actual time=0.005..0.007 rows=1 loops=986,192)

65. 1,972.384 1,972.384 ↑ 1.0 1 986,192

Index Only Scan using m_bank_pkey on m_bank q1 (cost=0.14..0.71 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=986,192)

  • Index Cond: (bank = q.bankreq)
  • Heap Fetches: 0
66. 986.192 3,944.768 ↑ 1.0 1 986,192

Nested Loop Left Join (cost=0.28..1.48 rows=1 width=17) (actual time=0.003..0.004 rows=1 loops=986,192)

67. 2,958.576 2,958.576 ↑ 1.0 1 986,192

Index Scan using o_bank_parent_pkey on o_bank_parent q3 (cost=0.14..0.72 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=986,192)

  • Index Cond: (bank = q1.bank)
68. 0.000 0.000 ↓ 0.0 0 983,392

Index Scan using o_bank_bik_pkey on o_bank_bik q4 (cost=0.14..0.73 rows=1 width=17) (actual time=0.000..0.000 rows=0 loops=983,392)

  • Index Cond: (bank = q3.parent)
69. 1,972.384 1,972.384 ↑ 1.0 1 986,192

Index Scan using o_bank_bik_pkey on o_bank_bik q2 (cost=0.14..0.72 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=986,192)

  • Index Cond: (bank = q1.bank)