PostgreSQL DBA

PostgreSQL Database Administration Quick Reference

Question

Which objects expose runtime settings and normalized statement statistics?

Answer

pg_settings, pg_stat_statements — system views for configuration and performance. Show server parameter settings and, when the extension is enabled, execution statistics for tracked SQL statements.

This is 22 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples