en es ja ko zh

Postgres MCP

by crystaldba

Verified

Python

MIT License

101

Reddit Discord

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

get_top_queries

Identify and analyze the slowest SQL queries by execution time using data from the 'pg_stat_statements' extension. Specify the number of queries and sort by total or mean execution time to optimize database performance.

Instructions

Reports the slowest SQL queries based on execution time, using data from the 'pg_stat_statements' extension.

Input Schema

Name	Required	Description	Default
`limit`	No	Number of slow queries to return
`sort_by`	No	Sort criteria: 'total' for total execution time or 'mean' for mean execution time per call	mean

Input Schema (JSON Schema)

{
  "properties": {
    "limit": {
      "default": 10,
      "description": "Number of slow queries to return",
      "title": "Limit",
      "type": "integer"
    },
    "sort_by": {
      "default": "mean",
      "description": "Sort criteria: 'total' for total execution time or 'mean' for mean execution time per call",
      "title": "Sort By",
      "type": "string"
    }
  },
  "title": "get_top_queriesArguments",
  "type": "object"
}

You must be authenticated.

Related Tools

explain_query
@crystaldba/postgres-mcp
optimize_sql
@madhukarkumar/singlestore-mcp-server
analyze_db_health
@crystaldba/postgres-mcp
analyze_database
@nahmanmate/postgresql-mcp-server
execute_sql
@crystaldba/postgres-mcp

ID: ecl7vgkzit

get_top_queries

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Postgres MCP

Related Tools