-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Due to a renewed interest in this patch, I've written a
version to patch against 7.2b3. It adds a timing to every
successful query in psql, and is toggled with
backslash-m. It defaults to "off", so there are no
visible changes (newlines added for readablity):
data=# UPDATE foobar SET spin=1 WHERE cat = 'alive';
UPDATE 42
data=# \m
Microsecond timing is on.
data=# UPDATE foobar SET spin=0 WHERE cat = 'alive';
UPDATE 42
TOTAL TIME: 0.000912
data=# CREATE index raul ON foobar(cat);
CREATE
TOTAL TIME: 0.010817
data=# SELECT COUNT(cat) FROM foobar WHERE spin IN (1,2,42);
count
- -------
91291
(1 row)
TOTAL TIME: 0.312139
data=# VACUUM;
VACUUM
TOTAL TIME: 1.469661
Greg Sabino Mullane
greg@turnstep.com
PGP Key: 0x14964AC8 200111281326
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iQA/AwUBPAUtvLybkGcUlkrIEQLSPACg7k5jWTuZio3tp5JDarf89kDL66sAnijX
bEhY6y1gpjViDEp5/uqaNsf2
=PqE4
-----END PGP SIGNATURE-----
