{"repo":"SmartPostgres/Box-of-Tricks","free":true,"listed":false,"github":"https://github.com/SmartPostgres/Box-of-Tricks","clone":"git clone https://github.com/SmartPostgres/Box-of-Tricks.git","description":"Utilities for Postgres databases.","language":"PLpgSQL","stars":57,"topics":["postgresql"],"license":"MIT","category":"databases-storage","readme_excerpt":"[![Contributors][contributors-shield]][contributors-url] [![Forks][forks-shield]][forks-url] [![Stargazers][stars-shield]][stars-url] [![Issues][issues-shield]][issues-url] [![MIT License][license-shield]][license-url] [![LinkedIn][linkedin-shield]][linkedin-url] Smart Postgres Box of Tricks Utility scripts to make PostgreSQL performance tuning easier. Brought to you by the folks at SmartPostgres.com . Report Bug · Contribute Code for a Feature Table of Contents Getting Started Prerequisites Usage Contributing License Contact Getting Started Click Releases at the top of this page to download the installation file, which contains each of the sql scripts. Our target audience is folks who already know how to create and query Postgres functions. If you don't fall into that audience, we're not quite ready for you yet, but at some point in the future we'll have more detailed instructions for folks who are completely new to Postgres. Prerequisites The Box of Tricks works with all currently supported versions of Postgres (as of this writing, going back to v12), plus Amazon RDS Aurora PostgreSQL. Other proprietary cloud brands of Postgres may also work, we just haven't tested 'em. If you run into problems on other versions, we only take bug reports that also include a pull request to make the necessary changes. Otherwise, we just can't test the Box of Tricks on every possible cloud platform. ( back to top ) Usage check indexes This function analyzes the health and design of your index","default_branch":null,"files":null,"tree":[],"storefront":"/r/SmartPostgres","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/SmartPostgres/Box-of-Tricks/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."}