#!/usr/sbin/dtrace -qs

dtrace:::BEGIN
{
    printf("%-20s  %-60s  %-10s\n", "TIMESTAMP", "SQL QUERY", "TIME");
}

postgresqljdbc*:::executesqlstatementstart,
postgresqljdbc*:::executepreparessqlstatementstart
{
    self->time = vtimestamp;
    self->sql = copyinstr(arg0);
}

postgresqljdbc*:::executesqlstatementstop,
postgresqljdbc*:::executepreparedsqlstatementstop
/ self->time /
{
    printf("%-20Y  %-60s  %-10d\n", timestamp, self->sql, vtimestamp - self->time);
}