# run execution by cte in a model - ideas/suggestions

**URL:** <https://discourse.getdbt.com/t/run-execution-by-cte-in-a-model-ideas-suggestions/5155>\
**Category:** Help\
**Tags:** best-practice\
**Created:** [October 22, 2022, 11:24am UTC](https://discourse.getdbt.com/t/run-execution-by-cte-in-a-model-ideas-suggestions/5155 "2022-10-22T11:24:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![obar1](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/obar1/32/1221_2.png) [@obar1](https://discourse.getdbt.com/u/obar1)\
**Post date:** [October 22, 2022, 11:24am UTC](https://discourse.getdbt.com/t/run-execution-by-cte-in-a-model-ideas-suggestions/5155/1 "2022-10-22T11:24:12Z")

</div>

hello  
you have a model with a couple lot of CTE - how do you check it looking for slow runners  
unfortunately

```auto
  {{ log("HERE", info = true) }}

```

does not work if you paste here and there in the model  
they print in the logs at parse time not at runtime

```auto
10:42:05 1 of 2 START table model xxx...... [RUN]
10:42:05 HERE
10:42:05 HERE
10:42:05 HERE

```

so not doing what I need

> apart splitting them as intermediate models

---

<div class="post-metadata">

**Author:** ![cristi](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristi](https://discourse.getdbt.com/u/cristi)\
**Post date:** [October 27, 2022, 7:48am UTC](https://discourse.getdbt.com/t/run-execution-by-cte-in-a-model-ideas-suggestions/5155/2 "2022-10-27T07:48:10Z")

</div>

interested as well. did you find why it doesnt work ?

---

<div class="post-metadata">

**Author:** ![obar1](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/obar1/32/1221_2.png) [@obar1](https://discourse.getdbt.com/u/obar1)\
**Post date:** [October 27, 2022, 6:10pm UTC](https://discourse.getdbt.com/t/run-execution-by-cte-in-a-model-ideas-suggestions/5155/3 "2022-10-27T18:10:57Z")

</div>

I have been using dbt v1.0 - I upgraded to v1.2 maybe it will work there

 ![image](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/2X/8/84ae0e52a1854b51b7ab42ef3e7faebbe5ecb649.png)