#!/usr/sbin/dtrace -qs

postgresql*:::transaction-start
{
	@startpersec["New"] = count();
}

postgresql*:::transaction-commit
{
	@commitpersec[ "Commit"] = count();
}

postgresql*:::transaction-abort
{
	@abort["Abort"] = count();
}

profile:::tick-1s
{

        printf("******** Transactions Per Second *********\n");
	printf("%20s %15s\n", "Txn Type", "Count");
	printf("==========================================\n");
	printa("%20s %@15d\n", @startpersec);
	printa("%20s %@15d\n", @commitpersec);
	printa("%20s %@15d\n", @abort);
        printf("\n");
	clear(@startpersec);
	clear(@commitpersec);
	clear(@abort);
}