Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL Query Slow or Particular Job Slow

1.Find out any network issues or not
2.Check any code/query changed or not.
3.Take Explain plan then check indexe used or not
  Force index scan --> Seq_scan=false,
  rebuild index-->pg_index,pg_stat_all_indexes 
  Find vaccum analyze-->pg_stat_all_tables
  check join condition
  check no.of process id in client connection 
       select count(*) from pg_stat_activity
       select backend from pg_stat_database


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Pgbadger Installation On Linux

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform