16

I've noticed sessions being highlighted in red recently though this never occurred in the past which leads me to believe it is a new feature. It appears to only occur on hanging queries. I looked through the PgAdmin documentation as well as change logs for all recent updates but could not find an explanation. Here is an example of how it appears:

PgAdmin session highlighted in red.

Improve this question

2 Answers 2

Reset to default
12

The session is running a query (state active), but is blocked and has to wait.

Often that blocking event is a database lock, but in your case it is IO: DataFileRead, which means it is waiting for an I/O request to complete.

If you see a lot of active sessions in that state, that is a clear indication that your I/O system is overloaded.

Improve this answer
5
  • Does the documentation for this highlight feature exist anywhere?
    – joepcash
    Commented Oct 14, 2021 at 8:15
  • 1
    I couldn't find it.
    – Laurenz Albe
    Commented Oct 14, 2021 at 8:23
  • 2
    I have a similar situation, a PID appears in red and is active with the wait event = "Client: WalSenderWaitForWAL" it is a subscriber logical replication connection. Both the publisher and subscriber are development databases with no loads at all. Any idea what is happening?
    – HMarioD
    Commented Nov 16, 2021 at 23:23
  • 3
    @HMarioD I'd say that everything is fine. pgAdmin just isn't hip to the fact that WAL senders are different from other backends.
    – Laurenz Albe
    Commented Nov 17, 2021 at 5:11
  • 1
    @Laurenz Albe Thank you very much. I was concerned with that matter.
    – HMarioD
    Commented Nov 17, 2021 at 13:28
3

The highlight means that the current query has been running for a long time. It could be blocked, but that is not always the case. If it is blocked, it should have more information in the "Blocking PIDs" column. In Preferences -> Dashboards -> Display, you can set threshold times for Warning and Alert (= Red(?)). More information is found here.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.