Monitoring PostgreSQL execution plans
pg_show_plans is a free PostgreSQL tool which allows you to monitor execution plans in real-time. Up to now it was not possible to monitor query plans while the SQL statement was still running. With the introduction of pg_show_plans, these restrictions are lifted. Now you can see exactly what is going on 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
pg_show_plans is available for all recent versions of PostgreSQL ( >= 9.1).
- 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 which can be downloaded directly from our GitHub page. It uses PostgreSQL core functionality to provide you with all necessary insights.
Data is exposed as a simple view and can be fetched easily. Therefore, pg_show_plans can be attached to any monitoring of your choice. We have already successfully implemented pg_show_plans within our extensive monitoring solution PGWatch.
You can download pg_show_plans for free from our GitHub page. As always, we encourage you to contribute to our Open Source solution and to send patches.DOWNLOAD >>
If you have any questions or want to discuss any details with us in person, feel free to contact us! We offer timely delivery, professional handling, and 20 years of PostgreSQL experience.contact us >>