PostgreSQL Tools | CYBERTEC - Data Science & PostgreSQL

CYBERTEC offers a variety of free PostgreSQL tools and extensions. These tools help make your daily work with PostgreSQL even more productive and fun. Here’s a list of our most popular tools:

1. pg_timetable

The best PostgreSQL tool for advanced job scheduling

PG Timetable (“pg_timetable”) is a PostgreSQL job scheduler developed by CYBERTEC. It offers cutting-edge flexibility and a large variety of features.

pg_timetable has PostgreSQL Tools for advanced job scheduling

2. 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. Until now it was not possible to monitor query plans while the SQL statement was still running. pg_show_plans lifts these restrictions. Now you can see exactly what goes on in your server – live and in real-time.

PG_show_plans_view is part of CYBERTEC's PostgreSQL tools - use it to view query plans

3. PGWatch

Enterprise PostgreSQL Monitoring – excellence in PostgreSQL tools

PGWatch is a comprehensive monitoring solution for PostgreSQL. PGWatch includes numerous graphics and dashboards that give you an instant overview of the health and behavior of your servers. Installation is very easy and configuration takes just a few minutes. With this highly user-friendly product you always have a clear overview. Developed by CYBERTEC.

4. pg_squeeze

Shrinks tables better than VACUUM

Managing storage well is one of the key factors to achieve good overall PostgreSQL database performance. While VACUUM does a good job and helps reclaim storage space, freeing up space and shrinking tables can also be useful. VACUUM FULL will shrink your table but it also requires a table lock, which can be a death sentence for a productive live application. pg_squeeze helps people re-organize their tables and shrink them without worrying about long table locks.

5. Walbouncer

Transaction log filtering

PostgreSQL streaming replication uses the transaction log of the database to move data around. Unfortunately, streaming replication only works if the entire database instance is replicated. However, in many cases that’s not necessary, and replicating all the data is not an option. walbouncer allows you to attach to the transaction log and filter its content so that only parts of a database instance (a database, a tablespace, or a table) are replicated.

walbouncer is one of CYBERTEC's PostgreSQL tools for version 9.4 and up. It allows you to filter the transaction log so that only parts of a database instance are replicated.

6. PGConfigurator

Visual PostgreSQL Configuration

PGConfigurator by CYBERTEC is a free online tool. It allows you to configure your PostgreSQL server quickly, easily and professionally. PGConfigurator takes your input data and produces a ready-made postgresql.conf file for you. It is completely visual and very simple to operate.

PGConfigurator is one of CYBERTEC's PostgreSQL tools. It allows you to visualise postgreSQL configurations

7. Patroni Environment Setup

Patroni Environment Setup (PES) is a graphical installer for Patroni on Windows which makes it easy to deploy Patroni High Availability.

Professional help

Contact us today to receive your personal offer from CYBERTEC. We offer timely delivery, professional handling, and 20 years of PostgreSQL experience.