Count Logical IO

From EggeWiki
Jump to navigation Jump to search

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>