# Get Indexes tables

This endpoint retrieves a lists of existing Indexes tables, "stats" attribute which holds the "status" and the "database_size" attributes, and a list of Users with access to the Indexes database with their access permissions.

Method Path Operation*
GET /account/services/indexes get_indexes_tables

*

In order for a user to perform the "get_indexes_tables" operation, the "get_indexes_tables" permission must be included in the list of allowed actions in the statement of the user's role.

# Request

No parameters.

# Response

The response returns the "stats" attribute which holds the "status" and the "database_size" attributes, a list of Users with their respective access permissions to the Indexes database held in the "users" attribute, and the names of the Indexes tables held in the "indexes" attribute.

Attribute Type Description
stats dictionary
Indexes database stats.
Attribute Type Description
table_size integer Size, in bytes, of actual data stored in the database tables backing the Index.
index_size integer Size, in bytes, of indices created on the database tables backing the index.
toast_size integer Size, in bytes, of the TOAST (The Oversized-Attribute Storage Technique (opens new window)) data for the database tables backing the index.
total_size integer Total size, in bytes, of the database relations (sum of actual, indices and toast data) backing the index.
users dictionary Key-value pairs:
- Key: User UUID.
- Value: Must be "read" (the User is only allowed to read the Indexes database, not to make any changes) or "write" (the User is allowed to read the Indexes database and to make changes to it. Users with no access to the Indexes database will not be returned in the response.
indexes list of strings List of names of Indexes tables in the Indexes database.

# Status codes

Requests to this endpoint result in generic status codes. For a comprehensive list of status codes, please consult the Status Codes section.