- publishing free software manuals
PostgreSQL Reference Manual - Volume 3 - Server Administration Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 204 pages
ISBN 0954612043
RRP £13.95 ($24.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

12.4.2 Built-in Trace Points

A few standard trace points are provided in the source code (of course, more can be added as needed for a particular problem). These are shown in Table 12-3.

Table 12-3: Built-in Trace Points
Name Parameters Overview
transaction__start (int transactionId) The start of a new transaction.
transaction__commit (int transactionId) The successful completion of a transaction.
transaction__abort (int transactionId) The unsuccessful completion of a transaction.
lwlock__acquire (int lockid, int mode) An LWLock has been acquired.
lwlock__release (int lockid, int mode) An LWLock has been released.
lwlock__startwait (int lockid, int mode) An LWLock was not immediately available and a backend has begun to wait for the lock to become available.
lwlock__endwait (int lockid, int mode) A backend has been released from its wait for an LWLock.
lwlock__condacquire (int lockid, int mode) An LWLock was successfully acquired when the caller specified no waiting.
lwlock__condacquire__fail (int lockid, int mode) An LWLock was not successfully acquired when the caller specified no waiting.
lock__startwait (int locktag_field2, int lockmode) A request for a heavyweight lock (lmgr lock) has begun to wait because the lock is not available.
lock__endwait (int locktag_field2, int lockmode) A request for a heavyweight lock (lmgr lock) has finished waiting (i.e., has acquired the lock).
ISBN 0954612043PostgreSQL Reference Manual - Volume 3 - Server Administration GuideSee the print edition