explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jd8s

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

Hash Left Join (cost=126,118,853.90..192,756,647.92 rows=14,329,963 width=1,798) (actual rows= loops=)

  • Hash Cond: ((rrs.id = rrl.raw_statement_id) AND (dmp_arcrecpt."REDLINE" = rrl.external_line_number))
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=126,118,840.65..192,609,752.51 rows=14,329,963 width=1,698) (actual rows= loops=)

  • Hash Cond: ((dmp_arcrecpt."REDNO" = rrs.external_statement_number) AND (downtown_muma_external_system.id = rrs.data_source_system_id) AND ((COALESCE(dmp_arcrecpt."SITE_ID", ''::text)) = (rrs.external_site_code)::text))
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=126,112,454.08..192,387,645.97 rows=14,329,963 width=1,698) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on downtown_muma_external_system (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Append (cost=126,112,454.08..192,244,345.33 rows=14,329,963 width=1,694) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=126,112,454.08..160,881,970.17 rows=13,074,543 width=1,689) (actual rows= loops=)

  • Hash Cond: (dmp_songcat."SONGCAT_CACD" = dmp_category_1."CACD")
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=126,112,206.31..139,960,787.74 rows=13,074,543 width=1,220) (actual rows= loops=)

  • Hash Cond: (dmp_song."TUCD" = dmp_songcat."SONGCAT_TUCD")
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=117,326,440.18..130,977,889.60 rows=5,901,030 width=1,220) (actual rows= loops=)

  • Hash Cond: (COALESCE(dmp_arcrecpt."SITE_ID", ''::text) = COALESCE(dmp_site_2."SITE_ID", ''::text))
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=117,326,416.46..130,766,492.91 rows=1,934,764 width=1,188) (actual rows= loops=)

  • Hash Cond: (("*SELECT* 1".sthd_id = dmp_receipt_links."RECEIPT_NO") AND (COALESCE(COALESCE("*SELECT* 1".sthd_site_id, ''::text), ''::text) = COALESCE(dmp_arcrecpt."SITE_ID", ''::text)))
10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=694.27..4,543.94 rows=21,853 width=659) (actual rows= loops=)

  • Hash Cond: (COALESCE("*SELECT* 1".sthd_site_id, ''::text) = COALESCE(dmp_site_1."SITE_ID", ''::text))
11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=670.54..3,737.44 rows=7,165 width=659) (actual rows= loops=)

  • Hash Cond: (dmp_source_1."SOSGCD" = dmp_sourcegroup_1."SGCD")
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=668.82..3,714.77 rows=7,165 width=637) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".sthd_source_code = dmp_source_1."SOCD")
13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=37.81..3,064.95 rows=7,165 width=617) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".sthd_territory_code = dmp_teritory_1."TECD")
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10.10..3,018.31 rows=7,165 width=601) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".sthd_income_type = dmp_inctype_1."INCODE")
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=4.24..2,993.23 rows=7,165 width=577) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".sthd_company_id = dmp_company."CMCD")
16. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2,658.59 rows=26,056 width=812) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=0.00..492.13 rows=2,048 width=428) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_stats (cost=0.00..466.53 rows=2,048 width=426) (actual rows= loops=)

  • Filter: ("STHSTAT" <> 'C'::text)
19. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_arcstats (cost=0.00..1,796.10 rows=24,008 width=529) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=3.55..3.55 rows=55 width=89) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_company (cost=0.00..3.55 rows=55 width=89) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=4.83..4.83 rows=83 width=27) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_inctype dmp_inctype_1 (cost=0.00..4.83 rows=83 width=27) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash (cost=20.09..20.09 rows=609 width=20) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_teritory dmp_teritory_1 (cost=0.00..20.09 rows=609 width=20) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Hash (cost=445.45..445.45 rows=14,845 width=24) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_source dmp_source_1 (cost=0.00..445.45 rows=14,845 width=24) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash (cost=1.32..1.32 rows=32 width=24) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_sourcegroup dmp_sourcegroup_1 (cost=0.00..1.32 rows=32 width=24) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash (cost=16.10..16.10 rows=610 width=32) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_site dmp_site_1 (cost=0.00..16.10 rows=610 width=32) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=112,410,061.23..112,410,061.23 rows=55,706,464 width=569) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=103,017,191.15..112,410,061.23 rows=55,706,464 width=569) (actual rows= loops=)

  • Hash Cond: (dmp_arcrecpt."RETECD" = dmp_teritory."TECD")
34. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=103,017,163.45..112,262,786.44 rows=55,706,464 width=553) (actual rows= loops=)

  • Hash Cond: (dmp_arcrecpt."PRODUCTION_ID" = dmp_production."PRODUCTION_ID")
35. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=103,015,371.90..111,912,829.48 rows=55,706,464 width=438) (actual rows= loops=)

  • Hash Cond: (dmp_source."SOSGCD" = dmp_sourcegroup."SGCD")
36. 0.000 0.000 ↓ 0.0

Hash Join (cost=103,015,370.18..111,749,968.63 rows=55,706,464 width=416) (actual rows= loops=)

  • Hash Cond: (dmp_arcrecpt."RESRCCD" = dmp_source."SOCD")
37. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=103,014,739.17..111,603,066.40 rows=55,706,464 width=394) (actual rows= loops=)

  • Hash Cond: (dmp_inctype."CATEGORY" = dmp_category."CACD")
38. 0.000 0.000 ↓ 0.0

Hash Join (cost=103,014,491.40..111,456,483.93 rows=55,706,464 width=372) (actual rows= loops=)

  • Hash Cond: (dmp_arcrecpt."REDINC" = dmp_inctype."INCODE")
39. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=103,014,485.53..111,302,781.92 rows=55,706,464 width=347) (actual rows= loops=)

  • Hash Cond: (dmp_arcrecpt."REDTUCD" = dmp_song."TUTCD")
40. 0.000 0.000 ↓ 0.0

Merge Join (cost=102,886,494.25..106,559,966.39 rows=55,706,464 width=297) (actual rows= loops=)

  • Merge Cond: ((dmp_receipt_links."RECEIPT_NO" = dmp_arcrecpt."REDNO") AND (dmp_receipt_links."RECEIPT_LN" = dmp_arcrecpt."REDLINE") AND (dmp_receipt_links."SITE_ID" = dmp_arcrecpt."SITE_ID"))
41. 0.000 0.000 ↓ 0.0

Sort (cost=65,975,179.27..66,404,208.62 rows=171,611,739 width=202) (actual rows= loops=)

  • Sort Key: dmp_receipt_links."RECEIPT_NO", dmp_receipt_links."RECEIPT_LN", dmp_receipt_links."SITE_ID
42. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=168,864.77..8,482,657.06 rows=171,611,739 width=202) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."OWNER_ROLE_ID" = dmp_rcpt_im_val80_3."ID")
43. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=155,327.99..8,018,633.39 rows=171,611,739 width=175) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."RIGHT_OWNER_ID" = dmp_rcpt_im_val80_2."ID")
44. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=141,791.21..7,554,609.72 rows=171,611,739 width=148) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."ALBUM_ID" = dmp_rcpt_im_val80_1."ID")
45. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=128,254.43..7,090,586.04 rows=171,611,739 width=121) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."ISAN_ID" = dmp_rcpt_im_val16_3."ID")
46. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=105,370.13..6,617,218.02 rows=171,611,739 width=113) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."ISRC_ID" = dmp_rcpt_im_val16_2."ID")
47. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=82,485.83..6,143,849.99 rows=171,611,739 width=105) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."CAE_IPI_ID" = dmp_rcpt_im_val16_1."ID")
48. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59,601.53..5,670,481.96 rows=171,611,739 width=97) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."ISWC_ID" = dmp_rcpt_im_val16."ID")
49. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=36,717.24..5,197,113.94 rows=171,611,739 width=89) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."ARTIST_ID" = dmp_rcpt_im_val100."ID")
50. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,536.78..4,723,449.02 rows=171,611,739 width=74) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links."PRODUCTION_ID" = dmp_rcpt_im_val80."ID")
51. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_receipt_links (cost=0.00..4,259,425.39 rows=171,611,739 width=99) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash (cost=9,663.57..9,663.57 rows=309,857 width=35) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val80 (cost=0.00..9,663.57 rows=309,857 width=35) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Hash (cost=16,667.98..16,667.98 rows=520,998 width=23) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val100 (cost=0.00..16,667.98 rows=520,998 width=23) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Hash (cost=14,741.91..14,741.91 rows=651,391 width=16) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val16 (cost=0.00..14,741.91 rows=651,391 width=16) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Hash (cost=14,741.91..14,741.91 rows=651,391 width=16) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val16 dmp_rcpt_im_val16_1 (cost=0.00..14,741.91 rows=651,391 width=16) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Hash (cost=14,741.91..14,741.91 rows=651,391 width=16) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val16 dmp_rcpt_im_val16_2 (cost=0.00..14,741.91 rows=651,391 width=16) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Hash (cost=14,741.91..14,741.91 rows=651,391 width=16) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val16 dmp_rcpt_im_val16_3 (cost=0.00..14,741.91 rows=651,391 width=16) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Hash (cost=9,663.57..9,663.57 rows=309,857 width=35) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val80 dmp_rcpt_im_val80_1 (cost=0.00..9,663.57 rows=309,857 width=35) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Hash (cost=9,663.57..9,663.57 rows=309,857 width=35) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val80 dmp_rcpt_im_val80_2 (cost=0.00..9,663.57 rows=309,857 width=35) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Hash (cost=9,663.57..9,663.57 rows=309,857 width=35) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val80 dmp_rcpt_im_val80_3 (cost=0.00..9,663.57 rows=309,857 width=35) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Materialize (cost=36,910,845.91..37,574,371.87 rows=132,705,192 width=102) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Sort (cost=36,910,845.91..37,242,608.89 rows=132,705,192 width=102) (actual rows= loops=)

  • Sort Key: dmp_arcrecpt."REDNO", dmp_arcrecpt."REDLINE", dmp_arcrecpt."SITE_ID
72. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_arcrecpt (cost=0.00..4,491,860.92 rows=132,705,192 width=102) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Hash (cost=110,381.57..110,381.57 rows=790,857 width=54) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_song (cost=0.00..110,381.57 rows=790,857 width=54) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash (cost=4.83..4.83 rows=83 width=28) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_inctype (cost=0.00..4.83 rows=83 width=28) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Hash (cost=190.12..190.12 rows=4,612 width=23) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_category (cost=0.00..190.12 rows=4,612 width=23) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Hash (cost=445.45..445.45 rows=14,845 width=26) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_source (cost=0.00..445.45 rows=14,845 width=26) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Hash (cost=1.32..1.32 rows=32 width=24) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_sourcegroup (cost=0.00..1.32 rows=32 width=24) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Hash (cost=1,517.92..1,517.92 rows=21,890 width=119) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=414.21..1,517.92 rows=21,890 width=119) (actual rows= loops=)

  • Hash Cond: (COALESCE(dmp_production."SITE_ID", ''::text) = COALESCE(dmp_site."SITE_ID", ''::text))
85. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=390.48..710.10 rows=7,177 width=120) (actual rows= loops=)

  • Hash Cond: (dmp_production."MAIN_PROD_ID" = dmp_production_1."PRODUCTION_ID")
86. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_production (cost=0.00..300.77 rows=7,177 width=56) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Hash (cost=300.77..300.77 rows=7,177 width=27) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_production dmp_production_1 (cost=0.00..300.77 rows=7,177 width=27) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Hash (cost=16.10..16.10 rows=610 width=32) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_site (cost=0.00..16.10 rows=610 width=32) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash (cost=20.09..20.09 rows=609 width=20) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_teritory (cost=0.00..20.09 rows=609 width=20) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Hash (cost=16.10..16.10 rows=610 width=64) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_site dmp_site_2 (cost=0.00..16.10 rows=610 width=64) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Hash (cost=8,773,068.36..8,773,068.36 rows=1,015,821 width=8) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_songcat (cost=0.00..8,773,068.36 rows=1,015,821 width=8) (actual rows= loops=)

  • Filter: (SubPlan 1)
97.          

SubPlan (forSeq Scan)

98. 0.000 0.000 ↓ 0.0

Index Scan using dmp_category_pkey on dmp_category dmp_category_3 (cost=0.28..8.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ("CACD" = dmp_songcat."SONGCAT_CACD")
  • Filter: ("CATYPE" = 8)
99. 0.000 0.000 ↓ 0.0

Hash (cost=190.12..190.12 rows=4,612 width=23) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_category dmp_category_1 (cost=0.00..190.12 rows=4,612 width=23) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=26,222,598.55..31,147,425.72 rows=1,255,420 width=1,751) (actual rows= loops=)

  • Hash Cond: (COALESCE(dmp_recpts."SITE_ID", ''::text) = COALESCE(dmp_site_5."SITE_ID", ''::text))
102. 0.000 0.000 ↓ 0.0

Hash Join (cost=26,222,574.83..29,169,086.47 rows=411,613 width=1,279) (actual rows= loops=)

  • Hash Cond: (("*SELECT* 1_1".sthd_id = dmp_receipt_links_1."RECEIPT_NO") AND (COALESCE(COALESCE("*SELECT* 1_1".sthd_site_id, ''::text), ''::text) = COALESCE(dmp_recpts."SITE_ID", ''::text)))
103. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=694.27..4,543.94 rows=21,853 width=691) (actual rows= loops=)

  • Hash Cond: (COALESCE("*SELECT* 1_1".sthd_site_id, ''::text) = COALESCE(dmp_site_4."SITE_ID", ''::text))
104. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=670.54..3,737.44 rows=7,165 width=691) (actual rows= loops=)

  • Hash Cond: (dmp_source_3."SOSGCD" = dmp_sourcegroup_3."SGCD")
105. 0.000 0.000 ↓ 0.0

Hash Join (cost=668.82..3,714.77 rows=7,165 width=669) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1_1".sthd_source_code = dmp_source_3."SOCD")
106. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=37.81..3,064.95 rows=7,165 width=649) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1_1".sthd_territory_code = dmp_teritory_3."TECD")
107. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10.10..3,018.31 rows=7,165 width=633) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1_1".sthd_income_type = dmp_inctype_3."INCODE")
108. 0.000 0.000 ↓ 0.0

Hash Join (cost=4.24..2,993.23 rows=7,165 width=609) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1_1".sthd_company_id = dmp_company_1."CMCD")
109. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2,658.59 rows=26,056 width=812) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1_1 (cost=0.00..492.13 rows=2,048 width=428) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_stats dmp_stats_1 (cost=0.00..466.53 rows=2,048 width=426) (actual rows= loops=)

  • Filter: ("STHSTAT" <> 'C'::text)
112. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_arcstats dmp_arcstats_1 (cost=0.00..1,796.10 rows=24,008 width=529) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Hash (cost=3.55..3.55 rows=55 width=89) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_company dmp_company_1 (cost=0.00..3.55 rows=55 width=89) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Hash (cost=4.83..4.83 rows=83 width=27) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_inctype dmp_inctype_3 (cost=0.00..4.83 rows=83 width=27) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Hash (cost=20.09..20.09 rows=609 width=20) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_teritory dmp_teritory_3 (cost=0.00..20.09 rows=609 width=20) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Hash (cost=445.45..445.45 rows=14,845 width=24) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_source dmp_source_3 (cost=0.00..445.45 rows=14,845 width=24) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Hash (cost=1.32..1.32 rows=32 width=24) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_sourcegroup dmp_sourcegroup_3 (cost=0.00..1.32 rows=32 width=24) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Hash (cost=16.10..16.10 rows=610 width=32) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_site dmp_site_4 (cost=0.00..16.10 rows=610 width=32) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Hash (cost=25,095,079.97..25,095,079.97 rows=11,851,306 width=628) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,515,469.19..25,095,079.97 rows=11,851,306 width=628) (actual rows= loops=)

  • Hash Cond: (dmp_recpts."RETECD" = dmp_teritory_2."TECD")
127. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,515,441.49..25,063,726.10 rows=11,851,306 width=612) (actual rows= loops=)

  • Hash Cond: (dmp_recpts."PRODUCTION_ID" = dmp_production_2."PRODUCTION_ID")
128. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,513,649.95..24,987,863.88 rows=11,851,306 width=497) (actual rows= loops=)

  • Hash Cond: (dmp_source_2."SOSGCD" = dmp_sourcegroup_2."SGCD")
129. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,513,648.23..24,953,214.60 rows=11,851,306 width=475) (actual rows= loops=)

  • Hash Cond: (dmp_recpts."RESRCCD" = dmp_source_2."SOCD")
130. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,513,017.21..24,921,465.03 rows=11,851,306 width=453) (actual rows= loops=)

  • Hash Cond: (dmp_inctype_2."CATEGORY" = dmp_category_2."CACD")
131. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,512,769.44..24,890,085.20 rows=11,851,306 width=431) (actual rows= loops=)

  • Hash Cond: (dmp_recpts."REDINC" = dmp_inctype_2."INCODE")
132. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,512,763.58..24,857,381.15 rows=11,851,306 width=406) (actual rows= loops=)

  • Hash Cond: (dmp_recpts."REDTUCD" = dmp_song_1."TUTCD")
133. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,384,772.29..23,579,496.02 rows=11,851,306 width=360) (actual rows= loops=)

  • Hash Cond: ((dmp_receipt_links_1."RECEIPT_NO" = dmp_recpts."REDNO") AND (dmp_receipt_links_1."RECEIPT_LN" = dmp_recpts."REDLINE") AND (dmp_receipt_links_1."SITE_ID" = dmp_recpts."SITE_ID"))
134. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=168,864.77..8,482,657.06 rows=171,611,739 width=202) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."OWNER_ROLE_ID" = dmp_rcpt_im_val80_7."ID")
135. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=155,327.99..8,018,633.39 rows=171,611,739 width=175) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."RIGHT_OWNER_ID" = dmp_rcpt_im_val80_6."ID")
136. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=141,791.21..7,554,609.72 rows=171,611,739 width=148) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."ALBUM_ID" = dmp_rcpt_im_val80_5."ID")
137. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=128,254.43..7,090,586.04 rows=171,611,739 width=121) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."ISAN_ID" = dmp_rcpt_im_val16_7."ID")
138. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=105,370.13..6,617,218.02 rows=171,611,739 width=113) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."ISRC_ID" = dmp_rcpt_im_val16_6."ID")
139. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=82,485.83..6,143,849.99 rows=171,611,739 width=105) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."CAE_IPI_ID" = dmp_rcpt_im_val16_5."ID")
140. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59,601.53..5,670,481.96 rows=171,611,739 width=97) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."ISWC_ID" = dmp_rcpt_im_val16_4."ID")
141. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=36,717.24..5,197,113.94 rows=171,611,739 width=89) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."ARTIST_ID" = dmp_rcpt_im_val100_1."ID")
142. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,536.78..4,723,449.02 rows=171,611,739 width=74) (actual rows= loops=)

  • Hash Cond: (dmp_receipt_links_1."PRODUCTION_ID" = dmp_rcpt_im_val80_4."ID")
143. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_receipt_links dmp_receipt_links_1 (cost=0.00..4,259,425.39 rows=171,611,739 width=99) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Hash (cost=9,663.57..9,663.57 rows=309,857 width=35) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val80 dmp_rcpt_im_val80_4 (cost=0.00..9,663.57 rows=309,857 width=35) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Hash (cost=16,667.98..16,667.98 rows=520,998 width=23) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val100 dmp_rcpt_im_val100_1 (cost=0.00..16,667.98 rows=520,998 width=23) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Hash (cost=14,741.91..14,741.91 rows=651,391 width=16) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val16 dmp_rcpt_im_val16_4 (cost=0.00..14,741.91 rows=651,391 width=16) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Hash (cost=14,741.91..14,741.91 rows=651,391 width=16) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val16 dmp_rcpt_im_val16_5 (cost=0.00..14,741.91 rows=651,391 width=16) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Hash (cost=14,741.91..14,741.91 rows=651,391 width=16) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val16 dmp_rcpt_im_val16_6 (cost=0.00..14,741.91 rows=651,391 width=16) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Hash (cost=14,741.91..14,741.91 rows=651,391 width=16) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val16 dmp_rcpt_im_val16_7 (cost=0.00..14,741.91 rows=651,391 width=16) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Hash (cost=9,663.57..9,663.57 rows=309,857 width=35) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val80 dmp_rcpt_im_val80_5 (cost=0.00..9,663.57 rows=309,857 width=35) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Hash (cost=9,663.57..9,663.57 rows=309,857 width=35) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val80 dmp_rcpt_im_val80_6 (cost=0.00..9,663.57 rows=309,857 width=35) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Hash (cost=9,663.57..9,663.57 rows=309,857 width=35) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_rcpt_im_val80 dmp_rcpt_im_val80_7 (cost=0.00..9,663.57 rows=309,857 width=35) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Hash (cost=1,802,346.28..1,802,346.28 rows=34,529,728 width=165) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_recpts (cost=0.00..1,802,346.28 rows=34,529,728 width=165) (actual rows= loops=)

164. 0.000 0.000 ↓ 0.0

Hash (cost=110,381.57..110,381.57 rows=790,857 width=50) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_song dmp_song_1 (cost=0.00..110,381.57 rows=790,857 width=50) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Hash (cost=4.83..4.83 rows=83 width=28) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_inctype dmp_inctype_2 (cost=0.00..4.83 rows=83 width=28) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Hash (cost=190.12..190.12 rows=4,612 width=23) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_category dmp_category_2 (cost=0.00..190.12 rows=4,612 width=23) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Hash (cost=445.45..445.45 rows=14,845 width=26) (actual rows= loops=)

171. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_source dmp_source_2 (cost=0.00..445.45 rows=14,845 width=26) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Hash (cost=1.32..1.32 rows=32 width=24) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_sourcegroup dmp_sourcegroup_2 (cost=0.00..1.32 rows=32 width=24) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Hash (cost=1,517.92..1,517.92 rows=21,890 width=119) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=414.21..1,517.92 rows=21,890 width=119) (actual rows= loops=)

  • Hash Cond: (COALESCE(dmp_production_2."SITE_ID", ''::text) = COALESCE(dmp_site_3."SITE_ID", ''::text))
176. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=390.48..710.10 rows=7,177 width=120) (actual rows= loops=)

  • Hash Cond: (dmp_production_2."MAIN_PROD_ID" = dmp_production_3."PRODUCTION_ID")
177. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_production dmp_production_2 (cost=0.00..300.77 rows=7,177 width=56) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Hash (cost=300.77..300.77 rows=7,177 width=27) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_production dmp_production_3 (cost=0.00..300.77 rows=7,177 width=27) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Hash (cost=16.10..16.10 rows=610 width=32) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_site dmp_site_3 (cost=0.00..16.10 rows=610 width=32) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Hash (cost=20.09..20.09 rows=609 width=20) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_teritory dmp_teritory_2 (cost=0.00..20.09 rows=609 width=20) (actual rows= loops=)

184. 0.000 0.000 ↓ 0.0

Hash (cost=16.10..16.10 rows=610 width=64) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Seq Scan on dmp_site dmp_site_5 (cost=0.00..16.10 rows=610 width=64) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Hash (cost=5,943.30..5,943.30 rows=25,330 width=15) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Seq Scan on raw_receipt_statement rrs (cost=0.00..5,943.30 rows=25,330 width=15) (actual rows= loops=)

188. 0.000 0.000 ↓ 0.0

Hash (cost=11.30..11.30 rows=130 width=12) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Seq Scan on raw_receipt_line rrl (cost=0.00..11.30 rows=130 width=12) (actual rows= loops=)