Slow query performance degrades from milliseconds to seconds

Queries that previously completed in milliseconds now take seconds, indicating performance regression from inefficient query plans, missing indexes, or resource contention.

Use pg_stat_statements extension to identify slow queries by execution time and call frequency. Analyze query plans with EXPLAIN ANALYZE. Create missing indexes, rewrite inefficient queries, or optimize configuration. Track query duration trends over time.