Re: DTrace and PostgreSQL

On Apr 12, 8:13 pm, "Karen Hill" <karen_hil(dot)(dot)(dot)(at)yahoo(dot)com> wrote:
> I was wondering if DTrace could tell me how many inserts are being
> done in a pl/pgsql function while in a loop for example. As you know
> a pl/pgsql function executes in a single transaction so the DTrace
> probe "transaction__commit(int)" I believe is not helpful here. Could
> DTrace measure how many inserts are being done in a transaction that
> has not yet been commited, especially if that transaction block is in
> a pl/pgsql function? This would be extremely useful as when one has a
> bunch of inserts one could be able to see how far along the pl/pgsql
> function was.

Karen, having fun with communicating with your V125??

FYI:
http://pgfoundry.org/docman/view.php/1000163/230/PostgreSQL-DTrace-Users-Guide.pdf

Rayson

>
> regards,
> karen