See if this helps. It groups results by host, node_name, node_id, active, and type. If there are 2 in a group then it's a match; otherwise, it isn't. index="postgresql" sourcetype="postgres" host=...
See more...
See if this helps. It groups results by host, node_name, node_id, active, and type. If there are 2 in a group then it's a match; otherwise, it isn't. index="postgresql" sourcetype="postgres" host=FLSM-ZEUS-PSQL-*
| fields host, node_name, node_id, active, type
| where NOT isnull(node_name)
| stats count by host, node_name, node_id, active, type
| eval match = if(count=2, "Yes", "No")
| fields - count