Skip to content
You're viewing documentation for v2026.11.6-beta. It may be out of date.Go to latest
TimescaleDB Enterprise
Esc
↑↓navigate↵open⌘Jpreview

List extension dependents

Reads, on the live leader, in the database of the extension, the objects that depend on it: columns of its types, indexes with its operator classes, views, functions, and the objects that depend on those. For pg_cron also its jobs, and for another extension its configuration tables with rows. Each table has its estimated rows.

GET/api/v1/database-services/{id}/extensions/{name}/dependents
Authorization
tse_sessionAPI key · cookierequired
Path parameters
idstringrequired
namestringrequired

The catalog name of the extension, for example pgvector.

Responses
200

OK

databasestringrequired

The database of the extension.

dependentsExtensionDependent[]required

The objects that depend on the extension: DROP EXTENSION drops them only with CASCADE. For pg_cron also its jobs, and for another extension its configuration tables with rows: DROP EXTENSION drops these rows also without CASCADE, so the console asks for CASCADE.

Show properties
Array of ExtensionDependent
estimated_rowsinteger<int64>

The estimated rows of the table (pg_class.reltuples). Not set when PostgreSQL has no estimate.

namestringrequired

The name of the object (pg_identify_object identity). For a cron job: its name and schedule.

tablestring

The table of a column.

typestringrequired

The type of the object (pg_identify_object), for example table column, index, view, function, or cron job.

existsbooleanrequired

The extension exists in the database.

extensionstringrequired

The catalog name of the extension.

moreinteger<int64>required

The number of other dependents that the answer does not show.

sql_namestringrequired

The name of the extension in pg_extension.

default

Error

codestring

Stable code of the refusal, when the route has codes

detailsstring[]

Additional detail, e.g. per-field validation failures

errorstringrequired

Human-readable error message

Request
curl -X GET 'https://console.example.com/api/v1/database-services/string/extensions/string/dependents' \
  -H 'Cookie: tse_session=YOUR_API_KEY' \
  -H 'Accept: application/json'
Response
{
  "database": "string",
  "dependents": [
    {
      "estimated_rows": 0,
      "name": "string",
      "table": "string",
      "type": "string"
    }
  ],
  "exists": true,
  "extension": "string",
  "more": 0,
  "sql_name": "string"
}