Slide 8 of 11

PostgreSQL

PostgreSQL: Query your databases directly

What it’s for: Application data including sales metrics, user counts, inventory, JSON data, and any PostgreSQL-stored data.

Also works with

TimescaleDB (time-series extension for PostgreSQL)

Good to know

  • Query language: SQL, including advanced features like common table expressions (CTEs) and window functions
  • Native JSON and JSONB support for querying semi-structured data
  • Works with TimescaleDB, the time-series extension for PostgreSQL

Best for

  • Application dashboards
  • Data already in PostgreSQL
  • Semi-structured data (JSON)
  • Time-series data with TimescaleDB
  • Combining technical and application metrics

Tip: As a general practice, point dashboard queries at a read replica to protect a busy production database.

Documentation

View the full documentation.

PostgreSQL data source

Script

PostgreSQL is a feature-rich relational database, and the data source gives you access to its advanced features. CTEs (Common Table Expressions) let you write complex analytical queries that would be painful in plain SQL. Window functions enable running totals, rankings, and moving averages.

Native JSON support means you can query JSONB columns directly, which helps if you’re storing semi-structured data.

And if you’re using TimescaleDB, the time-series extension for PostgreSQL, the data source works with it once you turn on the TimescaleDB option in the data source settings. As with MySQL, a good general practice is to point dashboard queries at a read replica to protect your production database.

PostgreSQL’s capabilities make it excellent for sophisticated application dashboards.

Previous Next