explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pTMe

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

Unique (cost=149,086.89..150,587.64 rows=66,700 width=232) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=149,086.89..149,253.64 rows=66,700 width=232) (actual rows= loops=)

  • Sort Key: f.elementid, f.elementtype, f.postgis_bbox, f.intersectedid, f.intersectedtype, f.intersectedbbox, ('smoke'::text), ($1)
3. 0.000 0.000 ↓ 0.0

Append (cost=67,343.51..136,444.92 rows=66,700 width=232) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Merge Join (cost=67,343.51..67,598.63 rows=16,675 width=232) (actual rows= loops=)

  • Merge Cond: ((f.intersectedid)::text = (vent.elementid)::text)
5.          

Initplan (for Merge Join)

6. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_federatedmodel bimrl_federatedmodel_1 (cost=0.00..4.34 rows=1 width=8) (actual rows= loops=)

  • Filter: (federatedid = 27)
7. 0.000 0.000 ↓ 0.0

Sort (cost=15,505.33..15,507.83 rows=1,000 width=192) (actual rows= loops=)

  • Sort Key: f.intersectedid
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15,435.48..15,455.50 rows=1,000 width=192) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Unique (cost=15,435.23..15,435.24 rows=1 width=23) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Sort (cost=15,435.23..15,435.23 rows=1 width=23) (actual rows= loops=)

  • Sort Key: ba.elementid
11. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.83..15,435.22 rows=1 width=23) (actual rows= loops=)

  • Join Filter: ((ba.elementtype)::text = (bimrl_objecthierarchy_2.elementsubtype)::text)
12. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.83..15,387.37 rows=1 width=35) (actual rows= loops=)

  • Join Filter: ((ba2.elementtype)::text = (bimrl_objecthierarchy_1.elementsubtype)::text)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..15,339.52 rows=1 width=47) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..15,331.49 rows=1 width=58) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.00..15,138.57 rows=24 width=23) (actual rows= loops=)

  • Join Filter: ((ba1.elementtype)::text = (bimrl_objecthierarchy.elementsubtype)::text)
16. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_element_001b ba1 (cost=0.00..15,074.62 rows=108 width=35) (actual rows= loops=)

  • Filter: (upper((longname)::text) ~~ '%LOBBY%'::text)
17. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..47.77 rows=10 width=18) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
19. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b ba2 (cost=0.42..8.03 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (ba1.elementid)::text)
  • Filter: (upper((longname)::text) ~~ '%SMOKE%'::text)
20. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b ba (cost=0.42..8.03 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (ba1.elementid)::text)
21. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy bimrl_objecthierarchy_1 (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
22. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy bimrl_objecthierarchy_2 (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
23. 0.000 0.000 ↓ 0.0

Function Scan on spatial_interact f (cost=0.25..10.25 rows=1,000 width=192) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Sort (cost=51,833.84..51,842.18 rows=3,335 width=114) (actual rows= loops=)

  • Sort Key: vent.elementid
25. 0.000 0.000 ↓ 0.0

Subquery Scan on vent (cost=51,571.99..51,638.69 rows=3,335 width=114) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

HashAggregate (cost=51,571.99..51,605.34 rows=3,335 width=210) (actual rows= loops=)

  • Group Key: cc.elementid, "cc1$properties".propertygroupname, "cc1$properties".propertyvalue, "cc1$properties".propertyname
27. 0.000 0.000 ↓ 0.0

Append (cost=20,758.07..51,538.64 rows=3,335 width=210) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Unique (cost=20,758.07..20,758.08 rows=1 width=70) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Sort (cost=20,758.07..20,758.07 rows=1 width=70) (actual rows= loops=)

  • Sort Key: cc.elementid, "cc1$properties".propertygroupname, "cc1$properties".propertyvalue, "cc1$properties".propertyname
30. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=20,690.08..20,758.06 rows=1 width=70) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=20,689.80..20,728.84 rows=1 width=82) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,689.52..20,699.63 rows=1 width=94) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,689.11..20,698.33 rows=1 width=128) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,688.68..20,696.71 rows=1 width=58) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

HashAggregate (cost=20,688.26..20,688.27 rows=1 width=23) (actual rows= loops=)

  • Group Key: (bimrl_properties_001b.elementid)::text
36. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_properties_001b (cost=0.00..20,688.26 rows=1 width=23) (actual rows= loops=)

  • Filter: ((upper((propertygroupname)::text) ~~ 'PSET_WINDOWCOMMON'::text) AND (upper((propertyname)::text) = 'ISEXTERNAL'::text))
37. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b cc1 (cost=0.42..8.44 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (bimrl_properties_001b.elementid)::text)
38. 0.000 0.000 ↓ 0.0

Index Scan using idx1_bimrl_properties_001b on bimrl_properties_001b "cc1$properties" (cost=0.42..1.61 rows=1 width=70) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (cc1.elementid)::text)
  • Filter: ((upper((propertyvalue)::text) ~~ '%TRUE%'::text) AND (upper((propertygroupname)::text) ~~ 'PSET_WINDOWCOMMON'::text) AND (upper((propertyname)::text) = 'ISEXTERNAL'::text))
39. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b cc (cost=0.42..1.29 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (cc1.elementid)::text)
40. 0.000 0.000 ↓ 0.0

Index Scan using idx2_bimrl_objhier on bimrl_objecthierarchy bimrl_objecthierarchy_3 (cost=0.28..14.75 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((elementsubtype)::text = (cc1.elementtype)::text)
  • Filter: (upper((elementtype)::text) = 'IFCWINDOW'::text)
41. 0.000 0.000 ↓ 0.0

Index Scan using idx2_bimrl_objhier on bimrl_objecthierarchy bimrl_objecthierarchy_4 (cost=0.28..14.75 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((elementsubtype)::text = (cc.elementtype)::text)
  • Filter: (upper((elementtype)::text) = 'IFCWINDOW'::text)
42. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=30,730.53..30,780.54 rows=3,334 width=119) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Unique (cost=30,730.53..30,747.20 rows=3,334 width=119) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Sort (cost=30,730.53..30,738.87 rows=3,334 width=119) (actual rows= loops=)

  • Sort Key: bc.elementid
45. 0.000 0.000 ↓ 0.0

Hash Join (cost=15,364.66..30,535.44 rows=3,334 width=119) (actual rows= loops=)

  • Hash Cond: ((bc1.elementid)::text = (bc.elementid)::text)
46. 0.000 0.000 ↓ 0.0

Hash Join (cost=47.97..15,129.16 rows=15,002 width=23) (actual rows= loops=)

  • Hash Cond: ((bc1.elementtype)::text = (bimrl_objecthierarchy_5.elementsubtype)::text)
47. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_element_001b bc1 (cost=0.00..14,737.08 rows=67,508 width=35) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Hash (cost=47.85..47.85 rows=10 width=18) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

HashAggregate (cost=47.75..47.85 rows=10 width=18) (actual rows= loops=)

  • Group Key: (bimrl_objecthierarchy_5.elementsubtype)::text
50. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy bimrl_objecthierarchy_5 (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCOPENINGELEMENT'::text)
51. 0.000 0.000 ↓ 0.0

Hash (cost=15,129.16..15,129.16 rows=15,002 width=23) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash Join (cost=47.97..15,129.16 rows=15,002 width=23) (actual rows= loops=)

  • Hash Cond: ((bc.elementtype)::text = (bimrl_objecthierarchy_6.elementsubtype)::text)
53. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_element_001b bc (cost=0.00..14,737.08 rows=67,508 width=35) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Hash (cost=47.85..47.85 rows=10 width=18) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

HashAggregate (cost=47.75..47.85 rows=10 width=18) (actual rows= loops=)

  • Group Key: (bimrl_objecthierarchy_6.elementsubtype)::text
56. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy bimrl_objecthierarchy_6 (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCOPENINGELEMENT'::text)
57. 0.000 0.000 ↓ 0.0

Merge Join (cost=67,413.92..68,179.29 rows=50,025 width=232) (actual rows= loops=)

  • Merge Cond: ((f_1.intersectedid)::text = (vent_1.elementid)::text)
58.          

Initplan (for Merge Join)

59. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_federatedmodel (cost=0.00..4.34 rows=1 width=8) (actual rows= loops=)

  • Filter: (federatedid = 27)
60. 0.000 0.000 ↓ 0.0

Sort (cost=15,575.74..15,583.24 rows=3,000 width=192) (actual rows= loops=)

  • Sort Key: f_1.intersectedid
61. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15,342.42..15,402.48 rows=3,000 width=192) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

HashAggregate (cost=15,342.17..15,342.20 rows=3 width=114) (actual rows= loops=)

  • Group Key: bf.elementid
63. 0.000 0.000 ↓ 0.0

Append (cost=76.88..15,342.16 rows=3 width=114) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Unique (cost=76.88..76.89 rows=1 width=23) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Sort (cost=76.88..76.88 rows=1 width=23) (actual rows= loops=)

  • Sort Key: bf.elementid
66. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.39..76.87 rows=1 width=23) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.11..47.65 rows=1 width=35) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..18.43 rows=1 width=47) -> Nested Loop (cost=0.42..17.14 rows=1 width=58) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_classifassignment_001b "bf1$classificationof" (cost=0.00..8.71 rows=1 width=23) (actual rows= loops=)

  • Filter: ((classificationname IS NOT NULL) AND (upper((classificationitemcode)::text) ~~ '%13-13 13%'::text))
70. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b bf1 (cost=0.42..8.44 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = ("bf1$classificationof".elementid)::text)
71. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b bf (cost=0.42..1.29 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (bf1.elementid)::text)
72. 0.000 0.000 ↓ 0.0

Index Scan using idx2_bimrl_objhier on bimrl_objecthierarchy bimrl_objecthierarchy_7 (cost=0.28..14.75 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((elementsubtype)::text = (bf1.elementtype)::text)
  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
73. 0.000 0.000 ↓ 0.0

Index Scan using idx2_bimrl_objhier on bimrl_objecthierarchy bimrl_objecthierarchy_8 (cost=0.28..14.75 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((elementsubtype)::text = (bf.elementtype)::text)
  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
74. 0.000 0.000 ↓ 0.0

Unique (cost=76.88..76.89 rows=1 width=23) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Sort (cost=76.88..76.88 rows=1 width=23) (actual rows= loops=)

  • Sort Key: bf_1.elementid
76. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.39..76.87 rows=1 width=23) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.11..47.65 rows=1 width=35) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..18.43 rows=1 width=47) -> Nested Loop (cost=0.42..17.14 rows=1 width=58) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_classifassignment_001b "bf2$classificationof" (cost=0.00..8.71 rows=1 width=23) (actual rows= loops=)

  • Filter: ((classificationname IS NOT NULL) AND (upper((classificationitemcode)::text) ~~ '%SL_90_60_02%'::text))
80. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b bf2 (cost=0.42..8.44 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = ("bf2$classificationof".elementid)::text)
81. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b bf_1 (cost=0.42..1.29 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (bf2.elementid)::text)
82. 0.000 0.000 ↓ 0.0

Index Scan using idx2_bimrl_objhier on bimrl_objecthierarchy bimrl_objecthierarchy_9 (cost=0.28..14.75 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((elementsubtype)::text = (bf2.elementtype)::text)
  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
83. 0.000 0.000 ↓ 0.0

Index Scan using idx2_bimrl_objhier on bimrl_objecthierarchy bimrl_objecthierarchy_10 (cost=0.28..14.75 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((elementsubtype)::text = (bf_1.elementtype)::text)
  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
84. 0.000 0.000 ↓ 0.0

Unique (cost=15,188.35..15,188.36 rows=1 width=23) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Sort (cost=15,188.35..15,188.36 rows=1 width=23) (actual rows= loops=)

  • Sort Key: bf_2.elementid
86. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.42..15,188.34 rows=1 width=23) (actual rows= loops=)

  • Join Filter: ((bf_2.elementtype)::text = (bimrl_objecthierarchy_12.elementsubtype)::text)
87. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..15,140.29 rows=2 width=35) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.00..15,123.42 rows=2 width=23) (actual rows= loops=)

  • Join Filter: ((bf3.elementtype)::text = (bimrl_objecthierarchy_11.elementsubtype)::text)
89. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_element_001b bf3 (cost=0.00..15,074.62 rows=7 width=35) (actual rows= loops=)

  • Filter: (upper((longname)::text) ~~ '%AIR WELL%'::text)
90. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..47.77 rows=10 width=18) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy bimrl_objecthierarchy_11 (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
92. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b bf_2 (cost=0.42..8.44 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (bf3.elementid)::text)
93. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..47.77 rows=10 width=18) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy bimrl_objecthierarchy_12 (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCSPACE'::text)
95. 0.000 0.000 ↓ 0.0

Function Scan on spatial_interact f_1 (cost=0.25..10.25 rows=1,000 width=192) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Sort (cost=51,833.84..51,842.18 rows=3,335 width=114) (actual rows= loops=)

  • Sort Key: vent_1.elementid
97. 0.000 0.000 ↓ 0.0

Subquery Scan on vent_1 (cost=51,571.99..51,638.69 rows=3,335 width=114) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

HashAggregate (cost=51,571.99..51,605.34 rows=3,335 width=210) (actual rows= loops=)

  • Group Key: cc_1.elementid, "cc1$properties_1".propertygroupname, "cc1$properties_1".propertyvalue, "cc1$properties_1".propertyname
99. 0.000 0.000 ↓ 0.0

Append (cost=20,758.07..51,538.64 rows=3,335 width=210) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Unique (cost=20,758.07..20,758.08 rows=1 width=70) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Sort (cost=20,758.07..20,758.07 rows=1 width=70) (actual rows= loops=)

  • Sort Key: cc_1.elementid, "cc1$properties_1".propertygroupname, "cc1$properties_1".propertyvalue, "cc1$properties_1".propertyname
102. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=20,690.08..20,758.06 rows=1 width=70) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=20,689.80..20,728.84 rows=1 width=82) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,689.52..20,699.63 rows=1 width=94) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,689.11..20,698.33 rows=1 width=128) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,688.68..20,696.71 rows=1 width=58) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

HashAggregate (cost=20,688.26..20,688.27 rows=1 width=23) (actual rows= loops=)

  • Group Key: (bimrl_properties_001b_1.elementid)::text
108. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_properties_001b bimrl_properties_001b_1 (cost=0.00..20,688.26 rows=1 width=23) (actual rows= loops=)

  • Filter: ((upper((propertygroupname)::text) ~~ 'PSET_WINDOWCOMMON'::text) AND (upper((propertyname)::text) = 'ISEXTERNAL'::text))
109. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b cc1_1 (cost=0.42..8.44 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (bimrl_properties_001b_1.elementid)::text)
110. 0.000 0.000 ↓ 0.0

Index Scan using idx1_bimrl_properties_001b on bimrl_properties_001b "cc1$properties_1" (cost=0.42..1.61 rows=1 width=70) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (cc1_1.elementid)::text)
  • Filter: ((upper((propertyvalue)::text) ~~ '%TRUE%'::text) AND (upper((propertygroupname)::text) ~~ 'PSET_WINDOWCOMMON'::text) AND (upper((propertyname)::text) = 'ISEXTERNAL'::text))
111. 0.000 0.000 ↓ 0.0

Index Scan using bimrl_element_001b_pkey on bimrl_element_001b cc_1 (cost=0.42..1.29 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((elementid)::text = (cc1_1.elementid)::text)
112. 0.000 0.000 ↓ 0.0

Index Scan using idx2_bimrl_objhier on bimrl_objecthierarchy bimrl_objecthierarchy_13 (cost=0.28..14.75 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((elementsubtype)::text = (cc1_1.elementtype)::text)
  • Filter: (upper((elementtype)::text) = 'IFCWINDOW'::text)
113. 0.000 0.000 ↓ 0.0

Index Scan using idx2_bimrl_objhier on bimrl_objecthierarchy bimrl_objecthierarchy_14 (cost=0.28..14.75 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((elementsubtype)::text = (cc_1.elementtype)::text)
  • Filter: (upper((elementtype)::text) = 'IFCWINDOW'::text)
114. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2_1 (cost=30,730.53..30,780.54 rows=3,334 width=119) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Unique (cost=30,730.53..30,747.20 rows=3,334 width=119) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Sort (cost=30,730.53..30,738.87 rows=3,334 width=119) (actual rows= loops=)

  • Sort Key: bc_1.elementid
117. 0.000 0.000 ↓ 0.0

Hash Join (cost=15,364.66..30,535.44 rows=3,334 width=119) (actual rows= loops=)

  • Hash Cond: ((bc1_1.elementid)::text = (bc_1.elementid)::text)
118. 0.000 0.000 ↓ 0.0

Hash Join (cost=47.97..15,129.16 rows=15,002 width=23) (actual rows= loops=)

  • Hash Cond: ((bc1_1.elementtype)::text = (bimrl_objecthierarchy_15.elementsubtype)::text)
119. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_element_001b bc1_1 (cost=0.00..14,737.08 rows=67,508 width=35) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Hash (cost=47.85..47.85 rows=10 width=18) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

HashAggregate (cost=47.75..47.85 rows=10 width=18) (actual rows= loops=)

  • Group Key: (bimrl_objecthierarchy_15.elementsubtype)::text
122. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy bimrl_objecthierarchy_15 (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCOPENINGELEMENT'::text)
123. 0.000 0.000 ↓ 0.0

Hash (cost=15,129.16..15,129.16 rows=15,002 width=23) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Hash Join (cost=47.97..15,129.16 rows=15,002 width=23) (actual rows= loops=)

  • Hash Cond: ((bc_1.elementtype)::text = (bimrl_objecthierarchy_16.elementsubtype)::text)
125. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_element_001b bc_1 (cost=0.00..14,737.08 rows=67,508 width=35) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Hash (cost=47.85..47.85 rows=10 width=18) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

HashAggregate (cost=47.75..47.85 rows=10 width=18) (actual rows= loops=)

  • Group Key: (bimrl_objecthierarchy_16.elementsubtype)::text
128. 0.000 0.000 ↓ 0.0

Seq Scan on bimrl_objecthierarchy bimrl_objecthierarchy_16 (cost=0.00..47.72 rows=10 width=18) (actual rows= loops=)

  • Filter: (upper((elementtype)::text) = 'IFCOPENINGELEMENT'::text)