Profiling Table Schema (profiling)


Stores the results of all the profiling runs

profiling table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
runid VARCHAR 32

the unique id for this run (as generated by xhprof)

url VARCHAR 255

the url this profiling record is about (without wwwroot nor query params)

data LONGTEXT 2147483647 null

the raw data gathered by xhprof

totalexecutiontime BIGINT 19 null

time (in microseconds) spent by the run

totalcputime BIGINT 19 null

time (in microseconds) spent by the CPU in this run

totalcalls BIGINT 19 null

Total number of calls performed by the run

totalmemory BIGINT 19 null

Total memory used byt the run

runreference TINYINT 3 0

Is this run a reference one

runcomment VARCHAR 255

Brief comment for this run

timecreated BIGINT 19 null

unix timestap of the creation of this run

Table contained -1 rows

profiling table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
prof_run_uix Must be unique Asc runid
prof_timrun_ix Performance Asc/Asc timecreated + runreference
prof_urlrun_ix Performance Asc/Asc url + runreference