PG Admin

Query optimization is one of the core responsibilities of DBAs. This article introduces how to use metrics provided by pg_stat_statements for macro-level PostgreSQL query optimization.

FIO is a convenient tool for testing disk I/O performance

Indexes are useful, but they’re not free. Unused indexes are a waste. Use these methods to identify unused indexes.

With file_fdw, you can easily view operating system information, fetch network data, and feed various data sources into your database for unified viewing and management.