How to subtract seconds from current timestamp
<p>I'm trying to create a query which will get the results that were inserted in the last 10 seconds:</p>

<pre class="lang-sql prettyprint-override"><code>SELECT *
  FROM table
  WHERE client_id = 1
    AND hash = 'x'
    AND insert_time &gt;= current_timestamp - **10 seconds**
</code></pre>

<p>I've been searching how to subtract 10 seconds from the current timestamp, but I didn't succeed yet.</p>