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 find the server is whether standby (slave) or primary(master) in Postgresql replication ?

spfile and pfile errors

2017 Shortern URL - Other Website Like ADFOC.US

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

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