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

PostgreSQL pgBadger

How to Return a Result Set from a PostgreSQL Stored Procedure

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

vacuumlo - removing large objects orphans from a database PostgreSQL