Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] How to get detailed query execution statistics for eachalgebra operator or primitive - Mailing list pgsql-admin

From Keith
Subject Re: [ADMIN] How to get detailed query execution statistics for eachalgebra operator or primitive
Date
Msg-id CAHw75vtbU3wVx42AUCASBw9qAjfYpsVjP_WtN42_6vef5-mzGg@mail.gmail.com
Whole thread Raw
In response to [ADMIN] How to get detailed query execution statistics for each algebraoperator or primitive  (Tiago Kepe <tiagokepe@gmail.com>)
List pgsql-admin
Tree view
Not sure if this does what you're looking for, but take a look at PoWA

http://dalibo.github.io/powa/

If you use the extra extensions it provides, it can provide some pretty detailed query statistics.

If that doesn't do it, there is the commercial product Vividcortex you can try out that does some pretty detailed query profiling.

https://www.vividcortex.com/

Keith

On Sat, Nov 11, 2017 at 8:49 AM, Tiago Kepe <tiagokepe@gmail.com> wrote:
I need to obtain statical information (execution time, main memory footprint and so on) for every single algebra operator or primitive from a query on PostgreSQL

I get those statistics using the Trace statement of MonetDB -> https://www.monetdb.org/Documentation/Manuals/SQLreference/Trace

But, I've researched a lot on PostgreSQL and I couldn't find any straightforward method like in MonetDB. In which when a query is executed with the Trace statement some pre-defined statistics are registered into the sys.tracelog table for every single primitive of that query. I wish something similar on PostgreSQL. I have seen the explain statement, but I need a detailed output for each primitive of a query like on MonetDB.


--
Best regards,
Tiago Rodrigo Kepe
PhD Student at UFPR
System Analyst at IFPR.

pgsql-admin by date:

Previous
From: Tiago Kepe
Date:
Subject: [ADMIN] How to get detailed query execution statistics for each algebraoperator or primitive
Next
From: Debraj Manna
Date:
Subject: [ADMIN] Postgres 10 installation failing on Ubuntu 14