get_user_functions_stats
Analyze PostgreSQL user-defined function performance statistics, including execution counts, average timing, and bottlenecks to identify slow or frequently called functions.
Instructions
[Tool Purpose]: Analyze performance statistics for user-defined functions
[Exact Functionality]:
Show execution count and timing statistics for user functions
Calculate average execution time per function call
Identify performance bottlenecks in user-defined functions
Provide total and self execution time breakdown
[Required Use Cases]:
When user requests "function stats", "function performance", etc.
When analyzing user-defined function performance
When identifying slow or frequently called functions
When optimizing application function usage
[Strictly Prohibited Use Cases]:
Requests for function modification or optimization
Requests for statistics reset
Requests for function execution or testing
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "get_user_functions_stats"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | Database name to analyze (uses default database if omitted) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |