Re: How to get detailed query execution statistics for each algebra operator or primitive

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(at)gmail(dot)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.
>