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)
Re: Microtiming patch for psql (reprise) |
Список | 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 по дате отправления: