title: TimescaleDB: force refresh or stability continuous aggregated views in functional testing
body: <p>I am using TimescaleDB as a backend for time-series data. Now I am writing some unit and functional tests against this backend.</p>
  <ul>
  <li><p>I spin up a new database from a PostgreSQL template</p>
  </li>
  <li><p>The template has continuos aggregated views set up</p>
  </li>
  <li><p>I load up data from test fixtures using bulk <code>INSERT</code>, etc.</p>
  </li>
  <li><p>Now I want my tests to query against those aggregated views</p>
  </li>
  </ul>
  <p>However, as far as I understand, continuous aggregated views are refreshed on a background by TimescaleDB worker processes. For the test to be correct, I need to be sure that all continuous aggregated views are up-to-date.</p>
  <p>Is there a way for me to query TimescaleDB for the updateness of a continuous aggregated view and wait until it has properly ingested all data as the result of INSERTs? Or should any INSERT automatically be reflected in all continuous aggregated views on commit?</p>