Daily scripts

 Blocking queries

=================

select pid,

       usename,

       pg_blocking_pids(pid) as blocked_by,

       query as blocked_query

from pg_stat_activity

where cardinality(pg_blocking_pids(pid)) > 0;
=================================================

select pid, usename, datname, state, query, state_change, now() - query_start as duration

from pg_catalog.pg_stat_activity

where state = 'active'

and now() - query_start > interval '5 minutes'

order by duration desc;
====================================================

===========================================================================================================================

psql -h Tf.com -p 5439 -d test -U "tprabhuc" -e -f prabhu.sql >> prabhuc.log

============================================================================================================================

export PGPASSWORD="test"

psql --host=TF.com --dbname=test --username=testdmin -a -f 01_tables.sql > 01_tables.out

======================================================================================================================

nohup sh CHG0088631_1.sh > CHG0088631_1.log &

================================================
select * from pg_stat_activity where pid = '9796';