{"repo":"pawurb/pg-extras-rs","free":true,"listed":false,"github":"https://github.com/pawurb/pg-extras-rs","clone":"git clone https://github.com/pawurb/pg-extras-rs.git","description":"Rust PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.","language":"Rust","stars":69,"topics":["database","performance","postgresql","rust"],"license":"MIT","category":"databases-storage","readme_excerpt":"pg-extras-rs Rust 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 Rust apps that are not using the Heroku PostgreSQL plugin. Queries 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. Rust API enables developers to easily integrate the tool into e.g. automatic monitoring tasks. You can check out this blog post for detailed step by step tutorial on how to optimize PostgreSQL using PG Extras library. Alternative versions: - Ruby on Rails - NodeJS - Elixir - Python - Haskell Installation Usage Package expects the $PG EXTRAS DATABASE URL or $DATABASE URL env in the following format: You can use pgextras shell command: Diagnose Report The simplest way to start using pg-extras is to execute a diagnose method. It runs a set of checks and prints out a report highlighting areas that may require additional investigation: Web UI Alternatively, you can use the application via the web UI. You have to enable the web feature flag: Now you can run: To launch the dashboard on http://localhost:3000 (you can customize the port by setting the PORT ENV). Keep reading to learn about methods that diagnose uses under the hood. Rust API You can also run queries using a Rust API to display an ASCCI table with results: Alternatively you","default_branch":null,"files":null,"tree":[],"storefront":"/r/pawurb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pawurb/pg-extras-rs/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."}