explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t7lf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

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

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,707,016.94..38,226,515.92 rows=986,192 width=221) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,707,016.37..35,541,196.82 rows=986,192 width=213) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,707,015.80..32,858,586.30 rows=986,192 width=210) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,707,015.23..30,174,001.48 rows=986,192 width=218) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,707,014.66..27,488,427.18 rows=986,192 width=207) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,707,013.53..22,099,942.20 rows=986,192 width=186) (actual rows= loops=)

  • Hash Cond: (o_account_ptpgroup_1.ptpgroup = o_ptpgroup_name_1.ptpgroup)
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,707,011.99..22,087,621.16 rows=986,192 width=180) (actual rows= loops=)

  • Hash Cond: (o_bvurequest_createdby.createdby = o_account_name_1.account)
9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,706,967.34..22,075,146.24 rows=986,192 width=173) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,706,966.20..16,702,734.67 rows=986,192 width=148) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,706,965.20..11,448,211.66 rows=986,192 width=127) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,706,964.63..9,816,226.59 rows=986,192 width=119) (actual rows= loops=)

  • Hash Cond: (o_bvurequest_createdby.createdby = o_account_ptpgroup.account)
13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,706,956.19..9,802,658.01 rows=986,192 width=105) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,706,955.62..7,117,398.31 rows=986,192 width=97) (actual rows= loops=)

  • Hash Cond: (o_bvurequest_contract.contract = o_contract_sasclientdwhid.contract)
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,633,952.39..6,992,076.41 rows=986,192 width=86) (actual rows= loops=)

  • Hash Cond: (o_contract_bvurequestsentby.bvurequestsentby = o_account_name.account)
16. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=5,633,907.74..6,979,601.49 rows=986,192 width=79) (actual rows= loops=)

  • Hash Cond: (o_bvurequest_actual.bvurequest = b.bvurequest)
17. 0.000 0.000 ↓ 0.0

Seq Scan on o_bvurequest_actual (cost=0.00..748,912.24 rows=42,498,824 width=12) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

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

19. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=139,754.17..5,609,059.34 rows=986,192 width=75) (actual rows= loops=)

  • Hash Cond: (o_contract_bvurequestsentby.bvurequestsentby = o_account_ptpgroup_1.account)
20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=139,749.02..5,596,666.03 rows=986,192 width=67) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (o_bvurequest_contract.contract = o_contract_contractdwhid.contract)
22. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (o_bvurequest_contract.contract = o_contract_bvurequestsentby.contract)
23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..2,699,586.82 rows=986,192 width=24) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

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

25. 0.000 0.000 ↓ 0.0

Index Scan using o_bvurequest_contract_pkey on o_bvurequest_contract (cost=0.57..2.72 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (bvurequest = b.bvurequest)
26. 0.000 0.000 ↓ 0.0

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

27. 0.000 0.000 ↓ 0.0

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

28. 0.000 0.000 ↓ 0.0

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

29. 0.000 0.000 ↓ 0.0

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

30. 0.000 0.000 ↓ 0.0

Index Scan using o_bvurequest_result_pkey on o_bvurequest_result (cost=0.57..2.72 rows=1 width=25) (actual rows= loops=)

  • Index Cond: (bvurequest = b.bvurequest)
31. 0.000 0.000 ↓ 0.0

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

32. 0.000 0.000 ↓ 0.0

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

33. 0.000 0.000 ↓ 0.0

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

34. 0.000 0.000 ↓ 0.0

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

35. 0.000 0.000 ↓ 0.0

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

36. 0.000 0.000 ↓ 0.0

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

37. 0.000 0.000 ↓ 0.0

Index Scan using o_bvurequest_createdby_pkey on o_bvurequest_createdby (cost=0.57..2.72 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (bvurequest = b.bvurequest)
38. 0.000 0.000 ↓ 0.0

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

39. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (o_account_ptpgroup.ptpgroup = o_ptpgroup_name.ptpgroup)
40. 0.000 0.000 ↓ 0.0

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

41. 0.000 0.000 ↓ 0.0

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

42. 0.000 0.000 ↓ 0.0

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

43. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (bvurequest = o_bvurequest_contract.bvurequest)
44. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..5.32 rows=1 width=37) (actual rows= loops=)

  • Join Filter: ((q_2.doc_ref)::text = (q1_2.refrd2)::text)
45. 0.000 0.000 ↓ 0.0

Index Scan using esb_dbz_bvu_doc_ref on esb_dbz q_2 (cost=0.57..2.72 rows=1 width=29) (actual rows= loops=)

  • Index Cond: ((bvu_request_id = q0.bvurequest) AND (bvu_request_id = q0.bvurequest))
46. 0.000 0.000 ↓ 0.0

Index Scan using gg_o_bvurequest_refrd2_bvureq on o_bvurequest_refrd2 q1_2 (cost=0.43..2.58 rows=1 width=25) (actual rows= loops=)

  • Index Cond: (bvurequest = q0.bvurequest)
47. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..5.44 rows=1 width=33) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Index Scan using o_bvurequest_ref_pkey on o_bvurequest_ref r (cost=0.56..2.72 rows=1 width=25) (actual rows= loops=)

  • Index Cond: ((bvurequest = q0.bvurequest) AND (bvurequest = q0.bvurequest))
49. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (bvurequest = r.bvurequest)
50. 0.000 0.000 ↓ 0.0

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

51. 0.000 0.000 ↓ 0.0

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

52. 0.000 0.000 ↓ 0.0

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

53. 0.000 0.000 ↓ 0.0

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

54. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..5.45 rows=1 width=37) (actual rows= loops=)

  • Join Filter: ((q1_1.refrd1)::text = (q_1.doc_ref)::text)
55. 0.000 0.000 ↓ 0.0

Index Scan using o_bvurequest_refrd1_pkey on o_bvurequest_refrd1 q1_1 (cost=0.57..2.72 rows=1 width=25) (actual rows= loops=)

  • Index Cond: (bvurequest = q0.bvurequest)
56. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((bvu_request_id = q0.bvurequest) AND (bvu_request_id = q0.bvurequest))
57. 0.000 0.000 ↓ 0.0

Index Scan using o_bvurequest_state_pkey on o_bvurequest_state (cost=0.57..2.72 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (bvurequest = b.bvurequest)
58. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (bvurequest = q0.bvurequest)
59. 0.000 0.000 ↓ 0.0

Index Scan using o_bvurequest_resultcode_pkey on o_bvurequest_resultcode (cost=0.57..2.72 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (bvurequest = b.bvurequest)
60. 0.000 0.000 ↓ 0.0

Index Scan using gg_o_bvurequest_respdate_unique on o_bvurequest_respdate (cost=0.57..2.72 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (bvurequest = b.bvurequest)
61. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.14..5.68 rows=1 width=226) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.00..4.93 rows=1 width=25) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((bvurequest = b.bvurequest) AND (bvurequest = b.bvurequest))
64. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..2.20 rows=1 width=17) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Index Only Scan using m_bank_pkey on m_bank q1 (cost=0.14..0.71 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (bank = q.bankreq)
66. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.28..1.48 rows=1 width=17) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Index Scan using o_bank_parent_pkey on o_bank_parent q3 (cost=0.14..0.72 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (bank = q1.bank)
68. 0.000 0.000 ↓ 0.0

Index Scan using o_bank_bik_pkey on o_bank_bik q4 (cost=0.14..0.73 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (bank = q3.parent)
69. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (bank = q1.bank)