PostgreSQL User-Space Markers

Newer versions of PostgreSQL include support for SystemTap user-space markers. The PostgreSQL user-space markers are enabled in Fedora 11 and Red Hat Enterprise Linux 6. The markers allow SystemTap to probe various PostgreSQL events including the start of a query, the completion of a query and lock operations. You can refer to the documentation in Monitoring Database Activity for a list of probe points available. You can list the available probe points with the following command:

Using PostgreSQL User-Space Markers

To use the PostgreSQL user-space markers on a Fedora you will need:

Examples and Demonstrations of Markers

Some short SystemTap example scripts for PostgreSQL:

A video demonstration of the PostgreSQL user-space markers.


None: PostgresqlMarkers (last edited 2012-01-16 21:35:28 by WilliamCohen)