jfcoz/postgresqltuner

Health v2 · maintenance only

Adoption not part of the score

2699 stars · 192 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

postgresqltuner.pl is a Perl script that analyzes a running PostgreSQL instance's configuration and produces a report with tuning hints, inspired by mysqltuner.pl. It inspects OS settings, memory configuration, connections, extensions, and version info to recommend configuration improvements.

Use cases

• tune postgresql configuration for my server
• analyze postgres memory settings like shared_buffers and work_mem
• audit postgresql instance for misconfigurations
• get tuning advice for a postgres database
• check if my postgres settings use RAM efficiently
• run a health report on my postgresql instance over ssh

When to choose

• you run self-hosted PostgreSQL and want quick config recommendations without installing agents
• you want a mysqltuner-style one-shot report for PostgreSQL
• you need to inspect remote instances via SSH or Docker

When to avoid

• you need continuous monitoring and alerting rather than point-in-time analysis
• you use a managed cloud database without superuser access
• you want automated config changes rather than advice

Facets

cli-tool · maturity active

monitoring developer-tools database databases performance cli self-hosted postgresql tuning perl database-configuration mysqltuner-inspired devops linux docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="jfcoz/postgresqltuner")