explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yXQN

Settings
# exclusive inclusive rows x rows loops node
1. 0.125 1,285.532 ↑ 1.0 1 1

Result (cost=1,184.70..1,184.71 rows=1 width=0) (actual time=1,285.524..1,285.532 rows=1 loops=1)

2.          

CTE query_set

3. 0.015 0.015 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.008..0.015 rows=1 loops=1)

4.          

CTE main_entity

5. 0.012 0.127 ↑ 2.0 1 1

Bitmap Heap Scan on t_entity (cost=6.04..8.83 rows=2 width=8) (actual time=0.120..0.127 rows=1 loops=1)

  • Recheck Cond: (c_entity_key @> $1)
  • Heap Blocks: exact=1
6.          

Initplan (for Bitmap Heap Scan)

7. 0.015 0.015 ↑ 1.0 1 1

CTE Scan on query_set (cost=0.00..0.02 rows=1 width=32) (actual time=0.008..0.015 rows=1 loops=1)

8. 0.100 0.100 ↑ 2.0 1 1

Bitmap Index Scan on idx_entity_key_gin (cost=0.00..6.01 rows=2 width=0) (actual time=0.100..0.100 rows=1 loops=1)

  • Index Cond: (c_entity_key @> $1)
9.          

CTE required_attributes_set

10. 0.055 0.070 ↑ 33.3 3 1

Function Scan on jsonb_each_text (cost=0.02..1.52 rows=100 width=64) (actual time=0.048..0.070 rows=3 loops=1)

11.          

Initplan (for Function Scan)

12. 0.015 0.015 ↑ 1.0 1 1

CTE Scan on query_set query_set_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.008..0.015 rows=1 loops=1)

13.          

CTE main_children

14. 57.552 495.756 ↓ 5.2 3,740 1

Sort (cost=347.49..349.29 rows=718 width=234) (actual time=467.268..495.756 rows=3,740 loops=1)

  • Sort Key: el.c_linked_entity_id, a.c_attribute_type, l.c_validity_datetime DESC, l.c_datetime DESC
  • Sort Method: quicksort Memory: 1,090kB
15.          

Initplan (for Sort)

16. 0.158 0.158 ↑ 2.0 1 1

CTE Scan on main_entity (cost=0.00..0.04 rows=2 width=8) (actual time=0.135..0.158 rows=1 loops=1)

17. 77.691 438.046 ↓ 5.2 3,740 1

Hash Join (cost=118.02..313.39 rows=718 width=234) (actual time=64.368..438.046 rows=3,740 loops=1)

  • Hash Cond: (a.c_attribute_type = raset.key)
18. 83.924 359.984 ↓ 7.8 5,610 1

Hash Join (cost=108.89..287.21 rows=718 width=202) (actual time=63.908..359.984 rows=5,610 loops=1)

  • Hash Cond: (l.c_linked_attrib_id = a.c_attribute_id)
19. 111.807 242.265 ↓ 7.8 5,610 1

Nested Loop (cost=21.86..190.31 rows=718 width=147) (actual time=30.079..242.265 rows=5,610 loops=1)

  • Join Filter: (el.c_linked_entity_id = l.c_entity_id)
20. 29.140 72.488 ↓ 8.0 1,870 1

Hash Join (cost=21.58..88.19 rows=235 width=123) (actual time=30.042..72.488 rows=1,870 loops=1)

  • Hash Cond: (e.c_entity_id = el.c_linked_entity_id)
21. 14.915 14.915 ↓ 1.0 1,994 1

Seq Scan on t_entity e (cost=0.00..56.83 rows=1,983 width=107) (actual time=0.013..14.915 rows=1,994 loops=1)

22. 14.031 28.433 ↓ 8.0 1,870 1

Hash (cost=18.64..18.64 rows=235 width=16) (actual time=28.433..28.433 rows=1,870 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 104kB
23. 14.402 14.402 ↓ 8.0 1,870 1

Index Only Scan using idx_entity_link_pk on t_entity_to_entity_link el (cost=0.28..18.64 rows=235 width=16) (actual time=0.205..14.402 rows=1,870 loops=1)

  • Index Cond: (c_entity_id = $5)
  • Heap Fetches: 1,870
24. 57.970 57.970 ↑ 1.0 3 1,870

Index Scan using t_entity_to_attrib_link_c_entity_id_idx on t_entity_to_attrib_link l (cost=0.28..0.40 rows=3 width=32) (actual time=0.009..0.031 rows=3 loops=1,870)

  • Index Cond: (c_entity_id = e.c_entity_id)
25. 16.958 33.795 ↑ 1.0 2,246 1

Hash (cost=57.57..57.57 rows=2,357 width=63) (actual time=33.795..33.795 rows=2,246 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 248kB
26. 16.837 16.837 ↑ 1.0 2,246 1

Seq Scan on t_attribute a (cost=0.00..57.57 rows=2,357 width=63) (actual time=0.011..16.837 rows=2,246 loops=1)

27. 0.038 0.371 ↑ 33.3 3 1

Hash (cost=7.88..7.88 rows=100 width=40) (actual time=0.371..0.371 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
28. 0.071 0.333 ↑ 33.3 3 1

Hash Join (cost=4.50..7.88 rows=100 width=40) (actual time=0.266..0.333 rows=3 loops=1)

  • Hash Cond: (raset.key = required_attributes_set.key)
29. 0.086 0.086 ↑ 33.3 3 1

CTE Scan on required_attributes_set raset (cost=0.00..2.00 rows=100 width=36) (actual time=0.064..0.086 rows=3 loops=1)

30. 0.040 0.176 ↑ 33.3 3 1

Hash (cost=3.25..3.25 rows=100 width=4) (actual time=0.176..0.176 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
31. 0.061 0.136 ↑ 33.3 3 1

HashAggregate (cost=2.25..3.25 rows=100 width=4) (actual time=0.115..0.136 rows=3 loops=1)

  • Group Key: required_attributes_set.key
32. 0.075 0.075 ↑ 33.3 3 1

CTE Scan on required_attributes_set (cost=0.00..2.00 rows=100 width=4) (actual time=0.007..0.075 rows=3 loops=1)

33.          

CTE inherited_entity_type

34. 0.478 0.569 ↓ 30.5 61 1

Bitmap Heap Scan on t_entity e_1 (cost=6.04..8.83 rows=2 width=8) (actual time=0.100..0.569 rows=61 loops=1)

  • Recheck Cond: (c_entity_key @> $8)
  • Heap Blocks: exact=2
35.          

Initplan (for Bitmap Heap Scan)

36. 0.016 0.016 ↑ 1.0 1 1

CTE Scan on query_set query_set_2 (cost=0.00..0.02 rows=1 width=32) (actual time=0.008..0.016 rows=1 loops=1)

37. 0.075 0.075 ↓ 30.5 61 1

Bitmap Index Scan on idx_entity_key_gin (cost=0.00..6.01 rows=2 width=0) (actual time=0.075..0.075 rows=61 loops=1)

  • Index Cond: (c_entity_key @> $8)
38.          

CTE inherited_key_ea

39. 3.637 8.867 ↓ 30.5 183 1

Nested Loop (cost=0.33..9.53 rows=6 width=16) (actual time=2.021..8.867 rows=183 loops=1)

40. 0.920 3.339 ↓ 30.5 61 1

Unique (cost=0.05..0.06 rows=2 width=8) (actual time=1.984..3.339 rows=61 loops=1)

41. 0.914 2.419 ↓ 30.5 61 1

Sort (cost=0.05..0.06 rows=2 width=8) (actual time=1.967..2.419 rows=61 loops=1)

  • Sort Key: inherited_entity_type.c_entity_id
  • Sort Method: quicksort Memory: 27kB
42. 1.505 1.505 ↓ 30.5 61 1

CTE Scan on inherited_entity_type (cost=0.00..0.04 rows=2 width=8) (actual time=0.116..1.505 rows=61 loops=1)

43. 1.891 1.891 ↑ 1.0 3 61

Index Only Scan using t_entity_to_attrib_link_c_entity_id_idx on t_entity_to_attrib_link ea (cost=0.28..4.70 rows=3 width=16) (actual time=0.009..0.031 rows=3 loops=61)

  • Index Cond: (c_entity_id = inherited_entity_type.c_entity_id)
  • Heap Fetches: 183
44.          

CTE inherited_entites

45. 0.533 182.718 ↓ 11.3 34 1

HashAggregate (cost=21.06..21.09 rows=3 width=16) (actual time=182.463..182.718 rows=34 loops=1)

  • Group Key: ea_1.c_entity_id, ea_1.c_linked_attrib_id
46. 14.199 182.185 ↓ 11.3 34 1

Hash Join (cost=18.23..21.04 rows=3 width=16) (actual time=154.582..182.185 rows=34 loops=1)

  • Hash Cond: (mc.c_linked_attrib_id = ea_1.c_linked_attrib_id)
47. 28.164 154.978 ↓ 9.3 1,870 1

HashAggregate (cost=18.04..20.04 rows=200 width=8) (actual time=141.067..154.978 rows=1,870 loops=1)

  • Group Key: mc.c_linked_attrib_id
48. 41.954 126.814 ↓ 5.2 1,870 1

Hash Join (cost=0.04..17.14 rows=359 width=8) (actual time=0.137..126.814 rows=1,870 loops=1)

  • Hash Cond: (mc."attributeType" = query_set_3.link_inherited_attribute)
49. 84.789 84.789 ↓ 5.2 3,740 1

CTE Scan on main_children mc (cost=0.00..14.36 rows=718 width=40) (actual time=0.008..84.789 rows=3,740 loops=1)

50. 0.023 0.071 ↑ 1.0 1 1

Hash (cost=0.03..0.03 rows=1 width=32) (actual time=0.071..0.071 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
51. 0.033 0.048 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=32) (actual time=0.040..0.048 rows=1 loops=1)

  • Group Key: query_set_3.link_inherited_attribute
52. 0.015 0.015 ↑ 1.0 1 1

CTE Scan on query_set query_set_3 (cost=0.00..0.02 rows=1 width=32) (actual time=0.008..0.015 rows=1 loops=1)

53. 1.377 13.008 ↓ 30.5 183 1

Hash (cost=0.12..0.12 rows=6 width=16) (actual time=13.008..13.008 rows=183 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
54. 11.631 11.631 ↓ 30.5 183 1

CTE Scan on inherited_key_ea ea_1 (cost=0.00..0.12 rows=6 width=16) (actual time=2.037..11.631 rows=183 loops=1)

55.          

CTE inherited_attributes

56. 0.536 9.700 ↓ 3.8 34 1

HashAggregate (cost=20.60..20.72 rows=9 width=99) (actual time=9.447..9.700 rows=34 loops=1)

  • Group Key: ea_2.c_entity_id, ea_2.c_linked_attrib_id, atype.value, (a_1.c_attribute_value_jsonb ->> 'value'::text)
57. 1.058 9.164 ↓ 3.8 34 1

Hash Join (cost=3.81..20.51 rows=9 width=99) (actual time=0.338..9.164 rows=34 loops=1)

  • Hash Cond: (a_1.c_attribute_type = atype.key)
58. 3.051 8.036 ↓ 11.3 102 1

Nested Loop (cost=0.56..17.12 rows=9 width=71) (actual time=0.084..8.036 rows=102 loops=1)

59. 2.042 3.353 ↓ 11.3 102 1

Nested Loop (cost=0.28..14.26 rows=9 width=16) (actual time=0.047..3.353 rows=102 loops=1)

60. 0.257 0.257 ↓ 11.3 34 1

CTE Scan on inherited_entites ie (cost=0.00..0.06 rows=3 width=8) (actual time=0.008..0.257 rows=34 loops=1)

61. 1.054 1.054 ↑ 1.0 3 34

Index Only Scan using t_entity_to_attrib_link_c_entity_id_idx on t_entity_to_attrib_link ea_2 (cost=0.28..4.70 rows=3 width=16) (actual time=0.009..0.031 rows=3 loops=34)

  • Index Cond: (c_entity_id = ie.c_entity_id)
  • Heap Fetches: 102
62. 1.632 1.632 ↑ 1.0 1 102

Index Scan using t_attribute_pkey on t_attribute a_1 (cost=0.28..0.31 rows=1 width=63) (actual time=0.009..0.016 rows=1 loops=102)

  • Index Cond: (c_attribute_id = ea_2.c_linked_attrib_id)
63. 0.040 0.070 ↑ 33.3 3 1

Hash (cost=2.00..2.00 rows=100 width=36) (actual time=0.070..0.070 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
64. 0.030 0.030 ↑ 33.3 3 1

CTE Scan on required_attributes_set atype (cost=0.00..2.00 rows=100 width=36) (actual time=0.008..0.030 rows=3 loops=1)

65.          

CTE entity_to_entity_link

66. 55.466 267.242 ↓ 5.2 3,740 1

Hash Left Join (cost=0.10..17.26 rows=718 width=16) (actual time=183.549..267.242 rows=3,740 loops=1)

  • Hash Cond: (mc_1.c_linked_attrib_id = ie_1.attribute_key_link)
67. 28.263 28.263 ↓ 5.2 3,740 1

CTE Scan on main_children mc_1 (cost=0.00..14.36 rows=718 width=16) (actual time=0.008..28.263 rows=3,740 loops=1)

68. 0.270 183.513 ↓ 11.3 34 1

Hash (cost=0.06..0.06 rows=3 width=16) (actual time=183.513..183.513 rows=34 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
69. 183.243 183.243 ↓ 11.3 34 1

CTE Scan on inherited_entites ie_1 (cost=0.00..0.06 rows=3 width=16) (actual time=182.479..183.243 rows=34 loops=1)

70.          

CTE children_with_main

71. 42.784 432.153 ↓ 2.7 1,904 1

HashAggregate (cost=28.44..35.62 rows=718 width=96) (actual time=417.919..432.153 rows=1,904 loops=1)

  • Group Key: ia.c_entity_id, ia.c_linked_attrib_id, ia.value, ia.c_attribute_value, ee."entityId", ee.c_entity_id
72. 55.541 389.369 ↓ 5.2 3,740 1

Hash Left Join (cost=0.29..17.67 rows=718 width=96) (actual time=194.088..389.369 rows=3,740 loops=1)

  • Hash Cond: (ee.c_entity_id = ia.c_entity_id)
73. 323.334 323.334 ↓ 5.2 3,740 1

CTE Scan on entity_to_entity_link ee (cost=0.00..14.36 rows=718 width=16) (actual time=183.564..323.334 rows=3,740 loops=1)

74. 0.270 10.494 ↓ 3.8 34 1

Hash (cost=0.18..0.18 rows=9 width=80) (actual time=10.494..10.494 rows=34 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
75. 10.224 10.224 ↓ 3.8 34 1

CTE Scan on inherited_attributes ia (cost=0.00..0.18 rows=9 width=80) (actual time=9.463..10.224 rows=34 loops=1)

76.          

CTE current

77. 0.000 0.127 ↓ 0.0 0 1

GroupAggregate (cost=37.75..44.74 rows=200 width=160) (actual time=0.127..0.127 rows=0 loops=1)

  • Group Key: mc_2.entitykey
78.          

Initplan (for GroupAggregate)

79. 0.016 0.016 ↑ 1.0 1 1

CTE Scan on query_set query_set_4 (cost=0.00..0.02 rows=1 width=32) (actual time=0.009..0.016 rows=1 loops=1)

80. 0.018 0.112 ↓ 0.0 0 1

Sort (cost=37.73..38.62 rows=359 width=160) (actual time=0.112..0.112 rows=0 loops=1)

  • Sort Key: mc_2.entitykey
  • Sort Method: quicksort Memory: 25kB
81. 0.027 0.094 ↓ 0.0 0 1

Hash Semi Join (cost=2.25..22.49 rows=359 width=160) (actual time=0.094..0.094 rows=0 loops=1)

  • Hash Cond: (mc_2."attributeType" = jsonb_each_text_1.value)
82. 0.008 0.008 ↑ 718.0 1 1

CTE Scan on main_children mc_2 (cost=0.00..14.36 rows=718 width=160) (actual time=0.008..0.008 rows=1 loops=1)

83. 0.015 0.059 ↓ 0.0 0 1

Hash (cost=1.00..1.00 rows=100 width=32) (actual time=0.059..0.059 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
84. 0.044 0.044 ↓ 0.0 0 1

Function Scan on jsonb_each_text jsonb_each_text_1 (cost=0.00..1.00 rows=100 width=32) (actual time=0.044..0.044 rows=0 loops=1)

85.          

CTE history

86. 0.000 0.120 ↓ 0.0 0 1

HashAggregate (cost=26.10..29.10 rows=200 width=160) (actual time=0.120..0.120 rows=0 loops=1)

  • Group Key: mc_3.entitykey, mc_3."attributeType
87.          

Initplan (for HashAggregate)

88. 0.019 0.019 ↑ 1.0 1 1

CTE Scan on query_set query_set_5 (cost=0.00..0.02 rows=1 width=32) (actual time=0.012..0.019 rows=1 loops=1)

89. 0.027 0.103 ↓ 0.0 0 1

Hash Semi Join (cost=2.25..22.49 rows=359 width=160) (actual time=0.103..0.103 rows=0 loops=1)

  • Hash Cond: (mc_3."attributeType" = jsonb_each_text_2.value)
90. 0.008 0.008 ↑ 718.0 1 1

CTE Scan on main_children mc_3 (cost=0.00..14.36 rows=718 width=160) (actual time=0.008..0.008 rows=1 loops=1)

91. 0.016 0.068 ↓ 0.0 0 1

Hash (cost=1.00..1.00 rows=100 width=32) (actual time=0.068..0.068 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
92. 0.052 0.052 ↓ 0.0 0 1

Function Scan on jsonb_each_text jsonb_each_text_2 (cost=0.00..1.00 rows=100 width=32) (actual time=0.052..0.052 rows=0 loops=1)

93.          

CTE history_current

94. 0.015 0.352 ↓ 0.0 0 1

Subquery Scan on ch (cost=20.00..25.50 rows=200 width=96) (actual time=0.352..0.352 rows=0 loops=1)

95. 0.017 0.337 ↓ 0.0 0 1

HashAggregate (cost=20.00..22.50 rows=200 width=160) (actual time=0.337..0.337 rows=0 loops=1)

  • Group Key: c.entitykey, h.entitykey, c.current_object
96. 0.028 0.320 ↓ 0.0 0 1

Hash Full Join (cost=6.50..18.00 rows=200 width=160) (actual time=0.320..0.320 rows=0 loops=1)

  • Hash Cond: (c.entitykey = h.entitykey)
97. 0.143 0.143 ↓ 0.0 0 1

CTE Scan on current c (cost=0.00..4.00 rows=200 width=64) (actual time=0.143..0.143 rows=0 loops=1)

98. 0.015 0.149 ↓ 0.0 0 1

Hash (cost=4.00..4.00 rows=200 width=96) (actual time=0.149..0.149 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
99. 0.134 0.134 ↓ 0.0 0 1

CTE Scan on history h (cost=0.00..4.00 rows=200 width=96) (actual time=0.134..0.134 rows=0 loops=1)

100.          

CTE children_inherited_attributes

101. 59.878 1,231.157 ↑ 1.4 1,870 1

GroupAggregate (cost=309.38..451.17 rows=2,578 width=192) (actual time=1,142.872..1,231.157 rows=1,870 loops=1)

  • Group Key: mc_4.entitykey, hc.history_and_current
102. 87.076 1,171.279 ↓ 1.5 3,808 1

Sort (cost=309.38..315.83 rows=2,578 width=192) (actual time=1,142.784..1,171.279 rows=3,808 loops=1)

  • Sort Key: mc_4.entitykey, hc.history_and_current
  • Sort Method: quicksort Memory: 883kB
103. 56.480 1,084.203 ↓ 1.5 3,808 1

Hash Join (cost=29.84..163.32 rows=2,578 width=192) (actual time=942.802..1,084.203 rows=3,808 loops=1)

  • Hash Cond: (mc_4."entityId" = cwm."entityId")
104. 56.674 552.655 ↓ 5.2 3,740 1

Hash Left Join (cost=6.50..47.79 rows=718 width=136) (actual time=467.702..552.655 rows=3,740 loops=1)

  • Hash Cond: (mc_4.entitykey = hc.entitykey)
105. 495.598 495.598 ↓ 5.2 3,740 1

CTE Scan on main_children mc_4 (cost=0.00..14.36 rows=718 width=104) (actual time=467.286..495.598 rows=3,740 loops=1)

106. 0.015 0.383 ↓ 0.0 0 1

Hash (cost=4.00..4.00 rows=200 width=64) (actual time=0.383..0.383 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
107. 0.368 0.368 ↓ 0.0 0 1

CTE Scan on history_current hc (cost=0.00..4.00 rows=200 width=64) (actual time=0.368..0.368 rows=0 loops=1)

108. 14.284 475.068 ↓ 2.7 1,904 1

Hash (cost=14.36..14.36 rows=718 width=72) (actual time=475.068..475.068 rows=1,904 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 92kB
109. 460.784 460.784 ↓ 2.7 1,904 1

CTE Scan on children_with_main cwm (cost=0.00..14.36 rows=718 width=72) (actual time=417.936..460.784 rows=1,904 loops=1)

110.          

CTE children_no_inherited_attributes

111. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=54.97..71.12 rows=718 width=128) (never executed)

  • Group Key: mc_5.entitykey, hc_1.history_and_current
112. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6.50..47.79 rows=718 width=128) (never executed)

  • Hash Cond: (mc_5.entitykey = hc_1.entitykey)
113. 0.000 0.000 ↓ 0.0 0

CTE Scan on main_children mc_5 (cost=0.00..14.36 rows=718 width=96) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Hash (cost=4.00..4.00 rows=200 width=64) (never executed)

115. 0.000 0.000 ↓ 0.0 0

CTE Scan on history_current hc_1 (cost=0.00..4.00 rows=200 width=64) (never executed)

116.          

Initplan (for Result)

117. 0.048 0.048 ↑ 1.0 1 1

CTE Scan on query_set query_set_6 (cost=0.00..0.02 rows=1 width=32) (actual time=0.025..0.048 rows=1 loops=1)

118. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.16..16.17 rows=1 width=32) (never executed)

119. 0.000 0.000 ↓ 0.0 0

CTE Scan on children_no_inherited_attributes (cost=0.00..14.36 rows=718 width=32) (never executed)

120. 25.765 1,285.359 ↑ 1.0 1 1

Aggregate (cost=58.01..58.02 rows=1 width=32) (actual time=1,285.352..1,285.359 rows=1 loops=1)

121. 1,259.594 1,259.594 ↑ 1.4 1,870 1

CTE Scan on children_inherited_attributes (cost=0.00..51.56 rows=2,578 width=32) (actual time=1,142.888..1,259.594 rows=1,870 loops=1)

122. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.16..16.17 rows=1 width=32) (never executed)

123. 0.000 0.000 ↓ 0.0 0

CTE Scan on children_no_inherited_attributes children_no_inherited_attributes_1 (cost=0.00..14.36 rows=718 width=32) (never executed)

Planning time : 2.437 ms
Execution time : 1,286.251 ms