Microtiming patch for psql (reprise)

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Microtiming patch for psql (reprise)
Дата
Msg-id E1699Vf-00019h-00@smtp10.atl.mindspring.net
обсуждение исходный текст
Ответы Re: Microtiming patch for psql (reprise)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Microtiming patch for psql (reprise)  (Peter Eisentraut <peter_e@gmx.net>)
Список 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@turnstep.com
PGP Key: 0x14964AC8 200111281326

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iQA/AwUBPAUtvLybkGcUlkrIEQLSPACg7k5jWTuZio3tp5JDarf89kDL66sAnijX
bEhY6y1gpjViDEp5/uqaNsf2
=PqE4
-----END PGP SIGNATURE-----


Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: "Igor Kovalenko"
Дата:
Сообщение: Re: Support for QNX6, POSIX IPC and PTHREAD-style locking
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Support for QNX6, POSIX IPC and PTHREAD-style locking