Answers for "postgre update too slow than select"

0

postgre update too slow than select

SELECT * FROM pg_stat_activity WHERE wait_event IS NOT NULL AND backend_type = 'client backend';
Posted by: Guest on January-18-2021
0

postgre update too slow than select

SELECT * FROM pg_stat_activity 
WHERE pid IN (SELECT pg_blocking_pids(<pid of blocked query>));
Posted by: Guest on January-18-2021

Browse Popular Code Answers by Language