administration

pg_profile: PostgreSQL historical workload reports

Summary: The pg_profile extension helps you to find out most resource-consuming activities in PostgreSQL databases.

Continue reading

pg_profile: User function statistics

Summary: This report section contains top functions in cluster, based on pg_stat_user_functions view.

Continue reading

pg_profile: Usage

Summary: in this section, you will learn how to use pg_profile in PostgreSQL.

Continue reading

pg_profile: SQL query statistics

Summary: This report section contains tables of top statements during report interval sorted by several important statistics.

Continue reading

pg_profile: Schema object statistics

Summary: This section of report contains top database objects, using statistics from Statistics Collector views.

Continue reading

pg_profile: Getting started

Summary: The pg_profile extension helps you to find out most resource intensive activities in PostgreSQL databases.

Continue reading

pgagroal: Getting started

Summary: The pgagroal is a high-performance connection pool for PostgreSQL.

Continue reading

pgBadger: a fast PostgreSQL log analysis report

Summary: pgBadger is a tool, which can be used to generate log analysis report in PostgreSQL.

Continue reading

check_postgres: PostgreSQL monitoring script

Summary: check_postgres.pl is a PostgreSQL monitoring script for Nagios, MRTG, Cacti, and others.

Continue reading

pg_gather: SQL script for PostgreSQL health inspection

Summary: Scan PostgreSQL instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.

Continue reading