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 
  USING:
       select count(*) from pg_stat_activity
       select backend from pg_stat_database

Comments

Popular posts from this blog

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

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

PostgreSQL Database startup / shutdown /restart

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger