Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: patch
Description: text/plain (7.6 KB)

Responses

pgsql-patches by date

Next:From: Igor KovalenkoDate: 2001-11-28 18:55:38
Subject: Re: Support for QNX6, POSIX IPC and PTHREAD-style locking
Previous:From: Tom LaneDate: 2001-11-28 18:17:45
Subject: Re: Support for QNX6, POSIX IPC and PTHREAD-style locking

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group