Amazon RDS for PostgreSQL vs PgHero

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL

405
183
+ 1
37
PgHero
PgHero

4
7
+ 1
0
Add tool

Amazon RDS for PostgreSQL vs PgHero: What are the differences?

Developers describe Amazon RDS for PostgreSQL as "* Set up, operate, and scale PostgreSQL deployments in the cloud". Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS. On the other hand, *PgHero** is detailed as "Rails database insights made easy. Add the gem, get a dashboard with long running queries, cache hit rate, and more". Postgres performance insights made easy.

Amazon RDS for PostgreSQL can be classified as a tool in the "PostgreSQL as a Service" category, while PgHero is grouped under "Database Tools".

Some of the features offered by Amazon RDS for PostgreSQL are:

  • Monitoring and Metrics –Amazon RDS provides Amazon CloudWatch metrics for you DB Instance deployments at no additional charge.
  • DB Event Notifications –Amazon RDS provides Amazon SNS notifications via email or SMS for your DB Instance deployments.
  • Automatic Software Patching – Amazon RDS will make sure that the PostgreSQL software powering your deployment stays up-to-date with the latest patches.

On the other hand, PgHero provides the following key features:

  • Live query stats
  • Available as a ruby gems
  • System stats for Amazon RDS

PgHero is an open source tool with 4.76K GitHub stars and 243 GitHub forks. Here's a link to PgHero's open source repository on GitHub.

No Stats
- No public GitHub repository available -

What is Amazon RDS for PostgreSQL?

Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS.

What is PgHero?

Postgres performance insights made easy.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Amazon RDS for PostgreSQL?
Why do developers choose PgHero?
    Be the first to leave a pro
      Be the first to leave a con
        Be the first to leave a con
        What companies use Amazon RDS for PostgreSQL?
        What companies use PgHero?

        Sign up to get full access to all the companiesMake informed product decisions

        What tools integrate with Amazon RDS for PostgreSQL?
        What tools integrate with PgHero?

        Sign up to get full access to all the tool integrationsMake informed product decisions

        What are some alternatives to Amazon RDS for PostgreSQL and PgHero?
        Heroku Postgres
        Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
        Google Cloud SQL for PostgreSQL
        Cloud SQL offers high performance, scalability, and convenience. Hosted on Google Cloud Platform, Cloud SQL provides a database infrastructure for applications running anywhere.
        Azure Database for PostgreSQL
        Azure Database for PostgreSQL provides a managed database service for app development and deployment that allows you to stand up a PostgreSQL database in minutes and scale on the fly – on the cloud you trust most.
        ElephantSQL
        ElephantSQL hosts PostgreSQL on Amazon EC2 in multiple regions and availability zones. The servers are continuously transferring the Write-Ahead-Log (the transaction log) to S3 for maximum reliability.
        Database Labs
        We manage an optimized Postgres image. You focus on your core app, not on becoming a database administrator.
        See all alternatives
        Decisions about Amazon RDS for PostgreSQL and PgHero
        FWScience
        FWScience
        Amazon DynamoDB
        Amazon DynamoDB
        Amazon RDS for PostgreSQL
        Amazon RDS for PostgreSQL

        We use Amazon RDS for PostgreSQL because RDS and Amazon DynamoDB are two distinct database systems. DynamoDB is NoSQL DB whereas RDS is a relational database on the cloud. The pricing will mainly differ in the type of application you are using and your requirements. For some applications, both DynamoDB and RDS, can serve well, for some it might not. I do not think DynamoDB is cheaper. Right now we are helping Companies in Silicon Valley and in Southern California go SERVERLESS - drastically lowering costs if you are interested in hearing how we go about it.

        See more
        Amazon RDS
        Amazon RDS
        Heroku Postgres
        Heroku Postgres
        Amazon RDS for PostgreSQL
        Amazon RDS for PostgreSQL
        Amazon EBS
        Amazon EBS
        PostgreSQL
        PostgreSQL
        Amazon EC2
        Amazon EC2

        I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.

        Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...

        See more
        Interest over time
        Reviews of Amazon RDS for PostgreSQL and PgHero
        No reviews found
        How developers use Amazon RDS for PostgreSQL and PgHero
        Avatar of Mark Walle
        Mark Walle uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

        Using PostGIS to serve GeoJSON data for the Leaflet front-end.

        Avatar of Tinkhaven
        Tinkhaven uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

        Main relational DB engine

        Avatar of Solcast
        Solcast uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

        Store and query data

        How much does Amazon RDS for PostgreSQL cost?
        How much does PgHero cost?
        Pricing unavailable
        Pricing unavailable
        News about PgHero
        More news