Too many waits on extension of relation - Mailing list pgsql-performance

From avinash varma
Subject Too many waits on extension of relation
Date
Msg-id CADaHE9EBXQxGW4OnkNO39pkd65C26c5hv09KyONS+LJAPpcVHQ@mail.gmail.com
Whole thread Raw
Responses Re: Too many waits on extension of relation  (Michael Lewis <mlewis@entrata.com>)
List 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.

pgsql-performance by date:

Previous
From: Hannah Huang
Date:
Subject: Re: SSL connection getting rejected on AWS RDS
Next
From: Michael Lewis
Date:
Subject: Re: Too many waits on extension of relation