Re: Queries that are running in postgres most of the time - Mailing list pgsql-admin

From Fabio Pardi
Subject Re: Queries that are running in postgres most of the time
Date
Msg-id 40457dbc-a236-406f-8afc-09fccca87ea9@portavita.eu
Whole thread Raw
In response to Queries that are running in postgres most of the time  (Debraj Manna <subharaj.manna@gmail.com>)
List pgsql-admin
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? 
> 


pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: psql error
Next
From: Gary Stainburn
Date:
Subject: Re: postgres encryption