A Ukrainian developer with over 10 years of experience in fintech has created and released pg_reports as open source — a comprehensive solution for monitoring and analyzing PostgreSQL databases. The tool will be especially useful for Ruby developers, but it also works perfectly as a standalone solution.
"For over 10 years I worked in fintech, particularly with payment systems and cryptocurrencies. Recently I was laid off. Many years ago, my colleagues and I started collecting SQL scripts, mostly based on pg_stat_statements, to see the main problems of a high-load system in a single dashboard. In my opinion, this is one of the best tools in the world for analyzing a database both in development and in production," the developer under the nickname ElAvat said on Reddit.
In addition, the repository contains a rich base of materials in English and Ukrainian dedicated to the intricacies of working with PostgreSQL. Both the tool itself and the built-in scripts will become a real find and a source of valuable knowledge for any backend developer, believes the author of the project.
The pg_reports library, which is supplied as a Ruby gem, offers a full-fledged control panel (a web dashboard in dark theme) for in-depth PostgreSQL diagnostics. It is designed both for integration into Ruby on Rails and for standalone launch.
Key functions of the tool
The project is distributed under the open MIT license. The source code and installation instructions are available in the repository on GitHub and the RubyGems service. The developer is currently continuing to improve the tool and plans to soon release Docker containers for even easier launch.