# ParadeDB Analytics (pg_analytics)

**Canonical:** https://apis.io/apis/paradedb/analytics/  
**Provider:** ParadeDB — https://apis.io/providers/paradedb/  
**Base URL:** postgresql://  
**Documentation:** https://docs.paradedb.com/documentation/aggregates/overview

ParadeDB Analytics (pg_analytics) is one of 3 APIs that [ParadeDB](https://apis.io/providers/paradedb/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include Analytics, OLAP, Columnar, and SQL. The published artifact set on APIs.io includes API documentation and an OpenAPI specification.

Columnar storage, fast aggregates, and OLAP-style analytics over Postgres data, powered by Apache DataFusion and Postgres parallel workers. Accessed entirely through standard SQL aggregate queries over the PostgreSQL wire protocol - there is no REST interface.

## Machine-readable artifacts (3)

- **Documentation** — https://docs.paradedb.com/documentation/aggregates/overview
- **GitHub** — https://github.com/paradedb/paradedb
- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/paradedb/refs/heads/main/openapi/_original/paradedb-openapi.yml

## Other ParadeDB APIs (2)

- [ParadeDB pg_search (Full-Text Search)](https://apis.io/apis/paradedb/pg_search/)
- [ParadeDB Postgres SQL Interface](https://apis.io/apis/paradedb/postgres-sql-interface/)

## Tags

Analytics, OLAP, Columnar, SQL

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/paradedb/analytics/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/paradedb/.