Potential Standard Probes for All Databases
The following table lists probes that may be standardized and the status of their implementation among the various OSDBs.
| No | Name | Arguments | Description | PostgreSQL | MySQL | MaxDB | Ingres | Firebird |
|---|---|---|---|---|---|---|---|---|
| 1 | transaction-start | (unsigned int) | Probe that fires at the start of a new transaction. arg0 is the transaction id. |  (8.2+) |
||||
| 2 | transaction-commit | (unsigned int) | Probe that fires when a transaction completes successfully. arg0 is the transaction id. | (8.2+) |
||||
| 3 | transaction-abort | (unsigned int) | Probes that fires when a transaction does not complete successfully. arg0 is the transaction id. | (8.2+) |
||||
| 4 | query-parse-start | (const char *) | Probe that fires when the parsing of a query is started. arg0 is the query string. | (8.4+) |
||||
| 5 | query-parse-done | (const char *) | Probe that fires when the parsing of a query is complete. arg0 is the query string. | (8.4+) |
||||
| 6 | query-rewrite-start | (const char *) | Probe that fires when the rewriting of a query is started. arg0 is the query string. | (8.4+) |
||||
| 7 | query-rewrite-done | (const char *) | Probe that fires when the rewriting of a query is complete. arg0 is the query string. | (8.4+) |
||||
| 8 | query-plan-start | () | Probe that fires when the planning of a query is started. | (8.4+) |
||||
| 9 | query-plan-done | () | Probe that fires when the planning of a query is complete. | (8.4+) |
||||
| 10 | query-execute-start | () | Probe that fires when the execution of a query is started. | (8.4+) |
||||
| 11 | query-execute-done | () | Probe that fires when the execution of a query is complete. | (8.4+) |
||||
| 12 | query-start | (const char *) | Probe that fires when the execution of a statement is started. arg0 is the query string. | (8.4+) |
||||
| 13 | query-done | (const char *) | Probe that fires when the execution of a statement is complete. arg0 is the query string. | (8.4+) |
||||
| 14 | statement-status | (const char *) | Probe that fires anytime an SQL statement is executed on the server. arg0 is the query string. | (8.4+) |
Sign up or Log in to add a comment or watch this page.