Tool
List slow queries
The List Slow Queries tool by Neon helps database administrators and developers identify and analyze slow-running queries within their Neon databases. By leveraging the pg_stat_statements extension, it provides detailed insights into query execution times to optimize database performance.
Features
- Lists slow SQL queries from Neon databases accurately.
- Sorts queries by execution time with the slowest first for prioritized optimization.
- Supports filtering slow queries based on minimum execution time in milliseconds.
- Allows selection of specific projects, branches, databases, and compute endpoints for targeted querying.
- Returns a customizable number of slow query results to manage output size and focus.
Benefits
- Enhances database performance by pinpointing inefficient queries.
- Reduces application latency through targeted query optimization.
- Improves resource allocation by identifying high-cost queries.
- Facilitates proactive monitoring and troubleshooting of database issues.
- Saves development time with automated slow query detection and reporting.
Description
<use_case> Use this tool to list slow queries from your Neon database. </use_case> <important_notes> This tool queries the pg_stat_statements extension to find queries that are taking longer than expected. The tool will return queries sorted by execution time, with the slowest queries first. </important_notes>
Parameters
1 parameter
| Name | Type | Description |
|---|---|---|
| paramsrequired | object | — |