openPR Logo
Press release

dbForge Studio for PostgreSQL 2.1 Gained a New Query Profiler

05-14-2019 07:02 PM CET | IT, New Media & Software

Press release from: Devart

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

2230/4 Na Žertvách St.
Prague
Czech Republic
180 00

This release was published on openPR.

Permanent link to this press release:

Copy
Please set a link in the press area of your homepage to this press release on openPR. openPR disclaims liability for any content contained in this release.

You can edit or delete your press release dbForge Studio for PostgreSQL 2.1 Gained a New Query Profiler here

News-ID: 1738773 • Views: 284

More Releases from Devart

Data Access Components from Devart Now Support Lazarus 2.0.2
The new release of Delphi Data Access Components by Devart brings numerous updates. One of them is the long-awaited support for Lazarus 2.0.2. Devart, a recognized vendor of database management software, announced a new release of its DAC components. The renewed tools support Lazarus 2.0.2 and have improved performance of the SaveToFile/LoadFromFile methods of TVirtualTable, as well as a range of other important updates. These are the changes that merit special
dbForge DevOps Automation for SQL Server – A New Approach to Database Developm …
Devart, a Czech software vendor of database tools and data connectivity solutions, has released its brand new product – dbForge DevOps Automation for SQL Server. Powered by the tools from dbForge Developer Bundle and embracing cutting-edge DevOps practices, the solution brings a new approach to conventional database development. The tool drastically reduces overall database release costs, minimizes deployment risks, energizes quality & update frequency, makes the workflow consistent and safe.
Support for MariaDB 10.4 in Upgraded dbForge Studio for MySQL, v.8.1 and dbForge …
Devart, a Czech software provider of database connectivity solutions and tools for database management and development, has released a new version of dbForge Studio for MySQL with connectivity support for the latest MariaDB 10.4. Devart keeps expanding connectivity options for its MySQL management tool to ensure that the users of dbForge Studio for MySQL can work with the most up-to-date database engines. In the updated versions of dbForge tools for
Support for PostgreSQL 11 in dotConnect for PostgreSQL, LinqConnect, SSIS Compon …
Devart offers support for the latest PostgreSQL 11 version in the newly released dotConnect for PostgreSQL 7.12 and SSIS Data Flow Components 1.10 as well as in LinqConnect, and Entity Developer products Devart, a Czech software provider of database connectivity solutions and tools for database management and development, introduced support for PostgreSQL 11 in the newly released dotConnect for PostgreSQL 7.12 and SSIS Data Flow Components 1.10 as well as

All 36 Releases


More Releases for SQL

DataNumen SQL Recovery 2.7 has been released!
DataNumen SQL Recovery (DSR) is a powerful tool to repair and recover corrupt SQL Server MDF database files. It can scan the MDF files and associated NDF files, then recover your data in them as much as possible, so to minimize the loss in file corruption. Main Features: Support SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016. Support to recover the structure and data in the tables. Support to recover all
SQL-Lessons.com Launched to Learn SQL Easier & Faster
Starnberg, Germany -- In our big data age, the ability to query databases efficiently becomes more and more important. On SQL-Lessons.com beginners can learn SQL step by step in an interactive environment. The often complicated step for beginners to set up a database is not necessary as all SQL queries will be executed against the provided online database. So beginners can invest their time in actually learning SQL and not
Fix Bad SQL Databases with DataNumen SQL Recovery v. 2.5
DataNumen has launched DataNumen SQL Recovery v. 2.5, a Windows utility that fixes bad files that were built by MS SQL Server and by other applications that write MDF and NDF files. Version 2.5 showcases a redesigned file analysis and recovery engine that shorten the amount of time required to fix files, and require less computer memory to recover damaged files. While Microsoft SQL Server includes basic tools for preventing and
Retrieve SQL data effectively with Kernel for SQL Database
Kernel for SQL Database recovery tool is an impeccable utility that allows the users to repair corrupted or inaccessible MDF files thus recovering data from corrupted SQL database. This tool has the perfect package of various outstanding features which make it a distinguished tool to recover damaged SQL files being irrespective of the intensity of corruption. Using this tool, damaged as well as deleted records can be retrieved and are
Stellar Phoenix SQL Database Recovery V1.2
Stellar Information Systems Ltd, leader in hard drive data recovery software and services has come up with the latest update on its SQL recovery software- Stellar Phoenix SQL Database Recovery V1.2. The newer version of this MDF recovery software is capable of recovering data from MS SQL Server 2005. Stellar Phoenix SQL Database Recovery is an extensive solution for all of the MDF recovery related user needs. This SQL Recovery
Stellar Rolls out SQL Recovery Software
Stellar Rolls out SQL Recovery Software Stellar Information System Ltd. introduces SQL Recovery software. The data recovery company, which has achieved its customer’s satisfaction up to a peak level through its topmost data recovery services and products, has now come up with new software which can recover and repair corrupted Microsoft SQL server Database file. Until now Stellar is known for its quality products and this MS SQL Repair application