@@ -57,13 +57,13 @@ class WaitSampling(Plugin):
5757 jsonb_each(setoflocks.locktuple) AS json_data)
5858 SELECT
5959 CASE
60- WHENevent_type = 'LWLockNamed' THEN 'lwlock'
61- WHENevent_type = 'LWLockTranche' THEN 'lwlock'
62- WHENevent_type = 'LWLock' THEN 'lwlock'
63- WHENevent_type = 'Lock' THEN 'hwlock'
64- WHENevent_type = 'BufferPin' THEN 'buffer'
65- WHENevent_type = 'Extension' THEN 'extension'
66- WHENevent_type = 'Client' THEN 'client'
60+ WHENkey = 'LWLockNamed' THEN 'lwlock'
61+ WHENkey = 'LWLockTranche' THEN 'lwlock'
62+ WHENkey = 'LWLock' THEN 'lwlock'
63+ WHENkey = 'Lock' THEN 'hwlock'
64+ WHENkey = 'BufferPin' THEN 'buffer'
65+ WHENkey = 'Extension' THEN 'extension'
66+ WHENkey = 'Client' THEN 'client'
6767 ELSE 'other'
6868 END,
6969 sum(count) AS count
@@ -157,29 +157,29 @@ class WaitSampling(Plugin):
157157"""
158158 SELECT
159159 CASE
160- WHENlock_type LIKE 'ProcArray%' THEN 'xid'
161- WHENlock_type LIKE 'Autovacuum%' THEN 'autovacuum'
162- WHENlock_type LIKE 'AutovacuumSchedule%' THEN 'autovacuum'
163- WHENlock_type LIKE 'WALBufMapping%' THEN 'wal'
164- WHENlock_type LIKE 'WALInsert%' THEN 'wal'
165- WHENlock_type LIKE 'WALWrite%' THEN 'wal'
166- WHENlock_type LIKE 'ControlFile%' THEN 'wal'
167- WHENlock_type = 'wal_insert' THEN 'wal'
168- WHENlock_type LIKE 'CLogControl%' THEN 'clog'
169- WHENlock_type LIKE 'CLogTruncation%' THEN 'clog'
170- WHENlock_type = 'clog' THEN 'clog'
171- WHENlock_type LIKE 'SyncRep%' THEN 'replication'
172- WHENlock_type LIKE 'ReplicationSlotAllocation%' THEN 'replication'
173- WHENlock_type LIKE 'ReplicationSlotControl%' THEN 'replication'
174- WHENlock_type LIKE 'ReplicationOrigin%' THEN 'replication'
175- WHENlock_type = 'replication_origin' THEN 'replication'
176- WHENlock_type = 'replication_slot_io' THEN 'replication'
177- WHENlock_type LIKE 'LogicalRepWorker%' THEN 'logical_replication'
178- WHENlock_type LIKE 'BufferContent%' THEN 'buffer'
179- WHENlock_type LIKE 'BufferMapping%' THEN 'buffer'
180- WHENlock_type = 'buffer_content' THEN 'buffer'
181- WHENlock_type = 'buffer_io' THEN 'buffer'
182- WHENlock_type = 'buffer_mapping' THEN 'buffer'
160+ WHENevent LIKE 'ProcArray%' THEN 'xid'
161+ WHENevent LIKE 'Autovacuum%' THEN 'autovacuum'
162+ WHENevent LIKE 'AutovacuumSchedule%' THEN 'autovacuum'
163+ WHENevent LIKE 'WALBufMapping%' THEN 'wal'
164+ WHENevent LIKE 'WALInsert%' THEN 'wal'
165+ WHENevent LIKE 'WALWrite%' THEN 'wal'
166+ WHENevent LIKE 'ControlFile%' THEN 'wal'
167+ WHENevent = 'wal_insert' THEN 'wal'
168+ WHENevent LIKE 'CLogControl%' THEN 'clog'
169+ WHENevent LIKE 'CLogTruncation%' THEN 'clog'
170+ WHENevent = 'clog' THEN 'clog'
171+ WHENevent LIKE 'SyncRep%' THEN 'replication'
172+ WHENevent LIKE 'ReplicationSlotAllocation%' THEN 'replication'
173+ WHENevent LIKE 'ReplicationSlotControl%' THEN 'replication'
174+ WHENevent LIKE 'ReplicationOrigin%' THEN 'replication'
175+ WHENevent = 'replication_origin' THEN 'replication'
176+ WHENevent = 'replication_slot_io' THEN 'replication'
177+ WHENevent LIKE 'LogicalRepWorker%' THEN 'logical_replication'
178+ WHENevent LIKE 'BufferContent%' THEN 'buffer'
179+ WHENevent LIKE 'BufferMapping%' THEN 'buffer'
180+ WHENevent = 'buffer_content' THEN 'buffer'
181+ WHENevent = 'buffer_io' THEN 'buffer'
182+ WHENevent = 'buffer_mapping' THEN 'buffer'
183183 ELSE 'other'
184184 END,
185185 sum(count * current_setting('pg_wait_sampling.profile_period')::bigint) AS count