Tuning

pg_settings — Query PostgreSQL Configuration Parameters The live configuration PostgreSQL is running with and the values written in postgresql.conf are not always the same. A parameter that requires a server restart has already been updated in the file but the old value is still in effect. A reload that produced a …

Monitor Running Queries in PostgreSQL (9.2+ and Newer) A query that has been running for forty minutes looks identical, from a load balancer's perspective, to one that finished in forty milliseconds — nothing in a typical connection-pool dashboard flags the difference between a session doing real, expected work and one …