Archives: Wait Events

DataFileSync wait event (IO) — PostgreSQL

PostgreSQL IO wait event DataFileSync: Waiting for changes to a relation data file to reach durable storage.

DataFileTruncate wait event (IO) — PostgreSQL

PostgreSQL IO wait event DataFileTruncate: Waiting for a relation data file to be truncated.

DataFileWrite wait event (IO) — PostgreSQL

PostgreSQL IO wait event DataFileWrite: Waiting for a write to a relation data file.

DsmAllocate wait event (IO) — PostgreSQL

PostgreSQL IO wait event DsmAllocate: Waiting for a dynamic shared memory segment to be allocated.

DsmFillZeroWrite wait event (IO) — PostgreSQL

PostgreSQL IO wait event DsmFillZeroWrite: Waiting to fill a dynamic shared memory backing file with zeroes.

LockFileAddtodatadirRead wait event (IO) — PostgreSQL

PostgreSQL IO wait event LockFileAddtodatadirRead: Waiting for a read while adding a line to the data directory lock file.

LockFileAddtodatadirSync wait event (IO) — PostgreSQL

PostgreSQL IO wait event LockFileAddtodatadirSync: Waiting for data to reach durable storage while adding a line to the data directory…

LockFileAddtodatadirWrite wait event (IO) — PostgreSQL

PostgreSQL IO wait event LockFileAddtodatadirWrite: Waiting for a write while adding a line to the data directory lock file.

LockFileCreateRead wait event (IO) — PostgreSQL

PostgreSQL IO wait event LockFileCreateRead: Waiting to read while creating the data directory lock file.

LockFileCreateSync wait event (IO) — PostgreSQL

PostgreSQL IO wait event LockFileCreateSync: Waiting for data to reach durable storage while creating the data directory lock file.