I have an application which uses PostgreSQL. I want to monitor all the queries that the application sends to the database. Is there a way to monitor the queries sent?
Postgresql – How to monitor PostgreSQL queries
monitoringpostgresql
Related Question
- Sql-server – Bandwidth usage in Sql Server
- Postgresql – Monitoring real-time statistics on PostgreSQL
- Postgresql – Get count of processed queries
- Postgres Monitoring – Creating a User to Monitor Database Activity
- Postgresql – How to monitor general performance and wellbeing of a database
- Sql-server – How to monitor performance in application insights of an on prem SQL Server database
Best Answer
You can point pgAdmin4 at your PostgreSQL server, it has a dashboard you can use. You can then drill down in a session to see the query.
If thats not what you are looking for then I guess a logging solution would be what you need like
pg_stat_statements
.