Fields

• numBackends :: Int64

  Connections to the database, the reading one excluded.

• connActive :: Int64

  Connections running a query and not waiting on a lock.

• connIdle :: Int64

  Idle connections.

• connIdleInTxn :: Int64

  Connections idle inside an open transaction.

• connIdleInTxnAborted :: Int64

  Connections idle inside a failed transaction.

• connBlocked :: Int64

  Connections running a query that waits on a lock.

• connOther :: Int64

  Connections in any other state, including ones whose state is hidden without pg_read_all_stats.

• oldestTxnAge :: Double

  Age of the oldest open transaction, in seconds. 0 when none is open.

• oldestQueryAge :: Double

  Age of the oldest running query, in seconds. 0 when none runs.

Fields

• table :: Text
   
• liveTup :: Int64

  Estimated live rows.

• deadTup :: Int64

  Estimated dead rows.

• vacuumAge :: Maybe Double

  Seconds since the last vacuum, manual or auto. Nothing when the table has never been vacuumed.

• totalBytes :: Int64

  Size with indexes and TOAST, in bytes.

• seqScan :: Double

  Sequential scans started.

• idxScan :: Double

  Index scans started.

• blksHit :: Double

  Blocks read from the buffer cache, for the table, its indexes, and its TOAST.

• blksRead :: Double

  Blocks read from disk, for the table, its indexes, and its TOAST.

• xidAge :: Maybe Int64

  Age of the table's frozen transaction id, in transactions. Nothing when the table has no frozen transaction id.