On Tue, May 22, 2018 at 8:58 AM, mooh Rash <moohr...@yahoo.com> 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.* *https://sourceforge.net/projects/pgbadger/ <https://sourceforge.net/projects/pgbadger/>* -- *Melvin Davidson* *Maj. Database & Exploration Specialist* *Universe Exploration Command – UXC* Employment by invitation only!
