8000 fix: fixed Wait Sampling lock types in queries · postgrespro/mamonsu@7b623e8 · GitHub
[go: up one dir, main page]
Skip to content

Commit 7b623e8

Browse files
cuprumtancuprumtan
committed
fix: fixed Wait Sampling lock types in queries
1 parent 8e4cd38 commit 7b623e8

File tree

1 file changed

+4
-2
lines changed

1 file changed

+4
-2
lines changed

‎mamonsu/plugins/pgsql/wait_sampling.py

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -24,6 +24,7 @@ class WaitSampling(Plugin):
2424
CASE
2525
WHEN event_type = 'LWLockNamed' THEN 'lwlock'
2626
WHEN event_type = 'LWLockTranche' THEN 'lwlock'
27+
WHEN event_type = 'LWLock' THEN 'lwlock'
2728
WHEN event_type = 'Lock' THEN 'hwlock'
2829
ELSE 'buffer'
2930
END,
@@ -49,6 +50,7 @@ class WaitSampling(Plugin):
4950
CASE
5051
WHEN key = 'LWLockNamed' THEN 'lwlock'
5152
WHEN key = 'LWLockTranche' THEN 'lwlock'
53+
WHEN key = 'LWLock' THEN 'lwlock'
5254
WHEN key = 'Lock' THEN 'hwlock'
5355
ELSE 'buffer'
5456
END,
@@ -161,7 +163,7 @@ class WaitSampling(Plugin):
161163
END,
162164
sum(count * current_setting('pg_wait_sampling.profile_period')::bigint) AS count
163165
FROM {extension_schema}.pg_wait_sampling_profile
164-
WHERE event_type = 'LWLockTranche' OR event_type = 'LWLockNamed'
166+
WHERE event_type IN ('LWLock', 'LWLockTranche', 'LWLockNamed')
165167
AND queryid IS NOT NULL AND queryid != 0
166168
GROUP BY 1
167169
ORDER BY count DESC;
@@ -177,7 +179,7 @@ class WaitSampling(Plugin):
177179
FROM {extension_schema}.pgpro_stats_totals
178180
WHERE object_type = 'cluster'))) setoflocks,
179181
jsonb_each(setoflocks.locktuple) AS json_data
180-
WHERE setoflocks.key IN ('Lock', 'LWLock', 'LWLockTranche', 'LWLockNamed'))
182+
WHERE setoflocks.key IN ('LWLock', 'LWLockTranche', 'LWLockNamed'))
181183
SELECT
182184
CASE
183185
WHEN lock_type = 'ProcArrayLock' THEN 'xid'

0 commit comments

Comments
 (0)
0