5-10s long queries, but Neon Query History shows 40ms or less?
Hi! I regularly run into queries that take up 10s, but Query History in Neon Console shows my slowest query at 40ms, and cold starts at 400ms. Is this expected performance with Neon? And if not, any idea what’s going on, or how best to troubleshoot? Running in a typescript app with @neondatabase/serverless. Thanks!
1 Reply
subsequent-cyan•3mo ago
The query history page uses the pg_stat_statements extension for query times, which is typically reliable for Postgres query processing times. It would not account for anything else that might affect response times.
https://neon.com/docs/introduction/monitor-query-history
Neon
Monitor query history - Neon Docs
You can monitor query history for your Neon project from the Monitoring page in the Neon Console. 1. In the Neon Console, select a project. 2. Go to Monitoring. 3. Select the Query History tab. The Qu...