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
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 !
1 Reply
It could be you are not doing much else. Look at execution time. I know pg_net polls.