Statistics

The statistics endpoint provides insight into the database size, broken down by table.

Get Database Size

Get database size statistics broken down by table.

Example

curl "http://api.poly-data.xyz/stats/db-size"

Response:

{
  "database": "defaultdb",
  "size_bytes": 5368709120,
  "size_pretty": "5.00 GB",
  "tables": [
    {
      "table": "orderbooks",
      "size_bytes": 4294967296,
      "size_pretty": "4.00 GB"
    },
    {
      "table": "markets",
      "size_bytes": 536870912,
      "size_pretty": "512.00 MB"
    },
    {
      "table": "events",
      "size_bytes": 268435456,
      "size_pretty": "256.00 MB"
    },
    {
      "table": "outcomes",
      "size_bytes": 134217728,
      "size_pretty": "128.00 MB"
    }
  ]
}

Response Fields

Field	Type	Description
`database`	string	Database name
`size_bytes`	integer	Total database size in bytes
`size_pretty`	string	Human-readable total size
`tables`	array	Per-table size breakdown

Table Object

Field	Type	Description
`table`	string	Table name
`size_bytes`	integer	Table size in bytes (including indexes)
`size_pretty`	string	Human-readable table size

The orderbooks table typically accounts for the vast majority of database size due to the volume of historical snapshots stored.

Overview

Endpoints

Get Database Size

Example

Response Fields

Table Object

​Get Database Size

​Example

​Response Fields

​Table Object

Get Database Size

Example

Response Fields

Table Object