administration

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

Use Navicat to compare and synchronize structure

Summary: Navicat compares objects between two databases and/or schemas and states the differences in structure, and synchronize the table structures and other objects.

Continue reading

Use Navicat to compare and synchronize data

Summary: Navicat provides the ability for data in different databases and/or schemas to be kept consistent so that each repository contains the same information.

Continue reading

pg_repack: Reorganize tables with minimal locks

Summary: pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes.

Continue reading

pg_wait_sampling: Sampling based statistics of wait events

Summary: The pg_wait_sampling extension exposes a lot of sampling based statistics of wait events that will be helpful for optimizing PostgreSQL database.

Continue reading