Re: [ADMIN] How to get detailed query execution statistics for eachalgebra operator or primitive

Поиск
Список
Период
Сортировка
От Keith
Тема Re: [ADMIN] How to get detailed query execution statistics for eachalgebra operator or primitive
Дата
Msg-id CAHw75vtbU3wVx42AUCASBw9qAjfYpsVjP_WtN42_6vef5-mzGg@mail.gmail.com
обсуждение исходный текст
Ответ на [ADMIN] How to get detailed query execution statistics for each algebraoperator or primitive  (Tiago Kepe <tiagokepe@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tiago Kepe
Дата:
Сообщение: [ADMIN] How to get detailed query execution statistics for each algebraoperator or primitive
Следующее
От: Debraj Manna
Дата:
Сообщение: [ADMIN] Postgres 10 installation failing on Ubuntu 14