DTrace

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(+cat)
m (Remove dead links)
Line 5: Line 5:
 
* [http://pgfoundry.org/docman/?group_id=1000163 PostgreSQL DTrace Users Guide]
 
* [http://pgfoundry.org/docman/?group_id=1000163 PostgreSQL DTrace Users Guide]
 
* [http://lethargy.org/~jesus/writes/postgresql-performance-through-the-eyes-of-dtrace PostgreSQL performance through the eyes of DTrace] and [http://lethargy.org/~jesus/writes/postgresql-looking-under-the-hood-with-solaris Looking under the hood with Solaris].  The pg_file_stress utility there is being migrated to [http://labs.omniti.com/trac/pgtreats Tasty Treats for PostgreSQL].
 
* [http://lethargy.org/~jesus/writes/postgresql-performance-through-the-eyes-of-dtrace PostgreSQL performance through the eyes of DTrace] and [http://lethargy.org/~jesus/writes/postgresql-looking-under-the-hood-with-solaris Looking under the hood with Solaris].  The pg_file_stress utility there is being migrated to [http://labs.omniti.com/trac/pgtreats Tasty Treats for PostgreSQL].
* [http://blogs.sun.com/jkshah/entry/profiling_postgresql_using_dtrace_on Profiling PostgreSQL using DTRACE on Solaris 10]
 
* [http://blogs.sun.com/robertlor/entry/user_level_dtrace_probes_in User-Level DTrace Probes in PostgreSQL 8.2]
 
  
 
General DTrace information:
 
General DTrace information:

Revision as of 19:48, 8 February 2014

DTrace is a technology for tracing arbitrary points in program execution. Originally developed for Solaris, it has since become available in one form or another on Mac OS and FreeBSD. PostgreSQL has included basic DTrace support since version 8.2, with newer versions (8.4 in particular) expanding the number of probe points in the database available.

Introduction to PostgreSQl and DTrace:

General DTrace information:

Example PostgreSQL DTrace scripts:

SystemTap & Linux

It's also possible to use the PostgreSQL DTrace probes on some recent Linux systems through the Systemtap user space markers feature:

Personal tools