Too many waits on extension of relation

From: avinash varma <avinashvarma443(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Too many waits on extension of relation
Date: 2020-10-05 05:02:55
Message-ID: CADaHE9EBXQxGW4OnkNO39pkd65C26c5hv09KyONS+LJAPpcVHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Team,

Can someone please guide me how to improve/reduce these wait events.

Postgres Version:9.5

LOG: process 3718 still waiting for ExclusiveLock on extension of relation
266775 of database 196511 after 1000.057 ms

*Detail:* Process holding the lock: 6423. Wait queue: 3718, 4600, 2670,
4046.
*Context:* SQL statement "INSERT INTO
cms_c207c1e2_0ce7_422c_aafb_77d43f61e563.cms_item
(display_name,ancestor_ids,content_size,case_node_id,case_model_id,case_instance_id,properties,mime_type,linked_ancestor_ids,linked_parent_folder_ids,payload_id,category,owner_id,version_no,latest,lock_time,lock_owner_id,version_label,chronicle_id,acl_id,trait_names,tags,parent_folder_id,updated_by,created_by,update_time,create_time,description,type,name,etag,id)
VALUES
(new.display_name,new.ancestor_ids,new.content_size,new.case_node_id,new.case_model_id,new.case_instance_id,json,new.mime_type,new.linked_ancestor_ids,new.linked_parent_folder_ids,new.payload_id,new.category,new.owner_id,new.version_no,new.latest,new.lock_time,new.lock_owner_id,new.version_label,new.chronicle_id,new.acl_id,new.trait_names,new.tags,new.parent_folder_id,new.updated_by,new.created_by,new.update_time,new.create_time,new.description,new.type,
new.name,new.etag,new.id)"

Thanks & Regards,
Avinash.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Lewis 2020-10-05 16:44:10 Re: Too many waits on extension of relation
Previous Message Hannah Huang 2020-10-01 04:51:24 Re: SSL connection getting rejected on AWS RDS