Wednesday, 14 August 2024

Grep for top 10 postgres memory process

 


/*OS process and DB Process check*/
———————————————————————————————————–

Grep for top 10 postgres memory process:-

ps axu | awk ‘{print $2, $3, $4, $11, $12 }’ | sort -k3 -nr |head -10| grep -i postgres

No comments:

Post a Comment

Master and Slave - Sync check - PostgreSQL

  1) Run the below Query on Primary:- SELECT     pid,     usename,     application_name,     client_addr,     state,     sync_state,     sen...