Thread: psql \timing patch

psql \timing patch

From
"Greg Sabino Mullane"
Date:
-----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

Re: psql \timing patch

From
Bruce Momjian
Date:
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

Re: psql \timing patch

From
Bruce Momjian
Date:
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