CYBERTEC Logo

PG_SHOW_PLANS

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.

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.

Inspecting Active Plans - pg_show_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:

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 in action

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

Example - pg_show_plans

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.

CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram