net._http_response query consume 97% of time...

Hello, In the query performance report this query takes 97% of time consumption :

with
  rows as (
    select
      ctid
    from
      net._http_response
    where
      created < now() - $1
    order by
      created
    limit
      $2
  )
delete from net._http_response r using rows
where
  r.ctid = rows.ctid

with
  rows as (
    select
      ctid
    from
      net._http_response
    where
      created < now() - $1
    order by
      created
    limit
      $2
  )
delete from net._http_response r using rows
where
  r.ctid = rows.ctid

with
  rows as (
    select
      ctid
    from
      net._http_response
    where
      created < now() - $1
    order by
      created
    limit
      $2
  )
delete from net._http_response r using rows
where
  r.ctid = rows.ctid

with
  rows as (
    select
      ctid
    from
      net._http_response
    where
      created < now() - $1
    order by
      created
    limit
      $2
  )
delete from net._http_response r using rows
where
  r.ctid = rows.ctid

I see that it a query who cleanning the net._http_response table.
Why does this query consume so many resources? And can it be optimized?

Thanks for your help !

net._http_response query consume 97% of time...

Similar Threads

Similar Threads

Similar Threads