Bird
0
0

After running ANALYZE, you notice query plans are not improving. Which of these might fix the issue?

medium📝 Debug Q7 of 15
PostgreSQL - Performance Tuning
After running ANALYZE, you notice query plans are not improving. Which of these might fix the issue?
ARun <code>ANALYZE</code> with incorrect table name
BRun <code>VACUUM ANALYZE</code> to clean and update stats
CDrop and recreate the database
DRestart the PostgreSQL server
Step-by-Step Solution
Solution:

  1. Step 1: Understand why query plans may not improve

    Sometimes stale data or dead tuples affect planner; VACUUM ANALYZE cleans and updates stats.

  2. Step 2: Evaluate other options

    Restarting or dropping database is extreme; wrong table name causes errors.

  3. Final Answer:

    Run VACUUM ANALYZE to clean and update stats -> Option B

  4. Quick Check:

    VACUUM ANALYZE refreshes stats and cleans tables [OK]
Quick Trick: VACUUM ANALYZE cleans and updates stats together [OK]
Common Mistakes:
  • Restarting server unnecessarily
  • Dropping database to fix stats
  • Running ANALYZE on wrong table

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes
Advanced Features - Extensions (pg_trgm, uuid-ossp, hstore) - Quiz 13medium PL/pgSQL Fundamentals - DO blocks for anonymous code - Quiz 5medium PL/pgSQL Fundamentals - RETURN and RETURN NEXT - Quiz 3easy PL/pgSQL Fundamentals - IF-ELSIF-ELSE control flow - Quiz 7medium PL/pgSQL Fundamentals - Function creation syntax - Quiz 8hard Performance Tuning - Work_mem and effective_cache_size tuning - Quiz 14medium Table Partitioning - Partition types (range, list, hash) - Quiz 8hard Transactions and Concurrency - Repeatable read behavior - Quiz 1easy Triggers in PostgreSQL - INSTEAD OF trigger for views - Quiz 12easy Triggers in PostgreSQL - Why triggers are needed - Quiz 3easy