diff options
| author | Michael Paquier <michael@paquier.xyz> | 2023-10-24 08:40:43 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2023-10-24 08:40:43 +0900 |
| commit | befe9451fbf5a4b49e80f17917d8c6d8b5edad26 (patch) | |
| tree | 7d26b15319b154f6a64513f71547c0d4a2b48219 /doc/src | |
| parent | 9972c7de1d078d30434c16081fe0624ee3d24a61 (diff) | |
| download | postgresql-befe9451fbf5a4b49e80f17917d8c6d8b5edad26.tar.gz postgresql-befe9451fbf5a4b49e80f17917d8c6d8b5edad26.zip | |
doc: Improve example query related to pg_wait_events
Author: Pavel Luzanov
Discussion: https://postgr.es/m/4f79be75-7e30-4817-b0da-4a691ea5427f@postgrespro.ru
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 1149093a8a6..3f49ff79f34 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1119,7 +1119,7 @@ SELECT a.pid, a.wait_event, w.description FROM pg_stat_activity a JOIN pg_wait_events w ON (a.wait_event_type = w.type AND a.wait_event = w.name) - WHERE wait_event is NOT NULL and a.state = 'active'; + WHERE a.wait_event is NOT NULL and a.state = 'active'; -[ RECORD 1 ]------------------------------------------------------&zwsp;------------ pid | 686674 wait_event | WALInitSync |