psql中使用\watch反复查看语句执行结果

来源:互联网 发布:如何注销知乎账号 编辑:程序博客网 时间:2024/09/21 09:04
test=> \c test a
You are now connected to database "test" as user "a".
test=> select * from a.test;
 id 
----
  1
(1 row)


test=> select * from a.test; \watch 1      -----单位为秒
 id 
----
  1
(1 row)


Wed 08 Feb 2017 09:57:04 AM CST (every 1s)


 id 
----
  1
(1 row)


Wed 08 Feb 2017 09:57:05 AM CST (every 1s)


 id 
----
  1
(1 row)


Wed 08 Feb 2017 09:57:06 AM CST (every 1s)


 id 
----
  1
(1 row)


Wed 08 Feb 2017 09:57:07 AM CST (every 1s)


 id 
----
  1
(1 row)
原创粉丝点击