PostgreSQL Performance Runbook

Executes diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, bloated tables via pgstattuple, and generates EXPLAIN ANALYZE reports with buffer statistics.

Installation

Use the upstream install or setup path that matches your environment:

• npm install pg
• From your workspace root run yarn and then yarn lerna bootstrap
• Run yarn test to run all the tests.

Requirements and caveats from upstream:

• node-postgres

• 
• Non-blocking PostgreSQL client for Node.js. Pure JavaScript and optional native libpq bindings.

Basic usage or getting-started notes:

• Documentation

• Each package in this repo should have its own readme more focused on how to develop/contribute. For overall documentation on the project and the related modules managed by this repo please see:

• Features

• Source: https://github.com/brianc/node-postgres

• Extracted from upstream docs: https://raw.githubusercontent.com/brianc/node-postgres/HEAD/README.md

Source

• Agent Skill Exchange