update on related table

[sasog23]

if I update the table global.organizations it takes more than 10s
is this normal behaviour ?

SELECT create_immv('servicedesk.hd_677533', '
SELECT h.id, h.created_at, h.updated_at, h.organization_id
, h.customer_id, cust.short_name AS "customer_name"
from servicedesk.helpdesk h
JOIN global.organizations cust on cust.id= h.customer_id
WHERE h.organization_id= 677533
');

[yugo-n]

Could you share your definition of tables and indexes, and the query you used to update a table?

[yugo-n]

In addition, it would be helpful if you could share the result of explain (analyze, verbose) of the udpate query because this contains the execution times of triggers that perform the actual view maintenance.