PostgreSQL online tools

An overview of various PostgreSQL-related online tools.

Have a favourite tool or resource you'd like to see listed here? Leave us some feedback.

Formatting tools

• explain.depesz.com - formats EXPLAIN output in a more human-readable format
• paste.depesz.com - formats uploaded queries for readability

Version comparisons

• Why upgrade PostgreSQL? - shows detail of differences between any two PostgreSQL versions
• postgresql.conf comparison - online tool comparing configuration parameters between PostgreSQL versions (from PostgreSQL 9.2)
• Postgres Observability - interactive chart from DataEgret showing anything related to "observability", by PostgreSQL major version:
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5

Tutorials

• PostgreSQL Interactive Learning Portal - interactive courses on various subjects from Crunchy Data
• Percona offer at least one free online course:
  • Deep Dive Into PostgreSQL Indexes