title: Take last hour and group it by 1 minute
body: <p>I was wondering if you can help me write a query that should just SELECT count(*) but only include data from last hour and group it by minute.</p>
  <p>So I have a table that has a <code>createdts</code> so I have the date there. I just want to see how many entries I have in the last hour, but group <code>COUNT(*)</code> per minute.</p>
  <pre><code>SELECT COUNT(*) FROM mytable 
  WHERE createdts &gt;= now()::date - interval '1 hour'
  GROUP BY 'every minute'
  </code></pre>