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

psql microsecond timing patch

From: greg(at)turnstep(dot)com
To: <pgsql-patches(at)postgresql(dot)org>
Subject: psql microsecond timing patch
Date: 2001-09-27 15:35:58
Message-ID: 200109271535.LAA00608@barry.mail.mindspring.net (view raw or flat)
Thread:
Lists: pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

This is a small patch to allow you to time your queries in 
psql. Myself and some others have been using it and find it 
useful for telling how long an actual specific query takes, 
as opposed to EXPLAIN which just does an estimate. Using the 
two together is a good way to tweak sql and indices. Even 
if not deemed useful, it should be good practice in learning 
to submit patches. :)

(I called it "microsecond timing" because "m" was one of the 
few letters still available as a backslash command that 
had some mnemonic potential.)

Thanks,
Greg Sabino Mullane
greg(at)turnstep(dot)com 200109270943
PGP Key: 0x14964AC8

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

iQA/AwUBO7NHE7ybkGcUlkrIEQIq9wCfSSsozUx5U55EPUsuBz5XZErfcIEAnAu7
FrtN+K+rtXIgTmRn9MABLC3i
=UXkx
-----END PGP SIGNATURE-----

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2001-09-27 16:21:00
Subject: Re: psql microsecond timing patch
Previous:From: Karel ZakDate: 2001-09-27 15:26:56
Subject: Re: Problem with setlocale (found in libecpg) [accessing a memory location after freeing it]

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