dbForge Studio for PostgreSQL 2.1.97

새 도구를 사용하여 병목 지점을 찾고 느린 SQL 쿼리를 시각적으로 최적화 합니다.
5월 7, 2019
신규 버전

기능

  • 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.
Locate bottlenecks and visually optimize slow SQL queries.

dbForge Studio for PostgreSQL

PostgreSQL 개발 및 관리를 위한 다기능 IDE.

dbForge Studio for PostgreSQL 도 구매할 수 있습니다:

궁금한 점이 있으세요?

Devart 사 제품 라이선스 담당자와 라이브 채팅