Re: Queries that are running in postgres most of the time

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? 
>