Thread: timing information for switching database
Hi,
In sqlsh, I issued `\timing on`.
I don't see timing information displayed for `\c database`.
Does someone know how I can obtain such information ?
Thanks
Hi
ne 21. 8. 2022 v 14:41 odesílatel Zhihong Yu <zyu@yugabyte.com> napsal:
Hi,In sqlsh, I issued `\timing on`.I don't see timing information displayed for `\c database`.Does someone know how I can obtain such information ?
you cannot do it in psql
you can write custom application and you can measure disconnect - connect time
Regards
Pavel
Thanks
*\timing* set the pset.timing flag of the global psql options, and use it in the client side to indicate whether to print the query time or not. There are two places using it, *SendQuery* and *PSQLexecWatch*, you may check these functions and add the *timing* logic in function *exec_command_connect* to display the time infomation, but this should be only used for your own testing purpose. On Sun, Aug 21, 2022 at 8:41 PM Zhihong Yu <zyu@yugabyte.com> wrote: > > Hi, > In sqlsh, I issued `\timing on`. > > I don't see timing information displayed for `\c database`. > > Does someone know how I can obtain such information ? > > Thanks -- Regards Junwang Zhao