Inspect bgwriter stats

sql

SELECT * FROM pg_stat_bgwriter;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Monitoring and Statistics

Review index scan counts when cleaning up indexes.

Open In sheetsqlsame section

Inspect current sessions and queries.

Open In sheetsqlsame section

Cancel a running query without terminating the session.

Open In sheetsqlsame section

Force a backend to disconnect.

Open In sheetsqlsame section

Inspect lock acquisition and contention.

Open In sheetsqlsame section

Measure one database's size.

Open In sheetsqlsame section