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.
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.
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:
Internal executions are efficiently stored in shared memory. That makes it easy to retrieve information quickly, as well as to filter those plans.
Here is an example of how pg_show_plans actually looks when implemented:
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.
+43 (0) 2622 93022-0
office@cybertec.at