pgsql: Allow \watch to display query execution time if \timing is enabl

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow \watch to display query execution time if \timing is enabl
Date: 2014-09-04 03:50:34
Message-ID: E1XPO4A-00069j-Sl@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow \watch to display query execution time if \timing is enabled.

Previously \watch could not display the query execution time even
when \timing was enabled because it used PSQLexec instead of
SendQuery and that function didn't support \timing. This patch
introduces PSQLexecWatch and changes \watch so as to use it, instead.
PSQLexecWatch is the function to run the query, print its results and
display how long it took (only when \timing is enabled).

This patch also changes --echo-hidden so that it doesn't print
the query that \watch executes. Since \watch cannot execute
backslash command queries, they should not be printed even
when --echo-hidden is set.

Patch by me, review by Heikki Linnakangas and Michael Paquier

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/f6f654ff12c527310ddbeaf53d463d22ab46ee2c

Modified Files
--------------
src/bin/psql/command.c | 63 +++++--------------------------
src/bin/psql/common.c | 96 ++++++++++++++++++++++++++++++++++++++++++++++++
src/bin/psql/common.h | 3 ++
3 files changed, 109 insertions(+), 53 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2014-09-04 05:07:17 pgsql: docs: Improve documentation of \pset without arguments.
Previous Message Bruce Momjian 2014-09-03 21:22:25 pgsql: Update URL reference material in /contrib/isn docs