xhprof_console

A console tool for grabbing profiles from XHProf database and collecting aggregates from them

Requirements:

• PHP with XHProf installed and set up.
• This script works directly with xhprof database, profiles should be taken as usual.

Why to use it instead of native XHProf interface:

It allows to collect and see stats for several XHProf profiles. Stats includes:

• average method exec time
• 90 percentile of method exec time
• min, max of the exec time

How to use

First run xhprof_console.php with no arguments. I'll give you a config format. Copy it to config.php

Then fill the config with mysql settings and also change the SQL to select desired profiles.

Run: php xhprof_console.php config.php

You'll see an error if something wrong. If not - the root method stats and a command prompt.

Stats format

There are three sections:

• Self Stat - the stats of current method
• Children - the stats of method which are called by current
• Parents - the stats of method which call current method

In each sections table columns are:

• # - id of method which is used for navigation in the prompt
• AVG_CT - average calls count of that method between all the collected profiles
• min_ct - minimum calls count in all the profiles (0 is not counted, so the minimum is 1)
• max_ct - maximum calls count in all the profiles
• AVG_WT - average wall time (total execution time of the method) between all the collected profiles
• PERCENT_WT - 90-th percentile of wall time between all the collected profiles
• max_wt - maximum wall time between all the collected profiles
• mark - used to marking method in prompt (just a star sign to mark anything you want, does not affect anything)
• method - method name

Prompt commands

• q - exit
• 0 - go back in the tree
• 1,2,3... - go to method N
• m1,m2,m3... - place a star sign on method N (it was meant to mark methods you've already looked at)