ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: usr / bin

#!/usr/bin/perl

use strict;

my $VERSION = sprintf("1.%06d", q$Revision$ =~ /(\d+)/o);

use Data::Dumper;
use DBI::ProfileData;
use Getopt::Long;

# default options
my $number         = 10;
my $sort           = 'total';
my $filename       = 'dbi.prof';
my $reverse        = 0;
my $case_sensitive = 0;
my (%match, %exclude);

# get options from command line
GetOptions(
           'version'        => sub { die "dbiprof $VERSION\n" },
           'help'           => sub { exit usage() },
           'number=i'       => \$number,
           'sort=s'         => \$sort,
           'dumpnodes!'     => \my $dumpnodes,
           'reverse'        => \$reverse,
           'match=s'        => \%match,
           'exclude=s'      => \%exclude,
           'case-sensitive' => \$case_sensitive,
           'delete!'        => \my $opt_delete,
) or exit usage();

sub usage {
    print <<EOS;
dbiprof [options] [files]

Reads and merges DBI profile data from files and prints a summary.

files: defaults to $filename

options:

-number=N        show top N, defaults to $number
    -sort=S          sort by S, defaults to $sort
    -reverse         reverse the sort
    -match=K=V       for filtering, see docs
    -exclude=K=V     for filtering, see docs
    -case_sensitive  for -match and -exclude
    -delete          rename files before reading then delete afterwards
    -version         print version number and exit
    -help            print this help

EOS
    return 1;
}

# list of files defaults to dbi.prof
my @files = @ARGV ? @ARGV : ('dbi.prof');

# instantiate ProfileData object
my $prof = eval {
    DBI::ProfileData->new(
        Files => \@files,
        DeleteFiles => $opt_delete,
    );
};
die "Unable to load profile data: $@\n" if $@;

if (%match) { # handle matches
    while (my ($key, $val) = each %match) {
        if ($val =~ m!^/(.+)/$!) {
            $val = $case_sensitive ? qr/$1/ : qr/$1/i;
        }
        $prof->match($key, $val, case_sensitive => $case_sensitive);
    }
}

if (%exclude) { # handle excludes
    while (my ($key, $val) = each %exclude) {
        if ($val =~ m!^/(.+)/$!) {
            $val = $case_sensitive ? qr/$1/ : qr/$1/i;
        }
        $prof->exclude($key, $val, case_sensitive => $case_sensitive);
    }
}

# sort the data
$prof->sort(field => $sort, reverse => $reverse);

# all done, print it out
if ($dumpnodes) {
    $Data::Dumper::Indent    = 1;
    $Data::Dumper::Terse     = 1;
    $Data::Dumper::Useqq     = 1;
    $Data::Dumper::Deparse   = 0;
    print Dumper($prof->nodes);
}
else {
    print $prof->report(number => $number);
}
exit 0;

__END__

=head1 NAME

dbiprof - command-line client for DBI::ProfileData

=head1 SYNOPSIS

See a report of the ten queries with the longest total runtime in the
profile dump file F<prof1.out>:

dbiprof prof1.out

See the top 10 most frequently run queries in the profile file
F<dbi.prof> (the default):

dbiprof --sort count

See the same report with 15 entries:

dbiprof --sort count --number 15

=head1 DESCRIPTION

This tool is a command-line client for the DBI::ProfileData.  It
allows you to analyze the profile data file produced by
DBI::ProfileDumper and produce various useful reports.

=head1 OPTIONS

This program accepts the following options:

=over 4

=item --number N

Produce this many items in the report.  Defaults to 10.  If set to
"all" then all results are shown.

=item --sort field

Sort results by the given field. Sorting by multiple fields isn't currently
supported (patches welcome).  The available sort fields are:

=over 4

=item total

Sorts by total time run time across all runs.  This is the default
sort.

=item longest

Sorts by the longest single run.

=item count

Sorts by total number of runs.

=item first

Sorts by the time taken in the first run.

=item shortest

Sorts by the shortest single run.

=item key1

Sorts by the value of the first element in the Path, which should be numeric.
You can also sort by C<key2> and C<key3>.

=back

=item --reverse

Reverses the selected sort.  For example, to see a report of the
shortest overall time:

dbiprof --sort total --reverse

=item --match keyN=value

Consider only items where the specified key matches the given value.
Keys are numbered from 1.  For example, let's say you used a
DBI::Profile Path of:

[ DBIprofile_Statement, DBIprofile_Methodname ]

And called dbiprof as in:

dbiprof --match key2=execute

Your report would only show execute queries, leaving out prepares,
fetches, etc.

If the value given starts and ends with slashes (C</>) then it will be
treated as a regular expression.  For example, to only include SELECT
queries where key1 is the statement:

dbiprof --match key1=/^SELECT/

By default the match expression is matched case-insensitively, but
this can be changed with the --case-sensitive option.

=item --exclude keyN=value

Remove items for where the specified key matches the given value.  For
example, to exclude all prepare entries where key2 is the method name:

dbiprof --exclude key2=prepare

Like C<--match>, If the value given starts and ends with slashes
(C</>) then it will be treated as a regular expression.  For example,
to exclude UPDATE queries where key1 is the statement:

dbiprof --match key1=/^UPDATE/

By default the exclude expression is matched case-insensitively, but
this can be changed with the --case-sensitive option.

=item --case-sensitive

Using this option causes --match and --exclude to work
case-sensitively.  Defaults to off.

=item --delete

Sets the C<DeleteFiles> option to L<DBI::ProfileData> which causes the
files to be deleted after reading. See L<DBI::ProfileData> for more details.

=item --dumpnodes

Print the list of nodes in the form of a perl data structure.
Use the C<-sort> option if you want the list sorted.

=item --version

Print the dbiprof version number and exit.

=back

=head1 AUTHOR

Sam Tregar <sam@tregar.com>

=head1 COPYRIGHT AND LICENSE

This program is free software; you can redistribute it and/or modify
it under the same terms as Perl 5 itself.

=head1 SEE ALSO

L<DBI::ProfileDumper|DBI::ProfileDumper>,
L<DBI::Profile|DBI::Profile>, L<DBI|DBI>.

=cut

[+] ..
[-] fc-cat [open]
[-] mariadb-access [open]
[-] pre-grohtml [open]
[-] echo [open]
[-] x86_64-redhat-linux-gcc [open]
[-] composite [open]
[-] autoreconf [open]
[-] size [open]
[-] mkfifo [open]
[-] libnetcfg [open]
[-] aclocal-1.16 [open]
[-] diff3 [open]
[-] tar [open]
[-] precat [open]
[-] du [open]
[-] tclsh [open]
[-] touch [open]
[-] fc-match [open]
[-] replace [open]
[-] gprof [open]
[-] post-grohtml [open]
[-] shuf [open]
[-] zsoelim [open]
[-] paste [open]
[-] yes [open]
[-] chmod [open]
[-] file [open]
[-] sum [open]
[-] more [open]
[-] pango-view [open]
[-] gzip [open]
[-] ldd [open]
[-] mysqlimport [open]
[-] montage [open]
[-] b2sum [open]
[-] renice [open]
[-] cal [open]
[-] perlml [open]
[-] strip [open]
[-] dig [open]
[-] fc-cache [open]
[-] fold [open]
[-] scl_source [open]
[-] rvim [open]
[-] znew [open]
[-] git-shell [open]
[-] gtroff [open]
[-] fmt [open]
[-] xsubpp [open]
[-] passwd [open]
[-] mailx [open]
[-] patch [open]
[-] nm [open]
[-] isosize [open]
[-] strings [open]
[-] gtbl [open]
[-] gem [open]
[-] aclocal [open]
[-] timeout [open]
[-] python2.7 [open]
[-] h2ph [open]
[-] curl [open]
[-] sync [open]
[-] sftp [open]
[-] tac [open]
[-] enchant [open]
[-] ps2pdf13 [open]
[-] basenc [open]
[-] vi [open]
[-] mariadb-find-rows [open]
[-] flex [open]
[-] gcc-nm [open]
[-] mysql_find_rows [open]
[-] ifnames [open]
[-] dircolors [open]
[-] soelim [open]
[-] ssh-keygen [open]
[-] xmlwf [open]
[-] tclsh8.6 [open]
[-] gsnd [open]
[-] autoconf [open]
[-] m4 [open]
[-] whoami [open]
[-] zipinfo [open]
[-] truncate [open]
[-] bzdiff [open]
[-] stat [open]
[-] head [open]
[-] gmake [open]
[-] awk [open]
[-] ps2ps [open]
[-] mysqlshow [open]
[-] crontab.cagefs [open]
[-] basename [open]
[-] fc-pattern [open]
[-] batch [open]
[-] nroff [open]
[-] stream [open]
[-] bzgrep [open]
[-] piconv [open]
[-] rmdir [open]
[-] hexdump [open]
[-] bunzip2 [open]
[-] xxd [open]
[-] catchsegv [open]
[-] grotty [open]
[-] bzcmp [open]
[-] mariadb-admin [open]
[-] sh [open]
[-] bash [open]
[-] mariadb-show [open]
[-] xmllint [open]
[-] autoupdate [open]
[-] perl [open]
[-] gm [open]
[-] fc-validate [open]
[-] vim [open]
[-] pod2usage [open]
[-] rview [open]
[-] c++ [open]
[-] g++ [open]
[-] sed [open]
[-] identify [open]
[-] mysqldump [open]
[-] tty [open]
[-] ssh-agent [open]
[-] icuinfo [open]
[-] mesg [open]
[-] realpath [open]
[-] pango-segmentation [open]
[-] ruby [open]
[-] git-upload-archive [open]
[-] sdiff [open]
[-] bashbug-64 [open]
[-] col [open]
[-] taskset [open]
[-] zip [open]
[-] login [open]
[-] pwdx [open]
[-] perlbug [open]
[-] c99 [open]
[-] mogrify [open]
[-] python [open]
[-] grops [open]
[-] cp [open]
[-] atq [open]
[-] kill [open]
[-] mariadb-embedded [open]
[-] hostid [open]
[-] setterm [open]
[-] gcc-ar [open]
[-] host [open]
[-] uptime [open]
[-] as [open]
[-] unzipsfx [open]
[-] link [open]
[-] rev [open]
[-] od [open]
[-] ssh-add [open]
[-] unzip [open]
[-] dnstap-read [open]
[-] zforce [open]
[-] word-list-compress [open]
[-] rename [open]
[-] dir [open]
[-] split [open]
[-] nsupdate [open]
[-] sleep [open]
[-] tr [open]
[-] ipcrm [open]
[-] ps2pdf [open]
[-] arpaname [open]
[-] unexpand [open]
[-] objdump [open]
[-] tset [open]
[-] mariadb-secure-installation [open]
[-] openssl [open]
[-] mariadb-dump [open]
[-] chcon [open]
[-] ps2pdf12 [open]
[-] test [open]
[-] automake-1.16 [open]
[-] pic [open]
[-] tail [open]
[-] mysqlbinlog [open]
[-] gawk [open]
[-] pkg-config [open]
[-] ssh-copy-id [open]
[-] cldetect [open]
[-] tput [open]
[-] tzselect [open]
[-] column [open]
[-] c++filt [open]
[-] c89 [open]
[-] watch [open]
[-] tmpwatch [open]
[-] crontab [open]
[-] ispell [open]
[-] pathchk [open]
[-] mcookie [open]
[-] free [open]
[-] reset [open]
[-] fc-cache-64 [open]
[-] enchant-lsmod [open]
[-] gneqn [open]
[-] readlink [open]
[-] gpgsplit [open]
[-] ssh-keyscan [open]
[-] zipgrep [open]
[-] uapi [open]
[-] ionice [open]
[-] base64 [open]
[-] gnroff [open]
[-] nproc [open]
[-] logname [open]
[-] icu-config-64 [open]
[-] nl [open]
[-] lto-dump [open]
[-] xsltproc [open]
[-] whereis [open]
[-] zcmp [open]
[-] python3.9 [open]
[-] mytop [open]
[-] localedef [open]
[-] flock [open]
[-] grep [open]
[-] gunzip [open]
[-] ping [open]
[-] pl2pm [open]
[-] geoiplookup [open]
[-] stty [open]
[-] dd [open]
[-] bzmore [open]
[-] locale [open]
[-] gpgv [open]
[-] mv [open]
[-] ps2pdfwr [open]
[-] objcopy [open]
[-] animate [open]
[-] namei [open]
[-] utmpdump [open]
[-] gpg-error [open]
[-] my_print_defaults [open]
[-] passenger [open]
[-] ld [open]
[-] x86_64-redhat-linux-c++ [open]
[-] nohup [open]
[-] zless [open]
[-] less [open]
[-] mariadb-binlog [open]
[-] dirname [open]
[-] ipcs [open]
[-] ul [open]
[-] chgrp [open]
[-] lesskey [open]
[-] mariadb-tzinfo-to-sql [open]
[-] zcat [open]
[-] [ [open]
[-] unlink [open]
[-] vimtutor [open]
[-] msql2mysql [open]
[-] toe [open]
[-] tabs [open]
[-] ptx [open]
[-] autoheader [open]
[-] selectorctl [open]
[-] lex [open]
[-] h2xs [open]
[-] expr [open]
[-] run-with-aspell [open]
[-] freetype-config [open]
[-] gencat [open]
[-] gpg [open]
[-] gcov-dump [open]
[-] readelf [open]
[-] ld.bfd [open]
[-] GET [open]
[-] scl_enabled [open]
[-] cagefs_enter.proxied [open]
[-] sha1sum [open]
[-] recode [open]
[-] neqn [open]
[-] expand [open]
[-] wc [open]
[-] libtoolize [open]
[-] hunspell [open]
[-] make [open]
[-] setsid [open]
[-] icu-config [open]
[-] ps [open]
[-] splain [open]
[-] mariadb-import [open]
[-] strace [open]
[-] autom4te [open]
[-] funzip [open]
[-] stdbuf [open]
[-] troff [open]
[-] ps2ps2 [open]
[-] cut [open]
[-] pdf2dsc [open]
[-] sort [open]
[-] install [open]
[-] true [open]
[-] mariadb-setpermission [open]
[-] join [open]
[-] printenv [open]
[-] xargs [open]
[-] env [open]
[-] aspell [open]
[-] vmstat [open]
[-] rm [open]
[-] fc-query [open]
[-] sha384sum [open]
[-] ps2epsi [open]
[-] rvi [open]
[-] base32 [open]
[-] libtool [open]
[-] gsoelim [open]
[-] ed [open]
[-] gtar [open]
[-] zfgrep [open]
[-] cc [open]
[-] zipnote [open]
[-] false [open]
[-] Mail [open]
[-] xmlcatalog [open]
[-] prove [open]
[-] tload [open]
[-] shred [open]
[-] fc-conflist [open]
[-] mysqlaccess [open]
[-] pmap [open]
[-] rnano [open]
[-] runcon [open]
[-] date [open]
[-] conjure [open]
[-] cmp [open]
[-] comm [open]
[-] vimdiff [open]
[-] mariadb-slap [open]
[-] skill [open]
[-] cpan [open]
[-] script [open]
[-] sha224sum [open]
[-] cksum [open]
[-] mknod [open]
[-] chrt [open]
[-] tee [open]
[-] id [open]
[-] getent [open]
[-] mariadb [open]
[-] getconf [open]
[-] automake [open]
[-] infotocap [open]
[-] clear [open]
[-] view [open]
[-] mysql_config [open]
[-] perlthanks [open]
[-] users [open]
[-] iconv [open]
[-] pod2man [open]
[-] colrm [open]
[-] groups [open]
[-] zdiff [open]
[-] at [open]
[-] fc-list [open]
[-] renew-dummy-cert [open]
[-] pydoc3 [open]
[-] pod2text [open]
[-] python2 [open]
[-] git-upload-pack [open]
[-] gpg-agent [open]
[-] ln [open]
[-] colcrt [open]
[-] ex [open]
[-] fgrep [open]
[-] mysqlcheck [open]
[-] zgrep [open]
[-] nice [open]
[-] gcov-tool [open]
[-] pdf2ps [open]
[-] git [open]
[-] mariadb-hotcopy [open]
[-] mariadb-dumpslow [open]
[-] mkdir [open]
[-] nano [open]
[-] scl [open]
[-] python3 [open]
[-] ps2pdf14 [open]
[-] captoinfo [open]
[-] mail [open]
[-] ps2ascii [open]
[-] x86_64-redhat-linux-gcc-11 [open]
[-] atrm [open]
[-] sha256sum [open]
[-] perl5.32.1 [open]
[-] getopt [open]
[-] gcov [open]
[-] cat [open]
[-] git-receive-pack [open]
[-] red [open]
[-] mktemp [open]
[-] printf [open]
[-] pango-list [open]
[-] tsort [open]
[-] who [open]
[-] cloudlinux-awp-user [open]
[-] egrep [open]
[-] mariadb-waitpid [open]
[-] ranlib [open]
[-] pgrep [open]
[-] geqn [open]
[-] mariadb-conv [open]
[-] eps2eps [open]
[-] factor [open]
[-] ghostscript [open]
[-] perlivp [open]
[-] preunzip [open]
[-] tbl [open]
[-] enc2xs [open]
[-] uname [open]
[-] zipcloak [open]
[-] numfmt [open]
[-] sha512sum [open]
[-] x86_64-redhat-linux-g++ [open]
[-] compare [open]
[-] cpp [open]
[-] pydoc [open]
[-] prezip-bin [open]
[-] uniq [open]
[-] md5sum [open]
[-] spell [open]
[-] mariadb-check [open]
[-] hostname [open]
[-] vdir [open]
[-] addr2line [open]
[-] import [open]
[-] convert [open]
[-] sqlite3 [open]
[-] nslookup [open]
[-] bzcat [open]
[-] mariadb-convert-table-format [open]
[-] df [open]
[-] seq [open]
[-] mysql [open]
[-] gcc [open]
[-] pydoc3.9 [open]
[-] pinky [open]
[-] bison [open]
[-] diff [open]
[-] gzexe [open]
[-] mysqladmin [open]
[-] groff [open]
[-] geoiplookup6 [open]
[-] display [open]
[-] bzip2recover [open]
[-] logger [open]
[-] mariadb-plugin [open]
[-] zegrep [open]
[-] zipsplit [open]
[-] slabtop [open]
[-] clwpos-user [open]
[-] cyrusbdb2current [open]
[-] ar [open]
[-] eqn [open]
[-] autoscan [open]
[-] screen [open]
[-] top [open]
[-] delv [open]
[-] bzip2 [open]
[-] pod2html [open]
[-] fc-scan [open]
[-] lessecho [open]
[-] idn [open]
[-] scalar [open]
[-] which [open]
[-] prezip [open]
[-] csplit [open]
[-] mysql_waitpid [open]
[-] gcc-ranlib [open]
[-] make-dummy-cert [open]
[-] sprof [open]
[-] wget [open]
[-] pwd [open]
[-] php [open]
[-] pr [open]
[-] snice [open]
[-] chown [open]
[-] gs [open]
[-] infocmp [open]
[-] scp [open]
[-] lesspipe.sh [open]
[-] ls [open]
[-] tic [open]
[-] podchecker [open]
[-] dbiprof [open]
[-] perldoc [open]
[-] look [open]
[-] instmodsh [open]
[-] zmore [open]
[-] pkill [open]
[-] gpic [open]
[-] ssh [open]
[-] flex++ [open]
[-] find [open]
[-] bzless [open]
[-] arch [open]