Aurora PostgreSQL wait events

Client:ClientRead

This event occurs when Aurora PostgreSQL is waiting to receive data from the client.

Client:ClientWrite

This event occurs when Aurora PostgreSQL is waiting to write data to the client.

CPU

This event occurs when a thread is active in CPU or is waiting for CPU.

IO:BufFileRead and IO:BufFileWrite

These events occur when Aurora PostgreSQL creates temporary files.

IO:DataFileRead

This event occurs when a connection waits on a backend process to read a required page from storage because the page isn't available in shared memory.

IO:XactSync

This event occurs when the database is waiting for the Aurora storage subsystem to acknowledge the commit of a regular transaction, or the commit or rollback of a prepared transaction.

IPC:DamRecordTxAck

This event occurs when Aurora PostgreSQL in a session using database activity streams generates an activity stream event, then waits for that event to become durable.

Lock:advisory

This event occurs when a PostgreSQL application uses a lock to coordinate activity across multiple sessions.

Lock:extend

This event occurs when a backend process is waiting to lock a relation to extend it while another process has a lock on that relation for the same purpose.

Lock:Relation

This event occurs when a query is waiting to acquire a lock on a table or view that's currently locked by another transaction.

Lock:transactionid

This event occurs when a transaction is waiting for a row-level lock.

Lock:tuple

This event occurs when a backend process is waiting to acquire a lock on a tuple.

LWLock:buffer_content (BufferContent)

This event occurs when a session is waiting to read or write a data page in memory while another session has that page locked for writing.

LWLock:buffer_mapping

This event occurs when a session is waiting to associate a data block with a buffer in the shared buffer pool.

LWLock:BufferIO (IPC:BufferIO)

This event occurs when Aurora PostgreSQL or RDS for PostgreSQL is waiting for other processes to finish their input/output (I/O) operations when concurrently trying to access a page.

LWLock:lock_manager

This event occurs when the Aurora PostgreSQL engine maintains the shared lock's memory area to allocate, check, and deallocate a lock when a fast path lock isn't possible.

LWLock:MultiXact

Timeout:PgSleep

This event occurs when a server process has called the pg_sleep function and is waiting for the sleep timeout to expire.