On Tue, May 22, 2018 at 8:58 AM, mooh Rash <moohrash@xxxxxxxxx> 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_plan) from postgreqsl. Also, I wonder if there is a plan-table in postgresql than I can access, and I can access it?. I appreciate if you guide me in getting the mentioned information that are necessary for my research.Best,Moohanad
>
I want to access the information about queries and statistics
I strongly recommend you install PgBadger, which analyzes the log file to provide you the information you need.
--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
