Databases · Middle · Question 15 of 75

How do you find the queries that consume the most total time in production?

✓Correct answer: Use the pg_stat_statements extension, which aggregates execution counts and times per normalized query
2Run EXPLAIN on every query in the codebase
3Read the PostgreSQL configuration file

Explanation

A query taking 5 ms but running a million times a day can matter more than one slow report. Sort by total time, then optimize the top entries.

Further reading

PostgreSQL: pg_stat_statements ↗

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.