PostgreSQL Query Analyzer

Analyzes PostgreSQL slow queries using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) output and pg_stat_statements views. Identifies missing indexes via pg_stat_user_tables sequential scan counters and suggests index creation with HypoPG extension.

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