Updated on 2023-10-23 GMT+08:00

PG_GET_INVALID_BACKENDS

PG_GET_INVALID_BACKENDS provides information about background threads on the primary database node that are connected to the current standby server.

Table 1 PG_GET_INVALID_BACKENDS columns

Name

Type

Description

pid

bigint

Thread ID

node_name

text

Node information connected to the background thread

dbname

name

Name of the connected database

backend_start

timestamp with time zone

Background thread startup time

query

text

Query statement executed by the background thread