分类: STAT

PostgreSQL load profile repository and report builder

Distributed Tracing for PostgreSQL

Export PostgreSQL query telemetry to ClickHouse

Capture or log C-level stack backtraces of PostgreSQL processes

Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.

Track per-plan call counts, execution times, and example EXPLAIN texts.

Server-side PostgreSQL performance flight recorder

Reporting and analysis functions for pgfr_record

Collector-friendly metric views and background refresh worker

SQL monitoring views for database activity, WAL, replication, and storage

Capture PostgreSQL statistics snapshots for time-series analysis and visualization

show query plans of all currently running SQL statements

Kernel statistics gathering

Measure backend CPU usage between explicit reset and print calls

The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.

An extension collecting statistics about quals

track plan statistics of all SQL statements executed

Track settings changes

Track planning decisions in comparison with execution reality

sampling based statistics of wait events

Observability and activity monitoring extension for PostgreSQL

active session history

EnterpriseDB system statistics for PostgreSQL

Operating-system and host metrics for pgexporter

Normalized, friendlier system catalog for PostgreSQL

Capture node OS metrics via SQL queries

PostgreSQL extension to access the OS process table

Server filesystem capacity and inode statistics through statvfs

Provide SQL interface to logs

Small PostgreSQL background worker to report whether a node is a replication master or standby

show memory usage

show details on toasted datums

easily jump into a visual plan UI for any SQL query

Log all the queries that reference a particular column

Visualise database pages in ascii code

PostgreSQL Workload Analyser-core

Allow EXPLAIN to dump even more details

Logical decoding components inspection

inspect the contents of database pages at a low level

show row-level locking information

information about SSL certificates

examine the shared buffer cache

functions to inspect contents of PostgreSQL Write-Ahead Log

examine the free space map (FSM)

examine the visibility map (VM) and page-level visibility info

show tuple-level statistics

Provides a means for logging execution plans of slow statements automatically

track planning and execution statistics of all SQL statements executed