No Seriously, Where Does The Time Go?


I’ve posted quite a bit about how cached plans can be misleading.

I’m gonna switch that up and talk about how an actual plan can be misleading, too.

In plans that include calling a muti-statement table valued function, no operator logs the time spent in the function. I’ve got a User Voice item for it here.

Here’s an example:

     p.Id AS [Post Link],
FROM dbo.VoteStats() AS vs --The function
JOIN dbo.Posts AS p
    ON vs.postid = p.Id
WHERE vs.down > vs.up_multiplier
AND   p.CommunityOwnedDate IS NULL
AND   p.ClosedDate IS NULL

When I run the query, it drags on for 30-ish seconds, but the plan says that it only ran for about 2.7 seconds.

As we proceed

But there it is in Query Time Stats! 29 seconds. What gives?

Hi there!


If we look at the estimated plan for the function, we can see quite a thick arrow pointing to the table variable we populate for our results.


That process is all part of the query, but it doesn’t show up in any of the operators. It really should.

More specifically, I think it should show up right here.

If you agree, vote for my User Voice item.

Thanks for reading!

One thought on “No Seriously, Where Does The Time Go?

Leave a Reply

Your email address will not be published. Required fields are marked *