8000 fix: fixed Wait Sampling queries columns · postgrespro/mamonsu@34c44c2 · GitHub
[go: up one dir, main page]
Skip to content

Commit 34c44c2

Browse files
cuprumtancuprumtan
committed
fix: fixed Wait Sampling queries columns
1 parent ee8b996 commit 34c44c2

File tree

2 files changed

+37
-37
lines changed

2 files changed

+37
-37
lines changed

‎mamonsu/plugins/pgsql/wait_sampling.py

Lines changed: 30 additions & 30 deletions
Original file line numberDiff line numberDiff line change
@@ -57,13 +57,13 @@ class WaitSampling(Plugin):
5757
jsonb_each(setoflocks.locktuple) AS json_data)
5858
SELECT
5959
CASE
60-
WHEN event_type = 'LWLockNamed' THEN 'lwlock'
61-
WHEN event_type = 'LWLockTranche' THEN 'lwlock'
62-
WHEN event_type = 'LWLock' THEN 'lwlock'
63-
WHEN event_type = 'Lock' THEN 'hwlock'
64-
WHEN event_type = 'BufferPin' THEN 'buffer'
65-
WHEN event_type = 'Extension' THEN 'extension'
66-
WHEN event_type = 'Client' THEN 'client'
60+
WHEN key = 'LWLockNamed' THEN 'lwlock'
61+
WHEN key = 'LWLockTranche' THEN 'lwlock'
62+
WHEN key = 'LWLock' THEN 'lwlock'
63+
WHEN key = 'Lock' THEN 'hwlock'
64+
WHEN key = 'BufferPin' THEN 'buffer'
65+
WHEN key = 'Extension' THEN 'extension'
66+
WHEN key = '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-
WHEN lock_type LIKE 'ProcArray%' THEN 'xid'
161-
WHEN lock_type LIKE 'Autovacuum%' THEN 'autovacuum'
162-
WHEN lock_type LIKE 'AutovacuumSchedule%' THEN 'autovacuum'
163-
WHEN lock_type LIKE 'WALBufMapping%' THEN 'wal'
164-
WHEN lock_type LIKE 'WALInsert%' THEN 'wal'
165-
WHEN lock_type LIKE 'WALWrite%' THEN 'wal'
166-
WHEN lock_type LIKE 'ControlFile%' THEN 'wal'
167-
WHEN lock_type = 'wal_insert' THEN 'wal'
168-
WHEN lock_type LIKE 'CLogControl%' THEN 'clog'
169-
WHEN lock_type LIKE 'CLogTruncation%' THEN 'clog'
170-
WHEN lock_type = 'clog' THEN 'clog'
171-
WHEN lock_type LIKE 'SyncRep%' THEN 'replication'
172-
WHEN lock_type LIKE 'ReplicationSlotAllocation%' THEN 'replication'
173-
WHEN lock_type LIKE 'ReplicationSlotControl%' THEN 'replication'
174-
WHEN lock_type LIKE 'ReplicationOrigin%' THEN 'replication'
175-
WHEN lock_type = 'replication_origin' THEN 'replication'
176-
WHEN lock_type = 'replication_slot_io' THEN 'replication'
177-
WHEN lock_type LIKE 'LogicalRepWorker%' THEN 'logical_replication'
178-
WHEN lock_type LIKE 'BufferContent%' THEN 'buffer'
179-
WHEN lock_type LIKE 'BufferMapping%' THEN 'buffer'
180-
WHEN lock_type = 'buffer_content' THEN 'buffer'
181-
WHEN lock_type = 'buffer_io' THEN 'buffer'
182-
8000 WHEN lock_type = 'buffer_mapping' THEN 'buffer'
160+
WHEN event LIKE 'ProcArray%' THEN 'xid'
161+
WHEN event LIKE 'Autovacuum%' THEN 'autovacuum'
162+
WHEN event LIKE 'AutovacuumSchedule%' THEN 'autovacuum'
163+
WHEN event LIKE 'WALBufMapping%' THEN 'wal'
164+
WHEN event LIKE 'WALInsert%' THEN 'wal'
165+
WHEN event LIKE 'WALWrite%' THEN 'wal'
166+
WHEN event LIKE 'ControlFile%' THEN 'wal'
167+
WHEN event = 'wal_insert' THEN 'wal'
168+
WHEN event LIKE 'CLogControl%' THEN 'clog'
169+
WHEN event LIKE 'CLogTruncation%' THEN 'clog'
170+
WHEN event = 'clog' THEN 'clog'
171+
WHEN event LIKE 'SyncRep%' THEN 'replication'
172+
WHEN event LIKE 'ReplicationSlotAllocation%' THEN 'replication'
173+
WHEN event LIKE 'ReplicationSlotControl%' THEN 'replication'
174+
WHEN event LIKE 'ReplicationOrigin%' THEN 'replication'
175+
WHEN event = 'replication_origin' THEN 'replication'
176+
WHEN event = 'replication_slot_io' THEN 'replication'
177+
WHEN event LIKE 'LogicalRepWorker%' THEN 'logical_replication'
178+
WHEN event LIKE 'BufferContent%' THEN 'buffer'
179+
WHEN event LIKE 'BufferMapping%' THEN 'buffer'
180+
WHEN event = 'buffer_content' THEN 'buffer'
181+
WHEN event = 'buffer_io' THEN 'buffer'
182+
WHEN event = 'buffer_mapping' THEN 'buffer'
183183
ELSE 'other'
184184
END,
185185
sum(count * current_setting('pg_wait_sampling.profile_period')::bigint) AS count

‎mamonsu/tools/bootstrap/sql.py

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -238,13 +238,13 @@
238238
jsonb_each(setoflocks.locktuple) AS json_data)
239239
SELECT
240240
CASE
241-
WHEN event_type = ''LWLockNamed'' THEN ''lwlock''
242-
WHEN event_type = ''LWLockTranche'' THEN ''lwlock''
243-
WHEN event_type = ''LWLock'' THEN ''lwlock''
244-
WHEN event_type = ''Lock'' THEN ''hwlock''
245-
WHEN event_type = ''BufferPin'' THEN ''buffer''
246-
WHEN event_type = ''Extension'' THEN ''extension''
247-
WHEN event_type = ''Client'' THEN ''client''
241+
WHEN key = ''LWLockNamed'' THEN ''lwlock''
242+
WHEN key = ''LWLockTranche'' THEN ''lwlock''
243+
WHEN key = ''LWLock'' THEN ''lwlock''
244+
WHEN key = ''Lock'' THEN ''hwlock''
245+
WHEN key = ''BufferPin'' THEN ''buffer''
246+
WHEN key = ''Extension'' THEN ''extension''
247+
WHEN key = ''Client'' THEN ''client''
248248
ELSE ''other''
249249
END,
250250
sum(count) AS count

0 commit comments

Comments
 (0)
0