dbForge Studio for PostgreSQL 2.1 Gained a New Query Profiler

Posted on 2019-05-14 by Devart
Related Proprietary

Devart launched the next version of dbForge Studio for PostgreSQL v.2.1 with a new query optimization feature, Greenplum DB connectivity, and a bunch of other notable improvements.

Devart, a recognized vendor of professional database management software for developers and DBAs, released dbForge Studio for PostgreSQL v2.1. The updated version has a new connectivity option, a brand new feature for optimizing queries, and a redesigned Execute Large Script Wizard, as well as Database Explorer and Code Completion improvements.

The new edition includes the following enhancements:

Greenplum DB Support — dbForge Studio for PostgreSQL broadened its database connectivity. From now on, Greenplum, an open-source massively parallel DBMS, is officially in a list of supported databases, which greatly expands the app’s capabilities.

New Query Profiler — the new Query Profiler functionality helps to locate bottlenecks and visually optimize slow SQL queries. The profiling results are neatly displayed in several tabs, providing the following profiling stats and data: plan tree and diagram of query execution, list of the top operations taking place on the server, and an execution plan in XML format.

Database Explorer Improvements — after the update, Database Explorer can display such database objects and nodes as domains, rules & triggers for views, and indexes for materialized views.

Code Completion Improvements — SQL coding became even more convenient with these useful code completion features:

  • Prompting the names of existing materialized views in the REFRESH MATERIALIZED VIEW;
  • Context prompting of database objects in the SELECT queries’ FROM list;
  • Syntax support for the VACUUM statement;
  • Prompting keywords for Functions;
  • Prompting keywords in SELECT queries.

Redesign of Execute Large Script Wizard — the wizard automatically selects the connection and database specified in the connection settings by default. The database list can also be refreshed.

dbForge Studio for PostgreSQL is a GUI tool for database development and management. This IDE for PostgreSQL allows users to create, develop and execute queries, edit and adjust the code to specific requirements in a convenient and user-friendly interface. For more information about dbForge Studio for PostgreSQL, please visit https://blog.devart.com/whats-new-dbforge-studio-pgsql-21.html

About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects. For additional information about Devart, visit https://www.devart.com/