select sessionid, clientip, username, relname as table_name, requesttime as lock_request_time, granttime as lock_acquired_time, command as sql, lockstate from _t_pg_locks where relid in ( select relid from _t_pg_locks where lockstate='WAIT') order by requesttime, granttimeTo kill a session / transaction you can simply right click it under current sessions in Netezza Administrator.
Sunday, June 15, 2014
Show locks in a Netezza Database
This SQL statement when run in Aginity or nzsql will show you all sessions that cause locks in a database.
Subscribe to:
Post Comments (Atom)
1xbet korean: What is 1xbet korean? - Legalbet.co.kr
ReplyDeleteOne bet on 1xbet in this bookie, is a 4 bets and the total is 1. The bets are the same 1xbet amount. The value of deccasino the winnings in a single bet choegocasino is 1.2 x