On Sat, 2006-04-08 at 15:10 +0100, Gavin Hamill wrote:
> SELECTS go to *both* live and test, but only the answers from live are
> sent back to clients - the answers from test are discarded...
Put log_min_duration_statement = 0 so all SELECTs go to the log.
Sniff the live log for SELECT statements (plus their live durations),
then route those same statements to the dev box and get a timing from
there also. That way you'll be able to do this without any C coding,
plus you'll have both the live and test elapsed times as a comparison.
Best Regards, Simon Riggs