explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IsFo

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

Hash Join (cost=269.85..481.18 rows=445 width=125,355) (never executed)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=254.92..460.14 rows=445 width=120,421) (never executed)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=252.73..456.26 rows=445 width=120,409) (never executed)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=238.44..436.38 rows=445 width=120,080) (never executed)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=224.16..415.97 rows=445 width=119,751) (never executed)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=222.59..412.73 rows=445 width=116,563) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=219.47..407.41 rows=445 width=115,385) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=217.93..401.77 rows=445 width=114,269) (never executed)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=216.37..396.32 rows=445 width=111,081) (never executed)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=212.54..388.02 rows=445 width=109,930) (never executed)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=204.69..374.69 rows=445 width=107,109) (never executed)

12. 0.000 0.000 ↓ 0.0

Hash Join (cost=198.88..363.49 rows=445 width=106,523) (never executed)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=196.67..355.6 rows=445 width=105,957) (never executed)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=191.91..349.17 rows=445 width=99,635) (never executed)

15. 0.000 0.000 ↓ 0.0

Hash Join (cost=187.16..339.78 rows=445 width=93,321) (never executed)

16. 0.000 0.000 ↓ 0.0

Hash Join (cost=178.26..327.45 rows=445 width=92,012) (never executed)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=176.14..323.29 rows=445 width=91,074) (never executed)

18. 0.000 0.000 ↓ 0.0

Hash Join (cost=174.03..319.4 rows=445 width=90,128) (never executed)

19. 0.000 0.000 ↓ 0.0

Hash Join (cost=170.9..310.16 rows=445 width=88,918) (never executed)

20. 0.000 0.000 ↓ 0.0

Hash Join (cost=155.98..289.12 rows=445 width=83,952) (never executed)

21. 0.000 0.000 ↓ 0.0

Hash Join (cost=153.99..282.95 rows=445 width=83,929) (never executed)

22. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.76..271.04 rows=445 width=78,230) (never executed)

23. 0.000 0.000 ↓ 0.0

Hash Join (cost=139.19..260.35 rows=445 width=76,064) (never executed)

24. 0.000 0.000 ↓ 0.0

Hash Join (cost=132.58..251.67 rows=445 width=73,308) (never executed)

25. 0.000 0.000 ↓ 0.0

Hash Join (cost=126.95..239.92 rows=445 width=70,081) (never executed)

26. 0.000 0.000 ↓ 0.0

Hash Join (cost=122.56..233.15 rows=445 width=70,008) (never executed)

27. 0.000 0.000 ↓ 0.0

Hash Join (cost=120.86..228.18 rows=445 width=66,878) (never executed)

28. 0.000 0.000 ↓ 0.0

Hash Join (cost=109.51..210.71 rows=445 width=65,712) (never executed)

29. 0.000 0.000 ↓ 0.0

Hash Join (cost=101.36..200.87 rows=445 width=53,792) (never executed)

30. 0.000 0.000 ↓ 0.0

Hash Join (cost=92.46..185.85 rows=445 width=52,491) (never executed)

31. 0.000 0.000 ↓ 0.0

Hash Join (cost=90.27..180.03 rows=445 width=51,886) (never executed)

32. 0.000 0.000 ↓ 0.0

Hash Join (cost=88.7..176.57 rows=445 width=48,698) (never executed)

33. 0.000 0.000 ↓ 0.0

Hash Join (cost=73.78..155.75 rows=445 width=43,764) (never executed)

34. 0.000 0.000 ↓ 0.0

Hash Join (cost=71.61..148.98 rows=445 width=43,759) (never executed)

35. 0.000 0.000 ↓ 0.0

Hash Join (cost=70.07..143.4 rows=445 width=42,635) (never executed)

36. 0.000 0.000 ↓ 0.0

Hash Join (cost=67.85..135.93 rows=445 width=42,069) (never executed)

37. 0.000 0.000 ↓ 0.0

Hash Join (cost=66.29..130 rows=445 width=38,881) (never executed)

38. 0.000 0.000 ↓ 0.0

Hash Join (cost=61.54..121.27 rows=445 width=32,519) (never executed)

39. 0.000 0.000 ↓ 0.0

Hash Join (cost=56.57..110.19 rows=445 width=31,392) (never executed)

40. 0.000 0.000 ↓ 0.0

Hash Join (cost=47.66..97.45 rows=445 width=30,067) (never executed)

41. 0.000 0.000 ↓ 0.0

Hash Join (cost=45.55..93.58 rows=445 width=29,105) (never executed)

42. 0.000 0.000 ↓ 0.0

Hash Join (cost=40.6..86.02 rows=445 width=28,026) (never executed)

43. 0.000 0.000 ↓ 0.0

Hash Join (cost=35.85..78.13 rows=445 width=21,712) (never executed)

44. 0.000 0.000 ↓ 0.0

Hash Join (cost=31.07..67.3 rows=445 width=13,692) (never executed)

45. 0.000 0.000 ↓ 0.0

Hash Join (cost=25.67..58.72 rows=445 width=13,598) (never executed)

46. 0.000 0.000 ↓ 0.0

Hash Join (cost=20.9..47.89 rows=445 width=5,530) (never executed)

47. 0.000 0.000 ↓ 0.0

Hash Join (cost=14.29..38.86 rows=445 width=2,758) (never executed)

48. 0.000 0.000 ↓ 0.0

Seq Scan on material_line t0 (cost=0..22.45 rows=445 width=2,429) (never executed)

49. 0.000 0.000 ↓ 0.0

Hash (cost=11.35..11.35 rows=235 width=337) (never executed)

50. 0.000 0.000 ↓ 0.0

Seq Scan on delivery_information t1 (cost=0..11.35 rows=235 width=337) (never executed)

51. 0.000 0.000 ↓ 0.0

Hash (cost=5.16..5.16 rows=116 width=2,780) (never executed)

52. 0.000 0.000 ↓ 0.0

Seq Scan on delivery_note_line t13 (cost=0..5.16 rows=116 width=2,780) (never executed)

53. 0.000 0.000 ↓ 0.0

Hash (cost=3.79..3.79 rows=79 width=8,076) (never executed)

54. 0.000 0.000 ↓ 0.0

Seq Scan on material t30 (cost=0..3.79 rows=79 width=8,076) (never executed)

55. 0.000 0.000 ↓ 0.0

Hash (cost=3.51..3.51 rows=151 width=102) (never executed)

56. 0.000 0.000 ↓ 0.0

Seq Scan on material_line_status_time t42 (cost=0..3.51 rows=151 width=102) (never executed)

57. 0.000 0.000 ↓ 0.0

Hash (cost=3.79..3.79 rows=79 width=8,028) (never executed)

58. 0.000 0.000 ↓ 0.0

Seq Scan on material t43 (cost=0..3.79 rows=79 width=8,028) (never executed)

59. 0.000 0.000 ↓ 0.0

Hash (cost=3.78..3.78 rows=78 width=6,322) (never executed)

60. 0.000 0.000 ↓ 0.0

Seq Scan on order_line t44 (cost=0..3.78 rows=78 width=6,322) (never executed)

61. 0.000 0.000 ↓ 0.0

Hash (cost=3.31..3.31 rows=131 width=1,087) (never executed)

62. 0.000 0.000 ↓ 0.0

Seq Scan on request_group t45 (cost=0..3.31 rows=131 width=1,087) (never executed)

63. 0.000 0.000 ↓ 0.0

Hash (cost=2.05..2.05 rows=5 width=970) (never executed)

64. 0.000 0.000 ↓ 0.0

Seq Scan on custom_document t2 (cost=0..2.05 rows=5 width=970) (never executed)

65. 0.000 0.000 ↓ 0.0

Hash (cost=7.29..7.29 rows=129 width=1,333) (never executed)

66. 0.000 0.000 ↓ 0.0

Seq Scan on request_list t8 (cost=0..7.29 rows=129 width=1,333) (never executed)

67. 0.000 0.000 ↓ 0.0

Hash (cost=3.32..3.32 rows=132 width=1,135) (never executed)

68. 0.000 0.000 ↓ 0.0

Seq Scan on delivery_note t14 (cost=0..3.32 rows=132 width=1,135) (never executed)

69. 0.000 0.000 ↓ 0.0

Hash (cost=3.78..3.78 rows=78 width=6,370) (never executed)

70. 0.000 0.000 ↓ 0.0

Seq Scan on order_line t15 (cost=0..3.78 rows=78 width=6,370) (never executed)

71. 0.000 0.000 ↓ 0.0

Hash (cost=1.25..1.25 rows=25 width=3,196) (never executed)

72. 0.000 0.000 ↓ 0.0

Seq Scan on change_id t31 (cost=0..1.25 rows=25 width=3,196) (never executed)

73. 0.000 0.000 ↓ 0.0

Hash (cost=1.54..1.54 rows=54 width=574) (never executed)

74. 0.000 0.000 ↓ 0.0

Seq Scan on finance_header t32 (cost=0..1.54 rows=54 width=574) (never executed)

75. 0.000 0.000 ↓ 0.0

Hash (cost=1.24..1.24 rows=24 width=1,132) (never executed)

76. 0.000 0.000 ↓ 0.0

Seq Scan on material_header t33 (cost=0..1.24 rows=24 width=1,132) (never executed)

77. 0.000 0.000 ↓ 0.0

Hash (cost=1.52..1.52 rows=52 width=13) (never executed)

78. 0.000 0.000 ↓ 0.0

Seq Scan on material_last_modified t39 (cost=0..1.52 rows=52 width=13) (never executed)

79. 0.000 0.000 ↓ 0.0

Hash (cost=13.3..13.3 rows=130 width=4,942) (never executed)

80. 0.000 0.000 ↓ 0.0

Seq Scan on procure_line t40 (cost=0..13.3 rows=130 width=4,942) (never executed)

81. 0.000 0.000 ↓ 0.0

Hash (cost=1.25..1.25 rows=25 width=3,196) (never executed)

82. 0.000 0.000 ↓ 0.0

Seq Scan on change_id t41 (cost=0..1.25 rows=25 width=3,196) (never executed)

83. 0.000 0.000 ↓ 0.0

Hash (cost=1.53..1.53 rows=53 width=613) (never executed)

84. 0.000 0.000 ↓ 0.0

Seq Scan on pick_list t46 (cost=0..1.53 rows=53 width=613) (never executed)

85. 0.000 0.000 ↓ 0.0

Hash (cost=7.29..7.29 rows=129 width=1,309) (never executed)

86. 0.000 0.000 ↓ 0.0

Seq Scan on request_list t47 (cost=0..7.29 rows=129 width=1,309) (never executed)

87. 0.000 0.000 ↓ 0.0

Hash (cost=8.14..8.14 rows=1 width=11,928) (never executed)

88. 0.000 0.000 ↓ 0.0

Index Scan using i_nvc_mtn_customdocument on invoice_information t3 (cost=0.13..8.14 rows=1 width=11,928) (never executed)

89. 0.000 0.000 ↓ 0.0

Hash (cost=10.6..10.6 rows=60 width=1,174) (never executed)

90. 0.000 0.000 ↓ 0.0

Seq Scan on shipping_material t6 (cost=0..10.6 rows=60 width=1,174) (never executed)

91. 0.000 0.000 ↓ 0.0

Hash (cost=1.31..1.31 rows=31 width=3,138) (never executed)

92. 0.000 0.000 ↓ 0.0

Seq Scan on dispatch_note t9 (cost=0..1.31 rows=31 width=3,138) (never executed)

93. 0.000 0.000 ↓ 0.0

Hash (cost=3.06..3.06 rows=106 width=81) (never executed)

94. 0.000 0.000 ↓ 0.0

Seq Scan on approval t10 (cost=0..3.06 rows=106 width=81) (never executed)

95. 0.000 0.000 ↓ 0.0

Hash (cost=4.17..4.17 rows=117 width=3,235) (never executed)

96. 0.000 0.000 ↓ 0.0

Seq Scan on order_line_version t16 (cost=0..4.17 rows=117 width=3,235) (never executed)

97. 0.000 0.000 ↓ 0.0

Hash (cost=5.16..5.16 rows=116 width=2,764) (never executed)

98. 0.000 0.000 ↓ 0.0

Seq Scan on delivery_note_line t18 (cost=0..5.16 rows=116 width=2,764) (never executed)

99. 0.000 0.000 ↓ 0.0

Hash (cost=3.7..3.7 rows=70 width=2,174) (never executed)

100. 0.000 0.000 ↓ 0.0

Seq Scan on orders t19 (cost=0..3.7 rows=70 width=2,174) (never executed)

101. 0.000 0.000 ↓ 0.0

Hash (cost=10.1..10.1 rows=10 width=5,707) (never executed)

102. 0.000 0.000 ↓ 0.0

Seq Scan on alarm t20 (cost=0..10.1 rows=10 width=5,707) (never executed)

103. 0.000 0.000 ↓ 0.0

Hash (cost=1.44..1.44 rows=44 width=31) (never executed)

104. 0.000 0.000 ↓ 0.0

Seq Scan on order_line_last_modified t22 (cost=0..1.44 rows=44 width=31) (never executed)

105. 0.000 0.000 ↓ 0.0

Hash (cost=13.3..13.3 rows=130 width=4,974) (never executed)

106. 0.000 0.000 ↓ 0.0

Seq Scan on procure_line t23 (cost=0..13.3 rows=130 width=4,974) (never executed)

107. 0.000 0.000 ↓ 0.0

Hash (cost=2.5..2.5 rows=50 width=1,218) (never executed)

108. 0.000 0.000 ↓ 0.0

Seq Scan on material_header_version t34 (cost=0..2.5 rows=50 width=1,218) (never executed)

109. 0.000 0.000 ↓ 0.0

Hash (cost=2.05..2.05 rows=5 width=954) (never executed)

110. 0.000 0.000 ↓ 0.0

Seq Scan on custom_document t4 (cost=0..2.05 rows=5 width=954) (never executed)

111. 0.000 0.000 ↓ 0.0

Hash (cost=2.05..2.05 rows=5 width=946) (never executed)

112. 0.000 0.000 ↓ 0.0

Seq Scan on custom_document t7 (cost=0..2.05 rows=5 width=946) (never executed)

113. 0.000 0.000 ↓ 0.0

Hash (cost=7.29..7.29 rows=129 width=1,317) (never executed)

114. 0.000 0.000 ↓ 0.0

Seq Scan on request_list t11 (cost=0..7.29 rows=129 width=1,317) (never executed)

115. 0.000 0.000 ↓ 0.0

Hash (cost=3.78..3.78 rows=78 width=6,322) (never executed)

116. 0.000 0.000 ↓ 0.0

Seq Scan on order_line t17 (cost=0..3.78 rows=78 width=6,322) (never executed)

117. 0.000 0.000 ↓ 0.0

Hash (cost=3.78..3.78 rows=78 width=6,330) (never executed)

118. 0.000 0.000 ↓ 0.0

Seq Scan on order_line t21 (cost=0..3.78 rows=78 width=6,330) (never executed)

119. 0.000 0.000 ↓ 0.0

Hash (cost=1.54..1.54 rows=54 width=574) (never executed)

120. 0.000 0.000 ↓ 0.0

Seq Scan on finance_header t24 (cost=0..1.54 rows=54 width=574) (never executed)

121. 0.000 0.000 ↓ 0.0

Hash (cost=3.69..3.69 rows=169 width=594) (never executed)

122. 0.000 0.000 ↓ 0.0

Seq Scan on part_alias t25 (cost=0..3.69 rows=169 width=594) (never executed)

123. 0.000 0.000 ↓ 0.0

Hash (cost=6.27..6.27 rows=127 width=2,829) (never executed)

124. 0.000 0.000 ↓ 0.0

Seq Scan on requisition t27 (cost=0..6.27 rows=127 width=2,829) (never executed)

125. 0.000 0.000 ↓ 0.0

Hash (cost=2.81..2.81 rows=81 width=1,159) (never executed)

126. 0.000 0.000 ↓ 0.0

Seq Scan on supplier t28 (cost=0..2.81 rows=81 width=1,159) (never executed)

127. 0.000 0.000 ↓ 0.0

Hash (cost=1.25..1.25 rows=25 width=3,196) (never executed)

128. 0.000 0.000 ↓ 0.0

Seq Scan on change_id t35 (cost=0..1.25 rows=25 width=3,196) (never executed)

129. 0.000 0.000 ↓ 0.0

Hash (cost=1.24..1.24 rows=24 width=1,124) (never executed)

130. 0.000 0.000 ↓ 0.0

Seq Scan on material_header t36 (cost=0..1.24 rows=24 width=1,124) (never executed)

131. 0.000 0.000 ↓ 0.0

Hash (cost=2.5..2.5 rows=50 width=1,186) (never executed)

132. 0.000 0.000 ↓ 0.0

Seq Scan on material_header_version t37 (cost=0..2.5 rows=50 width=1,186) (never executed)

133. 0.000 0.000 ↓ 0.0

Hash (cost=1.25..1.25 rows=25 width=3,196) (never executed)

134. 0.000 0.000 ↓ 0.0

Seq Scan on change_id t38 (cost=0..1.25 rows=25 width=3,196) (never executed)

135. 0.000 0.000 ↓ 0.0

Hash (cost=11.35..11.35 rows=235 width=337) (never executed)

136. 0.000 0.000 ↓ 0.0

Seq Scan on delivery_information t5 (cost=0..11.35 rows=235 width=337) (never executed)

137. 0.000 0.000 ↓ 0.0

Hash (cost=11.35..11.35 rows=235 width=337) (never executed)

138. 0.000 0.000 ↓ 0.0

Seq Scan on delivery_information t12 (cost=0..11.35 rows=235 width=337) (never executed)

139. 0.000 0.000 ↓ 0.0

Hash (cost=1.53..1.53 rows=53 width=20) (never executed)

140. 0.000 0.000 ↓ 0.0

Seq Scan on part_number t26 (cost=0..1.53 rows=53 width=20) (never executed)

141. 0.000 0.000 ↓ 0.0

Hash (cost=13.3..13.3 rows=130 width=4,942) (never executed)

142. 0.000 0.000 ↓ 0.0

Seq Scan on procure_line t29 (cost=0..13.3 rows=130 width=4,942) (never executed)