Hi, I think that select * from pg_stat_statements ; is a good starting point. You can then refine the query based on what you are interested for. This is a good read: https://www.postgresql.org/docs/10/static/monitoring-stats.html Regards, fabio pardi On 03/22/2018 08:57 AM, Debraj Manna wrote: > Is there any tool that will allow me to know which queries / transaction are getting executed most of the time in postgres? >
