DTrace and PostgreSQL

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DTrace and PostgreSQL
Date: 2007-04-13 00:13:59
Message-ID: 1176423239.406850.192210@d57g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards,
karen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-04-13 01:08:26 Re: DTrace and PostgreSQL
Previous Message Terry Martin 2007-04-12 22:14:01 question