Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node

Поиск
Список
Период
Сортировка
От Robert Lor
Тема Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node
Дата
Msg-id 477D086C.3080005@sun.com
обсуждение исходный текст
Ответ на Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Greg,

Gregory Stark wrote:
> I don't think DTrace is overkill either. The programmatic interface is
> undocumented (but I've gotten Sun people to admit it exists -- I just have to
> reverse engineer it from the existing code samples) but should be more or less
> exactly what we need.
>
>   
You  probably know this already. There are existing commands that use 
the programmatic interface and would provide a good starting point. Here 
are a couple:

http://cvs.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/cmd/lockstat/lockstat.c
http://cvs.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/cmd/dtrace/dtrace.c

One of my colleagues is in the process of putting a tutorial together 
for how to do this, so if you decided to pursue this approach and need 
assistance, please let me know.

Regards,
Robert


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Table rewrites vs. pending AFTER triggers
Следующее
От: Josh Berkus
Дата:
Сообщение: Please submit for OSCON!