Viewing Timer and Query Log Information

Using the page timer and query log is a simple matter of browsing your site with them enabled and enjoying the bounty of information that they produce. Figure 4-20 shows an excerpt from a timer and query log.

Executed 223 queries in 92.63 microseconds. Queries taking longer than 5 ms, and queries executed more than once, are highlighted Page execution time was 420.07 ms. ms # query

0.46 1 S

ELECT COUNT(pid) FROM url_alias

0.21 1 SELECT src FROM url_alias WHERE dst = 'node'

0.64 1 S

ELECT name, filename, throttle, bootstrap FROM system WHERE type = 'module' AND status = 1

1.23 1 S

ELECT data, created, headers, expire FROM cache WHERE cid = 'rnenu:l:en'

0.54 1 SELECT dst FROM url_alias WHERE src = 'blogapi/rsd'

0.51 1 SELECT u.* FROM users u WHERE u.uid = 1 AND u.status < 3 LIMIT 0, 1

0.37 1 S

ELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1

Figure 4-20. The page timer and query log

Figure 4-20. The page timer and query log

0 0

Post a comment