{"repo":"pawurb/rails-pg-extras","free":true,"listed":false,"github":"https://github.com/pawurb/rails-pg-extras","clone":"git clone https://github.com/pawurb/rails-pg-extras.git","description":"Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.","language":"Ruby","stars":1248,"topics":["rails","postgresql","activerecord"],"license":"MIT","category":"databases-storage","readme_excerpt":"Rails PG Extras Rails port of Heroku PG Extras with several additions and improvements. The goal of this project is to provide powerful insights into the PostgreSQL database for Ruby on Rails apps that are not using the Heroku PostgreSQL plugin. Included rake tasks and Ruby methods can be used to obtain information about a Postgres instance, that may be useful when analyzing performance issues. This includes information about locks, index usage, buffer cache hit ratios and vacuum statistics. Ruby API enables developers to easily integrate the tool into e.g. automatic monitoring tasks. You can read this blog post for detailed step by step tutorial on how to optimize PostgreSQL using PG Extras library. Shameless plug: rails-pg-extras is just one of the tools that I use when conducting Rails performance audits. Check out my offer if you need help with optimizing your application. Optionally you can enable a visual interface: rails-pg-extras-mcp gem provides an MCP (Model Context Protocol) interface enabling PostgreSQL metadata and performance analysis with an LLM support. Alternative versions: - Core dependency - Ruby - Rust - NodeJS - Elixir - Python Flask - Haskell Installation In your Gemfile calls and outliers queries require pg stat statements extension. You can check if it is enabled in your database by running: You should see the similar line in the output: ssl used requires sslinfo extension, and buffercache usage / buffercache usage queries need pg buffercache . You can","default_branch":null,"files":null,"tree":[],"storefront":"/r/pawurb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pawurb/rails-pg-extras/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."}