Count Logical IO

From EggeWiki

I append this one liner to my sqsh statement to get a count of logical io. Be sure to set statistics io on first.

| ruby -pe '
BEGIN{@sum=0}; if $_ =~ /logical reads: \(regular=\d+ apf=\d+ total=(\d+)\)/ then @sum += $1.to_i; end; END{puts "TOTAL = #{@sum}" }
'