Monitor query history
newView and analyze query history for your Neon database
Early Access
This feature is available for members of our Early Access Program. Read more about joining up here.
You can monitor query history for your Neon project from the Monitoring page in the Neon Console.
- In the Neon Console, select a project.
- Go to Monitoring.
- Select the Query History tab.
The Query History view shows the top 100 previously run queries for the selected Branch, Compute, and Database. Queries can be sorted by Frequency or Average time. Use the Refresh button to load the latest queries.
The Query History view is powered by the pg_stat_statements Postgres extension, installed on a system managed database in your Postgres instance.
query history retention
In Neon, data collected by the pg_stat_statements extension is not retained when your Neon compute (where Postgres runs) is suspended or restarted. For example, if your compute scales down to zero due to inactivity, your query history is lost. New data will be gathered once your compute restarts.
Running your own queries
To run your own queries on pg_stat_statements data, you can install the pg_stat_statements extension to your database and run your queries from the Neon SQL Editor or any SQL client, such as psql. For details on pg_stat_statements, including how to install it, what data it collects, and queries you can run, refer to our pg_stat_statements extension guide.