#!/usr/sbin/dtrace -qs

dtrace:::BEGIN
{
    printf("%-20s  %-20s  %-10s  %-10s  %-10s  %-10s\n", "TIMESTAMP", "HOST", "PORT", "DATABASE", "USER", "TIME");
}

postgresqljdbc*:::acquireconnectionstart
{
    self->time = timestamp;
}

postgresqljdbc*:::acquireconnectionstop
{
    printf("%-Y  %-20s  %-10d  %-10s  %-10s  %-10d\n", walltimestamp, copyinstr(arg0), arg1, copyinstr(arg2), copyinstr(arg3), timestamp - self->time);
}