{"repo":"samirketema/pg_roast","free":true,"listed":false,"github":"https://github.com/samirketema/pg_roast","clone":"git clone https://github.com/samirketema/pg_roast.git","description":"A Postgres extension that audits your database and harshly judges everything it finds.","language":"PLpgSQL","stars":40,"topics":["database","extension","management","postgres","postgresql","postgresql-database","postgresql-extension"],"license":"PostgreSQL","category":"databases-storage","readme_excerpt":"pg roast A PostgreSQL extension that automatically audits your database and harshly judges everything it finds. Inspired by the book PostgreSQL Mistakes and How to Avoid Them. How is this different from pganalyze? pganalyze is a performance monitoring tool — it watches query latency, index hit rates, autovacuum activity, and helps you tune a running system. It is great at answering \"why is this slow right now?\" pg roast is an opinionated database auditor that lives entirely inside your database. It answers a different question: \"what is wrong with this database?\" It covers schema design, naming anti-patterns, missing constraints, security misconfigurations, operational health, and query behavior — the kind of things that cause problems months later, not necessarily today. The other practical difference: pganalyze requires an account, an agent, and your query data leaving your server. pg roast is a single CREATE EXTENSION with no external dependencies. Requirements - PostgreSQL 14+ - C compiler and pg config on PATH Install Configure PostgreSQL pg roast needs two things in postgresql.conf : to be loaded at startup, and to know which database to audit. Find your postgresql.conf by running this in psql: Common locations: - macOS (Homebrew): /opt/homebrew/var/postgresql@14/postgresql.conf - Linux (apt): /etc/postgresql/14/main/postgresql.conf - Linux (yum): /var/lib/pgsql/14/data/postgresql.conf Open it and add (or update) these lines: Restart PostgreSQL to apply the changes: Cre","default_branch":null,"files":null,"tree":[],"storefront":"/r/samirketema","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/samirketema/pg_roast/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}