View running queries in postgresql

 View running queries in postgreSQL：

SELECT * FROM pg_stat_activity;

Golden gate commands

 Golden gate commands for ggsci:

$ ./ggsci

GGSCI>

info all - Displays status of all Extract, Replicat, and Manager processes.

 Start / Stop Processes

• start extract <extract_name>   --- Start Extract process

• stop extract <extract_name>   --- Stop Extract process

• start replicat <replicat_name>  --- Start Replicat process

• stop replicat <replicat_name>  --- Stop Replicat process

check info about individual.

• info extract <extract_name>, detail   -- Detailed info about Extract

• info replicat <replicat_name>, detail   -- Detailed info about Replicat

• info mgr - Displays Manager process status

Check Lag

• lag extract <extract_name>   -- Shows Extract lag

• lag replicat <replicat_name>   -- Shows Replicat lag

View Statistics

• stats extract <extract_name>   -- Displays Extract statistics

• stats replicat <replicat_name>  -- Displays Replicat statistics\

Troubleshooting

• view report <extract_name>  --- View Extract report

• view report <replicat_name>  --- View Replicat report

• send extract <extract_name>, status   --- Real-time Extract status

• send replicat <replicat_name>, status  ---  Real-time Replicat status

• kill extract <extract_name>  --- Forcefully terminate Extract (use with caution)

• kill replicat <replicat_name>  --- Forcefully terminate Replicat (use with caution)