Skip to main content

frozenid

Short Description

Waiting to update pg_database.datfrozenxid and pg_database.datminmxid

Detailed Description

The session is waiting to update the catalog information which keeps track of transaction ids which have been frozen and if a vacuum operation is needed to avoid a wraparound.

How to reduce this wait

Ensure your database autovacuum enabled.

PostgreSQL Docs - Wait Events of Type Lock

PostgreSQL Docs - Vacuum

PostgreSQL Docs - datfrozenxid

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.