Monitoring PostgreSQL execution plans
pg_show_plans is a free PostgreSQL tool which allows you to monitor execution plans in real-time. In the past, it was not possible to monitor query plans while the SQL statement was still running. Our free software lifts these restrictions. You can now see exactly what is happening on your server – live and in real-time.
- Inspect execution plans in real-time
- Support for various output formats (text, JSON, etc.)
- Support for nested plans
Available for all recent versions of PostgreSQL ( >= 9.5).
You can download the software for free from our GitHub page. As always, we encourage you to contribute to our Open Source solution and to send patches.DOWNLOAD >>
Read below to find out more detailed information about this product.
Your advantages with pg_show_plans:
- Dissect slow queries while they are still running
- Real-time insights
- Easy to use
- 100% enterprise-ready
Inspecting all active plans
pg_show_plans is a free extension for PostgreSQL. Download it directly from our GitHub page. It uses PostgreSQL core functionality to provide you with all the insights you need.
Data is exposed as a simple view and can be easily fetched. As a result, pg_show_plans can be attached to any monitoring system of your choice. We have already successfully implemented it within our extensive monitoring solution PGWatch.
Interested, but not sure how it can benefit you? Contact us, we’ll be happy to help:
If you have any questions or want to discuss your company’s situation with us in person, feel free to contact us! We offer timely delivery, professional handling, and 20 years of PostgreSQL experience.contact us >>