Update runbooks and dashboards to include patroni-sec

The following discussion from !8630 (merged) should be addressed:

• @tkuah started a discussion: (+1 comment)

  follow-up: Soon, we will have patroni-sec to monitor as well

@jjsisson @ghavenga Can you please take a look ? I am unsure which team should take this on.