Skip to Content
0
Jan 15, 2018 at 11:48 AM

What are Open, Fetch, Close in Timeline View?

115 Views Last edit Jan 15, 2018 at 12:00 PM 2 rev

In PlanViz timeline view, executed operations can be in several states: Open, Fetch, Close, Pop, Sleep, Overhead

In a pop state, a physical operator is executed, the sleep state shows that an operation is currently not active but what do the Open, Fetch and Close states mean?

I can imagine that "Open"/"Close" means that a statement opens/clodes access to a table and "Fetch" means getting the data after having opened it.

Example (upper in Open state, lower in Fetch state):

However, first, I have not found any information in my books or in the web that confirms this assumption and second, I would like to know what exactly happens in these states technically.

Can anyone provide more detailed information about these three states?