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
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
Post a Comment