Skip to content

Document parallel apply workers in the v5.6 pg_stat_subscription view #478

Open

Description

@Hanabi9248

Both v5.6 Monitoring guides omit worker_type and leader_pid from pg_stat_subscription and mention a null relid only for the main apply worker. A monitor that uses relid IS NULL to identify the leader can also select its parallel workers. The actual view exposes their worker type and leader PID. English guide Chinese guide Release view definition

Document one row for each running worker and the row with null worker columns when none is running. Add the two published columns and clarify that relid is populated for table synchronization workers. The release returns NULL for an unavailable received_lsn, and parallel apply worker rows have no WAL position or message timestamps. Worker rows and column values Release manual

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions