Обсуждение: [ADMIN] How to get detailed query execution statistics for each algebraoperator or primitive
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.
--
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.
Tiago Rodrigo Kepe
PhD Student at UFPR
System Analyst at IFPR.
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/
KeithIf 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/
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.