pgpool命令

查询锁:

SELECT

    locked.pid AS locked_pid,

    locker.pid AS locker_pid,

    locked_act.usename AS locked_user,

    locker_act.usename AS locker_user,

    locked.virtualtransaction,

    locked.transactionid,

    relname

FROM

    pg_locks locked

    LEFT OUTER JOIN pg_class ON (locked.relation = pg_class.oid),

    pg_locks locker,

    pg_stat_activity locked_act,

    pg_stat_activity locker_act

WHERE

    locker.granted=true AND

    locked.granted=false AND

    locked.pid=locked_act.pid AND

    locker.pid=locker_act.pid AND

    locked.relation=locker.relation;

---------------------

select * from pg_stat_activity aa,

(

    select a.locktype,a.database,a.pid,a.mode,a.relation,b.relname from pg_locks a join pg_class b on a.relation=b.oid

 where upper(b.relname)=FX_WDSJ_DSZH

) bb

where aa.pid=bb.pid

 and aa.waiting=t

–查询是否锁表了

select pid from pg_locks where relation=(select oid from pg_class where relname=表);

 tb_cyplate_localitycheck

查询proc:

select proname --, prosrc

from pg_proc where LOWER(prosrc) like %join% and CHAR_LENGTH(prosrc) ##  100;

查询连接:

SELECT * FROM pg_stat_activity

查询正在执行的语句:

select * from pg_stat_activity where waiting=t;



kill pid:

select pg_cancel_backend(16023);

select  pg_terminate_backend(16023);

查询备机延迟:

select now()-pg_last_xact_replay_timestamp()

查询备机:

select * from pg_stat_replication;

/opt/postgres/9.3/bin/psql -U postgres -p 5432 -c "select * from pg_stat_replication;"

查询语句log:

select * from pg_stat_statements

where query like %tttt%;

清除语句log:

SELECT pg_stat_statements_reset();

显示同步备机名:

show synchronous_standby_names



pgagent:

/opt/pgagent/bin/pgagent hostaddr=localhost dbname=postgres user=postgres



pgpool:

/opt/postgres/9.3/bin/psql -U postgres -p 9999 -c "show pool_nodes;"

查看主pgpool

pcp_watchdog_info 10 10.2.4.90 9898 postgres sa

pcp_watchdog_info 10 10.2.4.90 9898 postgres sa 0

添加pgpool节点

pcp_attach_node  10  localhost  9898  postgres  sa  0

删除pgpool节点

pcp_detach_node  10  localhost  9898  postgres  sa  0

停止pgpool

pcp_stop_pgpool  10  localhost  9898  postgres  sa  s

pcp_stop_pgpool  10  localhost  9898  postgres  sa  f

pcp_stop_pgpool  10  localhost  9898  postgres  sa  i

来源张永光的博客

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值