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.

Key features:

  • 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).

Download pg_show_plans

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.

PG Show Plans: Inspecting all active plans

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:

Contact us

pg_show_plans: Efficiently stored

Internal executions are efficiently stored in shared memory. That makes it easy to retrieve information quickly, as well as to filter those plans.

PG Show Plans: executions are stored in shared memory

pg_show_plans in action

Here is an example of how pg_show_plans actually looks when implemented:

pg_show_plans in

 

 

Professional 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 >>