# encoding: utf-8
#!/usr/bin/env ruby

require 'benchmark'
require 'pg'

conn = PG.connect host: 'localhost', dbname: 'dbname', user: 'user', password: 'password'

values, query = [], 'SELECT * FROM users LIMIT 1000'

measure = Benchmark.measure do
  conn.exec(query).each do |row|
    values << row
  end
end

puts "'#{query}' => #{measure}", values.first.to_json[0..800]