Definition of a high-traffic table for ‘with_lock_retries’
Should we have a standard definition what a high-traffic table is?
Solution proposal
Use the below table to find 3 monthly average of updates to that table
select avg(count) from
(select date_trunc('month', updated_at),
count(*) as count
from users
where updated_at > '2020-03-01'
AND updated_at < '2020-06-01'
group by 1) monthly_counts;
Edited by Alper Akgun