On Mon, 2020-10-05 at 10:32 +0530, avinash varma wrote: > 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 [...]
Process 6423 is holding a lock on the table into which you'd like to INSERT that blocks several other sessions. Make sure that the transaction in this database session ends, e.g. by SELECT pg_cancel_backend(6423); Either there is a session that did not close its transaction (coding bug), or a database statement ran inordinately long. Yours, Laurenz Albe -- +43-670-6056265 CYBERTEC PostgreSQL International GmbH Gröhrmühlgasse 26, A-2700 Wiener Neustadt Web: https://www.cybertec-postgresql.com
