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