dbForge Studio for PostgreSQL 2.1 Gained a New Query Profiler

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
<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/
<https://www.devart.com/>

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-Announce-f2208122.html