Microtiming patch for psql (reprise)

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

Responses

Browse pgsql-patches by date

  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