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.