API Reference
  1. Database Optimizer
  2. DBAgentAPI

Ingest PostgreSQL query stats snapshots for a database instance

post
https://api.cast.ai/database-optimizer/advisor/v1alpha/organizations//database-instances//databases//pg-query-stats:ingest

Ingest PostgreSQL query stats snapshots for a database instance

Stores cumulative PostgreSQL query stats snapshots. The server computes per-interval
deltas between consecutive snapshots, avoiding the need to reset pg_stat_statements.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required

Organization ID

string
required

Database instance ID

string
required

Database name

Body Params

Request to ingest PostgreSQL query stats snapshots for a database instance

string
required

Organization ID

string
required

Database instance ID

string
required

Database name

requests
array of objects
required

The query stats to ingest.
A maximum of 100 query stats can be sent in a batch.

requests*
metadata
object

Request metadata

date-time

Timestamp of the last pg_stat_statements reset. Only present on Postgres 14+

Responses

Updated 3 hours ago

Did this page help you?
Language
Credentials
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 3 hours ago

Did this page help you?