Re: Timing a query - Mailing list pgsql-general

This is fantastic patch.

Thank you very much.

(For "rookies" (such as myself), to apply the patch you will need "patch",
which is not included in the boxed RedHat 7.1 distribution. I got
patch-2.5.4-9.i386.rpm from ftp.rpmfind.net.)

Regards

Tielman J de Villiers
BondNet Pty Ltd

-----Original Message-----
From: Greg Sabino Mullane [mailto:greg@turnstep.com]
Sent: Wednesday, November 28, 2001 5:52 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Timing a query



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

> this looks superb.
>
> one small question though; how do i apply the patch ?

I'll assume you have the sources for 7.1.3. I'll rewrite the
patch for 7.2b3 in a little bit.

Change to the top level of the postgresql source tree.

> cd postgresql-7.1.3

Save the file at
http://www.gtsm.com/postgres/microtiming.patch
to a local file, perhaps named "microtiming.patch"

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

Patch the source with the file:

> patch -bp0 < microtiming.patch

If all goes well, you should see:

patching file ./src/bin/psql/command.c
patching file ./src/bin/psql/common.c
patching file ./src/bin/psql/help.c
patching file ./src/bin/psql/print.h
patching file ./src/bin/psql/startup.c
patching file ./src/bin/psql/tab-complete.c
patching file ./doc/src/sgml/ref/psql-ref.sgml

You can then run make from the top-level directory, or
to avoid some output, cd to src/bin/psql and run
make from there:

>cd src/bin/psql; make

When finished, you'll have a new psql binary in the
src/bin/psql directory, which should have the microtiming
stuff. Test it out before copying it over to anywhere
permanent:

>./psql

template1=# select version();
                           version
- - --------------------------------------------------------------
 PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 3.0.1 (1 row)

template1=# \m
Microsecond timing is on.
template1=# select version();
                           version
- - --------------------------------------------------------------
 PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 3.0.1 (1 row)

TOTAL TIME: 0.001660
template1=#



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



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

iQA/AwUBPAUIGrybkGcUlkrIEQK8BACcCpmnGT0u99QE+lLxhAyujiEDExgAoJ1C
8GpR/1FBwfHvO0u0P0G7tK2d
=JqYc
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)