title: Why did the query run so long in BigQuery
body: <p>I run a query on the really small amount of intraday GA data (about 166 rows).</p>
  
  <pre><code>SELECT pagePath
  FROM `dataset_id.ga_sessions_intraday_*`
  WHERE pagePath NOT IN (SELECT pagePath FROM `dataset_id.ga_sessions_intraday_*` WHERE type = 'EVENT') AND Type = 'PAGE'
  </code></pre>
  
  <p>After running the query, there was a counter: "Query running (792.7s)..." that kept going up and up. By 3000 s, I accidentally refreshed the windows in the browser and now there is even no sign of the query that was running in Query History. </p>
  
  <p>Why did it take so much time to run the query? Why is the query not available in the Query History? </p>