From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Microtiming patch for psql (reprise) |
Date: | 2001-11-28 18:33:53 |
Message-ID: | E1699Vf-00019h-00@smtp10.atl.mindspring.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
-----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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200111281326
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iQA/AwUBPAUtvLybkGcUlkrIEQLSPACg7k5jWTuZio3tp5JDarf89kDL66sAnijX
bEhY6y1gpjViDEp5/uqaNsf2
=PqE4
-----END PGP SIGNATURE-----
Attachment | Content-Type | Size |
---|---|---|
patch | text/plain | 7.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Kovalenko | 2001-11-28 18:55:38 | Re: Support for QNX6, POSIX IPC and PTHREAD-style locking |
Previous Message | Tom Lane | 2001-11-28 18:17:45 | Re: Support for QNX6, POSIX IPC and PTHREAD-style locking |