Neon Query Monitor -- does it show only queries from Neon SQL Editor?
If I run a query within Neon (SQL Editor), it shows up in the Query Monitor section under Query History. If I run the same query from an external tool that completes successfully, I see no record of it Query History. I have checked all branches and databases to be sure the external query was going where I expected, and none show any Query History. Also, it seems even when a record shows in Query History, it doesn't last long. If I switch to other branches / dbs and then come back even after about 20 minutes the history that was there is already gone.
3 Replies
optimistic-gold•6mo ago
Hi, from our developer:
- It does not show the same queries as multiple rows but instead groups them in one row (there is a column showing the number of calls)
- Query history resets after your compute scales to zero
- It should show queries no matter where they were issued from
absent-sapphireOP•6mo ago
Thanks, if the query is a function call, it doesn't seem to include the parameter values, just the placeholders for them $1, etc. How can I see the actual params passed in?
optimistic-gold•6mo ago
This query history UI uses the pg_stat_statements Postgres extension, which afaik doesn't show parameter values.