/admin

Uploads a file and saves it to a directory configured on the server

post

Uploads a file and saves it to a directory configured on the server

put

Set logging level for all loggers in the JVM or just for a specific package / class

get

Get the logging level for all loggers in the JVM

put

dumps jstacks every N seconds to a jstack file to find potential bottlenecks. Looking at this | file you can see if there are functions blocking for too long

get

Get stack trace

get

Get JVM memory info

post

run one of the following maintenance jobs on the Postgres DB. | analyze, vacuum, vacuum analyze, vacuum verbose

get

Get active PostgreSQL sessions

get

Get load information on PostgreSQL

get

Get access stats on the PostgreSQL tables

get

amount of disk usage for a specific database and its associated tables and indexes.

get

table index usage rates per table

get

cache hit rates

get

Check for currently running queries that have been executing longer than X seconds

get

Returns the size of the entire database for example, db_size = 711 MB

get

Returns a list of the tables / indexes in the shared_buffers (cache) and their size. This is | an expensive API from a DB resource perspective and should not run frequently (every few hours should suffice)

get

Returns a list of queries in transactions that are blocking other queries. The result includes the blocking query, the query being blocked, and their pids

delete

Stops a query from running based on its PID using the pg_terminate_backend command

put

Drop indexes, useful before a large batch load, tenantid will be used to select the correct schema to use

put

Create indexes, useful if prior to a large batch load the indexes were dropped, tenantid will be used to select the correct schema to use

post

Sets the AES secret key that the postgres config file password was encrypted with. The key will only be checked | when the configuration file is read in and the DB connection is created

post

The API takes the secret key passed in and the x-okapi-tenant header and returns the DB password generated for | that tenant's schema

get

The API returns 200 if service is up and responding. Should be overridden | by individual services that want to actually run some business logic to determine health.

get

The API returns service specific statistics. Should be overridden | by individual services that run a set of business logic functions / gather stats and return.