Where Postgres Update is spending time and how to optimize it?
The table has close to 250 million records and I am trying to update certain records and it take close to 45s, just want to understand if there a way to optimise it.
Query:
The table has close to 250 million records and I am trying to update certain records and it take close to 45s, just want to understand if there a way to optimise it.
Query: