Re: Too many waits on extension of relation

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