TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    DbVisualizer

    Score9.6 out of 10
    N/ADbVisualizer is a universal database client and SQL tool for developers, analysts, DBAs, data engineers, and anyone who works with data, from beginner developers and startups to professional teams managing complex database environments. It provides a graphical interface for exploring database structures, managing schemas and database objects, and running SQL queries across multiple database systems through JDBC drivers, including MySQL, PostgreSQL, SQL Server,…

    $0

    pganalyze

    Score9 out of 10
    Small Businesses (1-50 employees)
    Founded in 2012, pganalyze provides actionable insights into Postgres. Specializing in PostgreSQL database monitoring and optimization, pganalyze gives automatic insights into Postgres query plans, helps improve Postgres query performance with its Index Advisor and VACUUM Advisor, and lets the user perform query drill-down analysis, observe per-query statistics and conduct trend analysis in a platform that integrates with both self-managed Postgres servers as…

    $149

    per month per database server

    Pricing
    DbVisualizerpganalyze
    Editions & Modules
    DbVisualizer Free
    $0
    DbVisualizer Pro with Basic support - Renewal
    $89
    per year per user
    DbVisualizer Pro with Premium support - Renewal
    $119
    per year per user
    DbVisualizer Pro with Basic support
    $199
    per year per user
    DbVisualizer Pro with Premium support
    $229
    per year per user
    Production
    $149
    per month for 1 database server
    Scale
    $399
    per month for up to 4 database servers ($100/mo for each additional billable server)
    Enterprise Cloud
    Contact us
    per year per database server
    Enterprise Server
    Contact us
    per year per database server
    Offerings
    Pricing Offerings
    DbVisualizerpganalyze
    Free Trial
    YesYes
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional DetailsNew license cost includes a perpetual license, software upgrades and support for the length of the term. 1, 2 & 3 year terms are offered. Once license expires the user may access all Pro versions released before the license expiry indefinitely. To gain access to Pro versions released after the license expired, license renewal is offered. Volume discounts apply to both new and renewal licenses.Scale plan offers additional database servers at a cost of $100/month for each additional billable server. In general, each 1 Postgres server that is running (i.e. one parent postgres process) is considered 1 billable server. In the case of cloud providers these are often called "instances". Depending on the subscription plan you are on, you may have a special price for replica servers (also called "readers", or "followers"), which is implemented by multiplying the replica count with a multiplier (e.g. 0.5), with the total rounded up. Annual plans are available and come at a discount compared to the monthly plans Contact us for custom requirements
    More Pricing Information
    Community Pulse
    DbVisualizerpganalyze
    Considered Both Products
    DbVis Software AB
    No answer on this topic
    pganalyze
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    60 Answers
    No answers on this topic
    Delivers good value for the price
    98%
    Delivers good value for the price
    57 Answers
    No answers on this topic
    Happy with the feature set
    98%
    Happy with the feature set
    59 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    98%
    Lived up to sales and marketing promises
    47 Answers
    No answers on this topic
    Implementation went as expected
    100%
    Implementation went as expected
    55 Answers
    No answers on this topic
    Features
    DbVisualizerpganalyze
    Database Development
    Comparison of Database Development features of DbVisualizer and pganalyze
    Feature
    DbVisualizer
    7.4
    49 Ratings
    14% below category average
    pganalyze
    -
    Ratings
    Performance optimization tools7.144 Ratings00 Ratings
    Schema maintenance7.846 Ratings00 Ratings
    Database Administration
    Comparison of Database Administration features of DbVisualizer and pganalyze
    Feature
    DbVisualizer
    7.2
    36 Ratings
    11% below category average
    pganalyze
    -
    Ratings
    User management7.533 Ratings00 Ratings
    Database security6.427 Ratings00 Ratings
    Database status reporting7.526 Ratings00 Ratings
    Best Alternatives
    DbVisualizerpganalyze
    Small Businesses
    DBeaver
    Score8.6 out of 10
    No answers on this topic
    Medium-sized Companies
    DBeaver
    Score8.6 out of 10
    SolarWinds Database Performance Analyzer
    Score5.6 out of 10
    Enterprises
    DBeaver
    Score8.6 out of 10
    Foglight
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    DbVisualizerpganalyze
    Likelihood to Recommend
    8.7
    (60 ratings)
    9.0
    (1 ratings)
    Likelihood to Renew
    9.1
    (3 ratings)
    -
    (0 ratings)
    Usability
    8.2
    (30 ratings)
    -
    (0 ratings)
    Support Rating
    9.1
    (2 ratings)
    -
    (0 ratings)
    Implementation Rating
    8.4
    (2 ratings)
    -
    (0 ratings)
    User Testimonials
    DbVisualizerpganalyze
    Likelihood to Recommend
    DbVis Software AB
    Seamlessly querying PostgreSQL/PostGIS, Oracle, SQL Server, and SQLite from one interface without switching tools. The intelligent autocomplete and schema browsing make it ideal for writing queries and understanding unfamiliar databases. Complex performance tuning, deep monitoring, and automated backup/recovery require specialized DBA tools. Performance degrades with tens or hundreds of thousands of rows; command-line tools or ETL solutions are better suited to bulk data processing.
    Incentivized
    Read full review
    pganalyze
    pganalyze works great with the postgresql and gives a good alternatives to the existing producsts available out there like Slick or basic as microsoft SQL server manaagement studio. We have used in our projects of data migration and integration of enterprise data warehouseing and reporting . And it has provides us satisfactory results.
    Incentivized
    Read full review
    Pros
    DbVis Software AB
    • Out-of-the-box support for many different databases.
    • Intuitive UI for interacting with data.
    • Flexibility of SQL Commander for writing scripts.
    • Great support for working with JSON data in recent updates.
    • Database connections over SSH.
    • Table relationship visualization is very helpful.
    • The tree view is well organized in how it splits out schemas.
    Read full review
    pganalyze
    • User and role setup
    • Performance tuning
    • Tracking of queries
    Incentivized
    Read full review
    Cons
    DbVis Software AB
    • Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
    • Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
    • (I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)
    Read full review
    pganalyze
    • Visualization
    • Database insights
    Incentivized
    Read full review
    Likelihood to Renew
    DbVis Software AB
    We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.
    Incentivized
    Read full review
    pganalyze
    No answers on this topic
    Usability
    DbVis Software AB
    It does what we need it for, which is manipulate data, check connections, visualize database structures, check on user rights, or even just version checks on the used databases. The 'type to get to table name' feature is often irrational in behaviour, which leads to frustration. The start-up time could be much better, and the UI changes between versions are sometimes a hassle for us when buttons are suddenly moved or their appearance changes. We use a wide variety of DBVis versions on customer installations (which use the once-bought version), and differences in the look and feel between versions sometimes slow us down.
    Read full review
    pganalyze
    No answers on this topic
    Support Rating
    DbVis Software AB
    Never used
    Incentivized
    Read full review
    pganalyze
    No answers on this topic
    Alternatives Considered
    DbVis Software AB
    [DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.
    Incentivized
    Read full review
    pganalyze
    It is better in terms of results provided. We were using Microsoft SQL Server Management Studio so far and relying only on that but some one recommend to us to use pganalyze to do the query analysis and we started using it for one project and we liked it much that we have started recomended to all projects teams ..
    Incentivized
    Read full review
    Return on Investment
    DbVis Software AB
    • Positive: Real time saver when working across multiple databases. At least 30-40 mins a day are saved
    • Positive: Helpful for the 'quick DBA' tasks without switching to the native tools: approx 1-2 hours saved weekly
    • Positive: Easy switch between environments / schemas / etc without hassle: saved at least an hour daily
    Read full review
    pganalyze
    • Efficient product
    • Good value for money
    • You dont have to depend on external services
    Incentivized
    Read full review
    ScreenShots

    DbVisualizer Screenshots

    Product screenshotScreenshot of SQL formattingScreenshot of ERD diagramScreenshot of Auto completeScreenshot of Database connectionScreenshot of Database connection

    pganalyze Screenshots

    Screenshot of Query Performance Overview: pganalyze provides access to historic query data and provides tools to help with optimizing and performance tuning of Postgres databases, including trend analysis, and config tuning recommendations.Screenshot of Query Details Page: Displays detailed statistics on a per-query basis so users can learn what to focus on. pganalyze can also be used to perform query drill-down analysis and observe per-query statistics.Screenshot of pganalyze Index Advisor: pganalyze automatically validates that existing indexes are useful, gives index recommendations to improve performance, and helps reduce load on the database.Screenshot of pganalyze EXPLAIN Insights: pganalyze automatically collects EXPLAIN plans with auto_explain, provides visualizations and gives meaningful insights into Postgres Queries.Screenshot of pganalyze Log Insights: PostgreSQL logs often contain critical details about whats going on in an associated database. pganalyze Log Insights automatically extracts the logs into structured data, and filters any sensitive information.Screenshot of pganalyze VACUUM Advisor: pganalyze helps optimize table bloat, freezing and VACUUM performance - ensuring ideal performance, stability, and efficiency for  databases.