dbForge Studio for PostgreSQL 2.1.97

Il nuovo strumento consente di individuare i colli di bottiglia e ottimizzare visivamente le query SQL lente.
Maggio 7, 2019
Nuova versione

Funzionalità

  • Connectivity Support for Greenplum DB - dbForge Studio for PostgreSQL now allows you to connect to Greenplum Database.  Greenplum Database is an open-source massively parallel DBMS based on PostgreSQL that provides more control over the software being employed, reducing vendor lock-in, and allowing open influence on product direction.
  • New Query Profiler functionality - New tool helps locate bottlenecks and visually optimize slow SQL queries. The profiling results are neatly displayed in several tabs, providing the following profiling sats and data:
    • Plan Tree of query execution.
    • Diagram of query execution with the cost of all operations as a percentage of the total batch cost.
    • List of top operations taking place on the server.
    • Execution plan in the XML format.
  • Redesigned Execute Large Script Wizard - The Execute Large Script Wizard has been redesigned to deliver more productivity and convenience to your work. By default, the wizard automatically selects connection and database specified in the connection settings. The database list also includes an option to refresh the list.
  • Database Explorer Improvements - Database Explorer has been improved with the display of the following database objects and their nodes in the PostgreSQL database structure:
    • Rules and triggers for views.
    • Indexes for materialized views.
    • Domains.
  • Code Completion Improvements - This release adds several useful code completion features to add more convenience to your SQL coding.
    • Prompting the names of existing materialized views in REFRESH MATERIALIZED VIEW.
    • Context prompting of database objects in the FROM list of the SELECT queries.
    • Syntax support for the VACUUM statement.
    • Prompting keywords for Functions.
    • Prompting keywords in the SELECT queries.
dbForge Studio for PostgreSQL 2.1.97
Locate bottlenecks and visually optimize slow SQL queries.

dbForge Studio for PostgreSQL

IDE multifunzionale per lo sviluppo e la gestione di PostgreSQL.

Richiedi preventivo Acquista ora

dbForge Studio for PostgreSQL è disponibile anche in:

Hai una domanda?

Chatta live con i nostri specialisti di gestione delle licenze di Devart ora.