Search PostgreSQL documentation

pg_stat_wal_receiver.conninfoStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverConnection string used by this WAL receiver, with security-sensitive fields obfuscated. pg_stat_wal_receiver SELECT conninfo FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver … pg_stat_wal_receiver.flushed_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverLast write-ahead log location already received and flushed to disk, the initial value of this field being the first log location used when WAL receiver is started pg_stat_wal_receiver SELEC… pg_stat_wal_receiver.last_msg_receipt_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverReceipt time of last message received from origin WAL sender pg_stat_wal_receiver SELECT last_msg_receipt_time FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field last_msg… pg_stat_wal_receiver.last_msg_send_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverSend time of last message received from origin WAL sender pg_stat_wal_receiver SELECT last_msg_send_time FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field last_msg_send_… pg_stat_wal_receiver.latest_end_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverLast write-ahead log location reported to origin WAL sender pg_stat_wal_receiver SELECT latest_end_lsn FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field latest_end_lsn S… pg_stat_wal_receiver.latest_end_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverTime of last write-ahead log location reported to origin WAL sender pg_stat_wal_receiver SELECT latest_end_time FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field latest_… pg_stat_wal_receiver.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverProcess ID of the WAL receiver process pg_stat_wal_receiver SELECT pid FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field pid SQL type integer Units named in the field de… pg_stat_wal_receiver.receive_start_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverFirst write-ahead log location used when WAL receiver is started pg_stat_wal_receiver SELECT receive_start_lsn FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field receive_… pg_stat_wal_receiver.receive_start_tliStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverFirst timeline number used when WAL receiver is started pg_stat_wal_receiver SELECT receive_start_tli FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field receive_start_tli… pg_stat_wal_receiver.received_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverLast write-ahead log location already received and flushed to disk, the initial value of this field being the first log location used when WAL receiver is started pg_stat_wal_receiver SELEC… pg_stat_wal_receiver.received_tliStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverTimeline number of last write-ahead log location received and flushed to disk, the initial value of this field being the timeline number of the first log location used when WAL receiver is s… pg_stat_wal_receiver.sender_hostStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverHost of the PostgreSQL instance this WAL receiver is connected to. This can be a host name, an IP address, or a directory path if the connection is via Unix socket. (The path case can be dis… pg_stat_wal_receiver.sender_portStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverPort number of the PostgreSQL instance this WAL receiver is connected to. pg_stat_wal_receiver SELECT sender_port FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field sende… pg_stat_wal_receiver.slot_nameStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverReplication slot name used by this WAL receiver pg_stat_wal_receiver SELECT slot_name FROM pg_catalog.pg_stat_wal_receiver; View pg_stat_wal_receiver Field slot_name SQL type text Units nam… pg_stat_wal_receiver.statusStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverActivity status of the WAL receiver process. Possible values are: restarting: WAL receiver has been asked to restart streaming. starting: WAL receiver process has been launched but is not y… pg_stat_wal_receiver.written_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_wal_receiverLast write-ahead log location already received and written to disk, but not flushed. This should not be used for data integrity checks. pg_stat_wal_receiver SELECT written_lsn FROM pg_catal… pg_stat_xact_all_tables.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.idx_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xa… pg_stat_xact_all_tables.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.idx_tup_fetch. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_st… pg_stat_xact_all_tables.n_tup_delStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.n_tup_del. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_all_tables.n_tup_hot_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_st… pg_stat_xact_all_tables.n_tup_insStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.n_tup_ins. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_all_tables.n_tup_newpage_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.n_tup_newpage_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. p… pg_stat_xact_all_tables.n_tup_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.n_tup_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_all_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.relid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xact_… pg_stat_xact_all_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.relname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xac… pg_stat_xact_all_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.schemaname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_… pg_stat_xact_all_tables.seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.seq_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xa… pg_stat_xact_all_tables.seq_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_all_tablesSource-defined field pg_stat_xact_all_tables.seq_tup_read. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_sta… pg_stat_xact_sys_tables.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.idx_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xa… pg_stat_xact_sys_tables.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.idx_tup_fetch. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_st… pg_stat_xact_sys_tables.n_tup_delStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.n_tup_del. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_sys_tables.n_tup_hot_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_st… pg_stat_xact_sys_tables.n_tup_insStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.n_tup_ins. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_sys_tables.n_tup_newpage_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.n_tup_newpage_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. p… pg_stat_xact_sys_tables.n_tup_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.n_tup_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_sys_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.relid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xact_… pg_stat_xact_sys_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.relname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xac… pg_stat_xact_sys_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.schemaname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_… pg_stat_xact_sys_tables.seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.seq_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xa… pg_stat_xact_sys_tables.seq_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_sys_tablesSource-defined field pg_stat_xact_sys_tables.seq_tup_read. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_sta…