PT-04 How to Identify blocking queries in postgresql | Tribute to
Learn how to identify blocking queries in PostgreSQL with this quick YouTube tutorial. Master the art of pinpointing and resolving blocking issues for optimal database performance!
to identify blocking query;
SELECT bl.pid AS blocked_pid,
a.usename AS blocked_user,
ka.query AS blocking_statement,
now() - ka.query_start AS blocking_duration,
kl.pid AS blocking_pid,
ka.usename AS blocking_user,
a.query AS blocked_statement,
now() - a.query_start AS blocked_duration
FROM pg_catalog.pg_locks bl
JOIN pg_catalog.pg_stat_activity a ON a.pid = bl.pid
JOIN pg_catalog.pg_locks kl ON kl.transactionid = bl.transactionid AND kl.pid != bl.pid
JOIN pg_catalog.pg_stat_activity ka ON ka.pid = kl.pid
WHERE NOT bl.granted;
to identify currently running queries
#performance #dbs #longrunning #queries
Смотрите видео PT-04 How to Identify blocking queries in postgresql | Tribute to онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь mynotesoracledba 27 Июль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 306 раз и оно понравилось 14 людям.