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

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

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Database startup / shutdown /restart

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

PostgreSQL pgBadger