You will find Talend Errors and solutions, Optimization, Tips & Tricks, Performance, Components Explanations ... and much more.
Tuesday, 16 August 2016
Finding Blocked Tables in POSTGRES
select t.relname,l.locktype,page,virtualtransaction,pid,mode,granted from pg_locks l, pg_stat_all_tables t where l.relation=t.relid order by relation asc;