Count Logical IO

From EggeWiki
Revision as of 00:43, 21 January 2009 by Egge (talk | contribs) (New page: I append this one liner to my sqsh statement to get a count of logical io. Be sure to '''set statistics io on''' first. <geshi lang="bash">| ruby -pe ' BEGIN{@sum=0}; if $_ =~ /logical re...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

I append this one liner to my sqsh statement to get a count of logical io. Be sure to set statistics io on first. <geshi lang="bash">| ruby -pe ' BEGIN{@sum=0}; if $_ =~ /logical reads: \(regular=\d+ apf=\d+ total=(\d+)\)/ then @sum += $1.to_i; end; END{puts "TOTAL = #{@sum}" } '</geshi>