{"Entry":{"collection":"psql","key":"cmd-77-61-74-63-68","name":"\\watch","aliases":["\\watch"],"metadata":{"aliases":["\\watch"],"category":"Query execution","content_hash":"d1dbe67a18f8a847052d807f68df6901ad4c0a2c3ae4fc29bea2cd9ed03b9eb2","derived_content_hash":"995ad57da740aed526774d452a071dcbe9c0f7a5f560e55982dbdd9f4dfa27cd","documentation_refresh":{"batch":"20261113","original_source_rev":"","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"imported_at":"2026-09-30T00:40:45.230698+08:00","name":"\\watch","name_zh":"","slug":"cmd-77-61-74-63-68","summary":"Repeatedly execute the current query buffer (as \\g does) until interrupted, or the query fails, or the execution count limit (if given) is reached, or the query no longer returns the minimum number of rows. Wait the specified number of seconds (default 2) between executions. The default wait can be changed with the variable WATCH_INTERVAL . For backwards compatibility, seconds can be specified with or without an interval= prefix. Each query result is displayed with a header that includes the \\pset title string (if any), the time as of query start, and the delay interval."}},"Definition":{"Collection":"psql","Key":"cmd-77-61-74-63-68","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-77-61-74-63-68","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\watch","comparison_data":{"definition":"Repeatedly execute the current query buffer (as \\g does) until interrupted, or the query fails, or the execution count limit (if given) is reached, or the query no longer returns the minimum number of rows. Wait the specified number of seconds (default 2) between executions. The default wait can be changed with the variable WATCH_INTERVAL . For backwards compatibility, seconds can be specified with or without an interval= prefix. Each query result is displayed with a header that includes the \\pset title string (if any), the time as of query start, and the delay interval. If the current query buffer is empty, the most recently sent query is re-executed instead.","modifiers":[],"signature":"\\watch [ i[nterval]= seconds ] [ c[ount]= times ] [ m[in_rows]= rows ] [ seconds ]","spellings":["\\watch"]},"comparison_hash":"2d0001c3e602c9bddf8a7f0a2be5faf9f7352a1028ebe6b1a7845cc64ebe2913","description":["Repeatedly execute the current query buffer (as \\g does) until interrupted, or the query fails, or the execution count limit (if given) is reached, or the query no longer returns the minimum number of rows. Wait the specified number of seconds (default 2) between executions. The default wait can be changed with the variable WATCH_INTERVAL . For backwards compatibility, seconds can be specified with or without an interval= prefix. Each query result is displayed with a header that includes the \\pset title string (if any), the time as of query start, and the delay interval."],"description_zh":"重复执行当前查询缓冲区（如同 \\g 一样），直到被中断、查询失败、达到执行次数上限（如果给定）或查询返回的行数低于最小要求。两次执行之间等待指定的秒数（默认 2 秒）。默认等待时间可通过变量 WATCH_INTERVAL 修改。为保持向后兼容， seconds 可以带或不带 interval= 前缀。每次查询结果都会带有一个头部，其中包含 \\pset title 字符串（如果有）、查询开始时的时间以及延迟间隔。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        重复执行当前查询缓冲区（如同 \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e 一样），直到被中断、查询失败、达到执行次数上限（如果给定）或查询返回的行数低于最小要求。两次执行之间等待指定的秒数（默认 2 秒）。默认等待时间可通过变量 \u003ca class=\"xref\" href=\"/zh/docs/18/app-psql.html#APP-PSQL-VARIABLES-WATCH-INTERVAL\"\u003e\u003ccode class=\"varname\"\u003eWATCH_INTERVAL\u003c/code\u003e\u003c/a\u003e 修改。为保持向后兼容，\u003cem class=\"replaceable\"\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e 可以带或不带 \u003ccode class=\"literal\"\u003einterval=\u003c/code\u003e 前缀。每次查询结果都会带有一个头部，其中包含 \u003ccode class=\"literal\"\u003e\\pset title\u003c/code\u003e\n        字符串（如果有）、查询开始时的时间以及延迟间隔。\n        \u003c/p\u003e\u003cp\u003e\n        如果当前查询缓冲区为空，则重新执行最近发送的查询。\n        \u003c/p\u003e\u003c/dd\u003e","documentation_revision":{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"facts":[{"label":"Client","value":"psql 18.7"},{"label":"Case-sensitive spelling","value":"\\watch"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\watch"}],"localization":{"documentation_release":"18.7","language":"en","source_language":"en","source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552","status":"same-version-reviewed-manual"},"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-WATCH\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\watch [ i[nterval]=\u003cem class=\"replaceable\"\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e ] [ c[ount]=\u003cem class=\"replaceable\"\u003e\u003ccode\u003etimes\u003c/code\u003e\u003c/em\u003e ] [ m[in_rows]=\u003cem class=\"replaceable\"\u003e\u003ccode\u003erows\u003c/code\u003e\u003c/em\u003e ] [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Repeatedly execute the current query buffer (as \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e does)\n        until interrupted, or the query fails, or the execution count limit\n        (if given) is reached, or the query no longer returns the minimum number\n        of rows. Wait the specified number of seconds (default 2) between executions.\n        The default wait can be changed with the variable\n        \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES-WATCH-INTERVAL\"\u003e\u003ccode class=\"varname\"\u003eWATCH_INTERVAL\u003c/code\u003e\u003c/a\u003e.\n        For backwards compatibility,\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e can be specified\n        with or without an \u003ccode class=\"literal\"\u003einterval=\u003c/code\u003e prefix.\n        Each query result is\n        displayed with a header that includes the \u003ccode class=\"literal\"\u003e\\pset title\u003c/code\u003e\n        string (if any), the time as of query start, and the delay interval.\n        \u003c/p\u003e\u003cp\u003e\n        If the current query buffer is empty, the most recently sent query\n        is re-executed instead.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-WATCH","modifiers":[],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"psql 命令行选项及完整手册","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sections":[],"sections_zh":[],"signature":"\\watch [ i[nterval]= seconds ] [ c[ount]= times ] [ m[in_rows]= rows ] [ seconds ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-WATCH","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-WATCH"}],"spellings":["\\watch"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\watch","url":"/wiki/psql/cmd-77-61-74-63-68/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\watch","url":"/wiki/psql/cmd-77-61-74-63-68/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-WATCH","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-WATCH","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-WATCH"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-77-61-74-63-68","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\watch","Summary":"Repeatedly execute the current query buffer (as \\g does) until interrupted, or the query fails, or the execution count limit (if given) is reached, or the query no longer returns the minimum number of rows. Wait the specified number of seconds (default 2) between executions. The default wait can be changed with the variable WATCH_INTERVAL . For backwards compatibility, seconds can be specified with or without an interval= prefix. Each query result is displayed with a header that includes the \\pset title string (if any), the time as of query start, and the delay interval.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-WATCH\"\u003e\u003cspan\u003e\u003ccode\u003e\\watch [ i[nterval]=\u003cem\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e ] [ c[ount]=\u003cem\u003e\u003ccode\u003etimes\u003c/code\u003e\u003c/em\u003e ] [ m[in_rows]=\u003cem\u003e\u003ccode\u003erows\u003c/code\u003e\u003c/em\u003e ] [ \u003cem\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Repeatedly execute the current query buffer (as \u003ccode\u003e\\g\u003c/code\u003e does)\n        until interrupted, or the query fails, or the execution count limit\n        (if given) is reached, or the query no longer returns the minimum number\n        of rows. Wait the specified number of seconds (default 2) between executions.\n        The default wait can be changed with the variable\n        \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES-WATCH-INTERVAL\" rel=\"nofollow\"\u003e\u003ccode\u003eWATCH_INTERVAL\u003c/code\u003e\u003c/a\u003e.\n        For backwards compatibility,\n        \u003cem\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e can be specified\n        with or without an \u003ccode\u003einterval=\u003c/code\u003e prefix.\n        Each query result is\n        displayed with a header that includes the \u003ccode\u003e\\pset title\u003c/code\u003e\n        string (if any), the time as of query start, and the delay interval.\n        \u003c/p\u003e\u003cp\u003e\n        If the current query buffer is empty, the most recently sent query\n        is re-executed instead.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"5a39799fa6551566f44281e190a533ccad61f555496acc24f2b93a3a806ebbd9","Payload":{"description":["Repeatedly execute the current query buffer (as \\g does) until interrupted, or the query fails, or the execution count limit (if given) is reached, or the query no longer returns the minimum number of rows. Wait the specified number of seconds (default 2) between executions. The default wait can be changed with the variable WATCH_INTERVAL . For backwards compatibility, seconds can be specified with or without an interval= prefix. Each query result is displayed with a header that includes the \\pset title string (if any), the time as of query start, and the delay interval."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-WATCH\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\watch [ i[nterval]=\u003cem class=\"replaceable\"\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e ] [ c[ount]=\u003cem class=\"replaceable\"\u003e\u003ccode\u003etimes\u003c/code\u003e\u003c/em\u003e ] [ m[in_rows]=\u003cem class=\"replaceable\"\u003e\u003ccode\u003erows\u003c/code\u003e\u003c/em\u003e ] [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Repeatedly execute the current query buffer (as \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e does)\n        until interrupted, or the query fails, or the execution count limit\n        (if given) is reached, or the query no longer returns the minimum number\n        of rows. Wait the specified number of seconds (default 2) between executions.\n        The default wait can be changed with the variable\n        \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-VARIABLES-WATCH-INTERVAL\"\u003e\u003ccode class=\"varname\"\u003eWATCH_INTERVAL\u003c/code\u003e\u003c/a\u003e.\n        For backwards compatibility,\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003eseconds\u003c/code\u003e\u003c/em\u003e can be specified\n        with or without an \u003ccode class=\"literal\"\u003einterval=\u003c/code\u003e prefix.\n        Each query result is\n        displayed with a header that includes the \u003ccode class=\"literal\"\u003e\\pset title\u003c/code\u003e\n        string (if any), the time as of query start, and the delay interval.\n        \u003c/p\u003e\u003cp\u003e\n        If the current query buffer is empty, the most recently sent query\n        is re-executed instead.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\watch","url":"/wiki/psql/cmd-77-61-74-63-68/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\watch","Signature":"\\watch [ i[nterval]= seconds ] [ c[ount]= times ] [ m[in_rows]= rows ] [ seconds ]","Modifiers":[]}],"SQLState":null,"Evidence":null}