📄 dbiprof.1
字号:
.\" Automatically generated by Pod::Man 2.16 (Pod::Simple 3.05).\".\" Standard preamble:.\" ========================================================================.de Sh \" Subsection heading.br.if t .Sp.ne 5.PP\fB\\$1\fR.PP...de Sp \" Vertical space (when we can't use .PP).if t .sp .5v.if n .sp...de Vb \" Begin verbatim text.ft CW.nf.ne \\$1...de Ve \" End verbatim text.ft R.fi...\" Set up some character translations and predefined strings. \*(-- will.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left.\" double quote, and \*(R" will give a right double quote. \*(C+ will.\" give a nicer C++. Capital omega is used to do unbreakable dashes and.\" therefore won't be available. \*(C` and \*(C' expand to `' in nroff,.\" nothing in troff, for use with C<>..tr \(*W-.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'.ie n \{\. ds -- \(*W-. ds PI pi. if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch. if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch. ds L" "". ds R" "". ds C` "". ds C' ""'br\}.el\{\. ds -- \|\(em\|. ds PI \(*p. ds L" ``. ds R" '''br\}.\".\" Escape single quotes in literal strings from groff's Unicode transform..ie \n(.g .ds Aq \(aq.el .ds Aq '.\".\" If the F register is turned on, we'll generate index entries on stderr for.\" titles (.TH), headers (.SH), subsections (.Sh), items (.Ip), and index.\" entries marked with X<> in POD. Of course, you'll have to process the.\" output yourself in some meaningful fashion..ie \nF \{\. de IX. tm Index:\\$1\t\\n%\t"\\$2"... nr % 0. rr F.\}.el \{\. de IX...\}.\".\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2)..\" Fear. Run. Save yourself. No user-serviceable parts.. \" fudge factors for nroff and troff.if n \{\. ds #H 0. ds #V .8m. ds #F .3m. ds #[ \f1. ds #] \fP.\}.if t \{\. ds #H ((1u-(\\\\n(.fu%2u))*.13m). ds #V .6m. ds #F 0. ds #[ \&. ds #] \&.\}. \" simple accents for nroff and troff.if n \{\. ds ' \&. ds ` \&. ds ^ \&. ds , \&. ds ~ ~. ds /.\}.if t \{\. ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u". ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'. ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'. ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'. ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'. ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'.\}. \" troff and (daisy-wheel) nroff accents.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'.ds 8 \h'\*(#H'\(*b\h'-\*(#H'.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#].ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#].ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#].ds ae a\h'-(\w'a'u*4/10)'e.ds Ae A\h'-(\w'A'u*4/10)'E. \" corrections for vroff.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'. \" for low resolution devices (crt and lpr).if \n(.H>23 .if \n(.V>19 \\{\. ds : e. ds 8 ss. ds o a. ds d- d\h'-1'\(ga. ds D- D\h'-1'\(hy. ds th \o'bp'. ds Th \o'LP'. ds ae ae. ds Ae AE.\}.rm #[ #] #H #V #F C.\" ========================================================================.\".IX Title "DBIPROF 1".TH DBIPROF 1 "2008-01-23" "perl v5.10.0" "User Contributed Perl Documentation".\" For nroff, turn off justification. Always turn off hyphenation; it makes.\" way too many mistakes in technical documents..if n .ad l.nh.SH "NAME"dbiprof \- command\-line client for DBI::ProfileData.SH "SYNOPSIS".IX Header "SYNOPSIS"See a report of the ten queries with the longest total runtime in theprofile dump file \fIprof1.out\fR:.PP.Vb 1\& dbiprof prof1.out.Ve.PPSee the top 10 most frequently run queries in the profile file\&\fIdbi.prof\fR (the default):.PP.Vb 1\& dbiprof \-\-sort count.Ve.PPSee the same report with 15 entries:.PP.Vb 1\& dbiprof \-\-sort count \-\-number 15.Ve.SH "DESCRIPTION".IX Header "DESCRIPTION"This tool is a command-line client for the DBI::ProfileData. Itallows you to analyze the profile data file produced byDBI::ProfileDumper and produce various useful reports..SH "OPTIONS".IX Header "OPTIONS"This program accepts the following options:.IP "\-\-number N" 4.IX Item "--number N"Produce this many items in the report. Defaults to 10. If set to\&\*(L"all\*(R" then all results are shown..IP "\-\-sort field" 4.IX Item "--sort field"Sort results by the given field. Sorting by multiple fields isn't currentlysupported (patches welcome). The available sort fields are:.RS 4.IP "total" 4.IX Item "total"Sorts by total time run time across all runs. This is the defaultsort..IP "longest" 4.IX Item "longest"Sorts by the longest single run..IP "count" 4.IX Item "count"Sorts by total number of runs..IP "first" 4.IX Item "first"Sorts by the time taken in the first run..IP "shortest" 4.IX Item "shortest"Sorts by the shortest single run..IP "key1" 4.IX Item "key1"Sorts by the value of the first element in the Path, which should be numeric.You can also sort by \f(CW\*(C`key2\*(C'\fR and \f(CW\*(C`key3\*(C'\fR..RE.RS 4.RE.IP "\-\-reverse" 4.IX Item "--reverse"Reverses the selected sort. For example, to see a report of theshortest overall time:.Sp.Vb 1\& dbiprof \-\-sort total \-\-reverse.Ve.IP "\-\-match keyN=value" 4.IX 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 aDBI::Profile Path of:.Sp.Vb 1\& [ DBIprofile_Statement, DBIprofile_Methodname ].Ve.SpAnd called dbiprof as in:.Sp.Vb 1\& dbiprof \-\-match key2=execute.Ve.SpYour report would only show execute queries, leaving out prepares,fetches, etc..SpIf the value given starts and ends with slashes (\f(CW\*(C`/\*(C'\fR) then it will betreated as a regular expression. For example, to only include \s-1SELECT\s0queries where key1 is the statement:.Sp.Vb 1\& dbiprof \-\-match key1=/^SELECT/.Ve.SpBy default the match expression is matched case-insensitively, butthis can be changed with the \-\-case\-sensitive option..IP "\-\-exclude keyN=value" 4.IX Item "--exclude keyN=value"Remove items for where the specified key matches the given value. Forexample, to exclude all prepare entries where key2 is the method name:.Sp.Vb 1\& dbiprof \-\-exclude key2=prepare.Ve.SpLike \f(CW\*(C`\-\-match\*(C'\fR, If the value given starts and ends with slashes(\f(CW\*(C`/\*(C'\fR) then it will be treated as a regular expression. For example,to exclude \s-1UPDATE\s0 queries where key1 is the statement:.Sp.Vb 1\& dbiprof \-\-match key1=/^UPDATE/.Ve.SpBy default the exclude expression is matched case-insensitively, butthis can be changed with the \-\-case\-sensitive option..IP "\-\-case\-sensitive" 4.IX Item "--case-sensitive"Using this option causes \-\-match and \-\-exclude to workcase-sensitively. Defaults to off..IP "\-\-delete" 4.IX Item "--delete"Sets the \f(CW\*(C`DeleteFiles\*(C'\fR option to DBI::ProfileData which causes thefiles to be deleted after reading. See DBI::ProfileData for more details..IP "\-\-dumpnodes" 4.IX Item "--dumpnodes"Print the list of nodes in the form of a perl data structure.Use the \f(CW\*(C`\-sort\*(C'\fR option if you want the list sorted..IP "\-\-version" 4.IX Item "--version"Print the dbiprof version number and exit..SH "AUTHOR".IX Header "AUTHOR"Sam Tregar <sam@tregar.com>.SH "COPYRIGHT AND LICENSE".IX Header "COPYRIGHT AND LICENSE"Copyright (C) 2002 Sam Tregar.PPThis program is free software; you can redistribute it and/or modifyit under the same terms as Perl 5 itself..SH "SEE ALSO".IX Header "SEE ALSO"DBI::ProfileDumper,DBI::Profile, \s-1DBI\s0.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -