get_user_functions_stats
Analyze PostgreSQL user-defined function performance statistics including execution counts, timing data, and bottlenecks to optimize database operations.
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
Args: database_name: Database name to analyze (uses default database if omitted)
Returns: User-defined function performance statistics including call counts and timing
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No |