Skip to content

Latest commit

 

History

History
79 lines (77 loc) · 7.02 KB

PostgreSQL.md

File metadata and controls

79 lines (77 loc) · 7.02 KB

PostgreSQL

  • postgresql*:::statement-start(const char *)
    • Fires any time SQL is executed on the server. copyinstr(arg0) is the query.
  • postgresql*:::mark-dirty(uint32_t)
    • Fires when a buffer in the shared buffer pool is marked dirty for the first time. The first argument is the buffer (id).
  • postgresql*:::local-mark-dirty(uint32_t)
    • When a local buffer in the shared buffer pool is marked dirty for the first time. The first argument is the buffer (id).
  • postgresql*:::slru-readpage-entry(uintptr_t, uint32_t, uint32_t, uint32_t)
    • Fires on the entry to the slru SimpleLruReadPage function. arg0 is a pointer to the PostgreSQL SlruCtl. arg1 is the page number, arg2 is 0 or 1, indicating if the page needs to be writable. arg3 is the transaction id (xid).
  • postgresql*:::slru-readpage-return(uint32_t)
    • Fires when the slru SimpleLruReadPage function returns. arg0 is the slot number of the page returned.
  • postgresql*:::slru-readpage-ro(uintptr_t, uint32_t, uint32_t)
    • Fires when the slru SimpleLruReadPage_ReadOnly function is entered. arg0 is a pointer to the PostgreSQL SlruCtl. arg1 is the page number. arg2 is the transaction id (xid).
  • postgresql*:::slru-writepage-entry(uintptr_t, uint32_t, uint32_t)
    • Fires when the slru SimpleLruWritePage function is entered. arg0 is a pointer to the PostgreSQL SlruCtl. arg1 is the page number. arg2 is the slot number.
  • postgresql*:::slru-writepage-return()
    • Fires when the slru SimpleLruWritePage function returns.
  • postgresql*:::slru-readpage-physical-entry(uintptr_t, char *, uint32_t, uint32_t)
    • Fires when the slru SlruPhysicalReadPage function is entered. arg0 is a pointer to the PostgreSQL SlruCtl. copyinstr(arg1) is the pathname of the file being read. arg2 is the page number. arg3 is the slot number.
  • postgresql*:::slru-readpage-physical-return(uint32_t, uint32_t, uint32_t)
    • Fires when the slru SlruPhysicalReadPage function returns. arg0 is 0 or 1 indicating success. arg1 is the internal error cause (only valid if arg0 is 0). arg2 is the system errno (only valid if arg0 is 0).
  • postgresql*:::slru-writepage-physical-entry(uintptr_t, uint32_t, uint32_t)
    • Fires when the slru SlruPhysicalWritePage function is entered. arg0 is a pointer to the PostgreSQL SlruCtl. arg1 is the page number. arg2 is the slot number.
  • postgresql*:::slru-writepage-physical-return(uint32_t, uint32_t, uint32_t)
    • Fires when the slru SlruPhysicalWritePage function returns. arg0 is 0 or 1 indicating success. arg1 is the internal error cause (only valid if arg0 is 0). arg2 is the system errno (only valid if arg0 is 0).
  • postgresql*:::xlog-insert(uint32_t, uint32_t)
    • Fires when data is inserted in the XLog. arg0 is the resource manager (rmid) for the record. arg1 represents the info flags.
  • postgresql*:::xlog-switch()
    • Fires when an XLog switch is requested. This is always immediately proceeded by an firing of the xlog-insert probe.
  • postgresql*:::xlog-checkpoint-entry(uint32_t, uint32_t)
    • Fires when a checkpoint is started in PostgreSQL. arg0 is checkpoint the flag set. arg1 the next transaction id (xid).
  • postgresql*:::xlog-checkpoint-return()
    • Fires when the checkpoint has completed.
  • postgresql*:::clog-checkpoint-entry()
    • Fires when the CLOG portion of the checkpoint is started. The CLOG checkpoint involves flushing out an SLRU, see the slru-* probes.
  • postgresql*:::clog-checkpoint-return()
    • Fires when the CLOG portion of the checkpoint is complete.
  • postgresql*:::multixact-checkpoint-entry()
    • Fires when the MultiXact portion of the checkpoint is started. The MultiXact checkpoint involves flushing out an SLRU, see the slru-* probes.
  • postgresql*:::multixact-checkpoint-return()
    • Fires when the MultiXact portion of the checkpoint is complete.
  • postgresql*:::subtrans-checkpoint-entry()
    • Fires when the SUBTRANS portion of the checkpoint is started. The SUBTRANS checkpoint involves flushing out an SLRU, see the slru-* probes.
  • postgresql*:::subtrans-checkpoint-return()
    • Fires when the SUBTRANS portion of the checkpoint is complete.
  • postgresql*:::buffers-checkpoint-entry(uint32_t)
    • Fires when the shared buffers portion of the checkpoint is started. arg0 represents the flags passed to the checkpoint.
  • postgresql*:::buffers-checkpoint-return()
    • Fires when the shared buffers portion of the checkpoint is complete.
  • postgresql*:::buffer-sync-entry(uint32_t, uint32_t)
    • Fires when the buffer pool syncing is started. arg0 is the total number of buffers. arg1 is the number it intends to write.
  • postgresql*:::buffer-sync-written(uint32_t)
    • Fires when the buffer pool syncing is in progress and a buffer has been successfully written.
  • postgresql*:::buffer-sync-return(uint32_t, uint32_t, uint32_t)
    • Fires when the buffer pool syncing is complete. arg0 is the total number of buffers. arg1 is the number actually written. arg2 is the number it intended to write.
  • postgresql*:::buffer-flush-entry(uint32_t, uint32_t, uint32_t, uint32_t)
    • Fires when a buffer flush is started. arg0 is database Oid. arg1 is the tablespace Oid. arg2 is the relation Oid. arg3 is the block number.
  • postgresql*:::buffer-flush-return(uint32_t, uint32_t, uint32_t, uint32_t)
    • Fires when a buffer flush is complete. arg0 is database Oid. arg1 is the tablespace Oid. arg2 is the relation Oid. arg3 is the block number.
  • postgresql*:::exec-scan(uintptr_t, uint32_t, uintptr_t);
  • postgresql*:::exec-agg(uintptr_t, uint32_t);
  • postgresql*:::exec-group(uintptr_t, uint32_t);
  • postgresql*:::exec-hash-multi(uintptr_t);
  • postgresql*:::exec-hashjoin(uintptr_t);
  • postgresql*:::exec-limit(uintptr_t);
  • postgresql*:::exec-material(uintptr_t);
  • postgresql*:::exec-mergejoin(uintptr_t);
  • postgresql*:::exec-nestloop(uintptr_t);
  • postgresql*:::exec-setop(uintptr_t);
  • postgresql*:::exec-sort(uintptr_t, uint32_t);
  • postgresql*:::exec-subplan-hash(uintptr_t);
  • postgresql*:::exec-subplan-scan(uintptr_t);
  • postgresql*:::exec-unique(uintptr_t);
  • postgresql*:::autovacuum-start(uint32_t, char *)
    • Fires when a autovacuum process is started. arg0 is the database Oid. copyinstr(arg1) is the database name.
  • postgresql*:::autovacuum-relation(uint32_t, char *, char *, char *)
    • Fires when a relation is auto-vacuumed. arg0 is the relation Oid. copyinstr(arg1) is the database name. copyinstr(arg2) is the tablespace name. copyinstr(arg3) is the relation name.