Обсуждение: pgsql: Allow \watch to display query execution time if \timing is enabl

Поиск
Список
Период
Сортировка

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

От
Fujii Masao
Дата:
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(-)