DBI::ProfileData 1.58

DBI::ProfileData can manipulate DBI::ProfileDumper data dumps.

SYNOPSIS

The easiest way to use this module is through the dbiprof frontend (see dbiprof for details):

dbiprof --number 15 --sort count

This module can also be used to roll your own profile analysis:

# load data from dbi.prof
$prof = DBI::ProfileData->new(File => "dbi.prof");

# get a count of the records (unique paths) in the data set
$count = $prof->count();

# sort by longest overall time
$prof->sort(field => "longest");

# sort by longest overall time, least to greatest
$prof->sort(field => "longest", reverse => 1);

# exclude records with key2 eq disconnect
$prof->exclude(key2 => disconnect);

# exclude records with key1 matching /^UPDATE/i
$prof->exclude(key1 => qr/^UPDATE/i);

# remove all records except those where key1 matches /^SELECT/i
$prof->match(key1 => qr/^SELECT/i);

# produce a formatted report with the given number of items
$report = $prof->report(number => 10);

# clone the profile data set
$clone = $prof->clone();

# get access to hash of header values
$header = $prof->header();

# get access to sorted array of nodes
$nodes = $prof->nodes();

# format a single node in the same style as report()
$text = $prof->format($nodes->[0]);

# get access to Data hash in DBI::Profile format
$Data = $prof->Data();