Hello Moohanad,
Did you check for pg_stat_statements
https://www.postgresql.org/docs/10/static/pgstatstatements.html ?
This is based on postgres hooks and will give you: db,user,query id, query
text
There are many developments trying to add start /end time, planid, plan text
as described in
http:
On Tue, May 22, 2018 at 8:58 AM, mooh Rash wrote:
> Hi ,
>
> I am a PhD student searching in query optimization. I want to access the
> information about queries and statistics. Especially, I am interested in
> finding
> out how I can collect the history information (user, when, query,
> query
