[GENERAL] pg_stat_statements -- Historical Query - Mailing list pgsql-general

From anand086
Subject [GENERAL] pg_stat_statements -- Historical Query
Date
Msg-id 1502338993583-5977110.post@n3.nabble.com
Whole thread Raw
Responses Re: [GENERAL] pg_stat_statements -- Historical Query  (Michael Paquier <michael.paquier@gmail.com>)
List 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.


pgsql-general by date:

Previous
From: anand086
Date:
Subject: Re: [GENERAL] Audit based on role
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] pg_stat_statements -- Historical Query