pg_stat_statements -- Historical Query

From: anand086 <anand086(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_stat_statements -- Historical Query
Date: 2017-08-10 04:23:13
Message-ID: 1502338993583-5977110.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I was looking for a way to maintain historical query details in Postgres to
answer questions like

What was the sql call rate between time X and Y?
Did the execution count increase for the query increase between time X and
Y?
In past 10mins what all queries were run in the db?

and few others like this.

What would be best way to do it? Any thoughts?

--
View this message in context: http://www.postgresql-archive.org/pg-stat-statements-Historical-Query-tp5977110.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-08-10 04:41:46 Re: pg_stat_statements -- Historical Query
Previous Message anand086 2017-08-10 03:44:56 Re: Audit based on role