explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8yil : Jira reporting

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

Sort (cost=112,795,247,308.01..112,964,112,188.58 rows=67,545,952,227 width=828) (actual rows= loops=)

  • Sort Key: custom.cfname, project.pkey, jiraissue.issuenum
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=40,678,054.09..1,833,028,131.96 rows=67,545,952,227 width=828) (actual rows= loops=)

  • Hash Cond: (custom.issue = jiraissue.id)
3. 0.000 0.000 ↓ 0.0

Subquery Scan on custom (cost=16,557,097.22..18,419,713.09 rows=866,077 width=84) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Append (cost=16,557,097.22..18,411,052.32 rows=866,077 width=84) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=16,557,097.22..18,401,189.38 rows=864,880 width=61) (actual rows= loops=)

  • Group Key: customfieldvalue.issue, customfield.cfname
6. 0.000 0.000 ↓ 0.0

Sort (cost=16,557,097.22..16,664,382.06 rows=42,913,934 width=247) (actual rows= loops=)

  • Sort Key: customfieldvalue.issue, customfield.cfname
7. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=68,251.68..1,142,556.51 rows=42,913,934 width=247) (actual rows= loops=)

  • Merge Cond: ((upper((users.user_name)::text)) = (CASE WHEN (hashed SubPlan 6) THEN upper((customfieldvalue.stringvalue)::text) ELSE ''::text END))
8. 0.000 0.000 ↓ 0.0

Sort (cost=16,170.08..16,367.55 rows=78,989 width=36) (actual rows= loops=)

  • Sort Key: (upper((users.user_name)::text))
9. 0.000 0.000 ↓ 0.0

Subquery Scan on users (cost=8,164.80..9,744.57 rows=78,989 width=36) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,164.80..8,954.68 rows=78,989 width=36) (actual rows= loops=)

  • Group Key: cwd_user.user_name, cwd_user.display_name
11. 0.000 0.000 ↓ 0.0

Seq Scan on cwd_user (cost=0.00..7,769.85 rows=78,989 width=36) (actual rows= loops=)

  • Filter: (active = '1'::numeric)
12. 0.000 0.000 ↓ 0.0

Materialize (cost=42,731.97..43,275.26 rows=108,658 width=219) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Sort (cost=42,731.97..43,003.61 rows=108,658 width=219) (actual rows= loops=)

  • Sort Key: (CASE WHEN (hashed SubPlan 6) THEN upper((customfieldvalue.stringvalue)::text) ELSE ''::text END)
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12,636.76..22,128.03 rows=108,658 width=219) (actual rows= loops=)

  • Hash Cond: ((customfieldvalue.stringvalue)::text = ("AO_8542F1_IFJ_OBJ"."OBJECT_KEY")::text)
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12,615.85..21,419.72 rows=108,658 width=208) (actual rows= loops=)

  • Hash Cond: ("AO_8542F1_IFJ_OBJ_ATTR"."OBJECT_ID" = "AO_8542F1_IFJ_OBJ_ATTR_1"."OBJECT_ID")
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12,445.69..19,785.66 rows=108,658 width=203) (actual rows= loops=)

  • Hash Cond: ((CASE WHEN (hashed SubPlan 5) THEN (customfieldvalue.stringvalue)::integer ELSE 0 END)::numeric = customfieldoption.id)
17. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12,407.99..17,710.62 rows=108,658 width=191) (actual rows= loops=)

  • Hash Cond: (((CASE WHEN (("substring"(customfieldvalue.textvalue, 1, 1) = '<'::text) AND ("substring"(customfieldvalue.textvalue, 20, 5) ~ '^[0-9\.]+$'::text)) THEN COALESCE("substring"(customfieldvalue.textvalue, 20, 5), '0'::text) ELSE '0'::text END)::integer)::numeric = jiraissue_1.id)
18. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,225.30..14,947.30 rows=108,658 width=149) (actual rows= loops=)

  • Hash Cond: (customfieldvalue.customfield = customfield.id)
19. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=12,205.64..13,433.59 rows=108,658 width=127) (actual rows= loops=)

  • Merge Cond: ((customfieldvalue.stringvalue)::text = "AO_8542F1_IFJ_OBJ_ATTR_VAL"."TEXT_VALUE")
20. 0.000 0.000 ↓ 0.0

Sort (cost=11,855.77..12,127.42 rows=108,658 width=123) (actual rows= loops=)

  • Sort Key: customfieldvalue.stringvalue
21. 0.000 0.000 ↓ 0.0

Seq Scan on customfieldvalue (cost=0.00..2,766.84 rows=108,658 width=123) (actual rows= loops=)

  • Filter: (customfield <> ALL ('{11254,11255}'::numeric[]))
22. 0.000 0.000 ↓ 0.0

Sort (cost=349.87..357.04 rows=2,869 width=13) (actual rows= loops=)

  • Sort Key: "AO_8542F1_IFJ_OBJ_ATTR_VAL"."TEXT_VALUE
23. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=86.55..185.10 rows=2,869 width=13) (actual rows= loops=)

  • Hash Cond: ("AO_8542F1_IFJ_OBJ_ATTR"."ID" = "AO_8542F1_IFJ_OBJ_ATTR_VAL"."OBJECT_ATTRIBUTE_ID")
24. 0.000 0.000 ↓ 0.0

Seq Scan on "AO_8542F1_IFJ_OBJ_ATTR" (cost=0.00..57.35 rows=3,335 width=8) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash (cost=50.69..50.69 rows=2,869 width=13) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on "AO_8542F1_IFJ_OBJ_ATTR_VAL" (cost=0.00..50.69 rows=2,869 width=13) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash (cost=14.85..14.85 rows=385 width=29) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on customfield (cost=0.00..14.85 rows=385 width=29) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash (cost=150.64..150.64 rows=2,564 width=48) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on jiraissue jiraissue_1 (cost=0.00..150.64 rows=2,564 width=48) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=13.40..13.40 rows=640 width=18) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on customfieldoption (cost=0.00..13.40 rows=640 width=18) (actual rows= loops=)

33.          

SubPlan (forHash Left Join)

34. 0.000 0.000 ↓ 0.0

HashAggregate (cost=15.00..16.04 rows=104 width=7) (actual rows= loops=)

  • Group Key: customfieldoption_2.customfield
35. 0.000 0.000 ↓ 0.0

Seq Scan on customfieldoption customfieldoption_2 (cost=0.00..13.40 rows=640 width=7) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=161.83..161.83 rows=666 width=13) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash Join (cost=93.72..161.83 rows=666 width=13) (actual rows= loops=)

  • Hash Cond: ("AO_8542F1_IFJ_OBJ_ATTR_VAL_1"."OBJECT_ATTRIBUTE_ID" = "AO_8542F1_IFJ_OBJ_ATTR_1"."ID")
38. 0.000 0.000 ↓ 0.0

Seq Scan on "AO_8542F1_IFJ_OBJ_ATTR_VAL" "AO_8542F1_IFJ_OBJ_ATTR_VAL_1" (cost=0.00..50.69 rows=2,869 width=13) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Hash (cost=84.05..84.05 rows=774 width=8) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Hash Join (cost=6.45..84.05 rows=774 width=8) (actual rows= loops=)

  • Hash Cond: ("AO_8542F1_IFJ_OBJ_ATTR_1"."OBJECT_TYPE_ATTRIBUTE_ID" = "AO_8542F1_IFJ_OBJ_TYPE_ATTR"."ID")
41. 0.000 0.000 ↓ 0.0

Seq Scan on "AO_8542F1_IFJ_OBJ_ATTR" "AO_8542F1_IFJ_OBJ_ATTR_1" (cost=0.00..57.35 rows=3,335 width=12) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Hash (cost=5.80..5.80 rows=52 width=4) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on "AO_8542F1_IFJ_OBJ_TYPE_ATTR" (cost=0.00..5.80 rows=52 width=4) (actual rows= loops=)

  • Filter: (("NAME")::text = 'Name'::text)
44. 0.000 0.000 ↓ 0.0

Hash (cost=13.74..13.74 rows=574 width=17) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Seq Scan on "AO_8542F1_IFJ_OBJ" (cost=0.00..13.74 rows=574 width=17) (actual rows= loops=)

46.          

SubPlan (forHash Left Join)

47. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,164.80..9,152.16 rows=78,989 width=32) (actual rows= loops=)

  • Group Key: upper((cwd_user_4.user_name)::text)
48. 0.000 0.000 ↓ 0.0

Seq Scan on cwd_user cwd_user_4 (cost=0.00..7,967.32 rows=78,989 width=32) (actual rows= loops=)

  • Filter: (active = '1'::numeric)
49.          

SubPlan (forGroupAggregate)

50. 0.000 0.000 ↓ 0.0

HashAggregate (cost=15.00..16.04 rows=104 width=7) (actual rows= loops=)

  • Group Key: customfieldoption_1.customfield
51. 0.000 0.000 ↓ 0.0

Seq Scan on customfieldoption customfieldoption_1 (cost=0.00..13.40 rows=640 width=7) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Seq Scan on "AO_8542F1_IFJ_OBJ_ATTR_VAL" "AO_8542F1_IFJ_OBJ_ATTR_VAL_2" (cost=0.00..50.69 rows=2,869 width=9) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on "AO_8542F1_IFJ_OBJ" "AO_8542F1_IFJ_OBJ_1" (cost=0.00..13.74 rows=574 width=6) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,164.80..9,152.16 rows=78,989 width=32) (actual rows= loops=)

  • Group Key: upper((cwd_user_3.user_name)::text)
55. 0.000 0.000 ↓ 0.0

Seq Scan on cwd_user cwd_user_3 (cost=0.00..7,967.32 rows=78,989 width=32) (actual rows= loops=)

  • Filter: (active = '1'::numeric)
56. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=685.23..692.56 rows=326 width=70) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

HashAggregate (cost=685.23..689.30 rows=326 width=70) (actual rows= loops=)

  • Group Key: issuelink.source, ('Issue Link'::text)
58. 0.000 0.000 ↓ 0.0

Append (cost=185.07..660.78 rows=3,260 width=70) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Hash Join (cost=185.07..314.09 rows=1,630 width=70) (actual rows= loops=)

  • Hash Cond: (issue_destination.project = proj_destination.id)
60. 0.000 0.000 ↓ 0.0

Hash Join (cost=183.98..266.14 rows=1,630 width=533) (actual rows= loops=)

  • Hash Cond: (issuelink.destination = issue_destination.id)
61. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.29..61.04 rows=1,630 width=529) (actual rows= loops=)

  • Hash Cond: (issuelink.linktype = issuelinktype.id)
62. 0.000 0.000 ↓ 0.0

Seq Scan on issuelink (cost=0.00..36.78 rows=1,778 width=20) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Hash (cost=1.15..1.15 rows=11 width=536) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Seq Scan on issuelinktype (cost=0.00..1.15 rows=11 width=536) (actual rows= loops=)

  • Filter: (id <> '10100'::numeric)
65. 0.000 0.000 ↓ 0.0

Hash (cost=150.64..150.64 rows=2,564 width=17) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Seq Scan on jiraissue issue_destination (cost=0.00..150.64 rows=2,564 width=17) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Hash (cost=1.04..1.04 rows=4 width=10) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Seq Scan on project proj_destination (cost=0.00..1.04 rows=4 width=10) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Hash Join (cost=185.07..314.09 rows=1,630 width=71) (actual rows= loops=)

  • Hash Cond: (issue_source.project = proj_source.id)
70. 0.000 0.000 ↓ 0.0

Hash Join (cost=183.98..266.14 rows=1,630 width=534) (actual rows= loops=)

  • Hash Cond: (issuelink_1.source = issue_source.id)
71. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.29..61.04 rows=1,630 width=529) (actual rows= loops=)

  • Hash Cond: (issuelink_1.linktype = issuelinktype_1.id)
72. 0.000 0.000 ↓ 0.0

Seq Scan on issuelink issuelink_1 (cost=0.00..36.78 rows=1,778 width=20) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Hash (cost=1.15..1.15 rows=11 width=536) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Seq Scan on issuelinktype issuelinktype_1 (cost=0.00..1.15 rows=11 width=536) (actual rows= loops=)

  • Filter: (id <> '10100'::numeric)
75. 0.000 0.000 ↓ 0.0

Hash (cost=150.64..150.64 rows=2,564 width=17) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Seq Scan on jiraissue issue_source (cost=0.00..150.64 rows=2,564 width=17) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Hash (cost=1.04..1.04 rows=4 width=10) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on project proj_source (cost=0.00..1.04 rows=4 width=10) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

HashAggregate (cost=250.99..256.25 rows=421 width=70) (actual rows= loops=)

  • Group Key: issuelink_2.source
80. 0.000 0.000 ↓ 0.0

Hash Join (cost=183.78..243.89 rows=473 width=15) (actual rows= loops=)

  • Hash Cond: (issue_destination_1.project = proj_destination_1.id)
81. 0.000 0.000 ↓ 0.0

Hash Join (cost=182.69..236.30 rows=473 width=17) (actual rows= loops=)

  • Hash Cond: (issuelink_2.destination = issue_destination_1.id)
82. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..47.11 rows=473 width=13) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Seq Scan on issuelinktype issuelinktype_2 (cost=0.00..1.15 rows=1 width=20) (actual rows= loops=)

  • Filter: (id = '10100'::numeric)
84. 0.000 0.000 ↓ 0.0

Seq Scan on issuelink issuelink_2 (cost=0.00..41.23 rows=473 width=20) (actual rows= loops=)

  • Filter: (linktype = '10100'::numeric)
85. 0.000 0.000 ↓ 0.0

Hash (cost=150.64..150.64 rows=2,564 width=17) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Seq Scan on jiraissue issue_destination_1 (cost=0.00..150.64 rows=2,564 width=17) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Hash (cost=1.04..1.04 rows=4 width=10) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Seq Scan on project proj_destination_1 (cost=0.00..1.04 rows=4 width=10) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

HashAggregate (cost=250.99..256.61 rows=450 width=71) (actual rows= loops=)

  • Group Key: issuelink_3.destination
90. 0.000 0.000 ↓ 0.0

Hash Join (cost=183.78..243.89 rows=473 width=16) (actual rows= loops=)

  • Hash Cond: (issue_source_1.project = proj_source_1.id)
91. 0.000 0.000 ↓ 0.0

Hash Join (cost=182.69..236.30 rows=473 width=18) (actual rows= loops=)

  • Hash Cond: (issuelink_3.source = issue_source_1.id)
92. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..47.11 rows=473 width=13) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Seq Scan on issuelinktype issuelinktype_3 (cost=0.00..1.15 rows=1 width=20) (actual rows= loops=)

  • Filter: (id = '10100'::numeric)
94. 0.000 0.000 ↓ 0.0

Seq Scan on issuelink issuelink_3 (cost=0.00..41.23 rows=473 width=20) (actual rows= loops=)

  • Filter: (linktype = '10100'::numeric)
95. 0.000 0.000 ↓ 0.0

Hash (cost=150.64..150.64 rows=2,564 width=17) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Seq Scan on jiraissue issue_source_1 (cost=0.00..150.64 rows=2,564 width=17) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Hash (cost=1.04..1.04 rows=4 width=10) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Seq Scan on project proj_source_1 (cost=0.00..1.04 rows=4 width=10) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Hash (cost=4,241,309.90..4,241,309.90 rows=199,968,157 width=684) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=239,891.08..4,241,309.90 rows=199,968,157 width=684) (actual rows= loops=)

  • Merge Cond: ((upper((users_assignee.user_name)::text)) = (upper((jiraissue.assignee)::text)))
101. 0.000 0.000 ↓ 0.0

Sort (cost=16,170.08..16,367.55 rows=78,989 width=36) (actual rows= loops=)

  • Sort Key: (upper((users_assignee.user_name)::text))
102. 0.000 0.000 ↓ 0.0

Subquery Scan on users_assignee (cost=8,164.80..9,744.57 rows=78,989 width=36) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,164.80..8,954.68 rows=78,989 width=36) (actual rows= loops=)

  • Group Key: cwd_user_1.user_name, cwd_user_1.display_name
104. 0.000 0.000 ↓ 0.0

Seq Scan on cwd_user cwd_user_1 (cost=0.00..7,769.85 rows=78,989 width=36) (actual rows= loops=)

  • Filter: (active = '1'::numeric)
105. 0.000 0.000 ↓ 0.0

Materialize (cost=223,721.00..226,252.59 rows=506,319 width=663) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Sort (cost=223,721.00..224,986.79 rows=506,319 width=663) (actual rows= loops=)

  • Sort Key: (upper((jiraissue.assignee)::text))
107. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=16,778.36..26,917.56 rows=506,319 width=663) (actual rows= loops=)

  • Merge Cond: ((upper((jiraissue.creator)::text)) = (upper((users_creator.user_name)::text)))
108. 0.000 0.000 ↓ 0.0

Sort (cost=608.28..611.49 rows=1,282 width=642) (actual rows= loops=)

  • Sort Key: (upper((jiraissue.creator)::text))
109. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=442.34..542.11 rows=1,282 width=642) (actual rows= loops=)

  • Hash Cond: ((jiraissue.priority)::text = (priority.id)::text)
110. 0.000 0.000 ↓ 0.0

Hash Join (cost=441.23..527.66 rows=1,282 width=508) (actual rows= loops=)

  • Hash Cond: ((jiraissue.issuestatus)::text = (issuestatus.id)::text)
111. 0.000 0.000 ↓ 0.0

Hash Join (cost=439.92..508.71 rows=1,282 width=375) (actual rows= loops=)

  • Hash Cond: ((jiraissue.issuetype)::text = (issuetype.id)::text)
112. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=438.62..489.79 rows=1,282 width=243) (actual rows= loops=)

  • Hash Cond: (((userhistoryitem.entityid)::integer)::numeric = jiraissue.id)
113. 0.000 0.000 ↓ 0.0

HashAggregate (cost=178.16..196.44 rows=1,462 width=38) (actual rows= loops=)

  • Group Key: userhistoryitem.entityid
114. 0.000 0.000 ↓ 0.0

Seq Scan on userhistoryitem (cost=0.00..148.46 rows=2,970 width=16) (actual rows= loops=)

  • Filter: ((entitytype)::text = 'Issue'::text)
115. 0.000 0.000 ↓ 0.0

Hash (cost=244.44..244.44 rows=1,282 width=211) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=226.91..244.44 rows=1,282 width=211) (actual rows= loops=)

  • Hash Cond: (remotelink.issueid = jiraissue.id)
117. 0.000 0.000 ↓ 0.0

HashAggregate (cost=36.73..43.75 rows=561 width=39) (actual rows= loops=)

  • Group Key: remotelink.issueid
118. 0.000 0.000 ↓ 0.0

Seq Scan on remotelink (cost=0.00..30.42 rows=842 width=15) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Hash (cost=174.15..174.15 rows=1,282 width=179) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.07..174.15 rows=1,282 width=179) (actual rows= loops=)

  • Hash Cond: (jiraissue.project = project.id)
121. 0.000 0.000 ↓ 0.0

Seq Scan on jiraissue (cost=0.00..150.64 rows=2,564 width=167) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Hash (cost=1.05..1.05 rows=2 width=24) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Seq Scan on project (cost=0.00..1.05 rows=2 width=24) (actual rows= loops=)

  • Filter: (id = ANY ('{10000,10300}'::numeric[]))
124. 0.000 0.000 ↓ 0.0

Hash (cost=1.13..1.13 rows=13 width=276) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Seq Scan on issuetype (cost=0.00..1.13 rows=13 width=276) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Hash (cost=1.14..1.14 rows=14 width=276) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Seq Scan on issuestatus (cost=0.00..1.14 rows=14 width=276) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Hash (cost=1.05..1.05 rows=5 width=276) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Seq Scan on priority (cost=0.00..1.05 rows=5 width=276) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Sort (cost=16,170.08..16,367.55 rows=78,989 width=36) (actual rows= loops=)

  • Sort Key: (upper((users_creator.user_name)::text))
131. 0.000 0.000 ↓ 0.0

Subquery Scan on users_creator (cost=8,164.80..9,744.57 rows=78,989 width=36) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,164.80..8,954.68 rows=78,989 width=36) (actual rows= loops=)

  • Group Key: cwd_user_2.user_name, cwd_user_2.display_name
133. 0.000 0.000 ↓ 0.0

Seq Scan on cwd_user cwd_user_2 (cost=0.00..7,769.85 rows=78,989 width=36) (actual rows= loops=)