MSSQL

SELECT ag.name AS group_name,

  ISNULL(drs.log_send_queue_size, 0) as log_send_queue_size,

  ISNULL(drs.redo_queue_size, 0) as redo_queue_size,

  arcs.replica_server_name AS replica_name,

  db_name(drs.database_id) AS dbname,

  drs.is_local

FROM sys.dm_hadr_database_replica_states drs

JOIN sys.dm_hadr_availability_replica_cluster_states arcs

  ON arcs.replica_id = drs.replica_id

JOIN sys.availability_groups ag

  ON ag.group_id = arcs.group_id

JOIN sys.dm_hadr_availability_replica_states ars

  ON ars.replica_id = arcs.replica_id

WHERE drs.is_local = 0