postgres-database-overview
The “postgres-database-overview” fetches the current state of the PostgreSQL server.
Postgres
Tools that work with Postgres Sources, such as Cloud SQL for Postgres and AlloyDB.
postgres-execute-sql
A “postgres-execute-sql” tool executes a SQL statement against a Postgres database.
postgres-list-active-queries
The “postgres-list-active-queries” tool lists currently active queries in a Postgres database.
postgres-list-available-extensions
The “postgres-list-available-extensions” tool retrieves all PostgreSQL extensions available for installation on a Postgres database.
postgres-list-indexes
The “postgres-list-indexes” tool lists indexes in a Postgres database.
postgres-list-installed-extensions
The “postgres-list-installed-extensions” tool retrieves all PostgreSQL extensions installed on a Postgres database.
postgres-list-locks
The “postgres-list-locks” tool lists active locks in the database, including the associated process, lock type, relation, mode, and the query holding or waiting on the lock.
postgres-list-schemas
The “postgres-list-schemas” tool lists user-defined schemas in a database.
postgres-list-sequences
The “postgres-list-sequences” tool lists sequences in a Postgres database.
postgres-list-tables
The “postgres-list-tables” tool lists schema information for all or specified tables in a Postgres database.
postgres-list-triggers
The “postgres-list-triggers” tool lists triggers in a Postgres database.
postgres-list-views
The “postgres-list-views” tool lists views in a Postgres database, with a default limit of 50 rows.
postgres-long-running-transactions
The postgres-long-running-transactions tool Identifies and lists database transactions that exceed a specified time limit. For each of the long running transactions, the output contains the process id, database name, user name, application name, client address, state, connection age, transaction age, query age, last activity age, wait event type, wait event, and query string.
postgres-replication-stats
The “postgres-replication-stats” tool reports replication-related metrics for WAL streaming replicas, including lag sizes presented in human-readable form.
postgres-sql
A “postgres-sql” tool executes a pre-defined SQL statement against a Postgres database.