psql \timing patch

Started by Greg Sabino Mullaneover 24 years ago3 messagespatches
Jump to latest
#1Greg Sabino Mullane
greg@turnstep.com

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Another stab at the \timing patch for psql. It simply
shows how long each query takes.

Thanks to all those who have responded, on and off the list,
especially Peter Eisentraut - most of the improvements
are his.

I'm using \timing as opposed to \m, although this means
I lose the startup flag - unless someone can think of
another letter to use, since -t is aready taken and
not all clients support long options (--timing). I'm not
sure how useful it would be, but I for one would like to
be able to turn it on with a startup flag.

Greg Sabino Mullane
greg@turnstep.com
PGP Key: 0x14964AC8 200201031816

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

iQA/AwUBPDTni7ybkGcUlkrIEQLj2wCgzXKQRjTuCKLw2cOpflnKdA7fkf0AoMXY
5p8BKG1JrrgViMVHaJHNQoeR
=4ZPX
-----END PGP SIGNATURE-----

Attachments:

patchtext/plain; charset=us-ascii; name=patchDownload+36-23
#2Bruce Momjian
bruce@momjian.us
In reply to: Greg Sabino Mullane (#1)
Re: psql \timing patch

Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

Greg Sabino Mullane wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Another stab at the \timing patch for psql. It simply
shows how long each query takes.

Thanks to all those who have responded, on and off the list,
especially Peter Eisentraut - most of the improvements
are his.

I'm using \timing as opposed to \m, although this means
I lose the startup flag - unless someone can think of
another letter to use, since -t is aready taken and
not all clients support long options (--timing). I'm not
sure how useful it would be, but I for one would like to
be able to turn it on with a startup flag.

Greg Sabino Mullane
greg@turnstep.com
PGP Key: 0x14964AC8 200201031816

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

iQA/AwUBPDTni7ybkGcUlkrIEQLj2wCgzXKQRjTuCKLw2cOpflnKdA7fkf0AoMXY
5p8BKG1JrrgViMVHaJHNQoeR
=4ZPX
-----END PGP SIGNATURE-----

[ Attachment, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#3Bruce Momjian
bruce@momjian.us
In reply to: Greg Sabino Mullane (#1)
Re: psql \timing patch

Latest version of this Patch applied. Thanks.

http://www.gtsm.com/postgres/microtiming.patch

---------------------------------------------------------------------------

Greg Sabino Mullane wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Another stab at the \timing patch for psql. It simply
shows how long each query takes.

Thanks to all those who have responded, on and off the list,
especially Peter Eisentraut - most of the improvements
are his.

I'm using \timing as opposed to \m, although this means
I lose the startup flag - unless someone can think of
another letter to use, since -t is aready taken and
not all clients support long options (--timing). I'm not
sure how useful it would be, but I for one would like to
be able to turn it on with a startup flag.

Greg Sabino Mullane
greg@turnstep.com
PGP Key: 0x14964AC8 200201031816

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

iQA/AwUBPDTni7ybkGcUlkrIEQLj2wCgzXKQRjTuCKLw2cOpflnKdA7fkf0AoMXY
5p8BKG1JrrgViMVHaJHNQoeR
=4ZPX
-----END PGP SIGNATURE-----

[ Attachment, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026