Slide 55
Slide 55 text
初級編:スロークエリを追え!
=# SELECT l.locktype, c.relname, l.pid, l.mode,
substring(a.current_query, 1, 6) AS query,
(current_timestamp - xact_start)::interval(3) AS duration
FROM pg_locks l LEFT OUTER JOIN pg_stat_activity a
ON l.pid = a. procpid
LEFT OUTER JOIN pg_class c ON l.relation = c.oid
WHERE NOT l.granted ORDER BY l.pid;