在psql中,使用\watch反复查看语句的执行结果
程序员文章站
2022-10-31 22:52:12
test=> \c test a
You are now connected to database "test" as user "a&qu...
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)
上一篇: PHP经典面试题分享
下一篇: SQl语句中使用占位符的优点