title: Get all entries where the following entry is not +1 minute
body: <p>I have a table which stores all my executed jobs. Know I want to know if all the jobs get executed properly (every minute). Each entry has a <code>created_at</code> timestamp.</p>
  <p>My question now is how can I select all entries which where not executed 1 minute after the last entry. This is a very complex query I feel like. So far I just have all the entries orderd by <code>created_at</code>.</p>
  <pre><code>SELECT * 
  FROM jobs 
  WHERE created_at IS NOT NULL 
  ORDER By created_at
  </code></pre>
  <p><code>created_at</code> is a timestamp. Something like <code>2020-02-02 10:00:00</code>.</p>
  <p>Table Structure:</p>
  <pre class="lang-none prettyprint-override"><code>id    job_name  created_at
  -----------------------------------
  1     ABC       2020-02-02 10:00:00
  2     ABC       2020-02-02 10:01:00
  3     ABC       2020-02-02 10:02:00
  4     ABC       2020-02-02 10:04:00
  5     ABC       2020-02-02 10:07:00
  </code></pre>
  <p>The result I want is:
  Now I want to get all dates where the job didn't get executed. So, at <code>10:03:00</code>, <code>10:05:00</code> and <code>10:06:00</code> the job didn't get executed!</p>
  <p>Do you guys have any idea? I guess its a recursive query. This query needs to be written in postgres.</p>