Re: DTrace and PostgreSQL

Karen Hill wrote:
> I've got Solaris 10 11/06 on my PC. I removed the static keyword in
> src/backend/access/transam/xact.c. for the AbortTransaction and
> CommitTransaction functions declarations and compiled 8.2.3.
> Everything works nicely.
>
> 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.

There are no trace points for that, but you can insert them if you want.
I believe the appropriate place to put it would be either heap_insert or
ExecInsert.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.