=?utf-8?b?TWljaGHFgg==?= Roszka <mike@if-then-else.pl> writes:
> Quoting Raimon Fernandez <coder@montx.com>:
>> I want to understand why one of my postgresql functions takes an
>> eternity to finish.
> Maybe there is any check or constraint on belongs_to_compte_id.comptes that
> might take longer?
Or maybe the UPDATE is blocked on a lock ... did you look into
pg_stat_activity or pg_locks to check?
regards, tom lane